Sitemap

Amicuk Programming Answers

Error of Creating Data Server for XML

2015-10-11   Views:1

Advertisement

Hi all, When I want to create a new data server for XML in ODI, the error occur. error information: connection failed java.sql.SQLException: Unexpected token: EMP_TABLE in statement [create EMP_TABLE] My JDBC url is: jdbc:snps:xml?f=../demo/xml/MOP/M

Hi all,
When I want to create a new data server for XML in ODI, the error occur.
error information:
connection failed
java.sql.SQLException: Unexpected token: EMP_TABLE in statement [create EMP_TABLE]
My JDBC url is: jdbc:snps:xml?f=../demo/xml/MOP/MOPEMP.xml&rt=Export&ro=false&case_sens=true&s=EMP
It seems that the error is caused by the schema "EMP". But when I changed the name of schema, the error still occur...
Could you give me some advices about this?
Thanks&Regards
Yan

The replay answer
Advertisement
Hi,
Thans for your reply.
This is the DTD for my xmldoc.
<!ELEMENT Data (Department+)>
<!ELEMENT EmployeeID (#PCDATA)>
<!ATTLIST EmployeeID col (EMPID) #IMPLIED>
<!ELEMENT Education (EmployeeID, Sequence, Dgree)>
<!ATTLIST Education table NMTOKEN #IMPLIED>
<!ELEMENT Employee (EmployeeName, EmployeeID, DepartmentID, Education*)>
<!ATTLIST Employee table NMTOKEN #IMPLIED>
<!ELEMENT EmployeeName (#PCDATA)>
<!ATTLIST EmployeeName col NMTOKEN #IMPLIED>
<!ELEMENT DepartName (#PCDATA)>
<!ATTLIST DepartName col NMTOKEN #IMPLIED>
<!ELEMENT Table (Column+)>
<!ATTLIST Table importType NMTOKEN #IMPLIED>
<!ATTLIST Table parentTable NMTOKEN #IMPLIED>
<!ATTLIST Table tag NMTOKEN #IMPLIED>
<!ATTLIST Table columns NMTOKEN #IMPLIED>
<!ATTLIST Table name NMTOKEN #IMPLIED>
<!ELEMENT DepartID (#PCDATA)>
<!ATTLIST DepartID col NMTOKEN #IMPLIED>
<!ELEMENT MetaData (Table+)>
<!ELEMENT Sequence (#PCDATA)>
<!ATTLIST Sequence col NMTOKEN #IMPLIED>
<!ELEMENT Dgree (#PCDATA)>
<!ATTLIST Dgree col NMTOKEN #IMPLIED>
<!ELEMENT Export (MetaData, Data)>
<!ELEMENT DepartmentID (#PCDATA)>
<!ATTLIST DepartmentID col NMTOKEN #IMPLIED>
<!ELEMENT Column (#PCDATA)>
<!ATTLIST Column deleteKey NMTOKEN #IMPLIED>
<!ATTLIST Column isKey NMTOKEN #IMPLIED>
<!ELEMENT Department (DepartName, DepartID, Employee+)>
<!ATTLIST Department table NMTOKEN #IMPLIED>
Thanks again!
Yan

Go to See the other 3 answers

Error of Creating Data Server for XML

Category:DefaultRelease time:2015-10-11Views:130

Hi all, When I want to create a new data server for XML in ODI, the error occur. error information: connection failed java.sql.SQLException: Unexpected token: EMP_TABLE in statement [create EMP_TABLE] My JDBC url is: jdbc:snps:xml?f=../demo/xml/MOP/M[More]

Namespace not found error when creating data server for xml with namespace

Category:DefaultRelease time:-0001-11-30Views:130

Hi I tried creating XML data server in ODI with namespace in xml file. I followed the below steps but could not success in creating the dataserver. however when I remove the namespace in xml file I am able to reverse engineer the xml file. 1) Create[More]

Issue in creating data server for xml in ODI

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a XMl which has a size around 95 MB. When i tried to create data server in ODI for this xml file. I encounter below error, "oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database at[More]

What should i put in Schme while creating Data server for XML

Category:DefaultRelease time:2015-10-11Views:130

I am new to XML and ODI also. I was trying to create a data server for XML technology. I don't know what should i specify as a schmea in JDBC URL. e.g. jdbc:snps:xml?f=../demo/xml/1/file.xml&ro=false&ldoc=true&case_sens=true&s=LEO_FIZ&[More]

Error while creating data server to connect into Hyperion Financial Manag.

Category:DefaultRelease time:2015-10-11Views:130

Hi Cezar and others gurus, I need some help in the follow issue: I imported the technologie HFM (hyperion financial management) and it`s now displayed normally in the Physical and Logical architecture. The drivers imported are: HFMdriver.dll log4j-1.[More]

Error while creating data defintion in xml publisher

Category:DefaultRelease time:2015-10-11Views:130

Hi all when i am creating a data definition in xml publisher and click on apply button i got following error racle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement[More]

Creating data server for xml

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to create a dataserver for xml using following info: jdbc driver: com.sunopsis.jdbc.driver.xml.SnpsXmlDriver jdbc url: jdbc:snps:xml?f=C:/Day_Dim.xml&re=Year&ro=false&case_sens=true But I am getting following error: "Conne[More]

Query in Data server of XML Technology

Category:DefaultRelease time:-0001-11-30Views:130

Hello, We are doing Database to XML Transformation.we are achieving this successfully. But we are facing problem in XSD placeholder in target data server i.e XML Data server First time we mentioned absolute path of XSD and got target datastore by rev[More]

Creating data server for JMS Queues in ODI

Category:DefaultRelease time:-0001-11-30Views:130

hi, I am trying to create data server for JMS Queues in ODI. I am getting following error: java.sql.SQLException: Cannot load connection class because of underlying exception: 'javax.jms.JMSException: Cannot find the Connection Factory (jms/QueueConn[More]

Error while creating data warehouse tables.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am getting an error while creating data warehouse tables. I am using OBIA 7.9.5. The contents of the generate_clt log are as below. >>>>>>>>>>>>>>>>>>>>>>>>>> Schema will[More]

Error: 0xC020902A at Data Flow Task, XML Source [24515]: The "component "XML Source" (24515)" failed because truncation occurred, and the truncation row disposition on "output column "MsgLev1" (26196)" specifies failure on truncation. A truncation error o

Category:DefaultRelease time:-0001-11-30Views:130

When I was Importing data from XML to SqlServer using SSIS , I am getting this error. The import is working if i use small file and not working if I use large XMl file. Can any one of you guys help me out with the issue? Error: 0xC020902A at Data Flo[More]

Hot
I don't have a problem as much as just a lack of understanding: Question: Will I run into any problems using onEnterFrame inside a class? I know that onEnterFrame events can overwrite each other if they are written dynamically, but I'm not sure how t [More]
I have just been told by our DBA that we have to go through our code and remove the "WHERE 1 = 1" in our SQL statements on a SQL 2000 database. He said it is a performance issue when nothing else follows it (no AND's). For example (the wrong way [More]
Hello. I have a requirement wherein I need to print all the PO item which are not fully goods receipt ( open goods receipt qty). Can some one let me know exact logic and table from where data can be picked. Thank you! ArvindHi, You can check in table [More]
Help, my Mac book pro will not start, blank screen.Read this: http://www.ifixit.com/Wiki/MacBook_Pro_13%22_Unibody_Troubleshooting Sometimes this helps too: http://support.apple.com/kb/HT1379 Also this discussion provides a lot of troubleshooting; ht [More]
My iPhone 4 says I have an update but I have to be connected to wifi why ?Because the download consists of many tens of megabytes (very large).  You'll also be advised to have your iPhone plugged in when doing the download.Read other 3 answers [More]
I am in VA -> cluster -> server -. services -> SLD data Supplier -> CIM Client Generation Settings. I am trying to save and I get the following error - "Failed to set permissions for domains"  I am using administrator for the id so I [More]
Hi Guys, I just updated my Aperture to 3.2 and now every time I open it, it askes for a Serial number. Here's the problem: I don't have one! Because I bought the App in the App Store, and normally there you don't get a Serial! Can anyone help me??Hi [More]
Any one plz tell me how to install OHS web server? Thanks & Regards, Siva Pokuri.Check the following documentation: http://download.oracle.com/docs/cd/E12839_01/doc.1111/e14260/toc.htmRead other 3 answers [More]
Hello, If open a data model with 4.0.0.825 created with a previous version, the PK attributes that are FK disappear (identifying relation)Hi Philip, I have created a new model to be sure of the test details, I have created two tables in the logical m [More]
I'm using silverlight Datagrid For that DataGrid I'm binding the data from database.Very first time it is binding and the paged collection also grouping accordingly. itemListView.GroupDescriptions.Add(new PropertyGroupDescription("SkillSetName") [More]