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

Resolved Fail to generate dwsql

  1. How-to
0
Votes
Undo
  1. Bryant Burnard
    Bryant Burnard
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 12 February 2021 17:26 PM UTC

Hi,

Just updated to PB 2019 R3 Build 2670, Runtime 19.2.0.2670 from PB 2019 R2 all CloudPro editions. I am using PowerServer (PB Edition 2020 Build 2670) and Ora Client 19, 32 bit. I was able to deploy to the power server without issues in R2, but in R3 I am getting the following error:

Fail to generate dwsql

If I test my connection in the Dababase Settings:

I can't connect.

using the Edit Data Source;

I can.

Suggestions? Should I be using the Oracle instant client?

 

 

 

 

 

Install PowerServer Toolkit failed
Empty String in Appeon Server and Oracle 19c
Responses (3)
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 12 February 2021 17:40 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

You need to fix your connection in the PS client database type profile configuration.  If it can't connect to the database then it can't generate the dwsql

 

sounds like your client workstation can't get to your oracle database, but your powerserver (on the server) can?

 

 

Comment
There are no comments made yet.
Bryant Burnard
Bryant Burnard Accepted Answer Pending Moderation
  1. Friday, 12 February 2021 17:54 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

You are correct Mike, the client can't connect. Any suggestions on what to change? I know the user name is good, SQL Plus can connect, and so can the PB client.

Comment
There are no comments made yet.
Bryant Burnard
Bryant Burnard Accepted Answer Pending Moderation
  1. Tuesday, 16 March 2021 18:02 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

The Oracle ODAC for 19c wasn't configured correctly, altered this and I can make a connection now.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 16 March 2021 18:08 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.