Code Fix: Error occurs when trying to install a K2 Cumulative Update

Issue Description

When you attempt to install a K2 Cumulative Update on a multiple domain environment, an error occurs.

Error Message:

The following error occurs:

“...:>> 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

The fix is available in:

• K2 Five (5.4) March 2022 Cumulative Update Fix Pack 14.

1. Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed.
2. Download the latest Fix Pack using the links in the table above for the version you require.
3. Install the Fix Pack to apply the fix.

Considerations

If you are already blocked by the installer, follow the steps below:

NOTE: Ensure the failure occurs in the SourceCode.Data.ServerLog.inject.sql script before continuing with the steps below.

1. Go to the [Extracted Location][K2 Version]InstallationApps
2. Open the K2 Database.zip.
3. Go into this zip to Data -> Script Output.
4. Copied and paste the attached SourceCode.Data.ServerLog.inject.sql into this location.
5. It will prompt you to replace the entire file. Replace the file at this point.
6. Once you have replaced the file, open the SQL file with Notepad and see that it corresponds with the following:

------------------------------------------------------------------------------------------------------------------------

-- BEGIN : Use a Synonym to ensure cross-database support in GetIdentityAndContainers

------------------------------------------------------------------------------------------------------------------------

IF NOT EXISTS

(

SELECT * FROM SYS.SCHEMAS WHERE NAME = N'Identity'

)

BEGIN

EXECUTE SP_EXECUTESQL N'CREATE SCHEMA [Identity]'

CREATE SYNONYM [Identity].[GetIdentityAndContainers] FOR [Identity].[GetIdentityAndContainers];

END

GO

7. Run the Recover option and the install should continue without any errors.