Can't delete Job
Moderators: chulett, rschirm, roy
Can't delete Job
Hello,
when i would like to delete a job, i have the message :
"Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES
(Subroutine failed to complete successfully (30107))"
first , i thunk that my job was locked, but i could edit it !, transfom it and save it, but not complie it !
i try to reimport my job, by an older version of it ... but i got the same error message !
I try to use the datastage command DS.REINDEX.ALL, DS.REINDEX but nothing.
I always have the same message !
Could you tell me how i can delete drastically my job?
when i would like to delete a job, i have the message :
"Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES
(Subroutine failed to complete successfully (30107))"
first , i thunk that my job was locked, but i could edit it !, transfom it and save it, but not complie it !
i try to reimport my job, by an older version of it ... but i got the same error message !
I try to use the datastage command DS.REINDEX.ALL, DS.REINDEX but nothing.
I always have the same message !
Could you tell me how i can delete drastically my job?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
i try a DS.CHEKER, but same result.
same error.
if i try to compile the job : i obtain the error :
Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES
(Subroutine failed to complete successfully (30107))
+
(40503) A call to an OLE server has failed, or a runtime error occured within the ole itself.
...
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
same error.
if i try to compile the job : i obtain the error :
Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES
(Subroutine failed to complete successfully (30107))
+
(40503) A call to an OLE server has failed, or a runtime error occured within the ole itself.
...
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is my output.
I've heard about my problem that i should drop a line in DS_JOBS and then execute a cleanup on my project. But it seems that the cleanup command no longer exist in v7.5...COMO DSR_CHECKER established 15:52:13 25 JUN 2007
**********************************************************************
Checking job files
**********************************************************************
*** Processing: DS_JOBS...
Number of jobs found: 596
*** Processing job XXXX - Jobname
...
*** Checking for undeleted job files
*** Checking for redundant job files...
*** Checking for orphaned job records...
**********************************************************************
Checking Container files...
**********************************************************************
*** Processing: DS_CONTAINERS...
Number of containers found: 0
*** Checking for orphaned container records...
**********************************************************************
End of check.
COMO completed. 15:52:38 25 JUN 2007
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS.CHECKER is the Cleanup command. It has not found any undeleted, redundant or orphaned job or shared container files.
You can force-delete your job if it does not contain any shared containers. Can you please identify the records in DS_JOBOBJECTS using the following query? Post the results.
You can force-delete your job if it does not contain any shared containers. Can you please identify the records in DS_JOBOBJECTS using the following query? Post the results.
Code: Select all
SELECT DS_JOBOBJECTS.OBJNAME, DS_JOBOBJECTS.OBJTYPE, DS_JOBOBJECTS.OLETYPE FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND DS_JOBS.NAME = '<<Job name>>';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
At least i have found a way to delete my job.
1 - Open datastage Administrator and, in your project, open command window.
2 - execute the following SQL : DELETE FROM DS_JOBS WHERE NAME = 'JobName'
3 - Execute at least the DS.CHECKER command . It will find some files previously attached to yout job :
1 - Open datastage Administrator and, in your project, open command window.
2 - execute the following SQL : DELETE FROM DS_JOBS WHERE NAME = 'JobName'
3 - Execute at least the DS.CHECKER command . It will find some files previously attached to yout job :
and orphaned objects.Files found for old job number 952
(DS_TEMP952,RT_BP952,RT_BP952.O,RT_CONFIG952,RT_LOG952,RT_STATUS952)
OK to delete them(Y)?
Click yes , and your job is "quite" properly deletedOrphaned Job Object records found
(J\952)
OK to delete them(Y)?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: