topic Error Failure in preparing LOG storage unit locator in Qlik Replicate

Error Failure in preparing LOG storage unit locator

Naga_vivek — Thu, 22 Feb 2024 13:51:01 GMT

Hi Team,

In one of the replicate task we are observing this error and the task got errored out

ERROR_GENERAL "Failure in preparing LOG storage unit locator
RetCode: SQL_ERROR SqlState: 42S02 NativeError: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'msdb.dbo.backupmediafamily'. Line: 1 Column: -1"
10/18

ERROR_GENERAL "Stream component 'st_0_Accounting_Data' terminated
Stream component failed at subtask 0, component st_0_Accounting_Data
Error executing source loop
Endpoint is disconnected
Encountered an unexpeceted error. Aborting...
mssql_execute_log_lsn_peeper(...) failed upon SQLExecute with LSN parameters '<LSN number>
RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
"

we are using

1.Source Endpoint- Microsoft SQl server

2.Target Endpoint - CSV file

Please let us know the root cause why we are getting this error and let us know the solution to resolve the below error.

Re: Error Failure in preparing LOG storage unit locator

Heinvandenheuvel — Thu, 22 Feb 2024 13:59:29 GMT

Looks like incorrect privileges.

Replicate needs to be able to access this table. Try outside Replicate (SMSS) with exactly the same credentials.

Also, carefully review the requirements in the User's Guide.

Finally, did you try the 'test' button on the endpoint?

Hein.

Re: Error Failure in preparing LOG storage unit locator

Dana_Baldwin — Thu, 22 Feb 2024 17:52:41 GMT

Hi @Naga_vivek

Related to Hein's comment, you can check the documented required privileges here: Required permissions | Qlik Replicate Help

Please adjust for the version of Replicate you are using at the top left of the screen.

Thanks,

Dana