cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Transfer Status stuck

I have noticed that we have a lot of old transfer statuses that are stuck within NCM. They have been around for awhile now and I am unable to clear these (ever as admin), has anyone found a way to remove these? i have tried all of the below that i have seen around here.

1st. restart the server - we have restarted multiple times

2nd. tried with the user that I think created those jobs (Admin). It may have been done by an old account which has been deleted as we updated how we log onto this webpage.

We are using NCM Version 7.1

Any help would be great

Thanks

0 Kudos
17 Replies
Level 12

I have the same problem. My jobs have been stuck for several days and new jobs are not running

Capture.JPG

0 Kudos

Hi shawn_b,

Please see SolarWinds NCM 7.3 Release Candidate is Coming! that includes the feature "Admins can clear all transfers for all users from the Transfer Status resource" that you need.

What NCM version are you running?

Regards,

Jiri

0 Kudos

Jiri Cvachovec I am running 7.2.1

planning to upgrade to 7.2.2 to see if this helps

0 Kudos

shawn_b,

I'm not sure whether upgrade to 7.2.2 would help. I recommend waiting a little time and upgrading to NCM 7.3 release candidate directly.

In the meantime, you can try truncating the TransferQueue table directly in NCM database.

Regards,

Jiri

0 Kudos

Jiri Cvachovec, I understand what you are saying about the 7.3, it sounds like it will solve may problem, however, the stuck jobs were created by the admin account

can you provide some more guidance on this?

I have read in earlier posts that the [rocedure is:

To select just the frozen jobs, open DBO.Transfer in the Config Mgmt DB, Edit the first 200 rows
Locate Lines with Status Initializing. Note most values will be NULL.

In the Error column change False to True

In the Status column change Initializing to Cancelled.

In the Cancelling Column change False to True.

Configuration Management will show the frozen jobs as Cancelled.

where do I get the config mgmt. DB? SQL server?

As for the upgrade to v7.2.2, I have another issue that I hope it resolves:

Executing scripts with NCM

0 Kudos

Hi,

Feel free to open a support case.

Consider upgrading to 7.2.2 first as it should also resolve the other issue you are referring to.

Regards,

Jiri

0 Kudos

Upgrade to v7.2.2 solved my problem

to clear the stuck transfers, tech support recommended that I do the following:


Use the database manager on the Orion Server.

Start - All Programs - SolarWinds Orion - Advanced Features - Database Manager

Click "Add default server" and then expand the SQL server. Right click the NCM database name and choose "New Query..."

(Note, modifying the NCM database via Database Manager will only work via the above method if both Orion and NCM use the same database credentials. If they do not you will need to click "Add Server" and supply your Database Server and NCM SQL credentials.)

Paste the query below in to the query window and then choose "Execute Query":

DELETE FROM TransferQueue WHERE Status LIKE 'Cancelling%'


if your transfers are stuck at Initializing, then change the query to:


DELETE FROM TransferQueue WHERE Status LIKE 'Initializing%'

Now perform the following:

How to Repair Job Engine, Collector and Information Service

(Note: This will cause ~10 min. or less of downtime)

- Start - All Programs - SolarWinds Orion - Advanced Features - Orion Service Manager -> Shutdown Everything

- Open C:\Documents and Settings\All Users\Application Data\SolarWinds\Installers.
- On a 2008 system, this will be under C:\ProgramData\Solarwinds\Installers.

- Right-click the Jobengine.msi and select Uninstall.
- Right-click the Jobengine.v2.msi and select Uninstall.
- Right-click the CollectorInstaller.msi and select Uninstall.
- Right-click the InformationService.msi and select Uninstall.

- Right-click the Jobengine.msi and select Install.
- Right-click the Jobengine.v2.msi and select Install.
- Right-click the CollectorInstaller.msi and select Install.
- Right-click the InformationService.msi and select Install.

- Start - All Programs - SolarWinds Orion - Advanced Features - Orion Service Manager -> Start Everything

a courtesy server reboot would be nice as well, but not necessary

Level 12

Was there any fix to this?  I'm running NCM 7.1.1 and still cannot clear transfer statues that are created by other users...

0 Kudos

Same here

0 Kudos

Ok so I found a not so nice way to delete these from another thread and just tried it and it works.  I figured I would post it here.

Go to the Config Mgmt DB, and delete everything in dbo.TransferQueue.

Like I said, rather not do it directly in the db, rather have it work via gui but this cleared our 522 statuses that were stuck

To select just the frozen jobs, open DBO.Transfer in the Config Mgmt DB, Edit the first 200 rows
Locate Lines with Status Initializing. Note most values will be NULL.

In the Error column change False to True

In the Status column change Initializing to Cancelled.

In the Cancelling Column change False to True.

Configuration Management will show the frozen jobs as Cancelled.

Exactly what do you remove in the dboTransferqueue  section? Absolutely everything?

0 Kudos

alind - yes, removed everything from the transferqueue.   This is assuming you want to clear everything in your transfer status gui...if there is stuff you want to keep then you would obviously exclude from your deletion.

0 Kudos


I had the same issue.  I went ahead and updated to 7.1.1 and still could not clear the stuck jobs.  Manually removing them from the database was the only method that worked.

0 Kudos
Level 9

I've found that the only way to delete 'Transfer Status log entries' is to login as the username that created the job.  If the job was created as admin, admin can delete them.  If jjones created the job, only jjones can delete it.

0 Kudos
Level 18

Hi,

This looks like one of the problems we want to fix in an upcoming service release. I hope it will resolve your issue.

Regards,

Jiri

0 Kudos

FYI:

0 Kudos