DSXchange

Sorry Bruce, I should have also asked... Is there anything about this in the ALRT.LOG or in any trace files in the Oracle home directory? Also, was this error returned by the insert statement or by some other reference (lookup?) to Oracle? Are there any database triggers or referential integrity con...

Ouch. Not pretty. Exactly which version of Oracle 9i are you using? Unfortunately, 9i is known for throwing more ORA-00600 errors that it should. Id suggest searching metalink for that one. I presume you are using the Oracle 8i client on the DataStage server? -----Original Message----- From: Bruce W...

Hi, DataBase 9i DataStage 4.2 We are using OCI8 to insert data and getting the following Oracle error. ORA-00600: internal error code, arguments: [qersqrfc-1], [Invalid Handle], [], [], [], [], [], [] Any idea... Thanks, __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29...

The file that the operating system is unable to open is DSLOGInfo. It searches in the VOC file for a pointer to where this really is, but no such pointer exists, so an attempt is made to open the operating system file within RT_BP386.O, where compiled code for job number 386 is expected to be found....

Without customizing the code generated by compiling the routine, what you are seeking to do is not possible in DataStage versions up to and including 6.0. The reason is that a Job Activity will only accept either the names of its own parameters or literal values (quoted strings). If youre going to m...

This is a topic for an orphaned message.

The message from DSD.UVOpen indicates that the job is trying - and failing - to open a hashed file called DummyOut. Hashed file names are case sensitive; have you checked this? Otherwise, check for permissions on DummyOut. You need at least read and execute on the directory itself, and at least read...

Kasia What I would do is create a routine to return a parameter like: GetParam("ParamName"). Use this in the parameter value of the job activity. I have not tried this but I expect it would work. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message--...

I would like to do the following in my job sequencer : - a RoutineActivity stage launch a routine which recover the values for several parameters (about 15) from a hash file - a JobActivity stage should use these values for the job parameters How to pass them from the routine to the job? Thanks for ...

Hi, We get the message standing below... any idea what the problem might be? Thanks! Wim van Dommelen MESSAGE: >From previous run DataStage Job 386 Phantom 8937 [132578] Done : DSD.RUN ReadDstageparameters. 0/50 hashedPath=/appl/dstadm/Data/glas_g/Hashed DSJobController=ProcessFileControl [132580] D...

Lawrence, Ive had it appear that manager was locked, but when I minimized all other windows on my desktop, I found that DataStage Manager had displayed a dialog box that was partially under the manager window or export progress window. If you find this, click on the window and it will come to the fr...

Lawrence, If you are importing, and then Alt-TAB to another window, DS Manager may pop up a window that requires a response such as "over write job ??", but it may not be the TOP window. This will give the impression that it is hung. Check by using Alt-TAB to see if the said window is there. Andy. >...

Dear All Im having a problem when trying to import or export jobs through Dstage Manager. When I select to import or export "Datastage Components" then click on the import from file button, Manager freezes up and has to be killed via task manager. This problem is not client specific or project speci...

Hi Ray, These are the messages from the logfile: - SetGlasConnectstring..Dummy.Dummy_out: DSD.UVOpen Unable to open file DummyOut. - SetGlasConnectstring..SetValues: |SetGlasConnectstring..Dummy.Dummy_out: DSD.UVOpen Unable to open file DummyOut.| We also think it has to do something with permission...

Jobs are managed by number rather than by name, the mapping is in the DS_JOBS table (for example, SELECT NAME,JOBNO FROM DS_JOBS;). RT_STATUS22 is the status table for job number 22. For some reason, a running job (or one of its active stages) has not been able to write to this table. It might be a ...