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 [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' )
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 campaign_log.id) 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