1. Kevin Bell
  2. PowerServer
  3. Tuesday, 25 July 2023 21:25 PM UTC

Using PowerBuilder/PowerServer 2022 Build 1900

We are having a issue with dataobjects returning a -1 on retrieval. This is a new PS project for an existing (very large) app. Still trying to get past  pfc_logon. I can add the same select as inline SQL and it runs without issue, however, the dataobject an error. When running in client/server mode everything works without issue. 

Note: No all our dataobjects have C# code, only a small portion.

Thanks in advance,

Kevin Bell

Kevin Bell Accepted Answer Pending Moderation
  1. Thursday, 11 January 2024 17:51 PM UTC
  2. PowerServer
  3. # 1

The issue was that the login user only had naturally granted access to limited tables. When building the project we need to log onto the database with a user that has access to the entire schema without have to run additional scripts to get writes to that schema.

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 11 January 2024 18:46 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Kevin Bell Accepted Answer Pending Moderation
  1. Wednesday, 26 July 2023 15:11 PM UTC
  2. PowerServer
  3. # 2

No changes on the dataobject at all. 

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Tuesday, 25 July 2023 23:55 PM UTC
  2. PowerServer
  3. # 3

if you didn't redeploy the webapi that can happen if the datawindow sql changed

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.