Error Code Dictionary
Moderators: chulett, rschirm, roy
Error Code Dictionary
Hi Everyonne
Is there a place where we have all the Error codes for datastage, their explanations and possible resolutions to those errors just like Oracle Ora-codes. I think this will greatly reduce the repetition of posts on the forum and direct users to the required site.
Thanks
Bob
Is there a place where we have all the Error codes for datastage, their explanations and possible resolutions to those errors just like Oracle Ora-codes. I think this will greatly reduce the repetition of posts on the forum and direct users to the required site.
Thanks
Bob
Error codes may not be always the same acorss versions.
But you can search for it
Like the list of current Job Control Error codes.
But you can search for it
![Wink :wink:](./images/smilies/icon_wink.gif)
Like the list of current Job Control Error codes.
Code: Select all
Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator ntervention (can't tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
You can also use
from TCL. You can find most of the error codes but not all.
This uses six-digit keys, so to find 81002 your query would need to add a leading zero, and use a character string.
Code: Select all
SELECT * FROM SYS.MESSAGE WHERE @ID = 'error Code'
This uses six-digit keys, so to find 81002 your query would need to add a leading zero, and use a character string.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
You can find a FAQ regarding SQL error code for failed upsert.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
API Communication Layer Error Codes
Code: Select all
Error
Number Description
39121 The DataStage server license has expired.
39134 The DataStage server user limit has been reached.
80011 Incorrect system name or invalid user name or password provided.
80019 Password has expired.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Job Control, Job handler error values.
Code: Select all
******************************************************************************
* ERROR VALUES
******************************************************************************
Equ DSJE.NOERROR To 0 ;* not an error
Equ DSJE.BADHANDLE To -1 ;* Invalid JobHandle
Equ DSJE.BADSTATE To -2 ;* Job is not in the right state (compiled, not running)
Equ DSJE.BADPARAM To -3 ;* ParamName does not reference a known parameter of the job
Equ DSJE.BADVALUE To -4 ;* ParamValue/Limitvalue is not appropriate
Equ DSJE.BADTYPE To -5 ;* Token in LimitType/RunMode/InfoType not recognized
Equ DSJE.WRONGJOB To -6 ;* Job was not run from within the current job
Equ DSJE.BADSTAGE To -7 ;* StageName does not refer to a known stage in the job
Equ DSJE.NOTINSTAGE To -8 ;* StageName was DSJ.ME and the caller is not running within a stage
Equ DSJE.BADLINK To -9 ;* LinkName does not refer to a known link of the stage
Equ DSJE.JOBLOCKED To -10 ;* JobHandle refers to a job that is locked by another user
Equ DSJE.JOBDELETED To -11 ;* JobHandle refers to a job that has now been deleted
Equ DSJE.BADNAME To -12 ;* JobName badly formed
Equ DSJE.BADTIME To -13 ;* A TimeStamp parameter was badly formed
Equ DSJE.TIMEOUT To -14 ;* Given up waiting for something to happen
Equ DSJE.DECRYPTERR To -15 ;* Decryption of encrypted value failed
Equ DSJE.NOACCESS To -16 ;* Cannot get values, Default values or Design Default values
;* for any job except the current job (Job Handle == DSJ.ME)
Equ DSJE.NOTEMPLATE To -17 ;* Cannot find template file
Equ DSJE.BADTEMPLATE To -18 ;* Error encountered when processing template file
Equ DSJE.NOPARAM To -19 ;* Parameter name missing - field does not look like 'name:value'
Equ DSJE.NOFILEPATH To -20 ;* File path name not given
Equ DSJE.CMDERROR To -21 ;* Error when executing external command
Equ DSJE.BADVAR To -22 ;* Stage Variable name not recognised.
Equ DSJE.NONUNIQUEID To -23 ;* Id already exists for a job in this project.
Equ DSJE.INVALIDID To -24 ;* Invalid Job Id
Equ DSJE.REPERROR To -99 ;* general repository interface "other error"
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'