Adding a Local Query Processor For Linked Servers Causes IPM Process Injector to Fail for Specific Applications (Doc ID 1100851.1)

Last updated on MAY 04, 2016

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.2 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Dec-2011***


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.

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