Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-06502: PL/SQL: : character to number conversion error

Highlighted
Alexander (Sua)
Regular Collector

ORA-06502: PL/SQL: : character to number conversion error

Hi all

 

Last days we have problem with executing Run PPM Organization Unit Interface report

It gives "Error at line 1: ORA-06502: PL/SQL: : character to number conversion error"

 

  • We noticed that PPM doesn't create /reports/rep_xxxx.html file
  • We tried to execute commands ./scripts/krsc_org_unit_interface_1.sql "/export/PPMshare_new/reports/" "34488" "" "Y" "Y" "Y" "rep_33374" "107524" "Alexander.Sutyrin" "" "APPEND_MOVE" "N" "Y" and ./scripts/krsc_org_unit_interface_2.sql "/export/PPMshare_new/reports/" "34488" "" "Y" "Y" "Y" "rep_33374" "107524" "Alexander.Sutyrin" "" "APPEND_MOVE" "N" "Y" "" from command line and ther work well (report file has been created)

We checked with "Import Users" report and it works fine.

 

Are there ideas?

 

Thnks in advance, Alexander

1 REPLY
Celil
Esteemed Contributor

Re: ORA-06502: PL/SQL: : character to number conversion error

Hi Alexander,
could you please check PPM environment. Are all run correctly?

Celil
Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event