cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in Phase PREP_SPACECALC/LIST_LOAD_SPC using SUM SP07 to Update SolMan 7.1 to SPS08

Former Member
0 Kudos

Hello community,

I am currently trying to update a Solution Manager 7.1 SR1 SPS4 (fresh installation) to SPS08 using the SUM. I'm using the newest SUM "SUM10SP07_2-20006676.SAR" from the SWDC.

Operating system: Win Server 2008 R2

Database: MS SQL Server 2008 R2

In phase PREP_SPACECALC/LIST_LOAD_SPC the SUM stops because of the following error:

Severe error(s) occured in phase PREP_SPACECALC/LIST_LOAD_SPC!

Last error code set: tp failed with return code 237, check D:\SUM\abap\log\TPSQLSTD.OUT

TPSQLSTD.OUT:

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0237

tp finished with return code: 237

meaning:

  SQL-error

tp=>sapparam(1c): No Profile used.

tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: Statement: SELECT DISTINCT(PROG) FROM D010LINF ORDER BY PROG

ERROR: SQL ERROR 601: Could not continue scan with NOLOCK due to data movement.

SAPup> Process with PID 12344 terminated with status 237 at 20130526141029!

The last lines of the output of the "dbcc checkdb" are:

CHECKDB found 0 allocation errors and 75 consistency errors in table 'sm1.REPOLOAD' (object ID 1806629479).

CHECKDB found 0 allocation errors and 510 consistency errors in database 'SM1'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SM1)

This is a fresh Solution Manager 7.1 installation. I've only implemented two SAP Notes (875986, 1633725) and ran the initial / basic configuration. Could my activities be a reason for this inconsistencies?

Do you have any ideas how to solve this issue or should i restore the system (to the point before the SAP Notes implemenation and basic configuration)?

Best regards,

Marek


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Marek,

Perhaps you have some data corruption.

Check note 965530 - 601 Errors in SQL Server

Note 142731 - DBCC checks of SQL server

Kind Regards,

Johan

Former Member
0 Kudos

Hi Johan,

thank you for your reply.

I'll restore a backup.

Former Member
0 Kudos

Hi Marek,

Glad you managed, good luck.

Johan

Answers (0)