Evening All
I have had this error before "Value can not be converted to requested type" but last time it related to a caching issue between Stylus and SQL and a changed view. I rebuilt the section of the query related to that view and the issue went away
This time I have three xqueries drawing on the same views for the same data. The only difference between the three is a filter at the top level that breaks the data up into "Nab Cardfast", "NAB Direct Debit" and "Checque Receivable". However; if I remove the links to the Asset Combined Data HL view (which is not related to filter and is the same regardless) I don't get this error.
I have tried rebuilding the xquery in case it was a repeat of the caching issue: no joy.
I have eliminated all the fields i am importing from Asset Combined Data HL view one at a time in case it was one particular field that had the issue: no joy. In fact i get the error if no fields are mapped and just the flowr link to the 42 Contract view exists.
I am at a complete loss. Pls find attached the xqueries and a copy of the Asset Combined Data HL view data as seen by Stylus.
Asset_Combined_Data_HL.zip XML of view causing issues
HL_BIZv2_CC.xquery Xquery that works
|