1875362 - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name

1. Both WIP and ODS databases on MSSQL server have correct collations as required by SAP ME Component Installation Guide.
2. However, "Invalid object name" error occurs in the following cases:

• ODS scripts fail with the following error:

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)

• You cannot login to SAP ME with proper credentials and observe similar error message in defaultTrace logs, for example:

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SITE'.

WIP and ODS databases of SAP ME are running on MSSQL Server.

KBA , MFG-ME-PRD-ODS , Operational Data Store , MFG-ME , SAP Manufacturing Execution , Problem