My Oracle Support Banner

PDR Throws: ORA-06502 At "RXC.RDC_REPORT_XML_GENERATION", Line 2151 (Doc ID 1479396.1)

Last updated on OCTOBER 09, 2018

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Information in this document applies to any platform.

Symptoms

You are attempting to run a Patient Data Report (PDR).

The process fails with the following error messages which are found in the log file:

LOG :
      Report: d:\oracle\opapps45\oc\RXCDMLPD.rep
      Logged onto server: RTPOCP
      Username: OPS$MOTSOSN

MSG MSG-00005:   Graphic PDR ends with unexpected error. Please see the java log file for details: \\rtpoc11\opa_repout\j832409.log
ERR REP-1419: 'beforereport': PL/SQL program aborted.
ERR Error occurred sending Job output to cache

The jlog file contains the following at the end:

Tue Mar 09 06:30:12 EST 2010
Starting Graphic PDR...
  reportId     : 832409
  studyName    : CTOT05
  reportMode   : 0
  prodMode     : P
  dateFormat   : STANDARD
  loc          : \\rtpoc11\opa_repout
  tmpFolder    : d:\oracle\opapps45\temp
  logFileName  : \\rtpoc11\opa_repout\j832409.log

.
.
.

Generating Control File for Patient 01001
Printing Parameters - Report Id =832409  tmpFolder = d:\oracle\opapps45\temp noBookMark =  0 currPat = 01001 aud = 0 reportMode = 0
java.sql.SQLException:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RXC.RDC_REPORT_XML_GENERATION", line 2151
ORA-06512: at "RXC.RDC_REPORT_XML_GENERATION", line 2431
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:869)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1080)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2915)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3006)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4119)
at oracle.pharma.rdc.pdr.PatientDataReport.generateFull(PatientDataReport.java:1239)
at oracle.pharma.rdc.pdr.PatientDataReport.startPdr(PatientDataReport.java:1720)
at oracle.reports.engine.EngineImpl.CRunReport(Native Method)
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:413)
at oracle.reports.engine.EngineClassPOATie.run(EngineClassPOATie.java:84)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:117)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:62)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2355)
at com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:104)
at com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:492)
at com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapter.java:64)
at com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:653)
at com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java:99)
at com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76

 




  
This occurs whenever the fully expanded Clinical Planned Event name (appended with '.<subevent number>' if document is entered using a sub event) exceeds 20 characters in length and the CPE Name contains one of these special characters  : &, >, <, ", '

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.