Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Uknownn column 'disk.aggregateId' in 'where clause' error in WFA

MARTINLEGGATT

Hi,

 

I'm trying to connect WFA 2.2.0.2.6 to OCUM Version 6.2RC1. I have created the OCUM database user with the Integration Schema role.

 

When I add the credentials to WFA for the OCUM server and acquire WFA logs in to OCUM but then throws the error:

 

Uknownn column 'disk.aggregateId' in 'where clause'

 

If I change the credentials to invalid ones I get "Access denied for user 'xxxx@ocum-host' (using password: YES')

 

I realise I am using an RC version of OCUM and it looks like WFA is looking for a column that non longer exists in the OCUM DB schema?

 

Any pointers to how to troubleshoot this or resolve it would be appreciated.

 

Thanks

Martin

 

 

1 ACCEPTED SOLUTION

sinhaa

Martin,

 

       OCUM6.2RC1 is NOT supported on WFA2.2.x . The available Datasource Types do not have an OCUM6.2 . You perhaps added your OCUM6.2 Datasource as OCUM6.1.

 

Upgrade your WFA to 3.0RC1 and then add your OCUM. It should work fine.

 

sinhaa

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

4 REPLIES 4

sinhaa

Martin,

 

       OCUM6.2RC1 is NOT supported on WFA2.2.x . The available Datasource Types do not have an OCUM6.2 . You perhaps added your OCUM6.2 Datasource as OCUM6.1.

 

Upgrade your WFA to 3.0RC1 and then add your OCUM. It should work fine.

 

sinhaa

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

MARTINLEGGATT

Hi sinhaa

 

Thanks for the response. I just upgraded WFA and its now working as expected.

 

Thanks

Martin

upgraded WFA still shows same error.

 

6.2 RC1 and WFA 3.0 

sinhaa

Hi,

You can do the following:

 

  1. Upgrde to latest WFA which as of today is WFA3.0P1
  2. Upgrde your OCUM to 6.2 ( not 6.2RC1 )

 

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public