Skip to Content
0
Former Member
Apr 01, 2015 at 06:59 AM

Re: Error in Data Collection (DC Collect) in SAP ME

29 Views

Hello Experts,

Recently we have upgraded our SAP ME to Version 15.0 SP3. During data collection we get an error (this was working fine before the upgrade). The error details are as under:

On the screen error message displayed is:

"An internal error occurred; contact technical support"

In the developer trace report, we get the following details:

"[EXCEPTION]
javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "ROUTER_SEQUENCE": invalid identifier

java.sql.SQLSyntaxErrorException: ORA-00904: "ROUTER_SEQUENCE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397)
at com.sap.me.frame.jdbc.DynamicQuery.executeUpdate(DynamicQuery.java:863)
at com.sap.me.frame.AbstractSqlImplementation.executeUpdate(AbstractSqlImplementation.java:76)
at com.sap.me.frame.AbstractDataSource.executeUpdate(AbstractDataSource.java:303)
at com.sap.me.datacollection.ParametricBOBean.insertParametricBO(ParametricBOBean.java:1044)
at com.sap.me.datacollection.ParametricBOBean.log(ParametricBOBean.java:712)"


Can some one please give any input as to why this is happening?


Thanks in advance


Srinivas