cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01013: user requested cancel of current operation.

former_member190681
Active Participant
0 Kudos
2,001

Hi Experts,

i am facing an issue in PI 7.0 proxy to JDBC scenario,

the process is like from Enterprise portal aplication to Sap PI and then it is stored to JDBC (Database).

i am getting an error ORA-01013 but why it is showing in xi jdbc receiver communication channel.

when i discuss with DB Team they said don't have an option to cancel order at their end.

please provide me the suggestions...

error log:

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP_XI.SAP_ORDER' (structure 'statement'): java.sql.SQLException: ORA-01013: user requested cancel of current operation.

Regards,

Kiran Polani

Accepted Solutions (1)

Accepted Solutions (1)

jyothi_anagani
Active Contributor
0 Kudos

Hi Kiran,

Change(Increase) the Timeout Parameter in your Receiver Communication channel. Looks like its is some kind of timeout. Whenever Timeout occurs and process canceled without completing this error will come.

Increase the timeout parameter and retry.

Thanks

Jyothi A

former_member190681
Active Participant
0 Kudos

Dear Jyothi,

in the Receiver JDBC, where i need to change timedout parameter.

in advanced tab i already put sqlquerytimeout to 240.

it it is correct then how much i have to increase.

else please tell me where i have to put that parameter.

Regards,

Kiran Polani

former_member190681
Active Participant
0 Kudos

Dear Friends,

Do you have any solution for this.

Please help me on this.

Regards,

Kiran Polani

Former Member
0 Kudos

  Sri,

Please check the below link:

http://www.saptechies.org/symptom-solution/

.....

Mutti

former_member190681
Active Participant
0 Kudos

Dear KK,

For this is there any solution in XI level for not coming errors in communication channel.

Regards,

Kiran Polani

Answers (1)

Answers (1)

former_member190681
Active Participant
0 Kudos

Dear Experts,

My issue resolved, This issue is resolved by Database Administrator, they increased parallel connection in DB Level.

Regards,

Kiran Polani