V7.5.1 Admin user View All groups

[TitansNFL]

Using LAN Client.  The database has thousands of groups that have accumulated over the years.  Someone changed the setting in Group Manager for the Admin user to view all groups.  SLX will login and will load the Nav bar, menu and toolbars but will not load the default main view (Contacts) and runs like that for hours.  The server where the client is running will have 100% CPU usage. 

Went into Administrator and changed the default main view to Account with a small group and get the same blank main view and 100% CPU condition.

Is there a SQL script that will change the Group setting to "owned by" that can be run to fix this? 

Unfortunately SLXProfiler doesn't run on this server (Windows 2003) for some reason.

Thanks,

Bruce Pershke

[AdamTravers]

Hi Bruce,

You should be able to disable this logged in as the Administrator:

1. Open the SalesLogix Client as the Admin user.
2. On the Lookup bar, click Manage Groups and then click Manage Groups....
3. On the Group Manager window, uncheck the Show groups checkbox.

Ignore this Bruce! Re-read the thread and saw that you have already done this.

Message Edited by AdamTravers on 01-15-2010 03:54 PM

[steve_robertson]

Hi Bruce,

I haven't tried changing these in SQL but the SLX profiler showed the following:

Profiler shows the following 3 inserts i.e. changing from Admin:

---------- Client SQL ---------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED) VALUES ([DBTYPE_STR | DBTYPE_BYREF,"378906F395A0432F93989BA12E6D8BE9"], [DBTYPE_STR | DBTYPE_BYREF,"GroupFilterByUser"], [DBTYPE_STR | DBTYPE_BYREF,"GroupManager"], [DBTYPE_STR | DBTYPE_BYREF,"ADMIN"], [DBTYPE_STR | DBTYPE_BYREF,"T"], [DBTYPE_STR | DBTYPE_BYREF,"F"])
---------- Executed SQL ----------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED,CREATEDATE,CREATEUSER,MODIFYDATE,MODIFYUSER) VALUES (?, ?, ?, ?, ?, ?,'20100115 16:05:15','ADMIN','20100115 16:05:15','ADMIN')

---------- Client SQL ---------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED) VALUES ([DBTYPE_STR | DBTYPE_BYREF,"C3F71E884216467698CA0B357E41AD05"], [DBTYPE_STR | DBTYPE_BYREF,"GroupFilterOwnerOnly"], [DBTYPE_STR | DBTYPE_BYREF,"GroupManager"], [DBTYPE_STR | DBTYPE_BYREF,"ADMIN"], [DBTYPE_STR | DBTYPE_BYREF,"F"], [DBTYPE_STR | DBTYPE_BYREF,"F"])
---------- Executed SQL ----------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED,CREATEDATE,CREATEUSER,MODIFYDATE,MODIFYUSER) VALUES (?, ?, ?, ?, ?, ?,'20100115 16:05:22','ADMIN','20100115 16:05:22','ADMIN')

---------- Client SQL ---------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED) VALUES ([DBTYPE_STR | DBTYPE_BYREF,"83EF6689F52B4E6BA86BC2796CB2D2D7"], [DBTYPE_STR | DBTYPE_BYREF,"GroupFilterUserID"], [DBTYPE_STR | DBTYPE_BYREF,"GroupManager"], [DBTYPE_STR | DBTYPE_BYREF,"ADMIN"], [DBTYPE_STR | DBTYPE_BYREF,"U6UJ9A000017"], [DBTYPE_STR | DBTYPE_BYREF,"F"])
---------- Executed SQL ----------
INSERT INTO USEROPTIONS (OPTIONID, NAME, CATEGORY, USERID, OPTIONVALUE, LOCKED,CREATEDATE,CREATEUSER,MODIFYDATE,MODIFYUSER) VALUES (?, ?, ?, ?, ?, ?,'20100115 16:05:22','ADMIN','20100115 16:05:22','ADMIN')

Following SQL ran when I changed the Show Groups Visible To User :

---------- Client SQL ---------
UPDATE USEROPTIONS SET OPTIONVALUE = [DBTYPE_STR | DBTYPE_BYREF,"U6UJ9A00000Q"], LOCKED = [DBTYPE_STR | DBTYPE_BYREF,"F"] WHERE OPTIONID ='83EF6689F52B4E6BA86BC2796CB2D2D7'
---------- Executed SQL ----------
UPDATE USEROPTIONS SET OPTIONVALUE = ?, LOCKED = ?,MODIFYDATE='20100115 16:21:15',MODIFYUSER='ADMIN' WHERE OPTIONID ='83EF6689F52B4E6BA86BC2796CB2D2D7'

Reseting back to Admin:

---------- Client SQL ---------
UPDATE USEROPTIONS SET OPTIONVALUE = [DBTYPE_STR | DBTYPE_BYREF,"F"], LOCKED = [DBTYPE_STR | DBTYPE_BYREF,"F"] WHERE OPTIONID ='378906F395A0432F93989BA12E6D8BE9'
---------- Executed SQL ----------
UPDATE USEROPTIONS SET OPTIONVALUE = ?, LOCKED = ?,MODIFYDATE='20100115 16:25:45',MODIFYUSER='ADMIN' WHERE OPTIONID ='378906F395A0432F93989BA12E6D8BE9'

[TitansNFL · Accepted solution]

Got it resolved with Support. Deleted the admin records in the useroptionsdef table which reset the Admin user back to the default settings. That allowed the client to load with out the view all setting. Bruce