Hi All,

I previously posted this on the Sage Community forum but I'm hoping there will be a different audience here who might know the answer:

I have added some custom entities to SalesLogix Web.  To allow the users to build Contact groups that include my entities I have created a global join from Contact into the "first layer" of my new entities (I have added more than one entity) and global joins between my entities.

When I build a Contact group that includes my first new entity, everything works OK.  When I include the next level I get no data returned and the event log on the server shows a "Failed to Parse SQL" error.  I have included the error details below.  For some reason it seems to have messed up the SQL in the second join by including a ">" and missing off the field name after "=A3.".

The same group works absolutely fine in the LAN client.  Has anyone seen this before and knows a work-around or fix?

This is on 7.5.3.4227 with web hot fixes up to HF8 installed.

2012-08-14 17:27:15,002 ERROR Sage.SalesLogix.Client.GroupBuilder.GroupInfo - GetGroupDataReader Failed
SqlELECT TOP 50  A1.CONTACTID   FROM CONTACT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) LEFT OUTER JOIN EMADDRESSBOOKMEMBER A3 ON (A1.CONTACTID>SLXCONTACTID.EMADDRESSBOOKMEMBER!EMADDRESSBOOKID=A3.) LEFT OUTER JOIN EMADDRESSBOOK A4 ON (A3.EMADDRESSBOOKID=A4.EMADDRESSBOOKID) LEFT OUTER JOIN EMEMAILACCOUNT A5 ON (A4.EMEMAILACCOUNTID=A5.EMEMAILACCOUNTID) WITH FIRSTROW 0 ORDER BY A1.LASTNAME ASC, A1.FIRSTNAME ASC,  A1.CONTACTID  ASC
GroupId: pDEMOA0000R2
Group Name: DDDDDDD
Current User: ADMIN
Error Message: Failed to parse SQL.
Stack Trace:    at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetGroupDataReader(Boolean DoPaging, Int32 FirstRow, Int32 PageSize, String SortField, Boolean JustIDs, Boolean invertOrder)

redo the group, one join at a time. Always Build complex groups in the LAN.