Skip to Content
0

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

Dec 13, 2016 at 10:38 AM

121

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Luis Darui
Dec 14, 2016 at 12:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded