Lets discuss about one of the common issue which might be the root cause of db synchronization failure. There is a scenario in which we have create a computed column that returns a value and you are using this statement for it "returns itemName".
Problem : In above screen shot there is a computed method which returns item Name. Since it is returning direct value by assigning it to a variable and there are chance that item name might be empty.
Note : It just a example, you have to map things as per your requirements for computed columns. As you know that computed columns are always used to add computed values to a view and these columns do support sorting and filtering.
Problem : DB Sync fails - InvalidOperationException : Computed column returns empty value.
Root cause : Method is returning direct value for instance "returns itemName".
Solution : Instead of returning direct field, we need to replace the return statement with " returns SysComputerColumn class method for instance : SysComputedColumn::returnLiteral(variable name)"
Subscribe to:
Post Comments (Atom)
Connect and upload in azure blob with azure key vault using x++
Today, I will be sharing details about file upload in azure blob using azure vault that includes pre requisite and code snippet used to it....
-
Today, I will discussing about how to create a batch job using SysOperationFramework in Dynamics 365 Finance And Operations. Let's sup...
-
Today I will be discussing about how to create batch job through x++. Before going in code lets discuss what are batch jobs. Batch job : ...
-
Today, I will be discussing about one of the common issue related to query creation using query build data source. Let's suppose we ...
No comments:
Post a Comment
Note: only a member of this blog may post a comment.