Adding a Local Query Processor For Linked Servers Causes IPM Process Injector to Fail for Specific Applications

(Doc ID 1100851.1)

Last updated on NOVEMBER 16, 2017

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.2 to 10.1.3.6 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

You have added the local query processor back into your system so you can add linked servers for features such as full-text search. After doing so, Process Injector fails to inject for specific applications.

Shortly after filling, Process Injector fails with the following error:

"Error sending message: error 40174".


An error similar to the one below will occur in the InfoBroker Log:

"InfoBroker: InfoBrkr: General COM Error. Desc: SQL Command: SELECT T1.[RECID], T2.[DOCUMENTTYPE], T1.[AMOUNT] , T1.[BARCODE] , T1.[BATCHNAME] , T1.[DOCTYPE] , T1.[INVOICEDT] , T1.[INVOICEID] , T1.[SCANOPER] , T1.[VENDORID] , T1.[VENDORNAME] FROM [CUSTOM]..[CONTEXT].[APINVALL] AS T1, [CUSTOM]..[CONTEXT].[OBJECTLIST] AS T2 WHERE T2.[BATCHID] = 1465488800 AND T1.[RECID] = T2.[RECID] AND T2.[SEQUENCE] = 1 ORDER BY ([BARCODE]) Timeout expired. Code: -2147217871"


Memory and CPU spikes on machine hosting the query processor may also during these times.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms