DSXchange

You need to go into that particular job's log to find out what exactly is going on. The sequence level log will not be of much help. You need the job's log.

Try searching for the key words "Exception raised in GCI subroutine". You will be amazed as to how many people ran into this error. Do an exact search.

Look in the help docs for DSSetUserStatus() function to set userstatus and DSGetJobInfo() with InfoType of DSJ.USERSTATUS.
Search this website for specific examples, this has been discussed time and again.
Regards,

There should be a resolve button at the top. Just press that to mark it resolved.

That would be, infact, the easiest way rather than coding it. GUI is better than code, isnt it

When you say job stream, do the 20 jobs have dependencies or they are fired at the same time?
Try firing just one job for testing purposes. As Craig noted, you need to capture the scheduler's output to see whats going on. Even try to monitor it at the unix level if the jobs are fired via a script.

Yes, right. Well use the hashed file method.

How about passing dynamic sql from your database stage...? Something like select * from table 2 where key not in (select key from table 1) UNION select * from table 3 where key not in (select key from table 1) UNION select * from table 4 where key not in (select key from table 1&...

Well you can populate the hashed file with another column defined as key with a dummy value say 'x'. Do a lookup in your second transformer with the key value hardcoded to the value you specified while building the hashed file, in this case 'x'. Get the second column from the hashed file which is wh...

This is a very urgent requirement A piece of advice buddy, that statement will not guarantee a quicker reply. It just rubs the posters the wrong way, as this is an all-volunteer site. As per your requirement, you said you have just one column right? So that means this is the key too, which doesnt m...

The best way to go about doing it is analyze that job, what all user-defined funtions you are using and then go in that function to see if your calling Nvl(). Even thats not necessary, just go to the manager, find that routine and initialize the variable its complaining about.

ray.wurlod wrote:

Code: Select all

select * from users where clue > 0;

0 rows returned.

You are using the routine Nvl in your job in which the variable entree has not been initialized. Look into the job, you must be using the user defined routine 'Nvl'

Ops Sorry, its DS_JOBS and not DS_JOBOBJECTS, i corrected the earlier post


Do you have that particular job log opened in the director, close all clients except the administrator client. and then try clearing it again.

In the transformer, specify the constraint as @FALSE to see the throughput in the sql select. See how much time is that taking. I am guessing that shouldnt be too long. I think the bottleneck is your target OCI.
Are these all inserts? If yes then you can utlize the bulk loader.