DSXchange

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

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.

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.

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.

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

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?

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

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

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>

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

Ernie

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

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