topic Re: wfa SQL Anywhere Error -1090: Function 'substr' has invalid parameter '3' ('-7') in Active IQ Unified Manager Discussions

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

venkate_SAN — Wed, 04 Jun 2025 14:01:36 GMT

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

marz — Fri, 16 Feb 2018 13:44:08 GMT

What releases of WFA and "DFM"?

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

venkate_SAN — Fri, 16 Feb 2018 15:07:05 GMT

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

marz — Tue, 20 Feb 2018 14:49:50 GMT

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

DeepakKumar — Fri, 23 Mar 2018 06:11:47 GMT

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