Azure DB同步失败，无法将值NULL插入列"local_create_peer_timestamp"中 [英] Azure DB sync fails with Cannot insert the value NULL into column 'local_create_peer_timestamp'

问题描述

大家好

背景

我已经从bacpack中恢复了两个数据库Db0和Db1；

I have restored two databases Db0 and Db1 from bacpack;

我已经创建并定义了数据库同步组，以便Db1从Db0同步(集线器，集线器获胜)；

I have created the DB Sync group and defined it so Db1 would sync from Db0 (the hub, hub wins);

但是，数据库同步失败并显示以下错误；请注意结尾处提到的支持ID.

however the DB sync fails with the following error; please notice the support ID mentioned at the end as well.

有人可以告诉我们如何解决此问题吗?我们需要帮助才能继续进行下去.

数据库供应失败，但异常无法将值NULL插入表'Db1.DataSync.provision_marker_dss'的列'provision_timestamp'中；列不允许为空. INSERT失败.该语句已终止.内部异常: SqlException错误代码:-2146232060-SqlError数字:515，消息:无法将值NULL插入表'Db1.DataSync.provision_marker_dss'的列'provision_timestamp'中；列不允许为空. INSERT失败. SqlError号:3621，消息:该语句 已终止. "    

有关详细信息，请向客户支持提供跟踪ID"1244d970-d69c-4c1e-8ede-ceec4695f283".

Database provisioning failed with the exception "Cannot insert the value NULL into column 'provision_timestamp', table 'Db1.DataSync.provision_marker_dss'; column does not allow nulls. INSERT fails.The statement has been terminated.Inner exception: SqlException Error Code: -2146232060 - SqlError Number:515, Message: Cannot insert the value NULL into column 'provision_timestamp', table 'Db1.DataSync.provision_marker_dss'; column does not allow nulls. INSERT fails. SqlError Number:3621, Message: The statement has been terminated. "    

For more information, provide tracing ID ‘1244d970-d69c-4c1e-8ede-ceec4695f283’ to customer support.

推荐答案

我读过其他文章，其中删除了同步组，然后从DataSync模式中删除了表，然后重试创建同步组可能会有所帮助.所以我试了一下，仍然没有帮助.

i've read on other posts that deleting the sync group and then the tables from DataSync schema and then re-try creating the sync group might help. So I gave it a shot and still did not help.

然后，我查看了与相关的所有SP和触发器Db1.DataSync.provision_marker_dss(导致对该表的插入失败，对吗?) 我什么都没发现.
我还能如何调查为什么插入内容试图在不可为空的字段中写入NULL?

Then I looked to all the SPs and triggers that have a dependency on the Db1.DataSync.provision_marker_dss (cause an insert to this table fails right?) and I could not find anything wrong.
how else can I investigate why the insert is trying to write NULL in a not nullable field?

谢谢

这篇关于Azure DB同步失败，无法将值NULL插入列"local_create_peer_timestamp"中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！