Sync error on computed column in a view when "Valid Time State Enabled" set to "Yes"

(0) Share

Report

Posted on by Sebastian Aurand

1,650

Hello,

I have the strange situation that the activation of a "Valid Time State Enabled" = "Yes" leads to a synchronisation error. Here is the detailed description of the situation:

My view is based on a query with multiple tables including two times LogisticsPostalAddress

8883.Query.png

The view contains the following fields with some simple computed columns:

3252.View.png

    public static server str accountNumSQL()
    {
        TableName       view = tableStr(???BankAccountVendCustTransView);
        ;
        return SysComputedColumn::if(SysComputedColumn::isNullExpression(SysComputedColumn::comparisonField(view, identifierStr(CustTable), fieldStr(CustTable, AccountNum)))
                                   , SysComputedColumn::returnField(tableStr(???BankAccountVendCustTransView), identifierStr(VendTable), fieldStr(VendTable, AccountNum))
                                   , SysComputedColumn::returnField(tableStr(???BankAccountVendCustTransView), identifierStr(CustTable), fieldStr(CustTable, AccountNum)));
    }

At this point everything works fine (Build & Sync). As a result I see all values in the view as expected.

Because some of the customers / vendors changed their addresses the join on the LogisticsPostalAddress will double the records because of the "ValidTimeState" handling of the table. So I tried to get rid of this with the view property "Valid Time State Enabled" = "Yes". (the relevant ValidFrom / ValidTo fields are already in the view and were synchronised correctly before the change of the property).

After changing the property the build runs without an error but the synchronisation ends up with a strange error pointing to the computed column:

"Attempted to read or write protected memory. This is often an indication that other memory is corrupt.".....

Do you have any hint for me how I could solve this.

Thanks

Sebastian

All responses (4)

Answers (0)

Sebastian Aurand 1,650 on at

Like (1)

Report

RE: Sync error on computed column in a view when "Valid Time State Enabled" set to "Yes"

I think I've got the reason for the error. The view is missing the fields with the name "ValidFrom" and "ValidTo". Because I have two datatsources of type "LogisticsPostalAddress" with ValidFrom and ValidTo, I initially renamed them in order to distinguish them.

As soon as I named one of the fields "ValidFrom" / "ValidTo" the error is gone.

Unfortunatly the error message in this case was very misleading for me.

Thanks again Martin for your suppport and merry christmas ;-)
Martin Dráb 231,852 Most Valuable Professional on at

Like (0)

Report

RE: Sync error on computed column in a view when "Valid Time State Enabled" set to "Yes"

It seems to be a bug in kernel, therefore you should log a support request with Microsoft. At least we have simple steps for reproducing the problem.
Sebastian Aurand 1,650 on at

Like (0)

Report

RE: Sync error on computed column in a view when "Valid Time State Enabled" set to "Yes"

Hello Martin,

thanks for the response. I tried your suggestion with the runnable class:

The beavior is identical. With the view property "Valdi Time State Enabled" set to "No" the runnable class runs fine:

Afterwards I only changed the property to "Yes" and the known error comes up:

It seems as the view is not longer known!?!?

Sebastian
Martin Dráb 231,852 Most Valuable Professional on at

Like (0)

Report
RE: Sync error on computed column in a view when "Valid Time State Enabled" set to "Yes"

According to the stack trace, the error is throw from comparisonField().

Will you get the same error when you execute your code in a runnable classs?

SysComputedColumn::comparisonField( tableStr(???BankAccountVendCustTransView), identifierStr(CustTable), fieldStr(CustTable, AccountNum));