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

Resolved Build cloud errors

  1. Issue
0
Votes
Undo
  1. Marco Laroche
    Marco Laroche
  2. PowerServer
  3. Tuesday, 23 May 2023 14:45 PM UTC 
Good morning.

I'm experimenting with PBServer 2021. I'm using a simple app we have that compiles and runs smoothly as a client/server.

When I launch the 'Deploy Cloud', the compilation gives me a large amount of messages: "C:\POWERBUILDER\PIC\AppPic\pic.pbl|ds_pi_ressource_techno_child_asc Error: ORA-00942: Table or view does not exist"
The BD instance is in my opinion well configured in the Cloud project. The tables exist without any possible doubt. But I think the compilation is not using my BD connection. (Oracle)

If anyone has any suggestions, I would like to understand the situation.

Thanks
Run PS but failed with error
avoid dberror on Datawindow not existing initially
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 May 2023 16:25 PM UTC
  2. PowerServer
  3. # 1

In this screen, did you configure username and password that has full admin read/write rights to all the tables?  https://docs.appeon.com/ps2021/bk04ch13s02s02.html#Creating_a_cache_for_Oracle

Comment
Marco Laroche
  1. Marco Laroche
  2. Tuesday, 23 May 2023 19:05 PM UTC
My connection is defined (strong users) and I did the connection test.



Is it possible to test this connection somewhere? I mean via an ISQL command for example?
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 23 May 2023 20:24 PM UTC
Hi Marco, This error you mention is always caused by one of 3 reasons: 1) the database is Oracle 11g or older, 2) the account configured in the project object doesn't have proper rights, or 3) the table mentioned really doesn't exist in the particular instance of Oracle you are connecting to. I know you are using Oracle 19c, so if it is not problem #2 or #3 then I suggest you open support ticket: https://www.appeon.com/standardsupport/newbug
  1. Helpful
Marco Laroche
  1. Marco Laroche
  2. Wednesday, 24 May 2023 15:53 PM UTC
Thanks. I'll try to check for point #2.All "SELECT FROM DUAL" works... Seems to be a permissions issue.
  1. Helpful 1
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 May 2023 14:57 PM UTC
  2. PowerServer
  3. # 2

What version of Oracle are you trying to connect to?

Comment
Marco Laroche
  1. Marco Laroche
  2. Tuesday, 23 May 2023 15:35 PM UTC
Oracle 19c
  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.