Subscribe

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

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')

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

What releases of WFA and "DFM"?

 

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

Hi

 

WFA version : 4.0.0.0.0

 

DFM - 5.2.1P2

 

 

Regards

Venkatesan R

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

[ Edited ]

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.

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

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