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

Resolved Why do I get a -1 on retrieval using datastore/datawindow in PowerServer, but runs fine in client server mode.

  1. Issue
0
Votes
Undo
  1. Kevin Bell
    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

Powerserver 2022 using Stored Procedures - Fetch E...
Any gotchas when using the Long_connection dbparm ...
Responses (3)
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
Armeen Mazda @Appeon
  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
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
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.
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.