Skip to Content
0
May 30, 2013 at 02:13 PM

ODS Invalid object name SQL Error

154 Views

Hi,

I have done the set-up of ODS transfer for a planned production environment.
The current SAP ME version for it is 6.0.4.6.

In the odslog i get the following messages about not finding the objects. I can log in to the wip database

as WIP DB user and manually do the select query successfully. My SAP ME application works with no
problems.

Anybody have an idea about the reason.

Best Regards,

Johan Nordebrink

Thu May 30 15:54:13 CEST 2013 ODSProductionLogExtract: Started
Thu May 30 15:54:19 CEST 2013 ODSProductionLogExtract: [SQL][BaseDataSource].....The following fatal SQL exception has occurred:
SELECT EXTRACT_DATE_TIME FROM ODS_EXTRACT_CONTROL_DATE WHERE TABLE_NAME ='PRODUCTION_LOG' AND TRANS_TYPE ='1'
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ODS_EXTRACT_CONTROL_DATE'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at com.sap.me.ods.database.ODSBaseDataSource$StatementWrapper.executeQuery(ODSBaseDataSource.java:1107)
at com.sap.me.frame.jdbc.DynamicQuery.executeQuery(DynamicQuery.java:837)
at com.sap.me.frame.AbstractSqlImplementation.executeQueryAsResultSet(AbstractSqlImplementation.java:167)
at com.sap.me.ods.database.ODSBaseDataSource.executeQuery(ODSBaseDataSource.java:114)
at com.sap.me.ods.olap.ODSBase.getExtractDates(ODSBase.java:1569)
at com.sap.me.ods.olap.ODSProductionLogRollupProcess.ODSExtract(ODSProductionLogRollupProcess.java:77)
at com.sap.me.ods.ODSProductionLogExtract.main(ODSProductionLogExtract.java:40)

Thu May 30 15:54:19 CEST 2013 ODSProductionLogExtract: Exception Occurred.
javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ODS_EXTRACT_CONTROL_DATE'.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ODS_EXTRACT_CONTROL_DATE'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at com.sap.me.ods.database.ODSBaseDataSource$StatementWrapper.executeQuery(ODSBaseDataSource.java:1107)
at com.sap.me.frame.jdbc.DynamicQuery.executeQuery(DynamicQuery.java:837)
at com.sap.me.frame.AbstractSqlImplementation.executeQueryAsResultSet(AbstractSqlImplementation.java:167)
at com.sap.me.ods.database.ODSBaseDataSource.executeQuery(ODSBaseDataSource.java:114)
at com.sap.me.ods.olap.ODSBase.getExtractDates(ODSBase.java:1569)
at com.sap.me.ods.olap.ODSProductionLogRollupProcess.ODSExtract(ODSProductionLogRollupProcess.java:77)
at com.sap.me.ods.ODSProductionLogExtract.main(ODSProductionLogExtract.java:40)
javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ODS_EXTRACT_CONTROL_DATE'.
at com.sap.me.ods.database.ODSBaseDataSource.executeQuery(ODSBaseDataSource.java:121)
at com.sap.me.ods.olap.ODSBase.getExtractDates(ODSBase.java:1569)
at com.sap.me.ods.olap.ODSProductionLogRollupProcess.ODSExtract(ODSProductionLogRollupProcess.java:77)
at com.sap.me.ods.ODSProductionLogExtract.main(ODSProductionLogExtract.java:40)
Thu May 30 15:54:19 CEST 2013 ODSProductionLogExtract: Completed
Thu May 30 15:54:21 CEST 2013 ODSShopOrderExtract: Started
Thu May 30 15:54:25 CEST 2013 ODSShopOrderExtract: [SQL][BaseDataSource].....The following fatal SQL exception has occurred:
SELECT EXTRACT_DATE_TIME FROM ODS_EXTRACT_CONTROL_DATE WHERE TABLE_NAME ='SHOP_ORDER' AND TRANS_TYPE ='1'
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ODS_EXTRACT_CONTROL_DATE'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at com.sap.me.ods.database.ODSBaseDataSource$StatementWrapper.executeQuery(ODSBaseDataSource.java:1107)
at com.sap.me.frame.jdbc.DynamicQuery.executeQuery(DynamicQuery.java:837)
at com.sap.me.frame.AbstractSqlImplementation.executeQueryAsResultSet(AbstractSqlImplementation.java:167)
at com.sap.me.ods.database.ODSBaseDataSource.executeQuery(ODSBaseDataSource.java:114)
at com.sap.me.ods.olap.ODSBase.getExtractDates(ODSBase.java:1569)
at com.sap.me.ods.olap.ODSShopOrderRollupProcess.ODSExtract(ODSShopOrderRollupProcess.java:53)
at com.sap.me.ods.ODSShopOrderExtract.main(ODSShopOrderExtract.java:40)