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
My old version of Firefox had the option for me to set multiple home pages. My hard drive recently failed and had to be replaced, so I had to install the newest version of Firefox. The only option I see when I go to tools, options, general is to set [More]
I have created a form in livecycle designer with either "submit by email" (sends xml file) or a submit button with a pdf chosen as submit type. The form works fine in acrobat 9 but when I click on either button and it opens my email client (outl [More]
I have many documents from school that I'd like to scan, convert to PDFs and then compile together into one PDF file. The problem is that whenever I scan a document, I can't compress it down enough without sacrificing quality, so I can't have a small [More]
I would like to be able to view all the pages of a particular website when not connected to wifi or 3G. How do I set this up?iCab mobile allows for this, and does a pretty good job. There is also an app called Off line pages you might want to look in [More]
Is there a way to configure Apple TV through the MacBook Pro? I'm trying not to buy another remote.Welcome to the Apple community. Unfortunately, there is no way at all of configuring the Apple TV from your computer. Unless your Apple TV is already c [More]
i have a 3G, and since it was new, the photos have always been blurry in the upper left 1/8th of the photo, no matter which way i hold it. has anyone else had this problem? i don't think it's a lens cleanliness issue because it did that right out of [More]
Hey guys what iPhone case do you guys think I should get?No idea what you should get.  No one has any way of knowing your tastes, wants, needs, etcRead other 2 answers [More]
Just downloaded 11.0.1.12 and now cannot find a way to sort purchases by date added.  Please help!Enable the sidebar Ctrl S The purchase link is under the itunes store in the left hand sidbar. If the Date added field is not showing right mouse click [More]
Dear all PCM experts, I am a new FICO consultant and our PM from a BW team seeking for a FICO consultant to help out in his PCM project. I have never heard of PCM. And I found that setting up PCM is not same as setting up FICO (SPRO) although some CO [More]
error E_ACT_TOO_MANY_ACTIVATIONS  What can I do?You can activate a maximum of six computers and devices. If you reach the limit, contact Customer Service to reset your activations. Alternatively, you can erase the authorization of one of your activat [More]