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

Cache query generates id start from random auto-increment ID

Rutul

Hi All,

 

I have created new cache query for getting cifs server name from ocum vserver table since existing wfa vserver table does not have “cifs server name” column.

When I checked data in newly created vserver table, the auto increment id starts from 901 and not from 1. Because of that whenever I am creating filter using multiple tables it is unable to match the vserver id with any tables and no results show up.

 

 

ids.PNG

 

 

Any suggestion or workaround would be helpful.

1 REPLY 1

NICKBARTON

Can you show your SQL and SQL Create Table? It's not clear how you expect it to relate to data. If you are autoicementing an ID that won't have anything to do with your realtions to other tables those are foreign keys you need to include in the your table. You should have 'id' INT NOT NULL AUTO_INCREMENT in your Table syntax this by default will start at 1? Are you populating the ID field from another value in the OCUM vserver table? 

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