Sunday, February 7, 2016

DATASTAGE ERROR CODES

API error codes in numerical order
CODEERROR TOKENDESCRIPTION
0DSJE_NOERRORNo InfoSphere DataStage API error has occurred.
-1DSJE_BADHANDLEInvalid JobHandle.
-2DSJE_BADSTATEJob is not in the right state (compiled, not running).
-3DSJE_BADPARAMParamName is not a parameter name in the job.
-4DSJE_BADVALUEInvalid MaxNumber value.
-5DSJE_BADTYPEInformation or event type was unrecognized.
-6DSJE_WRONGJOBJob for this JobHandle was not started from a call to DSRunJob by the current process.
-7DSJE_BADSTAGEStageName does not refer to a known stage in the job.
-8DSJE_NOTINSTAGEInternal engine error.
-9DSJE_BADLINKLinkName does not refer to a known link for the stage in question.
-10DSJE_JOBLOCKEDThe job is locked by another process.
-11DSJE_JOBDELETEDThe job has been deleted.
-12DSJE_BADNAMEInvalid project name.
-13DSJE_BADTIMEInvalid StartTime or EndTime value.
-14DSJE_TIMEOUTThe job appears not to have started after waiting for a reasonable length of time. (About 30 minutes.)
-15DSJE_DECRYPTERRFailed to decrypt encrypted values.
-16DSJE_NOACCESSCannot get values, default values or design default values for any job except the current job.
-99DSJE_REPERRORGeneral engine error.
-100DSJE_NOTADMINUSERUser is not an administrator.
-101DSJE_ISADMINFAILEDFailed to determine whether user is an administrator.
-102DSJE_READPROJPROPERTYFailed to read property.
-103DSJE_WRITEPROJPROPERTYProperty not supported.
-104DSJE_BADPROPERTYUnknown property name.
-105DSJE_PROPNOTSUPPORTEDUnsupported property.
-106DSJE_BADPROPVALUEInvalid value for this property.
-107DSJE_OSHVISIBLEFLAGFailed to get value for OSHVisible.
-108DSJE_BADENVVARNAMEInvalid environment variable name.
-109DSJE_BADENVVARTYPEInvalid environment variable type.
-110DSJE_BADENVVARPROMPTNo prompt supplied.
-111DSJE_READENVVARDEFNSFailed to read environment variable definitions.
-112DSJE_READENVVARVALUESFailed to read environment variable values.
-113DSJE_WRITEENVVARDEFNSFailed to write environment variable definitions.
-114DSJE_WRITEENVVARVALUESFailed to write environment variable values.
-115DSJE_DUPENVVARNAMEEnvironment variable being added already exists.
-116DSJE_BADENVVAREnvironment variable does not exist.
-117DSJE_NOTUSERDEFINEDEnvironment variable is not user-defined and therefore cannot be deleted.
-118DSJE_BADBOOLEANVALUEInvalid value given for a boolean environment variable.
-119DSJE_BADNUMERICVALUEInvalid value given for an integer environment variable.
-120DSJE_BADLISTVALUEInvalid value given for a list environment variable.
-121DSJE_PXNOTINSTALLEDEnvironment variable is specific to parallel jobs which are not available.
-122DSJE_ISPARALLELLICENCEDFailed to determine if parallel jobs are available.
-123DSJE_ENCODEFAILEDFailed to encode an encrypted value.
-124DSJE_DELPROJFAILEDFailed to delete project definition.
-125DSJE_DELPROJFILESFAILEDFailed to delete project files.
-126DSJE_LISTSCHEDULEFAILEDFailed to get list of scheduled jobs for project.
-127DSJE_CLEARSCHEDULEFAILEDFailed to clear scheduled jobs for project.
-128DSJE_BADPROJNAMEInvalid project name supplied.
-129DSJE_GETDEFAULTPATHFAILEDFailed to determine default project directory.
-130DSJE_BADPROJLOCATIONInvalid path name supplied.
-131DSJE_INVALIDPROJECTLOCATIONInvalid path name supplied.
-132DSJE_OPENFAILEDFailed to open UV.ACCOUNT file.
-133DSJE_READUFAILEDFailed to lock project create lock record.
-134DSJE_ADDPROJECTBLOCKEDAnother user is adding a project.
-135DSJE_ADDPROJECTFAILEDFailed to add project.
-136DSJE_LICENSEPROJECTFAILEDFailed to license project.
-137DSJE_RELEASEFAILEDFailed to release project create lock record.
-138DSJE_DELETEPROJECTBLOCKEDProject locked by another user.
-139DSJE_NOTAPROJECTFailed to log to project.
-140DSJE_ACCOUNTPATHFAILEDFailed to get account path.
-141DSJE_LOGTOFAILEDFailed to log to UV account.
-201DSJE_UNKNOWN_JOBNAMEThe supplied job name cannot be found in the project.
-1001DSJE_NOMOREAll events matching the filter criteria have been returned.
-1002DSJE_BADPROJECTProjectName is not a known InfoSphere DataStage project.
-1003DSJE_NO_DATASTAGEInfoSphere DataStage is not installed on the system.
-1004DSJE_OPENFAILThe attempt to open the job failed – perhaps it has not been compiled.
-1005DSJE_NO_MEMORYFailed to allocate dynamic memory.
-1006DSJE_SERVER_ERRORAn unexpected or unknown error occurred in the engine.
-1007DSJE_NOT_AVAILABLEThe requested information was not found.
-1008DSJE_BAD_VERSIONThe engine does not support this version of the InfoSphere DataStage API.
-1009DSJE_INCOMPATIBLE_SERVERThe engine version is incompatible with this version of the InfoSphere DataStage API.
 
API Communication Layer Error Codes
ERROR NUMBERDESCRIPTION
39121The InfoSphere DataStage license has expired.
39134The InfoSphere DataStage user limit has been reached.
80011Incorrect system name or invalid user name or password provided.
80019Password has expired.

No comments:

Post a Comment

Creating SQL Hierarchical Queriy