DSXchange

snassimr wrote:And why all other jobs run more then 100 rows ?

Try to run the sequencer again and check the options in the Limits tab. Make sure that for Row limit "No limit" option is selected.

It should work fine.

Regards,
-Sumit

bryan wrote:Ensure that your datastage repository files are not missing

In your case, D_RT_STATUS file in your project directory should be present.

Thanks Bryan, it helped a lot.

-Sumit

Have you activated any filters in your Director? When you start your job with an instance, does it run correctly? Do the job entries show up in the main job's log, and if so, do they contain the instance in the log text? Thans for the reply Arnd. There are no filters in the director. The job runs f...

Hi All,

I have not yet been able to figure out the problem. The issue is bizarre but its happening. The job runs fine but the instance does not show up in the director. Any and all inputs would be appreciated.

Thanks in advance,
-Sumit

Satish, Multiple Instance option is checked in the job properties.

One thing I forgot to mention is that the Project is Protected.

Regards,
-Sumit

Hi, I have a multiple instance Server Job. When I trigger the Job after giving the invocation id I am not able to see the instance of the job in Director. Till yesterday whenever I triggered the job I was able to see the instance with name "JOBNAME.InvocationId". Today we compiled the job ...

Use a single trigger. Link to the move activity and then to the notification and do the abort routine last. In other words, run them in a serial fashion, not in parallel. Thanks Chulett. Actually we tried the same thing eariler but then we did not make the triggers unconditional. We now made the tr...

Hi, I have a sequencer job that uses a RoutineActivity stage to make a lookup to a hash file. Based on the return value of the Routine Activity the subsequent jobs are triggered. One of the trigger conditions is like this: If the return value is 'Y' then -Move the source file to a bad files director...

We found the issue. Actually we did not notice that when we were recreating the indexes it was not doing it on DS_JOBS because DS_JOBS was locked by another process. We bounced our server and ran REINDEX on DS_JOBS. All our jobs are now visible in Director.

Thanks for all the suggestions,
-Sumit

Yaa Ketfos, This is checked. We also just tried bouncing the server. The jobs still don't showup. Regards -Sumit Hi, Did you check in the Designer under Tools ---> Options --->Appeareance--->Repository Tree--->Category Customization .... Is Show Jobs Selected under Category Customization ? Ketfos

Routines are visible in Manager. I can create a new job but that job also does not show up in any of the clients. No, we did not bring the server down. This is something not controlled by and and will be done by the administrator at the end of the day. Regards, -Sumit Hi, Are you able to view the ro...

No, The jobs are not visible in any of client applications - Directory, Designer OR Manager.

Regards,
-Sumit

We have a Project which was working fine until Thursday. On Friday whichever jobs we triggered showed RUNNING in director but they were actually not running when checked in the UNIX box. Even if they were running, they were in idle state. Jobs are in idle state since friday. Today(Monday) when we lo...

Ray, the fields are Varchar.

Roy, I tried with MSSQL Server first and got weird characters in one Varchar field. For the other Varchar filed nothing got populated.
When I tried with ODBC option all the Varchar field were blank in the target.

Hi, I am facing a strange issue with DRS stage. I have a simple job that reads data from a table in ORACLE and inserts it into a table in MSSQL Server. I am using DRS stage to connect to both the databases. The reading part is fine but while writing the records into MSSQL Server the job is inserting...