1. CJ Lai
  2. PowerBuilder
  3. Thursday, 13 May 2021 18:30 PM UTC

Hi

I have been trying to figure out why this attached message came up and a solution to get pass it.

I am running PB 2017 R3

Here are some details

I have this dw object that was built with a stored procedure behind it. I ran the SP in SSMS and it went through just fine and I was able to get the result set.

However, when I open the dw in IDE, even before I retrieve anything, the attached SELECT ERROR message box pops up. Also, the error comes up when I do a retrieve as well.

For the life of me, I cannot figure out where the issue would be let alone how to solve it.

Can anyone provide any suggestions?

Thanks

CJ

Attachments (1)
mike S Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 20:22 PM UTC
  2. PowerBuilder
  3. # 1

check your procedure parameters - what type are they defined as vs what type are they actually? same with select/return values.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 18:49 PM UTC
  2. PowerBuilder
  3. # 2

Hi CJ;

  My suggestion would be to ...

1) Turn off Retrieve on Preview in the DW painter's Options dialogue

2) Open the DWO in question

3) Proceed to the SQL Painter and extract the SQL (Syntax Mode)

4) Copy & paste the SQL into the IDE's DB Painter's iSQL Pane

5) Try to Execute the SQL in the DB Painter and look for further diagnostic information from SQL Server.

6) Same as Step #5 - but use a DBA Oracle utility.

  Once you have located the DML syntax / execution issue - correct the SQL in the DWO with the issue & then retest.

HTH

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.