Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Super Contributor
Posts: 21
Registered: ‎12-08-2009

Windows Event Error when Loading Groups

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".