• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DataWindow is not displaying Stored procedures from database

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

Resolved DataWindow is not displaying Stored procedures from database

  1. Issue
0
Votes
Undo
  1. venumadhav p
    venumadhav p
  2. PowerBuilder
  3. Tuesday, 2 January 2024 16:54 PM UTC

Hi,

I am using PowerBuilder 19 and try to connect the Snowflake using ODBC Driver. I am able to connect and execute the queries in DataWindow. When I try to create a DataWindow using Stored Procedure as Data source. PowerBuilder is not displaying the list of stored procedure from the snowflake. Please let me know how to resolve the issue. Thanks in Advance.

 

  1. DataWindow
Weird issues in PB 2022 R3
Add tag to PDF using PDFDocument
Responses (2)
venumadhav p
venumadhav p Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2024 20:54 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,

We are trying to call the Stored procedures(which were migrated from Teradata to Snowflake) from Powerbuilder Datawindow, getting the below error when we run the application.. whereas if we directly retrieve the datawindow from Preview(Design time), it's giving the result set properly... 

 

Error message:

Database error code: 90232

Database error message:
Select Error: SQLSTATE = 25000
Stored procedure execution error: Scoped transaction started in stored procedure is incomplete and it was rolled back

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 6 March 2024 21:11 PM UTC
This looks like it might be a SnowFlake DBMS issue ... https://github.com/dbeaver/dbeaver/issues/15803

You might want to check with your DBA team on this one.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 2 January 2024 17:02 PM UTC
  2. PowerBuilder
  3. # 2

Hi Venumadhav ;

  The most common cause for this issue happening is that the User ID that your logging on with to the DBMS does not have sufficient privileges to access the SP's.

Regards .. Chris

 

Comment
Load more comments
venumadhav p
  1. venumadhav p
  2. Tuesday, 2 January 2024 18:53 PM UTC
Hi Chrish,

PowerBuilder catalogue tables are not created. My snowflake user is not having create table access, so the tables are not created. When I tried to connect with Teradata there is also catalogue tables is not created but I can able see the list of stored procedure available in Teradata. To get stored procedures displayed we need catalogue table to be created.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 2 January 2024 19:03 PM UTC
Hi Venumadhav ;

Thanks for the update on your SP situation. If he SnowFlake SQL Tools see your SP's using that same Login ID then it should also work in the PB IDE.

Unfortunately, SnowFlake is not "officially" supported by Appeon and thus I do not have any further suggestions for you at this time.

Hopefully, other PB developer that use SF can "chime in" here to help you further.

Regards .. Chris
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Tuesday, 2 January 2024 19:33 PM UTC
Interesting tidbit: Former PowerBuilder developer / Team Sybase member Paul Horan works for Snowflake as a Principal Sales Engineer.
  1. Helpful
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.