Siebel Upgrade to 8.1.1.11 did not stop after Sql Server error : Could not allocate space for object 'dbo.SORT temporary run storage (Doc ID 1627538.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Life Sciences CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Symptoms

While upgrading Siebel from 7.8.x to 8.1.1.11, an error occurred during the indexes re-creation. In this case, the affected index is S_AUDIT_ITEM_P1. Siebel did not stop the upgrade.

 

 [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not allocate space for object 'dbo.SORT temporary run storage: 422212577918976' in database 'qtsiebdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.


This caused that P1 index remained UNIQUE as defined in version 7.8.x.
Also, the log parse utility did not show the error in summary.html file.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms