NAV 2013 to NAV 2018 CU2 upgrade error

abrar273

I´m upgradaing from Nav 13 to Nav 18, when ´m trying to compile objects I´m getting this error


Server instance: NAV2018CU2UPgraded
Tenant ID: <ii>default</ii>
<ii>Session type: UnknownClient
Session ID: 5
User: MyComputer\Administrator
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException
ErrorNumber: 102
SuppressMessage: False
DiagnosticsSuppress: False
SuppressExceptionCreatedEvent: False
FatalityScope: None
Message:
<ii>The following SQL error was unexpected:
Incorrect syntax near '$7'.
SQL statement:
DECLARE @StatisticsToDrop NVARCHAR(MAX);
SELECT @StatisticsToDrop = COALESCE(@StatisticsToDrop +', ', '') + '[CDEV$Cust_ Ledger Entry].'+ s.name
FROM sys.stats AS s
INNER JOIN sys.stats_columns AS sc ON (s.stats_id = sc.stats_id AND sc.object_id = s.object_id)
INNER JOIN sys.all_columns AS c ON (c.column_id = sc.column_id AND c.object_id = s.object_id)
WHERE s.object_id = OBJECT_ID('CDEV$Cust_ Ledger Entry')
AND (c.name = 'Customer Posting Group' OR
c.name = 'Salesperson Code' OR
c.name = 'No_ Series' OR
c.name = 'Recipient Bank Account' OR
c.name = 'Message to Recipient' )
@ROWCOUNT > 0 BEGIN
SET @StatisticsToDrop = CONCAT('drop statistics ', @StatisticsToDrop)
EXECUTE sp_executesql @StatisticsToDrop
END

Montgo

I am sorry ... wrong Post ...

Montgo

You have to sync the tables before you import the merged objects. Then it works fine ... Reading helps ;-) ...