This discussion is archived
0 Replies Latest reply: Nov 6, 2013 11:19 PM by aditi1920 RSS

java.sql.sqlexception ora-01013 user requested cancel of current operation

aditi1920 Newbie
Currently Being Moderated

I am getting below exception when I'm trying to extract data from a query in OSB proxy service.

 

Invoke JCA outbound service failed with connection error, exception:

com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adap

ter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.or

g.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/Dis

puteAutomation/Resources/Getpaid_Audit_Report_Adapter [ Getpaid_Audi

t_Report_Adapter_ptt::Getpaid_Audit_Report_Adapter(Getpaid_Audit_Rep

ort_AdapterInput_msg,Getpaid_Audit_Report_AdapterOutputCollection) ]

- WSIF JCA Execute of operation 'Getpaid_Audit_Report_Adapter' fail

ed due to: Pure SQL Exception.

Pure SQL Execute of "----My SQL query here----" failed.

Caused by java.sql.SQLException: ORA-01013: user requested cancel of current operation

.

; nested exception is:

BINDING.JCA-11633

Pure SQL Exception.

Pure SQL Execute of "----My SQL query here----" failed.

Caused by java.sql.SQLException: ORA-01013: user requested cancel of current operation

.

The Pure SQL option is for border use cases only and provides simple

yet minimal functionality.  Possibly try the "Perform an operation

on a table" option instead.  This exception is considered retriable,

likely due to a communication failure.  Because the global transacti

on is rolling back the invoke must be retried in a new transaction,

restarting from the place of the last transaction commit. 

To classify it as non-retriable instead add property nonRetriable

ErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml).

 

 

My SQL query:

SELECT c.invno,

       b.company,

       b.custno,

       a.dispute_amt,

       trunc(m1.MinDate)  Frst_Dist,

       e1.group_name,

       a.salesid,

       g.team,

       g.collname,

       to_date(a.ucontent01,'yyyymmdd')  Extd_date,

       a.status,

       a.pcode,

       a.problem_id

FROM gpprob a

INNER JOIN

  (SELECT problem_id,

          status,

          min(modified_on) MinDate

   FROM gpproblog

   WHERE status = 'D'

     AND salesid IN

       (SELECT DISTINCT named_user

        FROM

          (SELECT a.named_user,

                  c.group_id,

                  d.group_name

           FROM gpglobal.GPUSERLIC A

           INNER JOIN

             (SELECT MIN(GROUP_ID) AS GROUP_ID,

                     USERLIC_ID

              FROM gpglobal.GPUSERGROUPMAP X

              WHERE (GROUP_ID IN

                       (SELECT GROUP_ID

                        FROM gpglobal.GPUSER_GROUP_ENTITLEMENT

                        WHERE (ENTITLEMENT LIKE '%CAN_BE_PROB_OWNER')))

              GROUP BY USERLIC_ID) C ON A.USERLIC_ID = C.USERLIC_ID

           INNER JOIN gpglobal.GPGROUP D ON C.GROUP_ID = D.GROUP_ID)

        WHERE group_name LIKE '%AREA BRANCH MANAGER%')

   GROUP BY problem_id,

            status) m1 ON a.problem_id = m1.problem_id

INNER JOIN gpcust b ON a.custno = b.custno

INNER JOIN gprecl c ON a.open_invoice_tran_id = c.tran_id

INNER JOIN GPCOLL g ON b.COLLECTOR = g.COLLCODE

INNER JOIN

  (SELECT a.named_user,

          c.group_id,

          d.group_name

   FROM gpglobal.GPUSERLIC A

   INNER JOIN

     (SELECT MIN(GROUP_ID) AS GROUP_ID,

             USERLIC_ID

      FROM gpglobal.GPUSERGROUPMAP X

      WHERE (GROUP_ID IN

               (SELECT GROUP_ID

                FROM gpglobal.GPUSER_GROUP_ENTITLEMENT

                WHERE (ENTITLEMENT LIKE '%CAN_BE_PROB_OWNER')))

      GROUP BY USERLIC_ID) C ON A.USERLIC_ID = C.USERLIC_ID

   INNER JOIN gpglobal.GPGROUP D ON C.GROUP_ID = D.GROUP_ID)e1 ON a.salesid = e1.named_user

WHERE b.businessunit LIKE '%SOLAR%'

  AND ((trunc(m1.MinDate)) + 60 <= trunc(sysdate))

  AND a.dispute_amt > 0

  AND g.team NOT in ('LEGAL')

  AND a.status NOT IN ('C',

                       'V')

  AND e1.group_name LIKE ('%AREA BRANCH MANAGER%')

  AND (sysdate - to_date(a.ucontent01, 'yyyymmdd') > 0

       OR a.ucontent01 IS NULL)

ORDER BY c.invno,

         b.custno,

         a.dispute_amt  

 

 

I have created DB connection using a DB adapter in BPEL.

The same query works in DB if run separately & also in Testing environment. But not here.

 

 

Thanks in advance !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points