Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Contributor
Posts: 46
Registered: ‎03-29-2009
Accepted Solution

V7.5.1 Admin user View All groups

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

 

 

Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: V7.5.1 Admin user View All groups

[ Edited ]

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
Regards, Adam Travers
empath-e Services Limited
Nickel Contributor
Posts: 58
Registered: ‎03-31-2009

Re: V7.5.1 Admin user View All groups

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'

 

 

Regards,

Steve Robertson
Senior CRM Consultant
Collier Pickard Ltd
Nickel Contributor
Posts: 46
Registered: ‎03-29-2009

Re: V7.5.1 Admin user View All groups

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