DB ADAPTER FAILED TO POLL DATA FROM MS SQL SERVER AFTER PATCH SERVER TO 10.1.3.4 MLR#9
Last updated on NOVEMBER 03, 2016
Applies to:Oracle(R) BPEL Process Manager 10g - Version 10.1.3.4 and later
Information in this document applies to any platform.
After patch the system to 10.1.3.4 MLR#9 from MLR#7, BPEL DB Adapter failed to poll data from MS SQL server.
Call:SELECT t0.trackingid, t0.version, t0.trackingtype, t0.trackingnumber, t0.resolution, t0.trackingdate, t0.comments, t0.status FROM dbo.tbstatustracking t0, dbo.tbstatus t1 WHERE ((((((((((t1.status = ?) OR (t1.status = ?)) OR (t1.status = ?)) OR (t1.status = ?)) OR (t1.status = ?)) OR (t1.status = ?)) OR (t1.status = ?)) OR (t1.status = ?)) AND (t0.trackingdate > ?) AND (t0.trackingdate < SYSDATE))) AND (t1.status = t0.status)) ORDER BY t0.trackingdate ASC
Applied for 10.1.3.4 MLR#9 on top of 10.1.3.4 MLR#7
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