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

Resolved PowerServer Project Error Ora-00942

  1. Misc
0
Votes
Undo
  1. Marko Gagliuffi
    Marko Gagliuffi
  2. PowerServer
  3. Thursday, 26 August 2021 14:33 PM UTC

Hi to everybody.

I was running Build & Deploy PowerServer Project and i got the error message shown in the attach image.

I really appreciate your help.

 

PD. I'm working with PowerBuilder 2021 CloudPro Edition Build 1288, and Oracle 11g as RDBMS

 

Thanks in advance.

Atte.

Gagliuffi Galjuf, Marko.

Attachments (1)
PowerServerError.png PowerServerError.png
Failed to launch / ERR_CONNECTION_REFUSED error wh...
Sharing PSvr Toolkit profiles
Accepted Answer
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 27 August 2021 05:46 AM UTC
  2. PowerServer
  3. # Permalink

Hi Marko,

PowerSerer 2021 support Oracle 12c, 18c, or 19c but not Oracle 11G, please refer to article below for details.

https://docs.appeon.com/ps2021/bk05ch02.html

Regards,
ZhaoKAI

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 27 August 2021 08:19 AM UTC
Make sure you don't use the 12.1.0.22 version of the 12c client. It has a bug:

https://community.appeon.com/index.php/qna/q-a/seek-for-advice-on-sqlca-setting-in-powerbuilder-web?limitstart=0#reply-12629

  1. Helpful 1
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 27 August 2021 08:21 AM UTC
Correction: Don't use v 12.1.0.2.2 . (I made a mistake when I said 12.1.0.22)
  1. Helpful
Marko Gagliuffi
  1. Marko Gagliuffi
  2. Friday, 27 August 2021 13:35 PM UTC
Thanks Miguel.



It was ORACLE Version....
  1. Helpful
There are no comments made yet.
Responses (4)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 26 August 2021 14:52 PM UTC
  2. PowerServer
  3. # 1

So did you check if the table used in d_servicios exists?

Maybe it's an access right problem for the user that you're connecting with on Powerserver.

 

Comment
Load more comments
Marko Gagliuffi
  1. Marko Gagliuffi
  2. Thursday, 26 August 2021 17:27 PM UTC
Not is not a graphical dw...

The DB configuration is without enclose...

Thanks.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 26 August 2021 17:32 PM UTC
I'd suggest you open a ticket on https://www.appeon.com/standardsupport/search

They'll also help you out on this post, but it'll be faster on the support site.

regards.
  1. Helpful
Marko Gagliuffi
  1. Marko Gagliuffi
  2. Thursday, 26 August 2021 22:30 PM UTC
Thanks Miguel.
  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 26 August 2021 15:49 PM UTC
  2. PowerServer
  3. # 2

is it only that 1 table?

check the login that is being used when you generate the application.  you need to be the same schema name or use synonyms 

Comment
Marko Gagliuffi
  1. Marko Gagliuffi
  2. Thursday, 26 August 2021 16:43 PM UTC
Yes, just one table, I'm just using it for testing :)

I've checked the connection and everything is right.

Thanks for your help.
  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 26 August 2021 21:12 PM UTC
  2. PowerServer
  3. # 3

This is almost certainly a RIGHTS issue in the database.

Get with the DBA to ensure that the userid to whcih you login to the database has the RIGHTS required to at least s ee the table.
If it's a testing table, you will need frull CRUD rights to that table. (Create, Read, Update, and Delete)

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.