Error Code Dictionary

babbu9 · Post by **babbu9** » Fri Feb 24, 2006 9:48 am

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

kumar_s · Post by **kumar_s** » Fri Feb 24, 2006 9:51 am

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

kumar_s · Post by **kumar_s** » Fri Feb 24, 2006 10:10 am

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.

kumar_s · Post by **kumar_s** » Fri Feb 24, 2006 10:27 am

You can find a FAQ regarding SQL error code for failed upsert.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 24, 2006 2:45 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 24, 2006 2:46 pm

In the next ("Hawk") release is promised an error code meanings and remedies manual.

kumar_s · Post by **kumar_s** » Sat Mar 10, 2007 3:46 am

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.

DSguru2B · Post by **DSguru2B** » Sat Mar 10, 2007 4:49 pm

Wow, Kumar, you have a treasure of all these error codes

kumar_s · Post by **kumar_s** » Sun Mar 11, 2007 11:40 pm

Which ought to be obsolete in upcomming version.

oacvb · Post by **oacvb** » Mon Mar 12, 2007 12:37 am

Anyways good work kumar. Keep going.

DSguru2B · Post by **DSguru2B** » Mon Mar 12, 2007 6:47 am

kumar_s wrote:Which ought to be obsolete in upcomming version.

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.

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 2:53 am

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"