DSXchange

[quote="chulett"]What other errors are logged? I'm assuming that's your "From previous run..." message after you reset it, yes? ...[/quote my job is getting struck when it reaches SELECT SEQ.NEXTVAL even after 1 hour time it doesnt show up anything. So I forcibly stopped it and r...

Sainath.Srinivasan wrote:Does the user with which you are connecting to Oracle via DataStage have select priviledges on the sequence ? ...

Yeah I am the user and I have select privilages on the Datastage Sequence.

Thanks

Hi friends, Im trying to load a dimensional table from ORACLE TO ORACLE. Here in MY Targey key field is a Database sequence generated, have taken ORACLE stage and written seq.next val as custom sql. This is actually working fine in DS7.5.2. We have migrated the same job to DS8.1 , the job doesnt wor...

ArndW wrote:

karry450 wrote:... DSP.Open at address 574...

What kind of stages are you opening? ...

An Aggregrator stage and then a transformer stage and loading into ORACLE from ORACLE

Hi Friends Im trying to run a job which is migrated from 7.5.2 to 8.1 but I face some issues Abnormal termination of stage detected and when I reset the job I see the below error. DataStage Job 127 Phantom 13857 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fa...

chulett wrote:Again, what exactly are you putting in the stage that it won't accept? ...

Im putting paramfile value expression as file it shows in red and the job doesnt compile

But when I call the routine in a job activity it is not accepting if I dont supply quotes to the values. Two problems here. One is you don't call a routine from a Job Activity stage - do you mean a Routine Activity stage? And what does "not accepting" mean, what exactly are you putting in...

And you've verified that path that you log is correct and that it not only exists but you have the proper permissions on it as well? Does this work when you 'Test' it and only fail in the job or does ... When Iam actually testing the routine If I dont supplying any quotes for the values and it is w...

chulett wrote:What do you think the "current directory" is when the routine is called? Best to stick with full pathnames to avoid issues like this. ...

I have even tried passing the fullpath it doesnt work

any inputs will help me a lot

thanks

Hi Friends, My routine A is trying get the paramaterfile and read the contents ERROR Full parameter filename = / (fatal error from A): Error opening parameters file, '/', status = 2 ROUTINE #include DSINCLUDE JOBCONTROL.H Ans = 0 Equate RoutineName To "A" FullParamFileName = Trim(paramfile...

Hi Friends,

Can Any one help me with below error Im getting

DataStage Job 222 Phantom 20151
Job Aborted after Fatal Error logged.
Program "DSD.WriteLog": Line 315, Abort.
Attempting to Cleanup after ABORT raised in job

Thanks

Can you please help me with full message I cant view I dont have the membership. No, because that would create a precedent of undermining a source of revenue that keeps DSXchange alive. Premium membership is not expensive, at less than 30c (Rs12) per day. If that's too much then, well, you ARE payi...

ray.wurlod wrote:Floating point exceptions are very rare in the DataStage run machine. The fault type reported is actually the UNIX signal number (8 = SIGFPE, or floating point exception).

The problem may be in yo ...

Can you please help me with full message I cant view I dont have the membership.

Thanks

Hi There, I have four jobs in a sequence and when I run the sequence all the jobs with in ran successfully but the sequence failed with the error shown below. Job control process (pid 13007) has failed From previous run DataStage Job 202 Phantom 13007 Abnormal termination of DataStage. Fault type is...

Hi There, We have migrated jobs from 7.5.2 to 8.1 DS but when we are using ORACLE OCI LOAD STAGE(BULK LOADER) we are not able to load date data types. we have tried using timestamp and as well as date but we are getting errors like ORA-26041: DATETIME/INTERVAL datatype conversion error Can any one t...