Deleting SMOATTACHCONT table contents on comm station

[Former Member]

Hi All,

We are using CRM 5.0 solution with mobile clients.

We have been observing that the table dbo.SMOATTACHCONT on communication server ( DB MS SQL2005) growing rapidly. We assume that this table contains attachments which already been sync to CRM database. Due to sapce constrains we would like to delete the contents of the above table. With this we might get few GBs space and we assume we may get rid of perforance issues.

Is it advisabe to delete the contents of dbo.SMOATTACHCONT? is this data is required for any mobile queries and trasactions.

Thank you very much for your help.

KK

[Former Member]

Hi Again,

Thank you very much for your answers.

CDB has been used by our support consultants if they want to attend an issue raised by site technicians.

To attended site technician's issues we are contransing the data (which already been contransed by site techs) from CRM to comm station and analysing the issue with work group site.

Every contrans from CRM to Comm station is very time consuming and synching attachments also.

We would like to eliminate attachments for some contrans jobs and not for some (for those if the issue associates with attachments).

As Kai mentioned we can do by deleting the interlinking objects. Could you please let me know how to do this.

Thank you,

KK

[Former Member]

The interlinkage objects can be found in CRM Online -> tx. SMOEAC (Administration Console) -> Search for Interlinkages.

But be aware that if you delete them, the attachments will not be replicated to any of the mobile clients at all, not just the commstation site. If you do not want this, you need to write a little SQL which deletes the table entries and plan this as a regular job (see SQL Server help on this).

If conntrans lasts a long time: Did you set it up as a service? If not: Search the OSS for conntransservice or have a look at the conntransservice.exe in your mobile\bin folder.

Regards, Kai

[Former Member]

Hi Wolfhard,

This is a consolidated database which helps to sync the transcations between CRM and mobile clients.

Thanks,

[Former Member]

Hi again,

why do you need a DB between CRM and MSA? There is definitely no need for that. The data is queued in CRM and transported via comm. station without any saving somewhere to the mobile clients.

Probably you are using the comm.-station as a workgroup server but then there must be a related site definition in one of the CRM systems. There you could check the attachment subscriptions.

Regards,

Wolfhard

[Former Member]

The table you mention contains attachment data. If you do not need these, you can go and delete the table directly, but this would cause data inconsistencies between the sites.

You can of cause delete interlinkage objects linking the ATA object, but then attachments are no longer distributed at all, but if you are not needing them in MSA this could also be a solution.

Regards, Kai

[Former Member]

Hi,

why do you have a MSSQL database installed on the comm.-station? What is it good for?

Regards,

Wolfhard