Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved PowerServer Select Error: ORA-01013: User requested cancel of current operation.

  1. Issue
0
Votes
Undo
  1. Pascal Phan
    Pascal Phan
  2. PowerServer
  3. Friday, 30 August 2024 16:27 PM UTC

Hi,

   I am using Appeon PowerBuilder 2022 R3

When I ran a remote procedure call in Oracle I got the following error:

In CMD, it was:

My Database settings:

 

Note: The App is running fine in PowerBuilder with no error !

 

 

 

 

PowerServer PBL optimization by using PBAutoBuild
Single Sign on - App launches in foreground
Responses (3)
Pascal Phan
Pascal Phan Accepted Answer Pending Moderation
  1. Friday, 6 September 2024 22:01 PM UTC
  2. PowerServer
  3. # 1

Hi David,

 

    I changed the command timeout to 3600 or even 7200 (See photo)

 

 

But it still not working! It looks like the Server timeout and I ran the app Within IDE

 

 

The code that it failed was:

 

But it was ran smoothly in PowerBuilder. Not sure why? Please help (I am depress)

Comment
There are no comments made yet.
David Xiong @Appeon
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 September 2024 08:46 AM UTC
  2. PowerServer
  3. # 2

Hi Pascal,

 

It seems that this issue might be caused by the stored procedure execution time exceeding the Command Timeout value set in the application. You could try increasing the Command Timeout value from 1200 to something larger, like 3600, and see if that resolves the problem.

 

Regards, 

David

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Monday, 2 September 2024 15:16 PM UTC
  2. PowerServer
  3. # 3

Hi

Looking at the ORA Error it would appear that the Client is terminating the process: "ORA-01013: user requested cancel of current operation" means your client told Oracle to abort the current call. Most likely you have a timeout setting in your client software configured.

Does/is it possible that the procedure is taking a long time? Does this exceed a timeout you have in the PowerBuilder DB connection, Command Timeout 1200?

Just a random thought.

Cheers

David

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.