Question

1
Replies
328
Views
Suman Gumudavelly (SUMAN_GUMUDAVELLY)
Ford Motor Company
Pega Operations, CoE and Administration
Ford Motor Company
US
SUMAN_GUMUDAVELLY Member since 2011 13 posts
Ford Motor Company
Posted: July 9, 2019
Last activity: July 10, 2019
Posted: 9 Jul 2019 9:22 EDT
Last activity: 10 Jul 2019 16:38 EDT
Closed
Solved

Getting an error while Upgrading from 7.1.9 to 7.4

Targets:Update


Unable to locate tools.jar.
Targets:Update
Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre8\lib\tools.jar
Buildfile: C:\Users\*******\Desktop\115944_Pega74-U\.\pegaGuiInstallerTemp\build.xml
SetupProperties:
Update:
[echo] calling update ....
update:
startover_or_resume:
[pega:propertyparser] Reading Properties from: C:\Users\*******\Desktop\115944_Pega74-U\scripts/setupDatabase.properties
[echo] Performing update...
Initialization:
[echo] Performing Update Finalization
[echo] Using logging configuration from: ./config/deploylogging.properties
[mkdir] Created dir: C:\Users\*******\Desktop\115944_Pega74-U\scripts\taskRuntimes
[pega:propertyparser] Reading Properties from: C:\Users\*******\Desktop\115944_Pega74-U\scripts/setupDatabase.properties
pega.jdbc.driver.jar=C:\Users\****\Desktop\sqljdbc4.jar
pega.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
pega.database.type=mssql
pega.jdbc.url=jdbc:sqlserver://*******:1433;databaseName=*****;SelectMethod=cursor;SendStringParametersAsUnicode=false
pega.jdbc.username=*******
pega.jdbc.password=*****
pega.admin.password=*****
rules.schema.name=Rules
data.schema.name=dbo
customerdata.schema.name=
user.temp.dir=
pega.zos.properties=
system.name=pega
production.level=2
multitenant.system=false
update.existing.applications=false
update.applications.schema=true
automatic.resume=true
pega.jdbc.driver.jar=C:\Users\*******\Desktop\sqljdbc4.jar
pega.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
pega.database.type=mssql
pega.jdbc.url=jdbc:sqlserver://*******:1433;databaseName=*****;SelectMethod=cursor;SendStringParametersAsUnicode=false
pega.jdbc.username=*****
pega.jdbc.password=*****
pega.admin.password=*****
rules.schema.name=Rules
data.schema.name=dbo
customerdata.schema.name=
user.temp.dir=
pega.zos.properties=
system.name=pega
production.level=2
multitenant.system=false
update.existing.applications=false
update.applications.schema=true
automatic.resume=true
[pega:propertyparser] pega.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
[pega:propertyparser] update.existing.applications=false
[pega:propertyparser] pega.jdbc.password=*****
[pega:propertyparser] update.applications.schema=true
[pega:propertyparser] automatic.resume=true
[pega:propertyparser] pega.jdbc.driver.jar=C:\Users\*******\Desktop\sqljdbc4.jar
[pega:propertyparser] rules.schema.name=Rules
[pega:propertyparser] pega.jdbc.url=jdbc:sqlserver://******:1433;databaseName=*****;SelectMethod=cursor;SendStringParametersAsUnicode=false
[pega:propertyparser] pega.database.type=mssql
[pega:propertyparser] user.temp.dir=
[pega:propertyparser] production.level=2
[pega:propertyparser] pega.zos.properties=
[pega:propertyparser] customerdata.schema.name=
[pega:propertyparser] pega.jdbc.username=******
[pega:propertyparser] pega.admin.password=*****
[pega:propertyparser] multitenant.system=false
[pega:propertyparser] system.name=pega
[pega:propertyparser] data.schema.name=dbo
[echo] *** JVM Arguments -XX:MaxHeapSize=1280m ***
[propertyfile] Creating new property file: C:\Users\*******\Desktop\115944_Pega74-U\scripts\resume.properties
[propertyfile] Updating property file: C:\Users\*******\Desktop\115944_Pega74-U\scripts\resume.properties
Found 99264240KB of free space on 'C:\Users\*******\AppData\Local\Temp\'
[echo] setting to generated ddl
[echo] Driver Path: C:\Users\*******\Desktop\sqljdbc4.jar
[mkdir] Created dir: C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\load
[mkdir] Created dir: C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\pr_temp
[touch] Creating C:\Users\*******\Desktop\115944_Pega74-U\scripts\logs\Warnings.log
[echo] Using C:\Users\*******\AppData\Local\Temp\/PegaInstallTemp-09-July-2019-09.13.52 for install scratch space...
[unzip] Expanding: C:\Users\*******\Desktop\115944_Pega74-U\archives\prweb.war into C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\load
[unzip] Expanding: C:\Users\*******\Desktop\115944_Pega74-U\archives\pegadbinstall-classes.zip into C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\load
[copy] Copying 1 file to C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\load\WEB-INF\classes
[copy] Copying 1 file to C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52
Checking Configuration Files:
[echo] Rules schema has been set to 'Rules'
[echo] ***writing resume property upgrade.from.version=07-10-20 to file***
[propertyfile] Updating property file: C:\Users\*******\Desktop\115944_Pega74-U\scripts\resume.properties
[echo] Upgrading from Pega-RULES product version 07-10-20
Processing Configuration Files:
[propertyfile] Creating new property file: C:\Users\*******\AppData\Local\Temp\PegaInstallTemp-09-July-2019-09.13.52\prbootstrap.properties
Configuration:
[echo] Database Type: mssql
[echo] JDBC Driver JAR: C:\Users\*******\Desktop\sqljdbc4.jar
[echo] Bootstrap Config: C:\Users\*******\AppData\Local\Temp\/PegaInstallTemp-09-July-2019-09.13.52/prbootstrap.properties
[echo] PegaRULES Config: C:\Users\*******\AppData\Local\Temp\/PegaInstallTemp-09-July-2019-09.13.52/prconfig.xml
[echo] PegaRULES Logging Config: C:\Users\*******\AppData\Local\Temp\/PegaInstallTemp-09-July-2019-09.13.52/prlog4j2.xml
[echo] Deployment Logging Config: ./config/deploylogging.properties
Verify ML Readiness:
System meets basic requirements for update to 07-10-35
PRPC_Rules build date: 2018-04-11 12.36 UTC
No superseded code or rules.
Generate Upgrade DDL:
[mkdir] Created dir: C:\Users\*******\Desktop\115944_Pega74-U\schema\generated\mssql\upgrade
[mkdir] Created dir: C:\Users\*******\Desktop\115944_Pega74-U\schema\generated\mssql\util
Execute SQL In Transaction:false
_clean:
[echo] Cleaning up previous invocation...
[delete] Deleting directory C:\Users\*******\Desktop\115944_Pega74-U\schema\generated\mssql
[echo] Cleaning up previous invocation...(Complete)
_createOutputDirs:
[echo] Creating output directory at C:\Users\*******\Desktop\115944_Pega74-U\scripts/../schema/generated/mssql
[mkdir] Created dir: C:\Users\*******\Desktop\115944_Pega74-U\schema\generated\mssql
_callDDLUtilityUpgrade:
[echo] Call DDL Generation Upgrade Utility...
[echo] C:\Users\*******\Desktop\115944_Pega74-U\scripts/lib/xercesImpl.jar;C:\Users\*******\Desktop\115944_Pega74-U\scripts/lib/xml-apis.jar;C:\Users\*******\Desktop\115944_Pega74-U\scripts/lib/resolver.jar;
[echo] archive_dir: C:\Users\*******\Desktop\115944_Pega74-U\scripts/lib
[java] 2019-07-09 09:14:41,245 ( install) INFO - Initializing properties with default values
[java] 2019-07-09 09:14:41,355 ( install) INFO - Setting default Entity Value for pega_enable_nologging = true
[java] 2019-07-09 09:14:41,355 ( install) INFO - Getting database metadata
[java] 2019-07-09 09:14:44,789 ( install) INFO - Reading views from schema "dbo"
[java] Exception in thread "main" java.lang.RuntimeException: Error during execution of upgrade on platform mssql using schemas Rules, dbo, dbo
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1569)
[java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'pr4_rule_vw'.
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:439)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:480)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.saveCurrentSchemaState(SchemaGenerator.java:496)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1395)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'pr4_rule_vw'.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
[java] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
[java] at com.microsoft.sqlserver.jdbc.SQLServerResultSet.<init>(SQLServerResultSet.java:311)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1526)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.getTablesDependentonViews(JDBCIntrospector.java:1631)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.readViews(JDBCIntrospector.java:496)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.createDatabaseJaxbObjectByIntrospection(JDBCIntrospector.java:120)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDomDocumentFromDbIntrospection(SchemaManager.java:2039)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:435)
[java] ... 3 more

System Administration Installation and Deployment Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.