DSXchange

Hi Craig, Good News! It worked finally. Yes both of the above mentioned are files found in project account path. I just thought about and gave a try on one of your suggestion. We did renamed to SDKSequences.bkp and D_SDKSequences.bkp and ran the routine and it created new files again and the seq val...

We just did copied the SDKSequences from the PROD directory craig and placed it in our dev server directory.

I see two files has been copied
1. SDKSequences
2. D_SDKSequences

Wondering why sdk utility throwing the error still

The above routine uses the sdk routine KeyMgtGetNextValueConcurrent . When i test with a argument as 'BATCH_SID' it fails with below error. :( TEST #1 ******* Arg1 = BATCH_SID Test failed. Program "TSTKeyMgtGetNextValueConcurrent.B": Line 3, COMMON size mismatch in subroutine "DSX.KEY...

Again the file has been found and the file name is SDKSequences. But still the routine fails saying "DSU.KeyMgtGetNextValueConcurrentBATCH": Line 39, Improper data type.

Oops. Craig/Ray, The problem is the sequence job uses a routine in the beginning of job which fails and unfortunately all seq jobs have that routine called in the beginning of the job. The routine is GetNextBatchNumber. So the issue is narrowed down to routine. They have migrated the routine and com...

Ray, No Ray. The <job name> is actually seq job name. The job design has routine activity and job activity. But the problem here is sequence aborting even before any job activity/routine activity is triggered. The below 4 lines are the only log i get in the seq when i run. Moreover this is a running...

When I run any sequence job in newly created projects it fails with below error message. Director log: Starting Job <job name> Environment variable settings: (...) Attempting to Cleanup after ABORT raised in job <job name>..JobControl Job <job name> aborted However the server jobs run fine. We creat...

Hi Ray, The installation was successful. I can see jobs in drector client. When I open designer from director client it opens the respective job. I could open a job even from menu ie., File-> Open and view the stages as well. And even one time the designer showed the reporsitory contents but when I ...

I recently installed DS and when I log in to DS for first time I couldn't see any repository items for my id and only in my machine :( Where as when I login from other machine with my credentials it is showing all jobs and other default folders. Even in my machine when I open from got File-> Open i ...

Thanks to everyone who gave a helping hand...
It's been found that Oracle server connection was working fine but the client connection had some problem.....That's why DS refused connection to Oracle.... Currently team was working on it resove that...

Error when i connect using a ODBC stage.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('ORA_USER','ORA_USER')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified

I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht..... I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available? Moreover don't i n...

Oracle and DS working seperately for me in Windows server edition but couldn't connect Oracle from DataStage. I'm getting TNS couldn't resolved.

Moreover I'm the admin user so no problem in accessibility.

Is there anything i have to do additional setup?

Oracle OCI Stage supports multiple queries in before as well as in after stage. You can even remove COMMIT bcoz it is available as default.
The seperator is also fine. Can u provide the metadata for Test table?

Please check whether all the queries which u gave in that OCI Stage works fine or not.