Syniti ADMM: Error during Repopulate snapshot in SKP

Tatsiana Dabravolskaya

• February 21, 2024 09:56

Hi,

During repopulation snapshot in SKP (metadata is imported successfully) for some tables from Oracle source we have faced error with description "Replication completed but appears to have been unsuccessfully".

We have tried  to replicate these tables in Replicate tool  and  have not succeeded as well: progress is Pending  and 0%.

Could you please advice what might be the reason and how the data can be populated.

Thanks.

0

• 

  Rakesh Ananthuni

  • February 21, 2024 10:00

  Hi Tatsiana,

  Could you please check the error log for this replication and let me know if you see any error.

  Regards,

  Rakesh

  0
• 

  Tatsiana Dabravolskaya

  • February 21, 2024 10:30
  • Edited

  Hi Rakesh

  history in Syniti Replicate does not contain any information. 

  Logs in SKP Monitor  are with next description

  { "Message": "The jobqueue step failed", "Type": "Concento.Deploy.Services.JobQueue.JobqueueStepFailedException", "elapsed_milliseconds": 13597, "Executor": "SnapshotTableRepopulateExecutor", "JobqueueId": "d760ed1c-a632-41ad-95dd-f808a68151e5", "Parameters": { "TABLE_ID": "f6a91441-e52d-4596-908b-69b934802f95" }, "Source": "Concento.Deploy.Services", "StepId": 10, "InnerException": { "Message": "Replication completed but appears to have been unsuccessful", "Type": "System.Exception", "HubId": { "Prefix": "sdr", "Suffix": "qLnRmO1AiGwyMVeFz8k8VQhmx6c=" }, "replication_id": 113, "replication_name": "SRCORAOAPP.dbo.HZ_CONTACT_POINTS-4dced", "replication_status": "Disabled", "Source": "Concento.Deploy.Services" } }

  The jobqueue step failed Replication completed but appears to have been unsuccessful

   

  0
• 

  Rakesh Ananthuni

  • February 21, 2024 10:38

  Please check in SKP->Replicate

  Select the replication and then check under Replication logs.

  

  Click on the below button to view the error.

  

  0
• 

  Jon Green

  • February 21, 2024 11:40

  Could you confirm which customer this is happening on?

  0
• 

  Tatsiana Dabravolskaya

  • February 21, 2024 12:00

  Hi Rakesh,

  In replication log we can see  next error description

  Oracle.DataAccess.Client.OracleException (0x80004005): ORA-03114: not connected to ORACLE
     at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
     at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
     at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
     at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
     at j.f()
     at am.a(v A_0, al A_1, Object[] A_2, Int32[]& A_3)
     at ag.a(Boolean bRecover)

   

  0
• 

  Rakesh Ananthuni

  • February 21, 2024 12:16

  May be the connection was lost when the replication was running, please check the connection and try again.

  Please check in Replicate if you have any errors/failed records.

  Regards,

  Rakesh

  0

Please sign in to leave a comment.