Page 1 of 1
Error Code Dictionary
Posted: Fri Feb 24, 2006 9:48 am
by babbu9
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
Posted: Fri Feb 24, 2006 9:51 am
by kumar_s
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.
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
Posted: Fri Feb 24, 2006 10:10 am
by kumar_s
You can also use
Code: Select all
SELECT * FROM SYS.MESSAGE WHERE @ID = 'error Code'
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.
Posted: Fri Feb 24, 2006 10:27 am
by kumar_s
You can find a FAQ regarding SQL error code for
failed upsert.
Posted: Fri Feb 24, 2006 2:45 pm
by ray.wurlod
Some of the client/server connection error codes that you won't find anywhere else are in the Intercall Reference Guide - this is a UniVerse manual.
Posted: Fri Feb 24, 2006 2:46 pm
by ray.wurlod
In the next ("Hawk") release is promised an error code meanings and remedies manual.
Posted: Sat Mar 10, 2007 3:46 am
by kumar_s
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.
Posted: Sat Mar 10, 2007 4:49 pm
by DSguru2B
Wow, Kumar, you have a treasure of all these error codes
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Sun Mar 11, 2007 11:40 pm
by kumar_s
Which ought to be obsolete in upcomming version.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Mon Mar 12, 2007 12:37 am
by oacvb
Anyways good work kumar. Keep going.
Posted: Mon Mar 12, 2007 6:47 am
by DSguru2B
kumar_s wrote:Which ought to be obsolete in upcomming version.
![Wink :wink:](./images/smilies/icon_wink.gif)
Who cares, only a fraction of us are actually working on the version 8.0. Rest of us appreciate the list you provided which is useful at the moment.
Posted: Wed Mar 14, 2007 2:53 am
by kumar_s
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"