In this example, the DTS runs without error in the TIBCO Scribe® Insight Workbench, but fails when run in the TIBCO Scribe® InsightConsole with the following error:

          Fatal error 327 occurred: Error opening the following query:   CREATE TABLE dbo.#TempDSN_NAME

See related article:  DTS (integration) runs in the Workbench but not in the Console


Troubleshooting Steps:

1.  Enable Console tracing –  see article for instructions Tracing In Scribe Insight
2. Using Notepad++, search the MessageProcessor_*.log files for:   ERROR!

The alert message provides the “327” error, but the MessageProcessor log provides the more detailed information indicating the Scribe services logon user did not have required access.

Example text from MessageProcessor log
Fatal error 327 occurred: Error opening the following query:
CREATE TABLE dbo.#TempDSN_NAME

[05/29/2018 15:19:27.756]ERROR!
   Error Number:  0x000003ed (1005)
   Native Error:  0x00000394 (916)
   Source:        [Microsoft][ODBC SQL Server Driver][SQL Server]
   Description:   [08004] SQL call failed. The server principal "MYORG\ServicesAccount" is not able to access the database "DSN_NAME" under the current security context.

[05/29/2018 15:19:27.756]Closing recordset Query 1

[05/29/2018 15:19:27.756]ERROR!
   Error Number:  0x00000000 (0)
   Native Error:  0x00000000 (0)
   Source:        ADP
   Description:   Error opening the following query:
CREATE TABLE dbo.#TempDSN_NAME
 

This article provides troubleshooting steps for when the “Fatal error 327” message is received in the Alert log.