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

Resolved PowerServer Web deployment - datawindow retrieval

  1. Issue
0
Votes
Undo
  1. Anna Uden
    Anna Uden
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 11 April 2018 20:15 PM UTC

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?

  1. PowerServer Web
  2. DataWindow
Statictext mouse pointer is not working
PowerServer on new Web Site, AEM works, Apps NOT, ...
Responses (3)
logiciel egis
logiciel egis Accepted Answer Pending Moderation
  1. Thursday, 14 March 2019 13:56 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

The datasource design must be Syntax mode, not Graphic mode.

 

Jean-Philippe

Comment
There are no comments made yet.
Anna Uden
Anna Uden Accepted Answer Pending Moderation
  1. Thursday, 12 April 2018 13:13 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

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.  

 

 

Comment
Anna Uden
  1. Anna Uden
  2. Thursday, 19 April 2018 19:18 PM UTC
I believe I have this working now.  Just needed to get dw cache turned off

  1. Helpful
Anna Uden
  1. Anna Uden
  2. Thursday, 19 April 2018 19:19 PM UTC
I believe I have this working now.  Just needed to get dw cache turned off and set up on database server side correctly.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 11 April 2018 20:29 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

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

 

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.