wfa SQL Anywhere Error -1090: Function 'substr' has invalid parameter '3' ('-7')

[venkate_SAN]

Hi,

we are getting below error in WFA after upgrading the DFM. please check and update.

SQL Anywhere Error -1090: Function 'substr' has invalid parameter '3' ('-7')

[marz]

What releases of WFA and "DFM"?

[venkate_SAN]

Hi

WFA version : 4.0.0.0.0

DFM - 5.2.1P2

Regards

Venkatesan R

[marz]

You may want to reset the appropriate DFM Data Source (Execution > Data Sources, right-click and Reset Scheme).  This action will clear the WFA data.  Once cleared, initiate an acquisition (right-click, Acquire Now) and wait for the acquistion to complete.  

If the above does not correct the problem, open a case.

[DeepakKumar]

Sharing here so that it can be beneficial for others having similar issue.

The issue was identified as wrong lun pathid entry in DFM DB for a particular filer and it was causing the acquisition to fail.

We worked with engineering and got this fixed.

We were provided with custom SQL update using following:

dfm query run -f "update ------------------->

Thanks!

Deepak