Hi All,

 

I have scheduleded import dicom files service and enable it. But it stacks, no files imported. Even I have disable it, restart the service and reboot the computer the service seems locked on the scheduling page and does not work, no file import

 

Any idea how to make it work or how to unlock the service

 

sinan

 

When a service is marked as "Locked" in the GUI, this means it is running in the ShredHostService. It should unlock itself after it completes running. You can also check the listed server IP Address to confirm where it is running.

If the service is stuck as Locked (this could happen if the IP address of the server changed after the service crashed or was shutdown improperly), the ShredHostService will not clean up after itself properly, and you have to manually go into the database and unlock the service in the ServiceLock table.

Steve

Yes it worked,

thanks

I am getting this issue as well. However, when I unlock it.. the service then proceeds to use up all the remaining memory in my server, but does not import anything. (4GB Memory)

As mentioned in a previous post, when a service is "Locked" in the Service Scheduling page, this means the service is actually running. Manually unlocking it in the database while the service is running can cause problems with the system. The intent of this mechanism is to ensure a service only runs at one time on a single server, and manually unlocking the service while it is still running may cause it to be run more than once.

Steve

Could you please tell me where the database is typically located and the steps required to unlock it. thank you

"When a service is marked as "Locked" in the GUI, this means it is running in the ShredHostService. It should unlock itself after it completes running. You can also check the listed server IP Address to confirm where it is running.

If the service is stuck as Locked (this could happen if the IP address of the server changed after the service crashed or was shutdown improperly), the ShredHostService will not clean up after itself properly, and you have to manually go into the database and unlock the service in the ServiceLock table.

Steve"

Is it possible to further elaborate on this? Within the SQL Server Management, I am having difficulty unlocking the service in the ServiceLock table. Am I in the correct location? All options seem to be greyed out and inaccessible.

This query will show the actual rows in the ServiceLock table, plus it joins on ServiceLockTypeEnum + Filesystem to show the type of entry and the filesystem its associated with respectively:

select * from ServiceLock
join ServiceLockTypeEnum on ServiceLock.ServiceLockTypeEnum = ServiceLockTypeEnum.Enum
left join Filesystem on Filesystem.GUID = servicelock.FilesystemGUID

The Lock bit in the ServiceLock table just has to be reset to 0 for the appropriate row. The above joins should help you identify the row for a specific filesytem and type of service scheduling entry.

Steve