DSXchange

What if it is a database problem and a deadlock occurs? Have you searched your tables if they are used in that very moments by another job or process ?

Guys, it is very frustrating in the very own topic that I start to see the premium account image covering all the information I am asking for. Neither of Ray's answers are visible. If I am asking and you are answering for me, couldn't it be possible that the premium image not to exists when the auth...

Unfortunately I have found a third possibility and that is when the job is called from a sequence with the Invocation Id passed from the sequence, then it is read the job's log and not the job.InvocationId's log. So my problem is now how to read the job.InvocationId log and also another problem occu...

Hi ArndW, I am using the code bellow which takes care of the presence of Invocation Id. What I am looking for is to obtain Event column in another way, maybe by its name, rather than by its position which could always give errors if other job parameters modify the columns order in the job log. LogAr...

I created a routine that basically takes all log and inserts it into an array. LogArray = DSGetLogSummary(JobHandle, DSJ.LOGFATAL, StartTime, StopTime, MAXLOGLINES) It works fine but I discovered a little problem. If job has Invocation Id an extra column is generated in the log. Other parameters mig...

hello there, thanks chullet, good info to know for the future :) yes, Ray's answer helped in a way because it made me look at partitionings, field types and sortings all around the sequence and with a few minor modifications of sortings and nullabilities everything works now like a charm. so thank y...

good point Ray the dataset is actually the first stage in the job so Same would not be very helpful ... hmmm I dunno, I would chose Entire then but I am afraid not to mess up the data ..

hello, you know my habit of not opening new posts since similar problems are already reported in here. right now I am facing exactly the same problem described above. I have a dataset with a column MyFlagCol which is all set to value 'N'. the data is then entering an aggregator where I use MyFlagCol...

Unfortunately .log is not created not even if I use the full path to the sqlldr. I can say now that I am out of ideas

My data is not loaded. I am not sure at what .log are you thinking. Oracle .log or DataStage log ?

It was suggested to me that DataStage might not know the path to sqlldr and I am now trying to find it out.

I am almost sure it doesn't run at all since I am receiving a warning

The code from the previous post is what I put in the 2 textboxes from the Execute Command Stage. Of course, user, password are different words but they do work in command line. Perhaps it shouldn't be like this and I am doing it wrong. My logic is to tell the Execute Command Stage to execute a ksh c...

The ksh script you are calling returns with a stderr status that is non-zero ("1" in this case) and thus DataStage is assuming that it has errors. You can use a conditional trigger for the value of " ... This is all I can see from the message, the rest went to Premium Content :( I do...

I am having a sequence with Execute Command Stage. I am trying to call sql loader to insert some bulk data. I have all needed parameters and I concatenate them to obtain the needed command. I can see the built command line in Director and it is ok. I execute that command line in shell and it works f...

Turn on $APT_PRINT_SCHEMAS for this job, it will show the actual schemas between each of the stages in the job and goes a long way into finding the sources of errors. ... Many thanks ArndW, for me that did the trick and helped me find where it was the problem. The variable name in my version is $OS...