DSXchange

Hi thanks for responding, yes the checkpoint is enabled, the issue is I don't know why all the the parameters values are getting assigned to the first parameter and why are they having "?" in them, don't know whether that is causing the issue. I saw this below thread, but there is no defin...

Hi thanks for responding, yes the checkpoint is enabled, the issue is I don't know why all the the parameters values are getting assigned to the first parameter and why are they having "?" in them, don't know whether that is causing the issue. I saw this below thread, but there is no defin...

Hi all, any ideas please?

Hi I'm trying to restart an aborted sequencer using the below dsjob command $DSHOME/bin/dsjob -run -mode RESTART -warn 0 $parameter $dsproj $sequencername for this sequencer all the parameter should run with the default values, so i'm not assigning any value for the "$parameter", when I su...

I don't think so, there is a lot of space and I tried writing the named pipe file to other directories as well, but facing the same issue.

Is there anyway to track what the netezza connector stage is doing, like enabling 'tracing' for the data, anything for specific stages?

Thanks for your response, I saw that and tried writing the named pipe files to a different directory, even then I'm facing the same issue.

As it is working for 100k records, It seems something is blowing up when number of records beyond a certain point.. not sure what is happening

Hi I'm having a job, where i'm extracting data from Netezza table using Netezza Connector stage and inserting into another Netezza table ( Netezza connector stage). the job works perfectly when i load around 100,000 records, It aborts with the below error message if the load count exceeds beyond 100...

why is it like this, Is there any way to avoid it?

I had a look at the job control basic code, I'm seeing all the variables are getting assigned first, but I don't understand why the user variables are getting refreshed when i enabled the checkpoint?

Hi Please assume below is the structure of my sequencer JobActivity_1--->UserVariable_1---->JobActivity_2---->UserVariable_2--->JobActivity_3----->JobActivity_4 Checkpoint is enabled in the sequencer I'm assigning DSMacro "pCurrenttime=DsJobStarttime" and defining some other variables in U...

Hi I have a sequencer which has to run in a loop for a maximum value in a table, i tried searching this forum and googling but couldnt find a way to pass the maximum loop count to the start loop activity ( please let me know if there is a way to do it), then now i'm thinking to pass that value as a ...

Hi
I have found a way to do this, instead of directly connecting to the job
activity again, i used a sequencer stage and start and end loop to finish
this.

thanks for your response..

MJ

Hi I'm using a netezza connector to extract a data and passing that to a dataset, at the middle of the job, the job got aborted due to the below issue, i have searched this forum, but finding various different reasons for it, but nothing related to netezza, can someone show some insight on this? err...

The loop back again is not from anywhere, its just from the Execute command stage which is very next to the job activity, i have tried to put a small diagram hope it helps first_test_job-----lk_on_pass---->Consecutive jobs | /\ lk_onfail | | lk_loop_back_after_sleep | | \/ | Execute_cmd_stg (sleep c...

Hi I have a scenario in the sequencer, I have a test job activity stage, which will run first, if it finishes successfully the rest of the job activities has to run, if it fails, then after one hour the job has to again rerun (i'm using the sleep command in the execute command stage to do the wait a...