Skip to Content
avatar image
Former Member

System Copy "No SAP data found in the database XXX"

Dear SAP Experts,

in the next month i need to do my first homogenous system copy from production system to qas system.

Information to the envieroment:
- SQL Server 2008
- Windows Server 2008 R2 64bit
- Unicode Installation
- Netweaver 701 (ECC 6.0 EHP4)
- ABAP and JAVA Instance on the same Server with different DB-Sids (one for Java, one for ABAP)

I downloaded the latest SWPM and started the SWPM WITHOUT RESTORING THE DATABASE because first I want to take a look at the setup routine how it works.

Everything seems to be clear but i get the error message
"No SAP data found in the database xxx!"
in the Step define parameters.

I think the SWPM cannot find the DB?!?
What can cause this problem?

Kind regards,
Klaus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 14, 2016 at 12:30 PM

    Hi Klaus,

    I see you have already an incident opened with SAP for this case. Anyway, I investigated this error and we had very few cases with this!

    All of them were related to permission problems with the database users. It seems that the restore probably didn't make the users with enough permissions.

    Some SAP notes that you might be interested in looking at:

    592514 - MSSQL: internal database users, permissions and security

    1645041 - FAQ: Microsoft SQL Server logins and their usage in SAP environment

    I would recommend you to run a schema repair with Schema4SAP with SAP note 1294762 and try again.

    If anything it doesn't help, I left a message for the engineer assigned to your incident to look at this topic. The following logs are required for further analysis:

    - sapinst_dev.log

    - control.xml

    - summary.html

    - keydb.xml

    As well the results, from each database this has failed:

    SELECT	uid, status, name
    FROM	sys.sysusers
    WHERE	uid < 16384;
    ---------------------------------------------
    SELECT	*
    FROM	sys.schemas
    WHERE	schema_id < 16384;
    ---------------------------------------------
    SELECT	count(schema_id) as #objects, schema_id
    FROM	sys.objects
    GROUP	by schema_id;
    
    

    Best regards,

    Luis

    Add comment
    10|10000 characters needed characters exceeded