AnsweredAssumed Answered

"The multi-part identifier ".id" could not be bound" error when viewing campaign status

Question asked by thowden thowden on Mar 26, 2014
Latest reply on Apr 1, 2014 by thowden thowden

Having sent test emails and checked everything, the 'live' campaign has been processed but the Campaign -> View Status page dies after the sugarchart section with a "Database failure. Please refer to sugarcrm.log for details." message.

Digging into the log I see:

03/26/14 14:46:06 [5068][232d6a73-7465-d6ef-4021-52015b2092cc][FATAL] Error retrieving Campaign list:  Query Failed:SELECT TOP 10 * FROM
                                  (SELECT ROW_NUMBER() OVER (ORDER BY .id) AS row_number,  campaign_log.*  FROM campaign_log WHERE campaign_log.campaign_id = N'e50e7242-757a-1d45-71e5-52f95e86b6b1' AND campaign_log.deleted=0 AND activity_type=N'send error' AND archived=0 AND marketing_id =N'9c42c9a3-c1b7-8ed8-9d60-53322c8c8108' )
                                           AS a
                                           WHERE row_number > 10::: [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier ".id" could not be bound.

I then copied and pasted this query into MS SQL Studio and confirmed that the error is in the (ORDER BY .id) section which should either read (ORDER BY or just (ORDER BY id) as the current table is correct.

I think the issue relates to the compiling of the SQL query but I cannot work out where to correct it.

Can anyone point me at the function or file that could be causing this.

SugarCRM CE 6.5.16 on Windows with MS-SQL