Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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