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
When I boot my computer (MacBook Pro, 15", Early 2010, 4GB RAM, 320GB HD, 2.4GHz Intel Core i5), it does nothing for quite awhile, and eventually gives me the folder with the question mark on it, signifying it can't find a startup volume. I think I k [More]
Can I open psd file made in photoshop cs3 with photoshop ps2? Thanks in advance!Actually you can open a CS3 file with smart filters in CS2 the only problem is CS2 will not understand the Smart filter and flatten it. If you leave the smart filtered ob [More]
Hello. I have lost 3 evenings of work the last week after the corruption of the iPhoto database. I lose my temper now . it was not the first time. but I'm ready to take long term action to improve the situation. I have now around 15.000 pics & someth [More]
For some reason, even when I have icon preview enabled, instead of showing the thumbnail of the image, it shows a generic JPG icon with an arrow.  This is really frustrating because I need to be able top see thumbnails of all my images at once, so I [More]
Hello there, Can anyone help me about my problem in optimizing my code in ABAP.. before i used SDF logical dbf..but simple select in BSIS,BKPF and BSEG tables are much faster than using logical dbf..but my main problem is it took a while also in proc [More]
I want to use a cursor in a stored procedure. I saw many examples on the net but none of them seem to work in Oracle 10g Express Edition. I am new to Oracle and any solution relevant to Oracle 10g XE is highly appreciated. Yosief KeseteDear user! Sim [More]
Ever since the update to 10.2, I noticed that if iTunes opens and it is not the window in focus, some of the colors were off in parts of the screen. I have recently discovered this is what happens in the Mini Player when it is not selected as the top [More]
Dear experts, I have created the a plant & assigned different storage locations under the plant. Is it possible to have MAP (Valuation) at storage location level? Is it possible to have split valuation at a plant level or is it at the Company code le [More]
Hi, We are installing FIM portal on 2 windows servers for achieving HA. Please help by sharing will it cost us two FIM Licence to do that. Thanks, VarunOn Tue, 18 Feb 2014 15:57:20 +0000, var9287 wrote: We are installing FIM portal on 2 windows serve [More]
Hello folks, Using SRSS 4.2 / SRWC 2.2 with Sun Ray Connector Windows Components software installed on the clients. Our test show amazing screen speed, and full 32 bit colour depth, great flash speed on Windows 2008 R2 RDS but no audio. Our test usin [More]