08-15-2010 10:13 AM
I am getting the following ERROR in the Windows Event Log. This happens when I try to load any OPPORTUNITIES group.
Sage.SalesLogix.Client.GroupBuilder.GroupInfo - Error executing the group.
The SQL it specifiies is:
SELECT COUNT(*) TOTAL,A2.Address VALUE, A2.Address NAME FROM OPPORTUNITY A1 INNER JOIN ACCOUNT A2 ON (A1.ACCOUNTID=A2.ACCOUNTID) INNER JOIN ADDRESS A3 ON (A2.ADDRESSID=A3.ADDRESSID) GROUP BY A2.Address, A2.Address ORDER BY A2.Address
There is no "Address" column on the Account table. There's an "AddressId", but not "Address".