Cannot restore from TSM. Another process is already in use or is locked by another process. (4292551)

The backup either hangs or throws a "TCP/IP connection failure" message with the error number ANS1017E.

LiteSpeed cannot restore from TSM server if the backup media is in Tape and has more than one stripe.

A  striped backup which has been moved to tape cannot be restored by Litespeed. This is because the Litespeed engine will want to read both stripes at the same time which it cannot do if the backup is on tape. This is a LiteSpeed limitation.

The error relates to the media format stored in TSM, the number of stripes it is divided into and the way LiteSpeed and TSM each operate.

As TSM locks the user ID for the client node for each stripe LiteSpeed tries to recover, LiteSpeed tries to recover every backup stripe at once using a single user ID, this is the reason it fails.

Source: https://www.ibm.com/support/pages/ans1017e-session-rejected-tcpip-connection-failure-web-client

If the backup media is in Disk this issue does not occur.

If you still use Tape, please make sure to use only one stripe to restore.

Workaround:

You can use the recast option in LiteSpeed to convert the database stored in TSM to a LiteSpeed format and then use Object Level Recovery to restore any part of the database you wish.

You can see more of these scripts in LiteSpeed User's Guide: https://support.quest.com/technical-documents/litespeed-for-sql-server/8.9/user-guide/18#TOPIC-1338355

First use the following Script:

If you have multiple stripes, you must first convert all of them into a single file:

Slsrecast.exe -E 1.bkp 2.bkp 3.bkp 4.bkp -F new.bkp

This is another example to convert a 2 striped backup into a single file in LiteSpeed:

Slsrecast -j c:\dsm.opt -E tsmbkp:test\test\test_file1 tsmbkp:test\test\test_file2 -c nodename -k password -F"D:\unified_file"

After you have converted the files to a LiteSpeed format, then you can perform a regular Object Level Recovery from the console’s wizard.