cancel
Showing results for 
Search instead for 
Did you mean: 

Change schema for SAPR3 user ?

nelis
Active Contributor
0 Kudos

Hi,

I installed a new sandbox system and did a restore from our DEV system. I changed the xuser SAPR3 entry to match that of the DEV system but the workprocess trace is telling me user SAPR3 is using the wrong schema and so the system will not start.

C *** ERROR => the connected user (SAPR3) does not work with the right user/schema

[dbslsdb.cpp 4846]

C *** ERROR => application has to work with schema SAPSNB (dbs/ada/schema)

[dbslsdb.cpp 4848]

How do I change the schema for the SAPR3 user ? (I couldn't find any notes/docs on this)

Thanks !

Regards,

Nelis

ps. using MaxDB 7.6.06.09 64bit on Linux.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Try to use profile parameter dbs/ada/schema=SAPR3

also check Note 39439 - XUSER entries for SAP DB and MaxDB

regards,

kaushal

Answers (2)

Answers (2)

nelis
Active Contributor
0 Kudos

I actually found the answer in [Note 129352 - Homogeneous system copy with MaxDB (SAP DB)|https://service.sap.com/sap/support/notes/129352] to replace profile parameter dbs/ada/schema with SAPR3. So Kaushal was correct

Thanks !

Nelis

Former Member
0 Kudos

Hi Nelis,

Are you sure that SAPR3 is not the sql mode in the xuser entries?

Can you post the output of: select username from all_users

You probably have to add SAPDEV (if DEV is your development SID) to the xuser file.

Kind regards,

Mark Dijsselbloem