Error in the XML Input Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Mon Nov 12, 2007 11:38 pm
- Location: Hyderabad
Error in the XML Input Stage
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
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.
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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.
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 9
- Joined: Mon Nov 12, 2007 11:38 pm
- Location: Hyderabad
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.
External_Source_0,0: Import complete; 1 records imported successfully, 0 rejected.
Sequential_File_2,0: Export complete; 0 records exported successfully, 0 rejected.
-
- Participant
- Posts: 9
- Joined: Mon Nov 12, 2007 11:38 pm
- Location: Hyderabad
swathi-
May be the below link will help you!!
http://dsxchange.com/viewtopic.php?p=26 ... 538#265459
May be the below link will help you!!
http://dsxchange.com/viewtopic.php?p=26 ... 538#265459
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Participant
- Posts: 9
- Joined: Mon Nov 12, 2007 11:38 pm
- Location: Hyderabad
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>
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
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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
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