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

Resolved Procedure has already been executed

  1. How-to
0
Votes
Undo
  1. Prasad Neelapala
    Prasad Neelapala
  2. PowerBuilder
  3. Tuesday, 2 August 2022 10:16 AM UTC

Hi team,

I am connnecting to MSSQL SNC SQL NATIVE CLIENT database profile and i am running the application within powerbuilder. 

When i run the menu i am getting the following error

"Error Severity (21)Bad runtime function reference at line11 in ue_m_refresh of object w_auditcusip"

 

Code:
string	sCusip

//Take the entered cusip from the cusip filter and refresh the report
sCusip = dw_cusipfilter.object.cusip[1]
IF Len(sCusip) > 1 THEN
	is_cusip = sCusip
ELSE
	is_cusip = '-'
END IF 

CALL SUPER::ue_m_refresh

This is the code where the above error occured
Attachments (1)
SQL error procedure has already executed.jpg SQL error procedure has already executed.jpg
PB2019R3: Specify Schema for Database Profile
HttpClient slow over VPN?
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 2 August 2022 14:44 PM UTC
  2. PowerBuilder
  3. # 1

Make sure the event is overridden. Using SUPER to call the ancestor when it has already been executed might cause an issue.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 2 August 2022 13:17 PM UTC
  2. PowerBuilder
  3. # 2

Hi Prasad;

  If this is issue is repeatable in the development environment, then the PB Debugger could be very helpful here.

  The next helpful diagnostic to use IMHO would be the SQL Trace feature to see how the DBMS calls are done leading up to the SP error.

  If this issue just started in your development environment, then I would suggest trying...

  1. Optimize your Apps PBLs 
  2. Perform an App Full Build 

Regards ... Chris 

 

 

 

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.