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.
Garima, please log a product support ticket for this so that product support can help.
Hi Tatsiana,
Could you please check the error log for this replication and let me know if you see any error.
Regards,
Rakesh
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
Please check in SKP->Replicate
Select the replication and then check under Replication logs.
Click on the below button to view the error.
Could you confirm which customer this is happening on?
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)
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
What is the resolution of this problem? We see this issue reccuring when repopulating T006, T002 tables in Snapshot Management.
It was asked 9 months ago but I don't see any resolution which can help.
Because of this we are not able to use the most efficient Syniti feature of Value Mapping.
Hi Garima,
Please check the error in error log of replicate.
If its due to primary key violation, please change the collation to case sensitive for primary key field (SPRAS for T002) and try to replicate again.
Regards,
Rakesh
Please sign in to leave a comment.
Comments
9 comments