LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Introduction


When a SQL Script is run, such as K2ServerAlter.sql, and the user does not have the correct permissons, excess memory is used by the K2 Server.

Error Scenario

Note: The circumstances described in this article are one scenario under which this issue may, or is known to occur. The description is intended to be specific to the scenario descirbed and does not take into account all possible scenarios or circumstances.
When the K2ServerAlter.sql script is run, and the user's default namespace is not [dbo], this reults in the script not being able to execute because the specified user does not have the correct database access rights. The K2 Server will however retry; the sql script is rerun which results in excess memory usage.

Error Resolution


Option 1 (Recommended only for users familiar with the relevant databases)

Where relevant, all users's namespace should be set to [dbo]

Option 2 (This option is recommended for best results)

The latest K2 blackpearl 0807 Update is available as an independent installation package which can be found here: http://portal.k2.com/downloads/bp/default.aspx