DSXchange

Hi, I'm trying to compile a parallel job with transformer, it's throwing an error while compiling and the job is compiling fine if there is no transformer stage. Below is the error Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 16:33:09(000) <main_program> IBM WebSphere DataSta...

Hi, I'm using a istool option to export and import jobs from one box to another box. I went to below path /apps/IBM/InformationServer/Clients/istools/cli and gave a following command ./istool export -domain appppp04:9080 -u Srinu12 -p 123rin -ar test1.isx -pre -ds '-incdep -base="hipwd02.bentle...

Thanks for the information Ray.

Hi Ray, There is no duplicate. I tested with so many things like keeping 99 output links and it worked fine and If I had extra link that it is throwing an error and it is simple links and with no complex logic at all, and the error it shows is misleading and as I mentioned it is limit that is causin...

Hi, I had a job which had couple of odbc stages and a transformer stage. I had 104 output links from a transformer and when I tried to compile the job it is throwing the error IIS-DSEE-TFCM-00005 11:46:33(000) <main_program> Fatal Error: Added field has duplicate identifier(): APT_TRinput0Rec99 (Com...

Hi Chulett,


Yes exactly I'm trying to do as Ernie mentioned. I will change to URL/File path and run the job. If I'm sucessfull I will let you know.



Thanks,
Raju

Hi Chulett, It's my bad. In External source I modified Source Method = Specific Programs and source Program = ls /Land/XML/Test20100121.xml | sort and column as XML_Data longVarchar no length and Nullable to No In source program I provided the unix commands ls and sort In format tab I mentioned Reco...

Hi Chulett,


The job design is External Source-----XMLinputStage------Transformer-----Sequential File Stage. I trying to parse the input XML file and trying to load the data in to a sequential File.




Thanks,
Raju

Hi Chulett,

I'm trying to read an XML file using External Source file stage.


Thanks,
Raju

Hi, The problem is due to I don't have execute permission on the file and the error was gone after I got execute permission. Now my new problem is with the syntax error at line2 xternal_Source_37,0: Source subproc: /Land/XML/Test20100121.xml: syntax error at line 2 : `newline or ;' unexpected . Exte...

HI, I'm reading an XML file using External Source stage and my job is aborting by throwing below errors External_Source_37,0: Source subproc: sh: /Land/XML/Test20100121.xml: cannot execute . External_Source_37,0: Filter status 32256; filter process failed: 126; import error at record 0. External_Sou...

Hi eostic, Thanks for reply. The problem is the end tag that is missing from my XML. directory end tag is missing. So I got the above error. <directory> <customer name="Acme" zone="Midwest"> <division>Chemical</division> <city>St. Louis</city> </customer> After fixing the XML it ...

Hi, I had an XML document. I'm using folder stage to read data from XML and parasing to the XML input stage but I'm getting below warining in my job : XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 2, column: 96333757): The input ended before all started ...

Thanks Ray it is working now after I changed it to decimal as you said

Hi, I'm trying to divide two integer numbers num1 and num2 in transformer and their values are 285363/362089 and the result is 0.78810 and I'm trying to write this to a output field out1 decimal(5,2) but I'm getting a value of 000.00 instead of 000.78. I searched the form on how/why floating point n...