question

Daideep-8056 avatar image
0 Votes"
Daideep-8056 asked ShaikMaheer-MSFT answered

Copy Activity fails due to Null Value returned from Odata Source to Azure Data lake

Failure type :- User configuration issue

Details :- Failure happened on 'Source' side.

ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path raw/ADO/SF_STAGING/2e963e85-3f43-4450-b52f-7258bdaca0f1/\2e963e85-3f43-4450-b52f-7258bdaca0f1.,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.OData.Core.ODataException,Message=A null value was found for the property named 'Title', which has the expected type 'Edm.String[Nullable=False]'. The expected type 'Edm.String[Nullable=False]' does not allow null values.,Source=Microsoft.OData.Core,'

azure-data-factoryazure-data-lake-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1) I can't able to change null Value with some dummy data in Odata source.

2) How can I use Query to filter condition that accept Title not equal to Null on Odatasouce

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @Daideep-8056 ,

Thank you for posting query in Microsoft Q&A Platform.

From the error message it seems in your source property Title is not nullable but system found some null values for it. Hence ending up this issue.

Could you please try to replace null values with some dummy values? For example, replace all null values as unknown and then try to perform copy.

Lookup activity can be used to execute queries on OData source. We can try using replacing null values with some dummy values using lookup activity.

Please let us know how it goes. Thank you.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Daideep-8056 , Just checking if you get chance to check above and share updates? Thank you.

0 Votes 0 ·

1) I can't able to change null Value with some dummy data in Odata source.

2) How can I use Query to filter condition that accept Title not equal to Null on Odatasouce

0 Votes 0 ·