Fabric copy job CDC fail

[Redcol]

Simple thre column CDC job fails with error.

ErrorCode=UserErrorInvalidValueInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to convert the value in 'useTempDB' property to 'System.Boolean' type. Please make sure the payload structure and value are correct.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.Reflection.TargetInvocationException,Message=Exception has been thrown by the target of an invocation.,Source=mscorlib,''Type=System.ArgumentNullException,Message=Value cannot be null.
Parameter name: value,Source=mscorlib,'

[v-prasare]

May I ask if you have resolved this issue? If so, Can you please share the resolution steps here. This will be helpful for other community members who have similar problems to solve it faster.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

@spaceman127, Thanks for letting us know that this is working for you. @Redcol, Could you please confirm whether you are able to resolve your issue? as issue got resolved we are closing this thread from our end. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

[spaceman127 · Accepted solution]

Hi @Redcol ,

today i have testet id again.

It works now.
The problem seems to have been fixed.

If I'm not mistaken, it wasn't possible to deselect the TempDB option before, or rather, the checkbox wasn't there.

I'm not so sure about that.

See Screenshot:

Best regards

[spaceman127]

Hi @Redcol ,

I was finally able to replicate your test setup and I'm getting the same error.
I'll continue testing and write back when I find out more.

Best regards

[v-prasare]

Hi @Redcol,

If you got any progress on this please update here. this will be helpful for the other community members with similar issues

Thanks,

Prashanth

[v-prasare]

Hi @Redcol,

since this was a bug which got fixed. we would like to know if there is any progress or did you get a chance retry this and impliment it?

@SatishBoddu, thanks for your prompt response here.

thanks,

Prashanth Are

MS fabric community support

[Redcol]

Same error

[Redcol]

ErrorCode=UserErrorInvalidValueInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to convert the value in 'useTempDB' property to 'System.Boolean' type. Please make sure the payload structure and value are correct.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.Reflection.TargetInvocationException,Message=Exception has been thrown by the target of an invocation.,Source=mscorlib,''Type=System.ArgumentNullException,Message=Value cannot be null.
Parameter name: value,Source=mscorlib,'

[ajarora]

This was a bug in the product, we have fixed this recently, please try again.

[SatishBoddu]

Thank you

[spaceman127]

Hello @Redcol,

Give us more information about your system, what you're planning to do, and so on.

Based on your error message, it is challenging to determine the issue without knowing the specific table or system involved.
However, your error message indicates that a conversion has failed.
But to check this thoroughly, we need more information.

Best regards

[Redcol]

Morning,
This was a very simple proof test of CDC between two Azure SQL databases. A Single table (1000 rows) three columns, INT,INT,Money. The two INT columns make up the Primary Key, set up for CDC. The copy job is doing the "intitial" copy into the second Azure database (empty table) but fails.

[spaceman127]

Hello,

I assume you have already looked at the documentation for CDC Azure SQL Database, especially the prerequisites.

https://learn.microsoft.com/en-us/azure/azure-sql/database/change-data-capture-overview?view=azuresq...

Best regards

[Redcol]

Yes, these are just test dabases owned by me.