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

Resolved Error: Not find database schema provider

  1. How-to
0
Votes
Undo
  1. Miguel Leeuwe
    Miguel Leeuwe
  2. PowerServer
  3. Monday, 8 March 2021 17:07 PM UTC

Powerserver 2021 beta:

Oracle 19c.

When trying to deploy my PS project, I'm getting this error message for just about every datawindow object:

Error: Not find database schema provider

What's missing?

TIA

MiguelL

 

Calling a stored procedure as source for a datawin...
Accepted Answer
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 10 March 2021 10:02 AM UTC
  2. PowerServer
  3. # Permalink

After having opened a ticket the problem has been resolved:

https://www.appeon.com/standardsupport/search/view?id=6241

The problem seems to be caused by having more than one target assigned to the workspace.

Thank you Chris and ZhaoKai!

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 10 March 2021 13:46 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 8 March 2021 19:30 PM UTC
  2. PowerServer
  3. # 1

Hi Miguel;

  During a PS2021 deployment, the DBMS / DB as set in the PS Project is used to verify the DWO and in-line SQL against that DB instance. If the DB settings in the PS Project are pointing to another DB instance that uses a different schema - errors like you mention would be the case. 

  Also, it could be related to the UserID / Password you are using in the PS Project that may not have the read access privileges to the Tables / SPs, / Views, etc that the PS Deployment needs to verify your DB entities.   HTH

Regards ... Chris

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 8 March 2021 21:22 PM UTC
Hi Chris,

Thank you.

This is a newly created DB by one of my colleagues, so you might be right that some permission or similar is missing. I've been looking into it, and even though I can connect, something seems to be missing at user levels.

I've run al the 'closing processes' we usually have to run, but I still cannot run as a specific user, even when running classic pb.

I'll talk to them tomorrow.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 8 March 2021 22:37 PM UTC
Well, I've managed to get all permission right and now I can run the app successfully from 'normal' powerbuilder. Still getting the same error message. Have tried to experiment with "delimit identifiers" etc. No luck.

Next step: install oracle 19 client (right now I'm using 12c client).

Will respond if any success, if not I'll open up a ticket.

Cheers
  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.
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.