Gettting error while trying to upload an xml in oracle report builder11g
907793May 21 2012 — edited May 21 2012REP-0069: An internal error occured. JDBCPDS-62008 : java.lang.NullPointerException
This is the error m getting while trying to upload an xml with the option Open an existing report in Oracle Forms and Reports 11g
An xml to be uploaded is as follows :
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<report DTDVersion="9.0.2.0.10" name="Simple">
<data>
<userParameter datatype="character" display="no" name="P_JDBCPDS" pluginClass="oracle.reports.plugin.datasource.jdbcpds.JDBCDataSourceFactory"/>
<dataSource name="SSRS_DB">
<plugin factoryClass="oracle.reports.plugin.datasource.jdbcpds.JDBCDataSourceFactory" signOnParameter="P_JDBCPDS"><![CDATA[<?xml version="1.0" encoding="UTF-8" standalone="no"?> <jdbcpds DTDVersion="1.0"> <JDBCQuery>Select * from TableName</JDBCQuery> <QueryDefinition>0</QueryDefinition> <driverType>jdbc-odbc</driverType> <connectionClass>oracle.reports.plugin.datasource.jdbcpds.JDBCConnectionHandling</connectionClass> <SignOnParameter>P_JDBCPDS</SignOnParameter> <jdbcElements> <element cloumnScale="0" cloumnSize="50" name="Product name" type="12" typeName="varchar"/> <element cloumnScale="0" cloumnSize="50" name="Region" type="12" typeName="varchar"/> </jdbcElements> </jdbcpds> ]]></plugin>
<group name="SSRS_DB">
<dataItem datatype="character" javaDatatype="varChar" name="Product name">
<dataDescriptor expression="Product name" order="1"/>
</dataItem>
<dataItem datatype="character" javaDatatype="varChar" name="Region">
<dataDescriptor expression="Region" order="2"/>
</dataItem>
</group>
</dataSource>
</data>
<layout>
<section name="header">
<margin>
<text name="PH0textboxH0">
<geometryInfo height="0.30210" width="3.61460" x="2.12500" y="1.43750"/>
<textSegment>
<string><![CDATA[This Is Header Section]]></string>
</textSegment>
</text>
</margin>
</section>
<section name="main">
<body>
<graph name="chart1">
<graphDefinition><![CDATA[<?xml version="1.0" encoding="UTF-8" standalone="no"?> <rw:graph dataValues="DataValues" groups="Product name" id="chart1" src="No_DataSet"> <Graph customLayout="" seriesEffect="SE_AUTO_GRADIENT" version="11.1.1.0"> <Y1Axis majorTickStepAutomatic="true"/> <Y2Axis majorTickStepAutomatic="true"/> </Graph> </rw:graph> ]]></graphDefinition>
</graph>
</body>
</section>
</layout>
<reportPrivate defaultReportType="tabular" templateName="rwbeige" versionFlags2="0"/>
</report>
Edited by: 904790 on May 21, 2012 4:00 AM