Hi,
one of our job strucked in between a load 2 days before
the situation fron the director is it gave 4 warning messages
like
------------------
GetMissingSecurityID: Column REJECT_VAL_TRANS_STG_ID floating point decimal not fully supported. Adjusting scale.
.
.
.
--------------------
and then while trying to reset it says (in director)
"Clearing file RT_STATUS403"
still i am not able to compile the job !
anybody have any idea?
Thanks in advance
Dsedi
Cannot get exclusive access to job to compile it!
Moderators: chulett, rschirm, roy
Morning dsedi,
You need to go into the Director -> Cleanup Resources (in enabled in your installation) or in the Administrator and remove the locks that are still set on that job. Other post describe the steps you need to do in details, as does the documentation. I thought that these lock issues had mostly been resolved in V7.x but I encountered the same issue yesterday with an aborted Px run.
You need to go into the Director -> Cleanup Resources (in enabled in your installation) or in the Administrator and remove the locks that are still set on that job. Other post describe the steps you need to do in details, as does the documentation. I thought that these lock issues had mostly been resolved in V7.x but I encountered the same issue yesterday with an aborted Px run.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks ArndW!!
I did that several times...even i kill that job thru UNIX command in unix machine..
regarding this, i approched a ascential tech support person too..
..but no use...
i am not able to do anything with the job...
any way I have an another copy in my backup..
but what to know why this was happend..
Thanks Again!
Edi
I did that several times...even i kill that job thru UNIX command in unix machine..
regarding this, i approched a ascential tech support person too..
..but no use...
i am not able to do anything with the job...
any way I have an another copy in my backup..
but what to know why this was happend..
Thanks Again!
Edi
dsedi,
avoid doing a "kill -9" of processes, that's a harsh way to remove processes and you might still have locks hanging around after doing that. Did you do a "Clear Status File" as well from the Director? If you are the only one in DS you could do a PORT.STATUS to see what DataStage thinks is out there.
avoid doing a "kill -9" of processes, that's a harsh way to remove processes and you might still have locks hanging around after doing that. Did you do a "Clear Status File" as well from the Director? If you are the only one in DS you could do a PORT.STATUS to see what DataStage thinks is out there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>