Hi,

I am getting an issue where when a user attach a file into SLX under Accounts: Attachments tab it seems to duplicate itself. I can see multiple copies of same attachment.

I tried attaching with Admin user and it is working fine.

Any idea/suggestion?

Thanks,

Karna

Hi,

This sounds like an old bug. You need to edit the Attachments form and change the join on the RemoteAttachments table from an Inner to a Left Join (If I remember rightly)

Yep, tought so! Found it (Assuming it is the same issue)

Duplicate values are displayed in the Account.Attachments tab

Defect ID: 1-51287 & 1-51314

Description:

Duplicate values are displayed in the Account:Attachments tab.

Two tables are used with the Attachments datagrid. Attachment and RemoteAttachments with a one to many relationship from Attachment to RemoteAttachments.  If the child table has multiple records in it for the same file then a network user will see multiple values for the same attachment.

SELECT A1.ATTACHID, A1.DESCRIPTION, A1.USERID, A1.ATTACHDATE, A1.FILESIZE, A2.STATUS A2_STATUS, A1.ACCOUNTID, A1.FILENAME FROM ATTACHMENT A1 LEFT OUTER JOIN REMOTEATTACHMENTS A2 ON (A1.ATTACHID=A2.ATTACHID) WHERE A1.ACCOUNTID = '<Accountid>'

Steps to reproduce:

This can be duplicated by having two remote users request the same attachment from the same account.  When the Account:Attachments tab is viewed from the host multiple results will be displayed for the same file.

Workaround:

Sub OnFormOpen

    Dim col

    InitSec

    Set col = grdAttach.Columns.Item("A2_STATUS") 'DNL

    If Not (col Is Nothing) Then

       col.Visible = Not gBlnHostDB

       Set col = Nothing

    End If

    'Fix begins here for duplicate attachments appear for network users

    Dim strCurrentUser, strSiteCode

    strCurrentUser = Application.BasicFunctions.CurrentUserID

    strSiteCode = Trim(GetField("PrimarySite", "UserSecurity", "UserID='" & strCurrentUser & "'"))

    strSQL = grdAttach.SQL

    strSQL = Replace(strSQL, "ON (A1.ATTACHID=A2.ATTACHID)", _

                             "ON (A1.ATTACHID=A2.ATTACHID) AND (A2.SITECODE='" & strSiteCode & "')")

    grdAttach.SQL = strSQL

    'End-Fix for duplicate attachments appear for network users

End Sub

Possible Resolution:

This is a know reported issue in SalesLogix version 7.0.1. To resolve:

• Apply service pack 2,


• Upgrade to version 7.2.1 or later
  
  

Thanks, We are using SLX V 7.0.2. Also I have checked the query in data grid. It is:

SELECT A1.ATTACHID, A1.DESCRIPTION, A1.USERID, A1.ATTACHDATE, A1.FILESIZE, A2.STATUS A2_STATUS, A1.ACCOUNTID, A1.FILENAME FROM ATTACHMENT A1 LEFT OUTER JOIN REMOTEATTACHMENTS A2 ON (A1.ATTACHID=A2.ATTACHID) WHERE A1.ACCOUNTID = :BindID

I guess this is the right one?

Also Wanted to know when we apply this solution,will it correct the previous duplicate entries under account:attachment?

Thats the one!

Also, it will correct the previous 'duplicates' (They are not actually duplicates, just displayed as duplicates)

But still I can see multiple entries under that tab.

Also I ran this query for a account on database and there are multiple entries as well with same attachid.

Change the join from a Left to an Inner on the Account | Attachments view. Failing that, upgrade to SP2