When running feeds, DPC issues a failure tells us to check the RQRS table:
“There is a problem with the remote staging commands. Check table ETL_RQRS for command details. Please reference SQLISPackage100 errors on the SQL server application event log more detail”
Upon inspecting the event viewer, the following error detail is displayed:
Event Name: OnError
Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Text Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
~ or ~
Event Name: OnError
Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.Odbc.OdbcException: ERROR [08004] [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'bpmc_stage' does not exist. Make sure that the name is entered correctly.
Issue Resolution:
This problem usually occurs on the container feeds in the 320 pack or higher. It is caused by a bad reference in stored procedure p_ETL_RQRS.
To solve this issue, run the following script on the affected SQL Server instance BPM Connect to patch the p_ETL_RQRS routine:
p_ETL_RQRS_v1.5.sql
This issue will be solved in the 325 pack of BPM Connect.
No comments:
Post a Comment