Hi,
I have Power Builder 2019 R2 Build 2323 installed.
The database version is '12.2.0.1.0'
The application is working fine in thick client.
But when I have deployed it, it is not working properly. All the screen is throwing the below error
"Failed to get DataWindow SQL from PowerServer (Application = xxx, DataObject = xxx, DBType = 19). Please make sure you have deployed your application correctly."
I have deployed the application using my "Oracle 10g/11g/12c" database type and also created the transaction object with "Oracle 10g/11g/12c" type only.
But still, the application is trying to connect with "Oracle18c/19c" type.
When I checked the server log, I could see that the application is trying to connect with Oracle18c/19c db type.
"PBTransaction=PBTransactionProperties[Name=Sqlca_validation, ConnectionCache =pvr12gt,DriverID=17, AutoCommitMode=NoAutoCommit, CommitOnDisconnect=True, DbType=Oracle18c/19c, ConnectionLifeTime=-1],"
Earlier I was using Power Builder 2017. I have not faced any issues in that version.
Is it any configuration/setting issue?
Can anyone tell me the solution?
For PowerBuilder, you are right.
For PowerServer, the correct DBMS is 'O10' for Oracle 10g/11g/12c, and is 'ORA' for Oracle 18c/19c. Please refer to the article below for details:
https://docs.appeon.com/appeon_online_help/ps2020/server_configuration_guide_for_net/Dynamic_transaction_object_to_connection_cache_mapping.html
Regards,
ZhaoKai
I find this confusing, but it's good to know, I've been trying to work on powerserver with ORA as dbms to 11g and 12c databases, which might explain some of the weird problems I had with especially stored procedures.
regards.