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

mike S Accepted Answer Pending Moderation
  1. Tuesday, 25 July 2023 23:55 PM UTC
  2. PowerServer
  3. # 1

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

Comment
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.
Kevin Bell Accepted Answer Pending Moderation
  1. Thursday, 11 January 2024 17:51 PM UTC
  2. PowerServer
  3. # 3

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.