My Oracle Support Banner

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 FEBRUARY 08, 2019

Applies to:

Siebel Life Sciences CRM - Version 8.1.1.11 [IP2013] 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.