• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • datawindow differences between PowerBuilder and PowerServer

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

Resolved datawindow differences between PowerBuilder and PowerServer

  1. How-to
0
Votes
Undo
  1. Jay Hastings
    Jay Hastings
  2. PowerServer
  3. Friday, 8 March 2024 21:08 PM UTC

How do you debug datawindow differences between PowerBuilder and PowerServer?  I have datawindows that work fine in the IDE but when deployed are missing data.  I've tried changing from a stored procedure to SQL and they're still missing.

The date is a string and the other two are numbers.  I've attached the Model for this dw if that helps (after changing extension to txt)

PowerBuilder

PowerServer

 

Attachments (1)
D_Rpt_Mas_Label_Svp_Drug.zip
What if the reverse proxy (NGINX) goes down? How w...
General questions regarding Docker and Kubernetes ...
Responses (2)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Friday, 8 March 2024 21:51 PM UTC
  2. PowerServer
  3. # 1

Hi Jay,

 

What's the name of the missing columns? You can try running the Web APIs locally on SnapDevelop. The IDE's Output window will show you the SQL statements as they're executed and thus get a little more info on what might be going wrong.

 

Regards,
Francisco

Comment
mike S
  1. mike S
  2. Saturday, 9 March 2024 16:05 PM UTC
the datawindows are not different, AFAIK. the difference is the use of webapis vs direct connection to the database. If the webapi's were not updated and the columns are new, i would expect you to get a lot of major errors rather than just 'missing' data if the webapis were not updated.

My guess is that you are connecting to a different database and it has nulls for those columns when using powerserver.



are you connecting to the same database when using powerserver as when you are using powerbuilder?
  1. Helpful
Arnd Schmidt
  1. Arnd Schmidt
  2. Saturday, 9 March 2024 16:53 PM UTC
Not only data is missing. Expires date also differs.
  1. Helpful 1
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Monday, 11 March 2024 10:03 AM UTC
  2. PowerServer
  3. # 2

Hi Jay,

What PowerServer release are you using, is it 2022 R3? If you can reproduce this issue exists in 2022 R3, please report it (including a small PowerBuilder case) via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/

Regards, Logan

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.