• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Issue with SyntaxFromSQL in application deployed to Powerserver ( PB 2021 )

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

Resolved Issue with SyntaxFromSQL in application deployed to Powerserver ( PB 2021 )

  1. Issue
1
Votes
Undo
  1. Shayne Salsbury
    Shayne Salsbury
  2. PowerServer
  3. Tuesday, 5 October 2021 18:31 PM UTC

I am currently working on deploying an application in Powerbuilder 2021 to Powerserver (development).  Wherever SyntaxFromSQL is used I get an error message that the table or view does not exists.  We are using Oracle for our database.  This is happening on all versions of Oracle that I have tested.  All other datawindows in the application are able to retrieve data.  I have verified that the connected user does have access to the tables.

There are no errors in the build and deployment of the project.

 

Thanks,

Shayne Salsbury

Other versions of appeon options
Error splitting PBD file
Responses (6)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 18:46 PM UTC
  2. PowerServer
  3. # 1

Hi Shayne,

This sounds like it might be a bug; please submit a support ticket for this.

Regards,
Francisco

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 19:24 PM UTC
  2. PowerServer
  3. # 2

Hi Shayne;

  Is this the only place in the App where the  SyntaxFromSQL command is being used or .... is the SyntaxFromSQL used in other places and these work OK?

Regards ... Chris

Comment
Shayne Salsbury
  1. Shayne Salsbury
  2. Tuesday, 5 October 2021 19:42 PM UTC
So far every SyntaxFromSQL encountered results in an error.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 19:31 PM UTC
  2. PowerServer
  3. # 3

Hi Shayne,

Are you using Oracle 12c and newer?  Older versions not supported: https://docs.appeon.com/ps2021/Database_Server.html

Is the table a temp table?  Temp tables not supported for the SyntaxFromSQL(): https://docs.appeon.com/ps2021/bk06ch02s02s07.html

Best regards,
Armeen

Comment
Shayne Salsbury
  1. Shayne Salsbury
  2. Tuesday, 5 October 2021 19:42 PM UTC
I am running on Oracle 18c and I am not using temp tables.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 9 November 2021 19:38 PM UTC
Hi Everyone ... FYI: Appeon are pleased to inform you that PowerBuilder 2021 MR Build 1311 has been officially released. The bug you reported in ticket 7343 for the SyntaxFromSQL issue has been fixed in this release.
  1. Helpful 1
There are no comments made yet.
Shayne Salsbury
Shayne Salsbury Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 19:38 PM UTC
  2. PowerServer
  3. # 4

There error occurs with all of the SyntaxFromSQL datawindows that are encountered.  I am not able run the application too far because of the errors.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 5 October 2021 19:46 PM UTC
This doesn't sound right. Please open a support ticket with your test case so we can help you.
  1. Helpful
Shayne Salsbury
  1. Shayne Salsbury
  2. Tuesday, 5 October 2021 19:50 PM UTC
A support ticket has been added. Thanks
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 5 October 2021 21:33 PM UTC
Excellent!
  1. Helpful
There are no comments made yet.
Shayne Salsbury
Shayne Salsbury Accepted Answer Pending Moderation
  1. Tuesday, 5 October 2021 19:39 PM UTC
  2. PowerServer
  3. # 5

I have been running on Oracle 18c

Comment
There are no comments made yet.
Pierre Couvreur
Pierre Couvreur Accepted Answer Pending Moderation
  1. Tuesday, 9 November 2021 08:17 AM UTC
  2. PowerServer
  3. # 6

Hi,

I'm also facing that issue, hope it will be fixed soon.

Pierre

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 9 November 2021 20:34 PM UTC
Already fixed! Upgrade to build 1311.
  1. Helpful 1
Pierre Couvreur
  1. Pierre Couvreur
  2. Wednesday, 10 November 2021 07:19 AM UTC
Great ! Thank you Armeen :-) !

Pierre

  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 10 November 2021 07:49 AM UTC
You’re very welcome!
  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.