Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

(0) Share

Report

Posted on by Charles Seguin

401

Hello!

I have a complex dataflow that has been running smoothly for over a month... until this morning. It is a Standard V1 dataflow.

Starting today, I have begun getting failed upserts, with the following error message:

Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

I am importing data into Yes/No columns (fields). This is an example of what I am loading:

"cra0c_shipcomplete":"false"

Anyone else suddenly getting this issue?

Categories:

Microsoft Dataverse

Dataflows

All responses (4)

Answers (1)

EricRegnier 8,714 Most Valuable Professional on at

Like (1)

Report

Re: Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

Cheers for the update @CharlesS. I've experience similar issues with Dataflows as backend updates occur, what I've done unfortunately is simply re-create them...
Verified answer

Charles Seguin 401 on at

Like (3)

Report

Re: Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

After much troubleshooting, I was able to find the cause of the error and solve the problem. It turns out that this message had nothing to do with importing yes/no fields, but was rather related to a problematic business rule.

If ever you have a similar problem, here are the steps to solve it:
1. Start by checking your business rules for the relevant entity.
2. Pay particular attention to any conditions including numeric comparisons for fields that are imported using the dataflow, such as FieldA is greater than X.
3. If, when importing this field, it sometimes includes null values, you will receive this error in your dataflow log and the record upload will fail.
4. To solve this problem, add a new condition before your numerical comparison condition in your business rule. The new condition should be as follows : IF FieldA Does not Contain Data.
5. Place your previous numerical comparison condition under the FALSE branch of the newly created IF FieldA Does not Contain Data condition.
6. Refresh your dataflow again.
7. Rejoice.

Basically, the "String was not recognized as a valid Boolean" error refers to the fact that the business rule was unable to get a valid TRUE/FALSE value from the numerical comparison of a null value. Indeed, IF null < 3 = error.

Hope this explanation can help others!
KSven 182 on at

Like (1)

Report

Re: Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

Hi @CharlesS ,

actually I'm working with Dataverse / Dataflows like a Data Warehouse incl. some ETL / ELTL processes, so yeah I guess I got some experience, but unfortunately I haven't used True or False with standard v2. Just choice columns with the regarding number.
But anyway one of the following columns should work as a dataflow column, cause these are the results out of dataverse connector in Power Bi (or ODatafeed connector as well):

Yes/No :
I guess you have already tested datatype String/boolean? You could also try simple Yes / No as string...

Choice:
Acutally works fine for me with the ID (e.g. 0 or 4)

Hope it helps little bit. Regarding to dataflows Ive already 2 open support tickets..

BR,
Sven
Charles Seguin 401 on at

Like (0)

Report

Re: Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

@KSven : I'm thinking you have some experience with dataflows... have you had issues lately importing Yes/No (Boolean) values into Dataverse?