PowerServer Web deployment - datawindow retrieval

1
0
-1

I am using PB 17 R2 and have the PowerServer installed. I'm running into issues with retrieving data when using a datawindow.  I can connect to the database, issue embedded sql and get data back, and can use a dynamically created datawindow and retrieve data.  But if I just use a datawindow control on the window and issue a retrieve, I get 0 rows back and no errors. 

I'm sure it is something I don't have configured correctly but I can not find the issue.  Any suggestions?

Question Tags: 

Answers

Chris Pollach answered PowerServer Web deployment - datawindow retrieval

1
0
-1

Hi Anna;

  • For your PowerServer Application Profile .. make sure that you have the PBL that contains the DW object(s) in the profile`s library list.
  • Make sure that the Data Source you defined in PowerServer is pointing to the correct DB instance
  • Check your logic on the DBError event of the DW Control and/or DataStore that would trap any DB error.
  • Also check your logic on the DC or DS's Error event as well.

HTH

Regards ... Chris

 

Anna Uden answered PowerServer Web deployment - datawindow retrieval

1
0
-1

I created a test app that has minimal code in it.  I did find in the PowerServer Toolkit  configuration that the Data Source Profile for my database will not connect when you click the Test Connection button.  I get the error, 12506 The input function type () is invalid.  No code can be found to match this type!

However, when I go into the AEM manager-->Server-->Resources-->Data Source on my PowerServer, the connection is set up and it tests successfully.  I've read that this can be due to different versions of PowerServer/Builder between my desktop and the server I'm deploying too. 

My PowerServer is on this version and is installed on Windows 2016 running IIS 10.0:  Appeon PowerServer 2017 Build 1689.00 64-bit Edition

My PowerServer Toolkit on my desktop is Appeon PowerServer Toolkit 2017 R2 Veersion 9.0.1756

I'm connecting to SQL SERVER 2016 using the MS SQL Server Native Driver for the database.  

 

 

auden@esu3.org's picture

I believe I have this working now.  Just needed to get dw cache turned off

auden@esu3.org's picture

I believe I have this working now.  Just needed to get dw cache turned off and set up on database server side correctly.