DSXchange

ray.wurlod wrote:Is node1 a different machine from the conductor node? ...

We only have one server available to us.

priyadarshikunal wrote:whats the value of environment variable DSIPC_OPEN_TIMEOUT? if default 30, try increasing it to 600.

and DS_TDM_PIPE_OPEN_TIMEOUT, by default it should be 720.

Our DSIPC_OPEN_TIMEOUT is set to 30 - this is something that our Admin team will have to tinker with.

The initial error on the Basic Transformer was: 1885 FATAL Thu May 14 22:45:56 2009 BASIC_Transformer_18,0: dspipe_wait(1597): Writer timed out waiting for Reader to connect. On trying to re-run the job after this failure (job is reset) we got the following on every other attempt: Event Id: 1995 Tim...

We have a parallel job which incorporates a Basic Transformer. When running a job there was a failure around the Basic Transformer due to some resources error on the UNIX server. When we restarted the job it kept failing as the Basic Transformer job was left in an invalid state. This is despite us d...

I'm afraid that I never ever sorted this problem - my jobs run almost every night without any deadlocks and it is not too important if they fail as the missed data will be picked up the following error. Still don't understand how there can be deadlock on a select statement - it maybe on a worktable ...

Thanks for the reply. I have been over at the DBA's desks and have gone through logs/housekeeping etc all of which have shown nothing up. My area of expertise is in the Database area so I have (in my mind) exhausted all areas of the database. It is doubtful that there were adhoc queries running as i...

I have a Multi Instance Job Sequence (10 wide) that is started concurrently. The first thing the Job Sequence does is to run an underlying Server Job (again multi instance) which attaches to a SQL Server selecting between 50 - 500 rows per instance. Each result set is written back to a different has...

I've read a great many threads on Parallel Jobs vs Server Jobs on topics such as which to use and when, BASIC vs 'C', and the future threat to Server Jobs being removed from the Product going forward. These fears have been alleviated somewhat by some of the comments on this forum. However, it seems ...

This is what I have done to get the log information for datastage job runs. (1) RESET Job before running it and then run following commands dsjob -lognewest $Project $SequencerName.$DSN > Filename first_event_id=`cat FileName |grep Newest | awk '{print $4}'` first_event_id=`expr $first_event_id + 1`...

I tried to create a simple loop Job Sequence that I could send to Support that mimicked the behaviour described above rather than send the entire Job Sequence that I have(had). Each example that I created worked differently (and as expected) contrary to the problem I have described. I can only imagi...

I will post back the response that I get - maybe a few days before I can do this though as I am on a two day week this week. Thanks for your help.

Yes my loop is as simple as you have stated. The example in the Designers Guide is the exact scenario that I am looking at. Referring to this example, if I took the waitabit routine out of the job sequence and piped the failure trigger from server job "networkwrite" then the code would not...

Thanks for the answer but I do exit the loop on success which is usually on iteration 1 of 3. The FTP Activity only stays in the loop on Failure "otherwise" it goes down the "Continue on success" path. What I am trying to say is that when the FTP does fail the loop is exited down...

I have a Job Sequence where I FTP files to another server. The FTP activity is within a StartLoop...EndLoop activity which is set for 1 to 3. i.e. if the first FTP attempt fails then the process will go round the loop and retry it 3 times. If the FTP fails on the 3rd attempt then it should follow th...

Thanks for the response - looks like we won't be going towards Hawk for a while until I find the time to learn PX. I'd love to come out to the conference but seeing as I have never even had a local based training course I think the chances are very remote but I'll keep asking !!. Looks like I'll hav...