Can not kill Hipo job

(Nick Cowie) #1

Got a dead hipo, but trying to remove it, I just get the Error message "Message: Unable To Send Abort, No TaskID for the process on the server [HIPO0049]"

(Anthony Barnes) #2

This can be removed by clearing the row in the database.

    
    select count(*) from sq_hipo_job;


Will show you how many hipos there are currently running. If you only have the one it should be safe to:

    
    truncate sq_hipo_job;


or you can delete the individual row if not.
(Nick Cowie) #3

[quote]
This can be removed by clearing the row in the database.

[/quote]



Thanks for that Anthony, I was sure there was a command to do that, but just could not find it on the forum (and forgot to look on our wiki).

(Ryan Archer) #4

Is there a way to do it without going into the database backend?

I just don't have access to it and it requires a 'momentus' amount of "effort" to coordinate it with our IT team... :(  :(