Skip to Content
author's profile photo Former Member
Former Member

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

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


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 26, 2013 at 04:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.