Error in the XML Input Stage

swathi.yanala · Post by **swathi.yanala** » Mon Jan 21, 2008 7:11 am

Hi,

I am new to XML Stage. Getting the following error in the XML Input Stage while using sequential file to read the XML document.

XML_Input_0,0: Error occurred in call to ORPHCallActivePluginInitialize().

In the source Sequential file I have given a single column. Also I am writing the data in a Flat File. Please tell me any of the options that I missed to enter in the XML Input Stage or any other parameter that I have to give in the Job.

Regards

eostic · Post by **eostic** » Mon Jan 21, 2008 6:26 pm

For starters, don't use the Sequential Stage to read your XML document. Search thru here and find info on using the External Source Stage.

eostic · Post by **eostic** » Mon Jan 21, 2008 6:27 pm

For starters, don't use the Sequential Stage to read your XML document. Search thru here and find info on using the External Source Stage.

swathi.yanala · Post by **swathi.yanala** » Tue Jan 22, 2008 3:39 am

I have tried the External source stage but that also is not solving the problem. Data(XML File name) is going from the External source to XML Input Stage but not going out of the XML Input stage into the Seq File.

External_Source_0,0: Import complete; 1 records imported successfully, 0 rejected.
Sequential_File_2,0: Export complete; 0 records exported successfully, 0 rejected.

sjordery · Post by **sjordery** » Tue Jan 22, 2008 4:48 am

This usually means that your xpath expressions don't match the incoming XML document. Worth double checking them.

How did you create the xpaths - XML Meta Data Importer?

Cheers,
Stu

swathi.yanala · Post by **swathi.yanala** » Tue Jan 22, 2008 7:00 am

yes, I have created the xpaths using XML Meta Data Importer itself. I am taking only three columns for my output out of the many columns. So checked the Xpaths too. All the three are in proper syntax. What else could be the problem?

chulett · Post by **chulett** » Tue Jan 22, 2008 7:53 am

If they were proper proper it would all be working. How about posting a sample of the XML and your XPath expressions?

dspxlearn · Post by **dspxlearn** » Tue Jan 22, 2008 11:29 am

swathi-
May be the below link will help you!!
http://dsxchange.com/viewtopic.php?p=26 ... 538#265459

swathi.yanala · Post by **swathi.yanala** » Wed Jan 23, 2008 12:03 am

dspxlearn,
Thanks, but I have seen the link n thats not the problem as it works fine with a folder stage in server job.

chulett,
The XPath expressions and the XML that I am using are below.
With a Folder Stage in Server Jobs its working fine but requirement is for a Parallel job.

/defns:contracts/defns:contract/@type
/defns:contracts/defns:contract/defns:document_no/text()
/defns:contracts/defns:contract/defns:signature_date/text()

<?xml version="1.0"?>
<contracts xmlns="http://www.cust.org/Contract"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.cust.org/Contract contract_1.xsd">
<contract type="LEASE">
<document_no>1</document_no>
<signature_date>2003-01-01</signature_date>
<lease>
<lessor gender="MALE">
<ssn>111111111</ssn>
<first_name>John</first_name>
<last_name>Doe</last_name>
<birth_date>1948-10-12</birth_date>
</lessor>
<lessee gender="MALE">
<ssn>007007007</ssn>
<first_name>James</first_name>
<last_name>Bond</last_name>
<birth_date>1950-07-07</birth_date>
</lessee>
<good>BMW Z3</good>
<start_date>2003-07-07</start_date>
<end_date>2007-07-07</end_date>
<price>500</price>
<frequency>MONTHLY</frequency>
</lease>
</contract>
<contract type="SALE">
<document_no>2</document_no>
<signature_date>2003-04-15</signature_date>
<sale>
<seller gender="MALE">
<ssn>321889645</ssn>
<first_name>Donald</first_name>
<last_name>Trump</last_name>
<birth_date>1945-01-20</birth_date>
</seller>
<buyer gender="MALE">
<ssn>876953210</ssn>
<first_name>Howard</first_name>
<last_name>Johnson</last_name>
<birth_date>1901-01-01</birth_date>
</buyer>
<good>Empire State Building</good>
<price>2000000000</price>
</sale>
</contract>
<contract type="SALE">
<document_no>3</document_no>
<signature_date>2003-04-15</signature_date>
<sale>
<seller gender="FEMALE">
<ssn>987521441</ssn>
<first_name>Margaret</first_name>
<middle_initial>H</middle_initial>
<last_name>Thatcher</last_name>
<birth_date>1940-10-05</birth_date>
</seller>
<buyer gender="MALE">
<ssn>888993333</ssn>
<first_name>Bill</first_name>
<last_name>Clinton</last_name>
<birth_date>1950-01-01</birth_date>
</buyer>
<good>Big Ben</good>
<price>999999999.99</price>
</sale>
</contract>
</contracts>

eostic · Post by **eostic** » Wed Jan 23, 2008 7:55 am

Delete the namespace prefixes from your XPath. That may not be it, but let us know what it does.

Ernie

dsdoubt · Post by **dsdoubt** » Thu Mar 27, 2008 1:25 pm

Swathi, does it worked for you? Any change that you made?

deesh · Post by **deesh** » Fri Apr 04, 2008 2:31 am

Hi swati,
better to use external souce from File(pallete). in that one you can give option and use in specific file programme
give like this= ls filepath ex: ls jaga/enti/file1

after the can approach in xml input transformer

in XML input transformer u can give option

In INPUT there is both options 1. xml input 2.URL/FilePath
instead of XML input u can give URL/file path
it would be work

if any u need help
can mail to me deeshline.info@gmail.com