SYMPTOM:
When attempting to edit any service via the service wizard in a Strategy Narrowcast 9.x - 10.x, the following error message appears:
Unable to execute a SQL statement: DROP TABLE ggA83A629EA74640F19DE6FC625A194546a; Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HY000:-20241: on SQLHANDLE] [Strategy][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE -20241 For more information, please consult DB2 document for error code SQL020241.
CAUSE:This issue may occur because there is not enough space within the database used to complete the SQL query generated when editing a service through the service wizard. The "SQL 20241" error code can occur when dropped table recovery is enabled on the table space in which the dropped table (table-name) resides on the database. When a table space has "dropped table recovery" enabled, a history file entry is created as part of a table drop. This history file contains data which is useful for the recovery of a dropped table. The writing of the new history file entry for the dropped table failed. As a result, the table drop could not be completed.
ACTION:The user should consult with their Database Administrator to check if there is enough space available within their database, and to grant more space if necessary.
