My Oracle Support Banner

ISSUE WHILE UPLOADING XSD TEMPLATE FOR XML TYPE EDS IN THE EDD SCREEN (Doc ID 2519114.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

Unable to upload XSD template for XML type EDS in the EDD screen. UI throws error `Unable to read the XM/XSD file¿ all the time while trying with various XSD templates.

Test one: 

XML file Name: xml_test.xml 
XSD file name: TermSheets.xsd 

DIH.log : 
[22-01-19 15:36:30 PM] ~ INFO  ~ DIHLOGGER ~ 
[DataEntityServiceClient][importExportExcel]importing excel 
[22-01-19 15:36:30 PM] ~ INFO  ~ DIHLOGGER ~ [GlobalDAO][parseXML]File 
Extension:.xsd, FileName: 
/scratch/weblogic/user_projects/domains/EBA806/applications/OFSAAEBA.ear/OFSAA 
EBA.war/TEMPLATE0.xsd 
[22-01-19 15:36:30 PM] ~ INFO  ~ DIHLOGGER ~ [GlobalDAO][parseXML]getting 
Connection 
[22-01-19 15:36:31 PM] ~ ERROR ~ DIHLOGGER ~ 
[DataEntityServiceClient][importExportExcel]null 
java.lang.NullPointerException: null 
              at 
com.ofss.fsgbu.dihapp.dao.GlobalDAO.parseXML(GlobalDAO.java:554) 
[dih-app.jar:8.0.6.0.0_10150147641969] 
              at 
com.ofss.fsgbu.dihapp.client.DataEntityServiceClient.importExportExcel(DataEnt 
ityServiceClient.java:198) [dih-app.jar:8.0.6.0.0_10150147641969] 
              at 
com.ofss.fsgbu.dihapp.servlet.DIHServletHelper.invokeActions(DIHServletHelper. 
java:90) [dih-app.jar:8.0.6.0.0_10150147641969] 

Test two: 
XMl file name: sample_xml_file.xml 
XSD file name: sample_xsd_file.xsd 

DIH.log: 
DIHLOGGER ~ [DataEntityServiceClient][importExportExcel]importing excel 
[22-01-19 15:40:44 PM] ~ INFO  ~ DIHLOGGER ~ [GlobalDAO][parseXML]File 
Extension:.xsd, FileName: 
<WLS_HOME>/domains/EBA806/applications/OFSAAEBA.ear/OFSAA 
EBA.war/TEMPLATE0.xsd 
[22-01-19 15:40:44 PM] ~ INFO  ~ DIHLOGGER ~ [GlobalDAO][parseXML]getting 
Connection 
[22-01-19 15:40:44 PM] ~ ERROR ~ DIHLOGGER ~ 
[GlobalUtils][getTableColumnData]user lacks privilege or object not found: 
ALL_TAB_COLUMNS 
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: 
ALL_TAB_COLUMNS 
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) 
~[hsqldb.jar:2.3.2] 
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) 
~[hsqldb.jar:2.3.2] 
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not 
found: ALL_TAB_COLUMNS 
[22-01-19 15:40:44 PM] ~ ERROR ~ DIHLOGGER ~ [GlobalDAO][parseXML]connection 
exception: connection does not exist 
java.sql.SQLNonTransientConnectionException: connection exception: connection 
does not exist 
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) 
~[hsqldb.jar:2.3.2] 
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) 
~[hsqldb.jar:2.3.2] 

Changes

 NO CHANGE
 

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
Changes
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.