cancel

Repair space system recalculation

Highlighted
Patrick Crowley
Super Contributor.

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
EWillsey
Acclaimed Contributor.

Re: Repair space system recalculation

Describe the steps you're taking to initiate a recalculation.
Patrick Crowley
Super Contributor.

Re: Repair space system recalculation

Normal process,

hight light space system, right click and choose recalculate. 

Patrick Crowley
Super Contributor.

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

EWillsey
Acclaimed 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

Patrick Crowley
Super Contributor.

Re: Repair space system recalculation

will give it a try,

Thanks

Patrick Crowley
Super Contributor.

Re: Repair space system recalculation

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

EWillsey
Acclaimed 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?
Patrick Crowley
Super Contributor.

Re: Repair space system recalculation

Will check