Search found 14 matches

by OAC
Thu Jun 16, 2005 12:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error:- ORA-01008: not all variables bound from jobs
Replies: 23
Views: 13807

Hi,

It is not User Defined Query, I am using the version 7.5.1A. The same job is running perfectly in 7.0.42. Both are poing to same database.
by OAC
Thu Jun 16, 2005 11:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error:- ORA-01008: not all variables bound from jobs
Replies: 23
Views: 13807

Error:- ORA-01008: not all variables bound from jobs

Hi, I wrote a job which retrieves a list of columns from one table and then in destination table it inserts the value. All the columns are mapped to destination table. We are passing null values for the column for which the source is not available. While running the job i got the following error. OR...
by OAC
Tue Jun 14, 2005 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error While importing job from 7.0.39 to 7.5.1.A
Replies: 1
Views: 1085

Error While importing job from 7.0.39 to 7.5.1.A

Hi, We have a job which is working perfectly in the version 7.0.39, while importing the job into new version 7.5.1.A we received the following error. Appreciate the help to resolve the problem. Error Message received while importing the job:- Problems encountered upgrading job JpmClsfnIntIndustryHie...
by OAC
Tue Mar 15, 2005 10:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error While Sending Mail from Routines
Replies: 3
Views: 1494

Hi,

I checked that also, Space for temp folder is availale. I checked in all the folders, it was fine. But still receiving such erros.

Thanks,
O.A.C.
by OAC
Tue Mar 15, 2005 5:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error While Sending Mail from Routines
Replies: 3
Views: 1494

Error While Sending Mail from Routines

Hi, I am trying to send a mail from routines which uses DSSENDMAIL function to send a routine. But i am unable to do that, i am getting the following error message. Error Is:- Error when executing command: /app/ascential/DataStage/Projects/PMDemoDB/sendmail_SeqDWPAT.sh *** Output from command was: *...
by OAC
Tue Jan 04, 2005 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts After 50 Errors Logged
Replies: 5
Views: 3144

I am running from a sequencer. No Limit Warning is set for that sequencer also. I want to run eventhough it logs more than 50 errors.
by OAC
Tue Jan 04, 2005 12:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts After 50 Errors Logged
Replies: 5
Views: 3144

Job Aborts After 50 Errors Logged

Hi,

I am running a job and it gets aborted after loggin 50 warnings eventhough the limits for warning is set as No Limit. Please let me know how to solve this issue. It is very urgent. Appreciate if i get help from this forum
by OAC
Tue Dec 21, 2004 3:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to import a routine
Replies: 6
Views: 2345

I am able to import the existing jobs to a protected project. Why the routines are not so? really i am getting confused :? . Please let us know is there any other way to import a routine into protected project.
by OAC
Tue Dec 21, 2004 2:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to import a routine
Replies: 6
Views: 2345

Already i have the routine in protected project. But i modified the routine in Development environment and wanted to import the routine in QA environment which is protected. Please let us advise how to import routine in this scenario.
by OAC
Mon Dec 20, 2004 8:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to import a routine
Replies: 6
Views: 2345

Not able to import a routine

Project in QA Environment is protected.I modified one existing in Development Environment. But i am not able to do.While importing i received the following error message "No Objects Found for Import:. Please give me a solution for this.
by OAC
Mon Dec 20, 2004 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Attempting to Cleanup after ABORT raised in one of our job
Replies: 2
Views: 1859

Attempting to Cleanup after ABORT raised in one of our job

We have a job which calls a routine subject to the availability of file. It is working fine in our Development Environment, Whereas it aborts in QA Environment. In QA we are getting the following error message. Attempting to Cleanup after ABORT raised in stage JpmFileLoadMail..JobControl It is helpf...
by OAC
Mon Dec 20, 2004 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts while OCI stage is used as Lookup
Replies: 4
Views: 1755

I think it is because of your solution. Thanks.
by OAC
Sat Dec 18, 2004 11:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts while OCI stage is used as Lookup
Replies: 4
Views: 1755

Hi,


It works fine now :D . Really i don't understand why it happens :? ? Project is protected in the environment where it gave problem. Is this is the problem?
by OAC
Sat Dec 18, 2004 10:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborts while OCI stage is used as Lookup
Replies: 4
Views: 1755

Job Aborts while OCI stage is used as Lookup

One of our Server job uses OCI as a look up and while executing the job in Development Environment it is working fine. Whereas in QA Environment, it is not working fine and we are receiving following error "Table Name is a required link property for Link DSLink5". I don't know why it is?Pl...