DSXchange

You can spilt the file to get Header and trail records, when passing the trailer records use Aggregort Stage to get the COUNT on number of rows and compare with value in the Header. Input File - Header Row - Check count Trailer Agg -> Count(number of records) Hope this helps

What is your environment like ?

Can you try a simple FTP script (Unix Script) and schedule it via Cron to mitigate issue on the networking side.

Just my thoughts

I have created the XML chunks (about 5) and when I tried to embed the XML chunks (nested loops) into the Main XML document either using a Look up or Join stage I get the following error: Fatal Error: Virtual data set.; output of "APT_JoinSubOperatorNC in Join_256": the record is too big to...

Chulett,

It is creating *.ds file.

I have tried to remove the files and rerun the job, still I am getting the issue.

Please advice.

Regards
C

Hi, I have a set of jobs that extracts data and write to a dataset, teh design is as follow <sourceStage> ------> Copy Stage -----> Dataset Stage The jobs works fine, but when I tried to run the job again after a couple of weeks later (i.e. today), The job finishes OK with lots of warnings, I checke...

I am calling a Data Stage Server Routine in a Sequencer which then calls a EE job, The Server Routine is used to unpack some data in the Source file, most of the times the Routine works fine but at times when unpacking it might hit issues that were not captured, so the Sequencer Aborts after 50 rows...

when I call the Seq1 from Master Seq ?

Chulett,

The only error message that I get is below

<Sequencer name>.JobControl (fatal error from @Count_Abort): Sequence abort requested

The Routine does a count check and returns 0 if true or else returns 1 for false condition.

Please advice

Hi Ray/Craig, I tried teh following and it worked, when running I changed the Config file and it worked fine, but when the next job to load the dataset in oracle was called it was taking a while and aborting after a while. On discussions with the DBA, found that there was not enough space and the nu...

Hi All, I have sequencer1 that calls 3 jobs and a routine, the jobs design sequencer 1 comprises of teh below: Job1 -> routine -> Job2 -> Job3 The sequercer1 is called by a Master Sequencer, Sequencer1 runs fine as a stand alone but when I try to call it it within the Master Sequencer the first job ...

Thanks ray, but the problem here is when I to write to another datasets.

Dataset1 -> xfm -> Dataset2

Takes more time and aborts.

Hi, I have around 15 million records extracted and written to a dataset 1 and transformed the dataset 1 to dataset 2 ( not much changes, mostly one to one mapping), however the issue I have is it takes a while to write to the dataset 2 and takes much longer time to load the data from dataset 2 into ...

IS v8.1 has been installed on Windows having a Core duo Processor with 4 GB of RAM When I am try to create a 2 nodes configuration file, I get the following warning message: <main_program> Warning: Config file checker on node node1 can only create 3 processes. IBM recommends that ORCHESTRATE users b...

There are environment variables for handling decimal data: APT_DECIMAL_INTERM_ROUND_MODE, descrption is it specifies the default rounding mode for any decimal intermediate variables required in calculations. The default is round_inf. APT_DECIMAL_INTERM_SCALE Specifies the default scale value for any...

The main issue is we DONOT have any Cobol Copy Books, We have been given a spreadsheet with the fields with start positions and number of bytes, also there are lots of Arrays, redfinitions and Occour Depening on clauses that are not upto the Cobol Standards. Also we have one single field that holds ...