System password expired

[Former Member]

Dear Experts,

We are upgrading ESO CLM 5.1 to 7.0 and during dbimport of upgrade_data.xml, scripts fails with error as below

2012-10-04 20:48:45.137 WARNING DBFWK AWT-EventQueue-0 The password for user 'system' is expired. It's highly recommended to change it.

2012-10-04 20:48:45.71 INFO DBFWK ScriptedImportEngine runSingleItem() DbGuiImporter.InstallThread system-85 #system# system action starting CheckSystemDataVersion (version=3.2;4.0;4.1;4.2;4.3;4.4;5.0;5.1;5.11;5.15;5.2;7.0)

2012-10-04 20:48:45.724 INFO DBFWK ScriptedImportEngine runSingleItem() DbGuiImporter.InstallThread system-85 #system# system action complete CheckSystemDataVersion (version=3.2;4.0;4.1;4.2;4.3;4.4;5.0;5.1;5.11;5.15;5.2;7.0)

2012-10-04 20:48:45.737 INFO DBFWK ScriptedImportEngine runSingleItem() DbGuiImporter.InstallThread system-85 #system# system action starting ProcessCsvFile (props={result_recorder=com.sap.odp.install.engine.DbConversionEngine@f9bca3f, filename=classpath:///com/sap/odp/common/platform/importer/data/system.property_metadata.csv, processor=com.sap.odp.common.platform.importer.processors.PropMetaProcessor})

2012-10-04 20:48:45.758 INFO DBFWK ConfigDatabase loadFromServletContext() DbGuiImporter.InstallThread Attempted to cache servlet context parameters without a servlet context.

2012-10-04 20:48:46.389 INFO PSERVER TimestampLogger logEvent DbGuiImporter.InstallThread system-85 #system# system E 000000 + Start SQL Execute SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, EXTERNAL_ID, DISPLAY_NAME FROM ESODU1.FCI_UPP_SECURITY_NAMES WHERE EXTERNAL_ID = ? AND CONTEXTID = ?

2012-10-04 20:48:46.411 INFO PSERVER TimestampLogger logEvent DbGuiImporter.InstallThread system-85 #system# system E 000022 - End SQL Execute SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, EXTERNAL_ID, DISPLAY_NAME FROM ESODU1.FCI_UPP_SECURITY_NAMES WHERE EXTERNAL_ID = ? AND CONTEXTID = ? Error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75 - SQLState: 42703 - SQLError: -206

2012-10-04 20:48:48.003 INFO DBFWK DbGuiImporter.InstallThread *** Cached Resource Bundle (LRU/Static): exception(0/1 IDs, 1 Values)

2012-10-04 20:48:48.011 ERROR DBFWK ProcessCsvFile executeHook() DbGuiImporter.InstallThread system-85 #system# system com.sap.odp.api.common.exception.ApplicationException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator. AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.ApplicationException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator.| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2044)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)|AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.DatabaseException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator.| at com.sap.odp.common.db.AbstractDb.createDatabaseException(AbstractDb.java:6761)| at com.sap.odp.common.db.AbstractDb.createDatabaseException(AbstractDb.java:6749)| at com.sap.odp.common.db.AbstractDb.executeSQLQuery(AbstractDb.java:6184)| at com.sap.odp.common.db.AbstractDb.findObjects(AbstractDb.java:6020)| at com.sap.odp.common.db.AbstractDb.findCommon(AbstractDb.java:5930)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4441)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4362)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByExternalId(NamedResourceHome.java:59)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByName(NamedResourceHome.java:86)| at com.sap.odp.usermgmt.security.AuthorizationComp.findResource(AuthorizationComp.java:383)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2010)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)|com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75| at com.ibm.db2.jcc.am.fd.a(fd.java:679)| at com.ibm.db2.jcc.am.fd.a(fd.java:60)| at com.ibm.db2.jcc.am.fd.a(fd.java:127)| at com.ibm.db2.jcc.am.yn.c(yn.java:2644)| at com.ibm.db2.jcc.am.yn.d(yn.java:2632)| at com.ibm.db2.jcc.am.yn.a(yn.java:2097)| at com.ibm.db2.jcc.am.zn.a(zn.java:7197)| at com.ibm.db2.jcc.t4.cb.h(cb.java:141)| at com.ibm.db2.jcc.t4.cb.b(cb.java:41)| at com.ibm.db2.jcc.t4.q.a(q.java:32)| at com.ibm.db2.jcc.t4.sb.i(sb.java:135)| at com.ibm.db2.jcc.am.yn.gb(yn.java:2066)| at com.ibm.db2.jcc.am.zn.pc(zn.java:3446)| at com.ibm.db2.jcc.am.zn.b(zn.java:4236)| at com.ibm.db2.jcc.am.zn.cc(zn.java:720)| at com.ibm.db2.jcc.am.zn.executeQuery(zn.java:694)| at com.sap.odp.common.db.DbHandle.executeQuery(DbHandle.java:778)| at com.sap.odp.common.db.AbstractDb.executeSQLQuery(AbstractDb.java:6169)| at com.sap.odp.common.db.AbstractDb.findObjects(AbstractDb.java:6020)| at com.sap.odp.common.db.AbstractDb.findCommon(AbstractDb.java:5930)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4441)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4362)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByExternalId(NamedResourceHome.java:59)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByName(NamedResourceHome.java:86)| at com.sap.odp.usermgmt.security.AuthorizationComp.findResource(AuthorizationComp.java:383)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2010)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)

2012-10-04 20:48:48.027 ERROR DBFWK DbSetupEngine execute() DbGuiImporter.InstallThread system-85 #system# system action failed

2012-10-04 20:48:48.049 INFO DBFWK ScriptedImportEngine runSingleItem() DbGuiImporter.InstallThread system-85 #system# system action starting ProcessCsvFile (props={result_recorder=com.sap.odp.install.engine.DbConversionEngine@f9bca3f, filename=classpath:///com/sap/odp/common/platform/importer/data/system.property.csv, processor=com.sap.odp.common.platform.importer.processors.PropProcessor, ignore=true})

2012-10-04 20:48:48.067 INFO PSERVER TimestampLogger logEvent DbGuiImporter.InstallThread system-85 #system# system E 000000 + Start SQL Execute SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, EXTERNAL_ID, DISPLAY_NAME FROM ESODU1.FCI_UPP_SECURITY_NAMES WHERE EXTERNAL_ID = ? AND CONTEXTID = ?

2012-10-04 20:48:48.069 INFO PSERVER TimestampLogger logEvent DbGuiImporter.InstallThread system-85 #system# system E 000002 - End SQL Execute SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, EXTERNAL_ID, DISPLAY_NAME FROM ESODU1.FCI_UPP_SECURITY_NAMES WHERE EXTERNAL_ID = ? AND CONTEXTID = ? Error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75 - SQLState: 42703 - SQLError: -206

2012-10-04 20:48:48.092 ERROR DBFWK ProcessCsvFile executeHook() DbGuiImporter.InstallThread system-85 #system# system com.sap.odp.api.common.exception.ApplicationException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator. AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.ApplicationException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator.| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2044)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)|AssociatedAttribute=STANDARD_ATTRIBUTE_ID - com.sap.odp.api.common.exception.DatabaseException: Database error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75. Contact your system administrator.| at com.sap.odp.common.db.AbstractDb.createDatabaseException(AbstractDb.java:6761)| at com.sap.odp.common.db.AbstractDb.createDatabaseException(AbstractDb.java:6749)| at com.sap.odp.common.db.AbstractDb.executeSQLQuery(AbstractDb.java:6184)| at com.sap.odp.common.db.AbstractDb.findObjects(AbstractDb.java:6020)| at com.sap.odp.common.db.AbstractDb.findCommon(AbstractDb.java:5930)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4441)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4362)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByExternalId(NamedResourceHome.java:59)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByName(NamedResourceHome.java:86)| at com.sap.odp.usermgmt.security.AuthorizationComp.findResource(AuthorizationComp.java:383)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2010)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)|com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EXTERNAL_ID, DRIVER=3.63.75| at com.ibm.db2.jcc.am.fd.a(fd.java:679)| at com.ibm.db2.jcc.am.fd.a(fd.java:60)| at com.ibm.db2.jcc.am.fd.a(fd.java:127)| at com.ibm.db2.jcc.am.yn.c(yn.java:2644)| at com.ibm.db2.jcc.am.yn.d(yn.java:2632)| at com.ibm.db2.jcc.am.yn.a(yn.java:2097)| at com.ibm.db2.jcc.am.zn.a(zn.java:7197)| at com.ibm.db2.jcc.t4.cb.h(cb.java:141)| at com.ibm.db2.jcc.t4.cb.b(cb.java:41)| at com.ibm.db2.jcc.t4.q.a(q.java:32)| at com.ibm.db2.jcc.t4.sb.i(sb.java:135)| at com.ibm.db2.jcc.am.yn.gb(yn.java:2066)| at com.ibm.db2.jcc.am.zn.pc(zn.java:3446)| at com.ibm.db2.jcc.am.zn.b(zn.java:4236)| at com.ibm.db2.jcc.am.zn.cc(zn.java:720)| at com.ibm.db2.jcc.am.zn.executeQuery(zn.java:694)| at com.sap.odp.common.db.DbHandle.executeQuery(DbHandle.java:778)| at com.sap.odp.common.db.AbstractDb.executeSQLQuery(AbstractDb.java:6169)| at com.sap.odp.common.db.AbstractDb.findObjects(AbstractDb.java:6020)| at com.sap.odp.common.db.AbstractDb.findCommon(AbstractDb.java:5930)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4441)| at com.sap.odp.common.db.AbstractDb.findUnique(AbstractDb.java:4362)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByExternalId(NamedResourceHome.java:59)| at com.sap.odp.usermgmt.security.NamedResourceHome.findByName(NamedResourceHome.java:86)| at com.sap.odp.usermgmt.security.AuthorizationComp.findResource(AuthorizationComp.java:383)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkPermission(CsvFileProcessor.java:2010)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.checkClassLevelPermission(CsvFileProcessor.java:1971)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.prepare2(CsvFileProcessor.java:249)| at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:270)| at com.sap.odp.common.install.dataimport.csv.CsvImporter.go(CsvImporter.java:195)| at com.sap.odp.install.actions.ProcessCsvFile.executeHook(ProcessCsvFile.java:159)| at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)| at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)| at com.sap.odp.install.engine.DbConversionEngine.execute(DbConversionEngine.java:375)| at com.sap.odp.install.tools.gui.DbGuiImporter.go(DbGuiImporter.java:282)| at com.sap.odp.install.tools.gui.DbGuiImporter$InstallThread.run(DbGuiImporter.java:583)

2012-10-04 20:48:48.096 ERROR DBFWK DbSetupEngine execute() DbGuiImporter.InstallThread system-85 #system# system action failed

 

1). How to change system password, kindly suggest

2). Upgrade_schema script prior to upgrade_data step showed complete during run, how to make sure that upgrade_schema ran successfully without error.

3). We are using SP03 Patch 3 software "setup.bin".

    a). As per my research, Eso can be installed straight using SP03_patch 03 software, please correct me if am wrong.

4). Error also has message check permission, am already gave 775 permission to jar files not sure what CSV file permission its looking for, kindly help

5). If I want to uninstall SP03 patvh and instal SP03 what would the procedure and will impact my database ?

6). NW is 7.3 SP7 & database is DB2 9.7 FP 5.

Thanks in advance,

Yoga

[Former Member]

1). The post above mentions Gary's blog which is a good resource.

2). Check the configure and install logs in the Sourcing home directory.  Any issues with the DBimport will appear in the install log.

3). You are correct. 

4). It may be related to the Grant permissions given to the schema owner and user.  I would consult the installation guide to be sure that you've configured the DB user/schema is set up correctly.  Also have you installed the text search componenets? as I know this can be a bit tricky.

5). Restore your database from backup to the point you started upgrading from. undeploy the .SCA file yusing telnet and uninstall the Sourcing home directory using the _Uninstall directories executables.  Then Re-install.

6). That is great.  Do you have the accessories suite and text search components installed to DB2?

[Former Member]

Hi Yoga,

I do not work on the system admin part so cant comment on the problem above but did you have a look at this blog by Gary.

Hope this helps

Thanks

Devesh