Active IQ Unified Manager Discussions

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

venkate_SAN
3,952 Views

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

4 REPLIES 4

marz
3,923 Views

What releases of WFA and "DFM"?

 

venkate_SAN
3,914 Views

Hi

 

WFA version : 4.0.0.0.0

 

DFM - 5.2.1P2

 

 

Regards

Venkatesan R

marz
3,852 Views

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
3,633 Views

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

 

Public