Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
AK
New Member
Posts: 24
Registered: ‎05-20-2011

Too much 'Activities on No Calendar' created atfer integrity check

Yesterday i've run integrity checker tool (Previous slx administrator never runs this tools).

When 'repair' was completed, user's find a huge number of activity, that was already closed.

And now they active again.

Some users have 800+ such 'new' activity. Is it possible to close them automatically?

 

 

 

 

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

integrity checker log:

==================================================

Number of tests selected is 118

 

Account Summary where Account has been deleted. (Delete)

    33 Records found.

 

Account Summary with the wrong owner (Set to Account owner)

    1 Records found.

 

Accounts with missing Addresses (Created)

    1 Records found.

 

Accounts with missing Shipping Addresses (Set to Address)

    1 Records found.

 

Activities on No Calendar (Create)

    1798 Records found.

 

Activities with bad Contact IDs (Delete)

    2 Records found.

 

User Activity Records with Bad Activity IDs (Delete)

    9 Records found.

 

User Notification Records with Bad To User IDs (Delete)

    1 Records found.

 

Attachments with bad file name/path. VBS (Delete)

 

Bad Contact LastName Mirrors (Uppercase)

    4 Records found.

 

Contact link to Account is broken. (Fix)

    7 Records found.

 

Contact_LeadSource: Unattached to Lead Sources (Delete)

    2 Records found.

 

Contacts with missing Addresses (Created)

    30 Records found.

 

Contacts with missing Shipping Addresses (Set to Address)

    30 Records found.

 

Contacts with no Account (Delete)

    23 Records found.

 

Contacts with the wrong owner (Set to Account owner)

    13 Records found.

 

Histories with bad Account IDs (Clear)

    9 Records found.

 

Histories with bad Contact IDs (Clear)

    18 Records found.

 

Histories with bad Opportunity IDs (Clear)

    6 Records found.

 

Library Documents with bad file name/path. VBS (Delete)

 

[Purge HIST_LEAD

    3478 Records found.

 

Opportunities with the wrong owner (Set to Account owner)

    22 Records found.

 

Opportuntity_Contact: Unattached to Contacts (Delete)

    1 Records found.

 

Opportuntity_Product: Unattached to Products (Delete)

    1 Records found.

 

Attachments with no or invalid TicketID (Delete Attachment)

    12 Records found.

 

Ticket Activities with no or invalid TicketID (Delete TicketActivity)

    19711 Records found.

 

Ticket History with no or invalid TicketID (Delete TicketHistory)

    31 Records found.

 

Ticket Problems with no or invalid TicketID (Delete TicketProblem)

    1 Records found.

 

Ticket Solutions with no or invalid TicketID (Delete TicketSolution)

    1 Records found.

 

Tickets with invalid Contract ID (Clear ContractID)

    2 Records found.

 

Tickets with invalid owner (Set to Everyone)

    11 Records found.

 

Tickets with missing TicketProblem (Create TicketProblem)

    1578 Records found.

 

Tickets with missing TicketSolution (Create TicketSolution)

    2240 Records found.

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

I guess, that something wrong with 'activities on No calendar':

 

=== List SQL =========================
SELECT ACTIVITYID, USERID, ACCOUNTID, ACCOUNTNAME, CONTACTID, CONTACTNAME, DESCRIPTION, CREATEDATE
FROM ACTIVITY A1
WHERE NOT EXISTS
(SELECT ACTIVITYID FROM USER_ACTIVITY A2
WHERE A1.ACTIVITYID = A2.ACTIVITYID)

=== Repair SQL =========================
INSERT INTO USER_ACTIVITY (ACTIVITYID, USERID, CONFIRMED) SELECT ACTIVITYID, USERID, 'T'
FROM ACTIVITY A1
WHERE NOT EXISTS
(SELECT ACTIVITYID FROM USER_ACTIVITY A2
WHERE A1.ACTIVITYID = A2.ACTIVITYID)

 

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

So, i see that 'repair' script insert data into table 'User_Activity' (system table).

I've restore this table from backup to another MSSQL server and copy by DTS to production server as table 'User_Activity1'.

 

Is it right way to rollback this new activities or not?

 

UPDATE sysdba.USER_ACTIVITY
SET CONFIRMED = 'F'
WHERE 1 = 1
and [ACTIVITYID] IN
( select [activityid] from sysdba.USER_ACTIVITY1

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

Also, i can't understand the DB's structure around this table: activities, user_activities and usernotification (last two - system table, you can't see them in DB manager, only via native Microsoft tools)

Activities are stored in sysdba.ACTIVITY. OK.

What are stored into User_Activities? And UserNotification?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Too much 'Activities on No Calendar' created atfer integrity check

No.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Too much 'Activities on No Calendar' created after integrity check

[ Edited ]

The Integrity Test is doing exactly what it is supposed to be doing - it is reporting Activities that are not  (also) in User_Activity...

 

Background:

   When an Activity is created, there is also a corresponding User_Activity created. It is the User_Activity (w/the Activity) That enables the Activity to show up on a user calendar.

 

You said you took over from a prev Slx Admin. Is it possible there's a customization in the system that "parks" "special activities" in the activity table and does NOT create the corresponding User_Activity record on purpose? We have done such customizations for clients before.... Or maybe it's a bad customization and is not setting the. There's also the possibility it's caused by another set of conditions/bugs...

 

I suggest the following:

   A - Get in contact w/your BP and have them take a look.

   B - Contact Sage SalesLogix Tech Support and have them take a look

   C - Go to SageU and take training in Administration of SalesLogix.

 

You can't assume anything from just the db side. It's all about the overall application/customization.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

Hm.... delete all this inserted records? (And never run this check for 'activiies'?)

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Too much 'Activities on No Calendar' created atfer integrity check

You cannot assume it's the right course of action - 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Too much 'Activities on No Calendar' created atfer integrity check

Globally, you're right. But today our tech_support fully paralyzed: there's no way to determine which activity are right.

The first thing is to get back to 'normal' situation.

And the second - find the way how-to insert correctly in 'User_Activity' table.