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.


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:

      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
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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
at oracle.pharma.rdc.pdr.PatientDataReport.generateFull(
at oracle.pharma.rdc.pdr.PatientDataReport.startPdr(
at oracle.reports.engine.EngineImpl.CRunReport(Native Method)
at oracle.reports.engine.EngineClassPOA._invoke(
at oracle.reports.engine.EngineClassPOA._invoke(
at com.inprise.vbroker.poa.POAImpl.invoke(
at com.inprise.vbroker.poa.ActivationRecord.invoke(
at com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(
at com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(
at com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(
at com.inprise.vbroker.orb.TPDispatcherImpl$
at com.inprise.vbroker.orb.ThreadPool$


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  : &, >, <, ", '


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

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