Script based Calculation View is not allowed as data source in CrossDB scenario

[former_member217306]

We are getting below error when we try to replace data source of SQLScript (SPS 9) in the Calculation View with SQLScript(SPS 12 activated) after upgrade from SPS 9 to SPS12 and even I tried with SQL Engine option in CV and still the error prompts. If I convert SQLScript to Table Function and no error, but I do not want to replace all existing SQLScripts with TFs. Any help would be appreciated!

"Script based Calculation View is not allowed as data source in CrossDB scenario"

[andrey_ryzhkov]

Hi!

We faced the same problem after upgrading to SPS12. Experts, please advice how to solve this issue.

Regards,

Andrey.

[Former Member]

We are facing same problem after SPS12 upgrade. Please update the resolution steps if it is resolved for you.

Thanks, Murali

[former_member233318]

Hi!

Facing the same issue, could you please advice on how to solve this issue.

Thanks in advance

Sonny

[Former Member]

We are also facing same issue.

Please share the answer if you solved the problem.