Showing results for 
Search instead for 
Do you mean 

Repair space system recalculation

Frequent Advisor

Repair space system recalculation

We just imported records from prior build into 7.1x space.  The boxes are present, but we can't get the space to recalculate.   Did a schema repair, but no go.  Suggestions out there how to get the available space to recalculate?

We actullay rebuilt the space system in the new db prior to the import of the records. Thanks

8 REPLIES
Honored Contributor

Re: Repair space system recalculation

Describe the steps you're taking to initiate a recalculation.
Frequent Advisor

Re: Repair space system recalculation

Normal process,

hight light space system, right click and choose recalculate. 

Frequent Advisor

Re: Repair space system recalculation

The system shows the boxes but does not list capacity.  So for each space the avialbe ins negative value of

 

HP TRIM Workgroup Server running on diobr-arch02.diobr.local reported the following message:

 Error : AS  User: DIOBR-ARCH02 -  The SQL transaction 'UpdateSpaceCapacityHigherLevelTotals' failed for user ABOLTIN22401:3100 on command UPDATE TSSPACE  SET spCapacity = ( SELECT SUM(spCapacity) FROM TSSPACE SP2 WHERE SP2.spFullId BETWEEN (RTRIM(TSSPACE.spFullId) + RTRIM('-0000')) AND (RTRIM(TSSPACE.spFullId) + RTRIM('-ZZZZ')) AND SP2.spIsLowestLevel = 'T' AND SP2.uri > 0) WHERE TSSPACE.spIsLowestLevel = 'F' AND TSSPACE.uri > 0.

 

 Details : Cannot insert the value NULL into column 'spCapacity', table 'arch02.dbo.TSSPACE'; column does not allow nulls. UPDATE fails.

 

               Detailed ADO Errors

               Number                              = 0x80040e2f

               Source                  = Microsoft OLE DB Provider for SQL Server

               Description         = Cannot insert the value NULL into column 'spCapacity', table 'arch02.dbo.TSSPACE'; column does not allow nulls. UPDATE fails.

               SQLState                             = 23000

               NativeError         = 515

               Number                              = 0x80040e2f

               Source                  = Microsoft OLE DB Provider for SQL Server

               Description         = The statement has been terminated.

               SQLState                             = 01000

               NativeError         = 3621

Honored Contributor

Re: Repair space system recalculation

Manually fix it by executing this statement in the database:

 

 

update tsspace set spCacity = 0 where spCapacity is null

Frequent Advisor

Re: Repair space system recalculation

will give it a try,

Thanks

Frequent Advisor

Re: Repair space system recalculation

This didn't work either.  Still receiving negative space allocation.

Honored Contributor

Re: Repair space system recalculation

Odd... the SQL statement is trying to push a null value as a result from a sum. Sum's only return nulls when there's a null in the set of records being added.

Does it behave like this for all recalcs? Have you tried at the second to lowest possible level first?
Frequent Advisor

Re: Repair space system recalculation

Will check