Absent Member.. Absent Member..
Absent Member..
422 views

Custom report failing after upgrade to PPM 9.14 to 9.31

Jump to solution

Hi ALl,

 

We have receiving the below error when we run one of the custom report.

SQL query is running successfully from Sql developer.

Please find error log

/opt/oracle/product/client_11g64/bin/sqlplus ppm_user/#!#*****#!#@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXX)(PORT=30650)))(CONNECT_DATA=(SERVICE_NAME=XXX))) @./scripts/ABC/SPE_FIscal_Year_COMP.sql  '/opt/ppmdev/ppm/reports/' 'rep_117605' '1' '2015'
���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������
exit code = 1
Errors occurred during command execution

 

One of the custom reports are running fine as required, but few of them fails, giving similar error.

This is failing after upgrading PPM from 9.14 to 9.31.

 

Thanks in advance.

0 Likes
1 Solution

Accepted Solutions
Absent Member.. Absent Member..
Absent Member..

we had the db_util package for sending mail from database, ppm_user did not have the required access to execute, hence the report was failing.

View solution in original post

0 Likes
2 Replies
Absent Member.. Absent Member..
Absent Member..

Hello,

 

PPM 9.2 and 9.31 integrates a change in reports for multivaluated tokens.

#@# separator has been replaced by comma.

 

PPM 9.31 patch 2 and PPM 9.32 use again #@# as a separator for tokens.

 

 

So double-check report type parameters, maybe one of them is multivaluated.

 

Regards,

Alex-H

0 Likes
Absent Member.. Absent Member..
Absent Member..

we had the db_util package for sending mail from database, ppm_user did not have the required access to execute, hence the report was failing.

View solution in original post

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.