Absent Member.. bzdafro Absent Member..
Absent Member..
283 views

Anyone know what causes SQLPLUS_VERSION setting to be empty in server configuration report?

Hi,

 

We are still unable to run some out of box reports from our PPM 9.12 Linux server.   It has something to do with sqlplus and or profile settings.   If we run the server configuration report from the workbench, the com.kintana.core.server.SQLPLUS_VERSION   setting is empty.     SQLPLUS  line is set to sqlplus.   If I log onto the server via ssh, which sqlplus works. 

 

Has anyone run into this when setting up new servers?   I'm guessing its easy fix but not making progress with our HP case.  

 

Thanks

 

0 Likes
1 Reply
Established Member.. Utkarsh_Mishra
Established Member..

Re: Anyone know what causes SQLPLUS_VERSION setting to be empty in server configuration report?

Previously we also faced the same issue and it got resolved by setting com.kintana.core.server.SQLPLUS_VERSION parameter in server.conf file

 

 

SQLPLUS_VERSION parameter controls how empty or blank parameters are passed to Sqlplus.

It could be either "" (double quotes) or '' (single quotes). PPM chooses either one based on SQLPLUS_VERSION version.

 

So set below parameter in server.conf (make sure the sqlplus version is supported by your PPM version) and then run kUpdateHtml.sh

 

com.kintana.core.server.SQLPLUS_VERSION=11.2.0.4

 

In case the issue still persists then login to Server (machine) and run the command which is there in the Report (i.e. call the SQL script from server). This will give you exact root cause or will let you know incase there is any setting issue in .profile file.

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.