Which files can i delete on the Micollab server?

Putty on to Micollab (MSL) (If you don’t know how check here)

Despite how it sounds these files are safe to delete

/var/corefiles/*.core

Find other files that might be eating hard drive space here

How to: Where are SOS logs stored once zipped?

/var/cache/e-smith/logcollector

How to: Find large files on MSL

Putty to the Micollab (if you don’t know how to do this click here)

find . -type f -size +50M

 

Despite how it sounds these files are safe to delete

/var/corefiles/*.core

MICC error Foreign Key Constraints

Source

 

Problem: tblConfig_AgentGroupMembers : ForeignKeyConstraint tblConfig_AgentGroup_tblConfig_AgentGroupMembers_fk_constraint requires the child key values (d5dac6e3-f237-40bc-806b-2d9d4713c066) to exist in the parent table.

select * from tblConfig_AgentGroupMembers where FKAgentGroup like ‘d5dac6e3-f237-40bc-806b-2d9d4713c066’

Problem: Error: 2018-Jun-13 16:29:29.376   Synchronization failed – System.Data.ConstraintException: tblConfig_QueueAgentGroupMembers : ForeignKeyConstraint tblConfig_Queue_tblConfig_QueueAgentGroupMembers_fk_constraint requires the child key values (c3ca877f-85ca-41be-b3bc-bef09140752b) to exist in the parent table.

statement to find it: select * from tblConfig_QueueAgentGroupMembers where FKQueue like ‘c3ca877f-85ca-41be-b3bc-bef09140752b’

To remove change remove select * and replace with del