Issue
When upgrading from K2 4.7 to K2 Five (5.4) or applying the Cumulative UpdateFix Pack you may experience the below error in the Installer trace log file.
Error Code
Exception: An exception occurred while executing a Transact-SQL statement or batch.
Incorrect syntax near '<'. An object or column name is missing or empty.....
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or are not allowed. Change the alias to a valid name.
Resolution
You will need to contact Nintex Support team and provide them with the below tables and Installer trace logs.
SQL Queries
SELECT * FROM [K2].[HostServer].[Securitylabel] SELECT * FROM [K2].[Identity].[ClaimAudience] SELECT * FROM [K2].[Identity].[ClaimIssuer] SELECT * FROM [K2].[Identity].[ClaimRealm] SELECT * FROM [K2].[Identity].[ClaimRealmIssuer] SELECT * FROM [K2].[Identity].[ClaimTypeMap] SELECT * FROM [K2].[Identity].[ClaimTypeMapping] SELECT * FROM [K2].[HostServer].[Configuration]
Installer logs locations
- %temp%K2 Setup Log
- [K2 install location]SetupLog
- [K2 install location]SetupUpdateLog
- [K2 install location]SourceCode.Configuration.ApiLogs
When attaching them to the case, ensure the following naming conventions are followed
for each of the categories above for the .zip files where applicable:
- K2 Setup Log
- Setup_Log
- Setup_Update_Log
- Api_Logs
Additional Information
Related Links