Authority issues after homogeneous system copy - as/400 v5r1 - R/3 4.6C

[Former Member]

Hello,

I am trying to complete a homogeneous system copy of an R/3 system.

The source system is PRD - the target system is TST. The hardware platforms are different (both iSeries) but the kernel/pdf/OS patch levels are all identical.

The process I have follow so far is this:

1. Preprocessing of the R3PRDDATA library.

2. SAVLIB of R3PRDDATA.

3. Delete old R3TSTDATA lib on target system using QSECOFR

4. Create new R3TSTDATA using SQLUTIL as TSTOFR (TSTOFR is my user for the target system)

5. CHGOBJOWN OBJ(R3TSTDATA) OBJTYPE(*LIB) NEWOWN(TSTOFR)

6. GRTOBJAUT OBJ(R3TSTDATA) OBJTYPE(LIB) USER(SAP02) AUT(CHANGE)

7. Detach existing Journal, create new journal receiver, create new journal ...

DLTJRN JRN(R3TSTDATA/QSQJRN)

DLTJRNRCV JRNRCV(R3TSTJRN/QSQJRN0001)

CRTJRNRCV JRNRCV(R3TSTJRN/QSQJRN0001) THRESHOLD(500000)

CHGOBJOWN OBJ(R3TSTJRN/QSQJRN0001) OBJTYPE(*JRNRCV) NEWOWN(R3OWNER)

CRTJRN JRN(R3TSTDATA/QSQJRN) JRNRCV(R3TSTJRN/QSQJRN0001) MNGRCV(SYSTEM) DLTRCV(NO)

CHGOBJOWN OBJ(R3TSTDATA/QSQJRN) OBJTYPE(*JRN) NEWOWN(R3OWNER)

8. RSTLIB from tape.

9. AS4FIXFILE on R3TSTDATA with

DBLIB R3TSTDATA

CHGOWN *NO

ENDJRN *YES

STRJRN *YES

CHGFILE *NO

10. install license key

So from this point the system will start without a problem. However whenever I try and write something to the database I get this type of error (via SM21 or ABAP dump) message:

‘Database error -551 at SEL access to table BTCOPTIONS

Not authorized to object BTCOPTIONS in R3TSTDATA type *file

Job=378721/TST02/WP02’

Database error text........: "Not authorized to object SCPRACTR in R3TSTDATA

type *FILE. Job=379089/TST02/WP00"

I have also run GRTOBJAUT for the - TST02 user on the R3TSTDATA lib but still the same problem.

I'm certain the issue is related to the user on the 400 that is actually used by the work processes, and that user does not have the relevant rights to R3TSTDATA.

Any suggestions on how to resolve this problem will be humbly received.

Many thanks, Colin

[Former Member · Accepted solution]

Hello Colin,

In your step 6, should it be "TST02"?

Best regards,

Victor

[Former Member · Accepted solution]

Hi Victor I have also run GRTOBJAUT on the TST02 user but still the same problem.

regards, Colin

[Former Member · Accepted solution]

Hi,

step 9 is wrong ;-(((

old:

9. AS4FIXFILE on R3TSTDATA with

DBLIB R3TSTDATA

CHGOWN *NO

ENDJRN *YES

STRJRN *YES

CHGFILE *NO

correct:

9. AS4FIXFILE on R3TSTDATA with

DBLIB R3TSTDATA

CHGOWN *YES <<<<<

ENDJRN *YES

STRJRN *YES

CHGFILE *NO

it NEEDS to run with QSECOFR !!!

=> it will work !

GRTOBJAUT on all objects is rubbish only !!! no real solution!!!

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member · Accepted solution]

Hi Volker, yes this has fixed it thank you so much!!!