I'm still running Opalis v5.5 and I have an ghost FTP job running
Even if all Policies are stopped there is almost every second and OPR-FTP.exe in the taskmanager.

I thought you could kill this within the OPALIS SQL database, but I no not find it in any table

I see on some forums something about a stored procedure sp_StopAllRequestsForPolicy 'PolicyID' but I do not have this in my SQL db

Can anyone help me out on this?

Hello,

Is there a policymodule.exe runningin the TaskManager as well?

Regards,

Stefan

Yes... but I do have a lot of policymodule.exe processes running in the taskmanager.

Rebooting the server isn't a solution, done that been there...

Hello,

Ok, I was asking because you wrote "Even if all Policies are stopped".

If this is case that then a policymodule.exe process is still running, I think a policy ist is still running which is marked as deleted in the database or which folder that it contains ins marked as deleted, so you can't see the policy in the client.

If you have access to the SQL-DB of Opalis, you cann check with some satements like

select * from policies where published =1 and deleted =1

or

select Polcies.Name from Policies inner join Folders on Policies.ParentID = Folders.UniqueID where Folders.deleted = 1 and Policies.published =1

Good Luck!

Stefan

Stefan, thank you for the reply.

After running the "select * from policies where published =1 and deleted =1" statement in the SQL DB returned 1 entry and this is the ghost FTP job I'm looking for. Now that I have found this UniqueID of that policy... how can I stop it? In what table to I have to change something?

Hello,

I suggest unmarking the published Policy as deleted by setting deleted from 1 to 0.

update Policies
set deleted = 0 where published = 1

Then after a refresh you should be able to locate the Policy in the Opalis Client. Stop it and delete again.

Regards,

Stefan

As you can see the policy is back in the client view
It's stopped and even checked out

but still the process is running

Hello,

"Undo Check Out" -> "Stop".

Regards,

Stefan

Hello,

"Undo Check Out" -> "Stop".

Regards,

Stefan,

all your replies are helpfull hints and tips in order to retreive information on the 'ghost' policy, but I wouldn't call it an answer to fix the problem. I was lucky that there was a 'schedule deny' over the weekend and that stopped the policy

Do you not be able to stop the policy if you see in the Opalis Client now?

Regards,

Stefan