The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom report failing after upgrade to PPM 9.14 to 9.31

SOLVED
Go to solution
Highlighted
shijub
Super Collector

Custom report failing after upgrade to PPM 9.14 to 9.31

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.

2 REPLIES
alex-h
Member

Re: Custom report failing after upgrade to PPM 9.14 to 9.31

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

shijub
Super Collector
Solution

Re: Custom report failing after upgrade to PPM 9.14 to 9.31

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.

//Add this to "OnDomLoad" event