My Oracle Support Banner

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 to [Release 10gR3]
Information in this document applies to any platform.


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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.