02-02-2011 12:27 PM
Hey Everyone,
So somehow somewhere either a users Intellisync went insane or the Outlook client went insane and they now have 89,000+ Meetings scheduled. In BOTH Outlook and the SLX Activities/Calendar. Yes, I know lucky me... Regardless, I'm looking into any way to do a mass kill of ALL activities in SLX. Once I do that, I will edit the Outlook calendar, and then start up Intellisync again so that it imports the remaining "clean" appointments.
So if anyone has ANY information on how to do this, would be greatly appreciated!!
Thanks,
Joe
Solved! Go to Solution.
02-04-2011 04:45 AM
One way is to perform a DELETE FROM {put table name here and leave off the braces} using the SLX Administrator. Test this on a backup DB first! You can send the results out to the remotes this way also. If you need to check which user then use DELETE FROM {tablename} WHERE SECCODEID IN ('....', '....'). Put the SLX user's ID in the single quotes (keep the single quotes).
HTH
Tom
02-04-2011 11:56 AM
Tom,
DELETE FROM {tablename} is a command that should only be used by seasoned professionals. And the qualifying WHERE SECCODEID IN {user seccodeid} doesn't apply to the Table in question.
While the Calendar Button on the Sales NavBar might bring Joe to an interface usable to filter and delete the desired Activities quickly, I'd strongly recommend that he contact his BP or Sage directly for assistance since Outlook Integration can be very ugly when it goes awry as demonstrated already!
Thanks,
Larry Esposito
02-04-2011 12:06 PM
Thanks guys for the suggestion and help! As always much appreciated.
SAGE SLX support was unable to assist me on this issue. Wasn't too happy on that front.
What I was happy about was that my BP came through with the proper coding of -
delete from activity
where userid = 'u6uj9a000009'
and description like 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx%' (where x represents the description searching for)
Not being a SQL coder is a slight hindrance in all of this too. But the issue is now put to bed.
Have a good weekend!
02-04-2011 02:21 PM
Did they also tell you to kill of the associated records in USER_ACTIVITY? These are the ones that cause an activity to show up on the calendar ;-)
02-05-2011 01:22 PM
Sorry to hear that Sage Support was not so helpful - they usually are for me!
And I would think that this was a fairly trivial request through the Activities Main View
But the Outlook Integration could make it tricky and perhaps there was more to the problem
Kudos for going to your BP and documenting your fix in the thread!
Thanks,
Larry Esposito
02-05-2011 01:33 PM
Kudos to you too for shedding light on a table I didn't even know existed! I suppose that's what makes you Silver Elite
Thanks,
Larry Esposito
02-05-2011 01:43 PM
My bad! Obviously, 89,000+ records is problem enough and makes this anything but trivial!
@LEsposito wrote:Sorry to hear that Sage Support was not so helpful - they usually are for me!
And I would think that this was a fairly trivial request through the Activities Main View
But the Outlook Integration could make it tricky and perhaps there was more to the problem
Kudos for going to your BP and documenting your fix in the thread!
02-05-2011 09:28 PM
I wonder how long it took for Intellisync to produce 89,000 ACTIVITY records?
It's a serious question; if it was creating them one-by-one in an endless loop, you'd think the user would have noticed, right? And why did it stop at 89,000 and not some other number? Maybe it was mass-copying them with one of those SQL INSERT INTO... SELECT FROM commands, and there was something wrong with the SELECT part - some sort of bad join, maybe, or nulls where there shouldn't be nulls.
02-06-2011 02:27 PM
Maybe a Cartesian Product (i.e. no join) - very common mistake for me in Access! Although I'm not sure how Intellisync would do such a thing.
Thanks,
Larry Esposito