Initially created a JOBsequence with a few sequence, these are independent with no dependencies, but When adding more jobsequences(with no dependencies) to the exsisting one i'am seeing this error message
============================================== Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project Dhl_Flat_Oracle
(Internal Error (81021))
===============================================
Where (designer/director) and when (runtime,save,open,add) are you seeing the error message? If you save-as another name does the new one have the same error?
Actually i had placed 10 job activitys on the sequence canvas and ran the sequence . every thing is fine and data has been populated to the subsequent target tables. on the same canvas then i added another 8 job activitys , when i try to run it then it is throughing this error. all my 18 jobs are compiled and they are working fine when i ran each job individually.
I am not aware that why this error has happened, Kindly through me a light on it that what are the area's that had a problem which is throughing me this kind of error
Where (designer/director) and when (runtime,save,open,add) are you seeing the error message? If you save-as another name does the new one have the same error?
I had done this on designer , while saving the sequence i am getting this problem, i tried to save the same sequence with another name , it is throughing the same error.
Are you running on multiple machines (MPP)? The conductor, section leader and player processes communicate via TCP, and with 16 jobs x N stages chances are you have overloaded the capacity of the processes all to communicate simultaneously. For example all processes must relay warnings and errors to the conductor process, which is the only process that writes to the log.
However, since the error is being reported from DSR_RECORD, which is a helper subroutine that accesses records in the DataStage Repository, I don't believe that is the appropriate diagnosis. It may be that one of your Repository tables is in need of verification and/or reindexing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Something (possibly intermittent) has gone awry between processes, dsrpcd, dsapi_server, dsapi_slave. Exactly where is not reported.
Establishing a new connection is likely to fix this problem.
I am relatively new to the admin side of DataStage, and have not been able to take an admin class yet either. I am researching an issue that is similar to this and found Ray's SQL query above.
How do I run this? I tried running with dssh and got the following error message:
myserver:/u001/Ascential/DataStage/DSEngine> bin/dssh
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: Wed Apr 25 07:48:38 2007
>select * from sys.message where @id = 081021;
DataStage/SQL: Table "sys.message" does not exist.
Am I running this in the right place? Where can I find documentation on what tables are in the database repository and how to use them?