Pi upgrade from 7.0 to 7.3

[Former Member]

Hello Guys,

Hope you guys doing well,

We are in process of upgrade sap PI from 7.0 to 7.3, while upgrade we are faced issue in configuration phase.

"/localdisk/NW73/SUM/sdt/log/SWITCH/GET-PAR-FOR-MIGRATION_02.LOG"

<!--LOGHEADER[START]/-->

<!--HELP[Manual modification of the header may cause parsing problem!]/-->

<!--LOGGINGVERSION[2.0.7.1006]/-->

<!--NAME[/localdisk/NW73/SUM/sdt/log/SWITCH/GET-PAR-FOR-MIGRATION_02.LOG]/-->

<!--PATTERN[GET-PAR-FOR-MIGRATION_02.LOG]/-->

<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/-->

<!--ENCODING[UTF8]/-->

<!--LOGHEADER[END]/-->

Oct 14, 2014 5:46:59 PM [Info  ]: Configuration has been built from input file /localdisk/NW73/SUM/sdt/config/GetParsForMigration.xml.

Oct 14, 2014 5:46:59 PM [Info  ]: Global configuration has been built from input file /localdisk/NW73/SUM/sdt/config/GetParsForMigration.xml.

Oct 14, 2014 5:46:59 PM [Info  ]: AS Java process ID 5, name com.sap.engine.offline.OfflineToolStart has been started.

Oct 14, 2014 5:46:59 PM [Info  ]:   Command line: /localdisk/NW73/SUM/jvm/jre/bin/java -cp ./launcher.jar:./:. com.sap.engine.offline.OfflineToolStart com.parextractor.StandAloneParExtractor ./ ./config.properties ./pcdStartup.properties /localdisk/NW73/SUM/sdt/data/archives/pars parextractor.log

Oct 14, 2014 5:46:59 PM [Info  ]:   Standard out: /localdisk/NW73/SUM/sdt/log/SWITCH/GET_PARS_FOR_MIGRATIONTaskExecutorService_01.OUT

Oct 14, 2014 5:46:59 PM [Info  ]: Process ID 5 has been started.

Oct 14, 2014 5:46:59 PM [Info  ]: Waiting for process ID 5, name java to finish.

Oct 14, 2014 5:47:01 PM [Info  ]: Process ID 5, name java has been finished, exit code 7.

Oct 14, 2014 5:47:01 PM [Error ]: The following problem has occurred during step execution: com.sap.sdt.util.diag.DiagException: Error while executing Task with input file GetParsForMigration.xml and task GET_PARS_FOR_MIGRATION.

Error while processing the result.

Could not extract the PAR archives from Portal Content Directory (PCD). For more information look at /localdisk/NW73/SUM/sdt/tmp/portalContent/sape_logger.log. Could not execute '/localdisk/NW73/SUM/jvm/jre/bin/java -cp ./launcher.jar:./:. com.sap.engine.offline.OfflineToolStart com.parextractor.StandAloneParExtractor ./ ./config.properties ./pcdStartup.properties /localdisk/NW73/SUM/sdt/data/archives/pars parextractor.log', return code '7'. Check if process output file(s) '/localdisk/NW73/SUM/sdt/log/SWITCH/GET_PARS_FOR_MIGRATIONTaskExecutorService.OUT', '/localdisk/NW73/SUM/sdt/log/SWITCH/GET_PARS_FOR_MIGRATIONTaskExecutorService.ERR' have been created.

************************************************************************************************************************************************************

GET_PARS_FOR_MIGRATIONTaskExecutorService.ERR'

java.lang.reflect.InvocationTargetException

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: com.sapportals.portal.pcd.pl.PlRuntimeException: Cannot initialize pool factory:

The SQL statement "SELECT COUNT(*) FROM "EP_ID_COUNTERS"" contains the semantics error[s]: - 1:21 - the table or view >>EP_ID_COUNTERS<< does not exist

  at com.sapportals.portal.pcd.gl.admin.Init.initPoolFactory(Init.java:251)

  at com.sapportals.portal.pcd.gl.admin.Init.initInternal(Init.java:295)

  at com.sapportals.portal.pcd.gl.admin.Init.getInitialPcdContext(Init.java:355)

  at com.parextractor.StandAloneParExtractor.getArchives(StandAloneParExtractor.java:173)

  at com.parextractor.StandAloneParExtractor.main(StandAloneParExtractor.java:93)

  ... 5 more

Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "SELECT COUNT(*) FROM "EP_ID_COUNTERS"" contains the semantics error[s]: - 1:21 - the table or view >>EP_ID_COUNTERS<< does not exist

  at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:38)

  at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:101)

  at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:87)

  at com.sap.sql.jdbc.common.AbstractCommonStatement.parseStatement(AbstractCommonStatement.java:472)

  at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:375)

  at com.sapportals.portal.pcd.pl.pooling.PlStmt.<init>(PlStmt.java:42)

  at com.sapportals.portal.pcd.pl.pooling.PlConnection.prepareStatement(PlConnection.java:203)

  at com.sapportals.portal.pcd.pl.pooling.PlPoolFactory.getStmt(PlPoolFactory.java:416)

  at com.sapportals.portal.pcd.pl.pooling.PlIdCountersTable.getNumberOfEntries(PlIdCountersTable.java:53)

  at com.sapportals.portal.pcd.pl.pooling.PlIdCountersTable.initialize(PlIdCountersTable.java:42)

  at com.sapportals.portal.pcd.pl.pooling.PlPoolFactory.init(PlPoolFactory.java:609)

  at com.sapportals.portal.pcd.pl.pooling.PlPoolFactory.getInstanceFromDataSource(PlPoolFactory.java:249)

  at com.sapportals.portal.pcd.gl.admin.Init.initPoolFactory(Init.java:233)

  ... 9 more

Caused by: com.sap.sql.sqlparser.CommonSQLParserException: - 1:21 - the table or view >>EP_ID_COUNTERS<< does not exist

  at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:171)

  at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:35)

  ... 21 more

.

regards,

Ravi

[hugo_amo]

Hi Ravi,

did you check point in note 1086644  where it is said:

3. How to fix inconsistencies

in particular where advised to run it several times to be sure that no temporary errors occurred during the check?

I recommend you to backup the db before starting the cleanup.

Regards,

Hugo