07-02-2014 07:56 AM
After upgrading to SLX 8.1 we were unable to access Contact Tabs till the Triggers on the Contact table that write to GLOBALCHANGETRACKING where disabled.
After Upgrading to SLX 8.1 we were having lockups and extreme slowness when creating and deleting Adhoc groups till we disabled the Triggers on the ADHOCGroup table that writes to GLOBALCHANGETRACKING.
I am currently seriously considering disabling the remaining triggers on all tables that write to GLOBALCHANGETRACKING.
Thoughts? Reasons I shouldn't disable these Triggers?
07-03-2014 03:46 PM
Sorry to here you are having issues. I would like to understand the problems you are having so I can try to help.
When you say you are unable to access contact tabs, does that mean just viewing or inserting/editing/deleting? The triggers have no impact on reading data only writing data.
I am also surpised by the issues you had with Adhoc groups. How much slowness were you experiencing? How many rows are in your AdhocGroup table and how many in the GlobalChangeTracking table?
The triggers are needed for Integrations like (X3, Outllook, and Google).
For a list of all triggers and their function visit the following post:
07-07-2014 05:50 AM
Our AdhocGroup table has a totoal of 330729 rows.
We implemented SLX 8.1 from SLX 7.5.2 May 16, 2014. GlobalChangeTracking has 40861 rows.
When creating a Adhoc group the SLX program would seem to lock and take 3 to 5 min to resolve. During that time locks would be experienced by other users. When deleting a AdhocGroup the SLX program would again become unresponsive and generate locks; An issue that was not experienced with 7.5.2. Disabling the triggers for GlobalChangeTracking cleared up the creation and deletion locks experienced with Adhocgroups.
07-07-2014 08:06 AM
Did you check to see if any of them have a PK starting w/teh letter "Q"?
"Q" records are generated as temp groups and normally disappear.. BUT several years ago there was a problem and they did NOT go away...... but teh code got fixed and if teh Q records were there they stayed...
SELECT Count(*) from sysdba.ADHOCGROUP WHERE GroupID Like 'Q%'
If you find any - delete them
DELETE from sysdba.ADHOCGROUP WHERE GroupID Like 'Q%'
07-07-2014 08:28 AM