Primavera P6 Professional 21.12 Login exception case sharing

Not long ago, a friend inquired about the abnormal login of P6 Professional. Because this problem is quite special, I will share it with you now, hoping to provide reference for peers/users who encounter similar problems

First introduce the basic information of P6 installation:

• APP server (App): WeblogicServer 12c 12.2.1.2.0
• DB server: Server 2019, with AD domain, Oracle Database 18.3c, single instance without CDP/PDB
• The client system is Windows 10 with AD domain

Currently win10 has been in accordance with the corresponding version of P6 Professional, directly using the database direct connection method, the configuration and testing are smooth

At the same time, I also tried the cloud connection, namely CloudConnectionPro, I thought it would be completed smoothly, but when I log in to professional, it prompts

Seeing this, I thought it was a very simple problem. It is easy to think that it is the problem of the P6 software itself, not the database link environment, so I uninstalled, checked the program files, and re-selected the installation path (non-system disk), the problemstill

Thinking that the Oracle Database Client is missing, the wrong version selection may also cause the exception, so I chose the 12c and 18c Client programs successively (the 12c was chosen because I had served the 19c db for a large customer, combined with experience,found that its compatibility is very good), install it

....

The problem persists

...

Helpless, look for the official SUPPORT knowledge base to understand the situation,

Not searching for the same question, but here are the most similar

Official detailed solution ideas

But obviously the solution (Solution) is not right, after all, my case itself does not carry data, it is a completely new system

...

Returning to the essence of the problem, in order not to affect the environment of my friends, I restored the problem on my home server

(Yes, fully restored)

Of course, the exception is the same

According to the advice of foreign friends, I hope to turn the problem to log data,

Seeing the last exception, I think I have a basic understanding of the reason, that is, the client system environment Professional is not effectively recognized

System environment and system environment variables, what else can it be, it can only be Oracle Client

So recheck and try to install and deploy the 18c client of the correct version, considering that 12c client 64bit and 18c client 32bit have been tried before, this time re-select 18c client 64bit

Re-Net config, re-login, success!

At this point, the problem is over

I didn't expect such a simple client version number to cause such a strange error. The database can be connected normally, but the login prompts a non-link exception, so I have to complain about P6

It should be noted that the connection name created by the Net Manager connection information configured on the client does not need to be actually used. At this time, Professional only needs to monitor the Net configuration.

There is not much sharing in this industry, I hope more interested friends can participate, discuss or cooperate together!

I can provide online technical services for Oracle a variety of products, including product deployment and maintenance, please contact [email protected] or Phone/WeChat:18620728408