Error came in the phase : SQLSCREXE_ALI_ORG

[Former Member]

Hi Technology consultants,

I am Upgrading CRM4.0 to CRM2007 on Oracle with Solaris 10, i got PREPARE phase completed successfully.But in UPGRADE phase getting an issue, Executes scripts for shadow instance was failed.

ERROR: during execution of script 'ALORDC.XQL'.

Error found in logfile or standard output file.

Check log files 'TPSQLSTD.OUT' and 'ALORDC.LOG'.

Still i am unable to solve the issue, plz do the needful.

Thanks & Regards,

srini.

[Former Member]

Hi,

Execute this :

1. Grant dba to <SAPSID> /or <SAPR3>.

2.Grant dba to <SAPSIDSHD>.

Also try Grant All .....

Regards,

Chetan.

[Former Member]

Did you got resolution to this issue???

Thanks & Regards,

Vinod Bhat

[Former Member]

Hi Mark,

After given privileges for SVERS, repeat the phase SQLSCREXEE_ALI_LOG , still it stucked in same phase.

The logfile of TPSQLSTD.OUT showing highest tp internal error 0200.

But i checked in /usr/sap/put/exe/R3trans -d shows rc<0000>.

plz do the needful.

Best Regards,

srini.

[Former Member]

Srini,

The ORA-01031 should no longer occur now. Please run the upgrade phase again. In case it fails, send me the same logs as the first time.

Regards,

Mark

[Former Member]

Srini,

Definitely some authorizations missing there...

Please do the following:

sqlplus / as sysdba

grant SAPDBA to SAPC01SHD;

grant SELECT on SAPC01.SVERS to SAPDBA;

To make sure the tables are there, also enter the following two commands:

select owner,table_name from dba_tables where table_name like 'SVERS%';

select owner,synonym_name,table_owner,table_name from dba_synonyms

where table_name like 'SVERS%';

Let me know the results.

Regards,

Mark

[Former Member]

Hi Markh,

Once again thanks alot, As u said i executed same commands it showing below result.

SQL>grant SAPDBA to SAPC01SHD;

grant succeeded.

SQL>grant SELECT on SAPC01.SVERS to SAPDBA;

grant succeeded.

SQL>select owner,table_name from dba_tables where table_name like 'SVERS%';

OWNER TABLE_NAME

-

---

-

---

SAPC01SHD SVERS1

SAPC01 SVERS~

SAPC01 SVERS

SQL>select owner,synonym_name,table_owner,table_name from dba_synonyms where table_name like 'SVERS%';

OWNER SYNONYM_NAME

-

---

-

---

TABLE_OWNER TABLE_NAME

-

---

-

---

PUBLIC SAP_USERS

SAPC01 SVERS

SAPC01SHD SVERS

SAPC01 SVERS~

Thanks and Regards,

srini.

[Former Member]

Hi Markh,

Thanks for ur reply, as u said i follwed but i am getting the following result.

SQL>select * from dba_role_privs where grantee='SAPC01SHD';

GRANTEE GRANTED_ROLE ADM DEF

-

---

SAPC01SHD SELECT_CATALOG_ROLE NO YES

SAPC01SHD SAPCONN NO YES

and also checked SQL>select * from SVERS;

it showing table or view does not exist.

Plz do the needful.

Best Regards,

srini.

[Former Member]

Hi Srini,

I notice you also seem to have a support message open at SAP for this (715526/2008), so being SAP myself I have to be careful not to contradict or overrule the advice you get from the support side. The ORA-01031 indicates that the shadow user (SAPC01SHD) is not authorized to execute the indicated SELECT statement. Perhaps something went wrong in the creation of this shadow user. Could you try the following:

sqlplus

connect SAPC01SHD/SAP

select * from SVERS;

select * from SAPC01.SVERS;

connect / as SYSDBA

select * from dba_role_privs where grantee = 'SAPC01SHD';

==> column GRANTED_ROLE should include "SAPDBA"

select privilege from dba_tab_privs where grantee in ('SAPC01SHD','SAPDBA')

and table_name = 'SVERS';

==> should list privilege "SELECT"

In the meantime I'll keep an eye on the support ticket as well.

Rgds,

Mark

[Former Member]

Hi Srini,

Please send the contents of the two logs mentioned in the error message. Also attach the file ALORDC.XQL itself (which you will find in /usr/sap/put/bin).

Regards,

Mark

[Former Member]

Hi Mark,

Thanks for ur response, i provided the logfile for ALORDC.XQL is

1. SQL script generated during phase SCRGEN_ALI_ORG.

2. aliases for original tables

> ALORDR.LOG

DROP SYNONYM "RSS_CTS_SERIAL";

DROP SYNONYM "RSS_DD12L";

DROP SYNONYM "RSS_E070";

DROP SYNONYM "RSS_E070A";

DROP SYNONYM "RSS_E070C";

DROP SYNONYM "RSS_E070M";

DROP SYNONYM "RSS_E070TC";

DROP SYNONYM "RSS_E071";

DROP SYNONYM "RSS_E071C";

DROP SYNONYM "RSS_E071E";

DROP SYNONYM "RSS_E071K";

DROP SYNONYM "RSS_E071KF";

DROP SYNONYM "RSS_E07T";

DROP SYNONYM "RSS_TADIR";

DROP SYNONYM "RSS_TLOCK";

#? EAZPGGYY

1. END

and TPSQLSTD.OUT logfile below mentioned

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 21421 at 20080829234927

ENV <0x8dec04>: auth_shadow_upgrade=1

ENV <0x8e52ec>: DIR_LIBRARY=/usr/sap/put/exe

ENV <0xffbffbf9>: dbs_ora_tnsname=C01

ENV <0xffbffc0d>: dbms_type=ORA

ENV <0xffbffc34>: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV <0x8e56ec>: LD_LIBRARY_PATH=/usr/sap/put/exe:/usr/jdk/instances/jdk1.5.0/jre/lib/sparc/server:/usr/jdk/instances/jdk1.5.0/jre/lib/sparc:/usr/jdk/instances/jdk1.5.0/jre/../lib/sparc:/usr/sap/C01/SYS/exe/run:/oracle/C01/102_64/lib:/oracle/client/10x_64/instantclient_10202:/usr/sap/put/exe

ENV <0xffbffdc4>: ORACLE_SID=C01

ENV <0xffbffdd3>: ORACLE_BASE=/oracle

ENV <0x8df004>: dbs_ora_schema=SAPC01

ENV <0xffbffe13>: PATH=/oracle/C01/102_64/bin:/home/c01adm:/usr/sap/C01/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

ENV <0xffbffe76>: ORACLE_PSRV=C01

ENV <0xffbfff53>: ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

ENV <0xffbfff8a>: ORACLE_HOME=/oracle/C01/102_64

EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/EXDBNEW.TPP execdbscript C01 -x ALORDC.XQL

This is /usr/sap/put/exe/tp version 372.04.36 (release 700)

ERROR: Connect to C01 failed (20080829234927), failed to read table SVERS.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

TRACE-INFO: 1: [dev trc ,00000] Fri Aug 29 23:49:27 2008 56312 0.056312

TRACE-INFO: 2: [dev trc ,00000] load shared library (/usr/sap/put/exe/dboraslib.so), hdl 0

TRACE-INFO: 3: 40 0.056352

TRACE-INFO: 4: [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 1507 0.057859

TRACE-INFO: 5: [dev trc ,00000] -->oci_initialize (con_hdl=0) 42 0.057901

TRACE-INFO: 6: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 32477 0.090378

TRACE-INFO: 7: [dev trc ,00000] Logon as OPS$-user to get SAPC01SHD's password 66 0.090444

TRACE-INFO: 8: [dev trc ,00000] Connecting as /@C01 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

TRACE-INFO: 9: 58 0.090502

TRACE-INFO: 10: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

TRACE-INFO: 11: 59 0.090561

TRACE-INFO: 12: [dev trc ,00000] 0 WE8DEC 1 1014cb238 1014d2cb8 1014d6650

TRACE-INFO: 13: 46 0.090607

TRACE-INFO: 14: [dev trc ,00000] Allocating service context handle for con_hdl=0 188 0.090795

TRACE-INFO: 15: [dev trc ,00000] Allocating server context handle 41 0.090836

TRACE-INFO: 16: [dev trc ,00000] Attaching to DB Server C01 (con_hdl=0,svchp=1014d6580,srvhp=1014d8920)

TRACE-INFO: 17: 104 0.090940

TRACE-INFO: 18: [dev trc ,00000] Assigning server context 1014d8920 to service context 1014d6580

TRACE-INFO: 19: 101760 0.192700

TRACE-INFO: 20: [dev trc ,00000] Allocating user session handle 68 0.192768

TRACE-INFO: 21: [dev trc ,00000] Starting user session (con_hdl=0,svchp=1014d6580,srvhp=1014d8920,usrhp=1014d34d0)

TRACE-INFO: 22: 65 0.192833

TRACE-INFO: 23: [dev trc ,00000] Assigning user session 1014d34d0 to service context 1014d6580

TRACE-INFO: 24: 37009 0.229842

TRACE-INFO: 25: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=1014e1360)

TRACE-INFO: 26: 154 0.229996

TRACE-INFO: 27: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

TRACE-INFO: 28: 49 0.230045

TRACE-INFO: 29: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=1014e23b8)

TRACE-INFO: 30: 251 0.230296

TRACE-INFO: 31: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

TRACE-INFO: 32: 43 0.230339

TRACE-INFO: 33: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e23b8) 1809 0.232148

TRACE-INFO: 34: [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

TRACE-INFO: 35: 44 0.232192

TRACE-INFO: 36: [dev trc ,00000] Connected to session 53. 7380 0.239572

TRACE-INFO: 37: [dev trc ,00000] Now '/@C01' is connected: con_hdl=0, nls_hdl=0, session_id=53.

TRACE-INFO: 38: 41 0.239613

TRACE-INFO: 39: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e23b8) 57 0.239670

TRACE-INFO: 40: [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

TRACE-INFO: 41: 42 0.239712

TRACE-INFO: 42: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e23b8) 798 0.240510

TRACE-INFO: 43: [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

TRACE-INFO: 44: 43 0.240553

TRACE-INFO: 45: [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER 1046 0.241599

TRACE-INFO: 46: [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 32 0.241631

TRACE-INFO: 47: [dev trc ,00000] Disconnecting from connection 0 ... 83 0.241714

TRACE-INFO: 48: [dev trc ,00000] Rolling back transaction ... 78 0.241792

TRACE-INFO: 49: [dev trc ,00000] Closing user session (con_hdl=0,svchp=1014d6580,usrhp=1014d34d0)

TRACE-INFO: 50: 358 0.242150

TRACE-INFO: 51: [dev trc ,00000] Now I'm disconnected from ORACLE 1962 0.244112

TRACE-INFO: 52: [dev trc ,00000] Try to connect with default password 30 0.244142

TRACE-INFO: 53: [dev trc ,00000] Connecting as SAPC01SHD/<pwd>@C01 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

TRACE-INFO: 54: 44 0.244186

TRACE-INFO: 55: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

TRACE-INFO: 56: 47 0.244233

TRACE-INFO: 57: [dev trc ,00000] 0 WE8DEC 1 1014cb238 1014d2cb8 1014d6650

TRACE-INFO: 58: 45 0.244278

TRACE-INFO: 59: [dev trc ,00000] Assigning username to user session 1014d34d0 37 0.244315

TRACE-INFO: 60: [dev trc ,00000] Assigning password to user session 1014d34d0 37 0.244352

TRACE-INFO: 61: [dev trc ,00000] Starting user session (con_hdl=0,svchp=1014d6580,srvhp=1014d8920,usrhp=1014d34d0)

TRACE-INFO: 62: 46 0.244398

TRACE-INFO: 63: [dev trc ,00000] Assigning user session 1014d34d0 to service context 1014d6580

TRACE-INFO: 64: 10253 0.254651

TRACE-INFO: 65: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=1014e0d78)

TRACE-INFO: 66: 89 0.254740

TRACE-INFO: 67: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

TRACE-INFO: 68: 44 0.254784

TRACE-INFO: 69: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=1014e1360)

TRACE-INFO: 70: 87 0.254871

TRACE-INFO: 71: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

TRACE-INFO: 72: 43 0.254914

TRACE-INFO: 73: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e1360) 1098 0.256012

TRACE-INFO: 74: [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

TRACE-INFO: 75: 43 0.256055

TRACE-INFO: 76: [dev trc ,00000] Connected to session 53. 737 0.256792

TRACE-INFO: 77: [dev trc ,00000] Now 'SAPC01SHD/<pwd>@C01' is connected: con_hdl=0, nls_hdl=0, session_id=53.

TRACE-INFO: 78: 42 0.256834

TRACE-INFO: 79: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e1360) 55 0.256889

TRACE-INFO: 80: [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

TRACE-INFO: 81: 43 0.256932

TRACE-INFO: 82: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e1360) 775 0.257707

TRACE-INFO: 83: [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET') ORDER BY PARAM

TRACE-INFO: 84: 43 0.257750

TRACE-INFO: 85: [dev trc ,00000] ETER

TRACE-INFO: 86: 42 0.257792

TRACE-INFO: 87: [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 975 0.258767

TRACE-INFO: 88: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e1360) 81 0.258848

TRACE-INFO: 89: [dev trc ,00000] SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

TRACE-INFO: 90: 43 0.258891

TRACE-INFO: 91: [dev trc ,00000] DB instance C01 is running on crmdev1 with ORACLE version 10.2.0.2.0 since AUG 26, 2008, 16:38:03

TRACE-INFO: 92: 1023 0.259914

TRACE-INFO: 93: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=1014e1360) 58 0.259972

TRACE-INFO: 94: [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

TRACE-INFO: 95: 43 0.260015

TRACE-INFO: 96: [dev trc ,00000] build_stmt: reallocating stmt buffer: 256 -> 2000 characters

TRACE-INFO: 97: 19569 0.279584

TRACE-INFO: 98: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=26, stmth_p=1014e1360)

TRACE-INFO: 99: 111 0.279695

TRACE-INFO: 100: [dev trc ,00000] SELECT VERSION FROM SVERS

TRACE-INFO: 101: 43 0.279738

TRACE-INFO: 102: [dev trc ,00000] DbSlRead(): table='SVERS' 73 0.279811

TRACE-INFO: 103: [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 1970 0.281781

TRACE-INFO: 104: [dev trc ,00000] SQL error 1031: 'ORA-01031: insufficient privileges' 32 0.281813

TRACE-INFO: 105: [dbsloci. ,00000] *** ERROR => Error 1031 in stmt_fetch() from oci_execute_stmt(), orpc=0

TRACE-INFO: 106: 89 0.281902

TRACE-INFO: 107: [dbsloci. ,00000] *** ERROR => ORA-1031 occurred when executing SQL stmt (parse error offset=20)

TRACE-INFO: 108: 60 0.281962

TRACE-INFO: 109: [dev trc ,00000] sc_p=1014177b8,no=0,idc_p=0,con=0,act=1,slen=26,smax=256,#vars=0,stmt=101570768,table=SVERS

TRACE-INFO: 110: 61 0.282023

TRACE-INFO: 111: [dev trc ,00000] SELECT VERSION FROM SVERS ; 28 0.282051

TRACE-INFO: 112: [dev trc ,00000] set_ocica() -> OCI or SQL return code 1031 28 0.282079

TRACE-INFO: 113: [dev trc ,00000] sc_p=1014177b8,no=0,idc_p=0,con=0,act=1,slen=26,smax=256,#vars=0,stmt=101570768,table=SVERS

TRACE-INFO: 114: 58 0.282137

TRACE-INFO: 115: [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0,ocistmth_p=1014e1360

TRACE-INFO: 116: 42 0.282179

TRACE-INFO: 117: [dev trc ,00000] IN : cols=0,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=0,vda_p=0

TRACE-INFO: 118: 46 0.282225

TRACE-INFO: 119: [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0 30 0.282255

TRACE-INFO: 120: [dev trc ,00000] OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=72,vmax=32,bound=1,iobuf_p=1014d8848,vda_p=1015710d8

TRACE-INFO: 121: 46 0.282301

TRACE-INFO: 122: [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0 30 0.282331

TRACE-INFO: 123: [dev trc ,00000] SELECT VERSION FROM SVERS ; 26 0.282357

TRACE-INFO: 124: [dblink ,01299] ***LOG BZA=>table SVERS does not exist on database [dblink#5 @ 1299]

TRACE-INFO: 125: 92 0.282449

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

connect failed

Process with ID 21421 terminated with status 232

But i checked /usr/sap/put/exe/R3trans -d it showing rc <0000>

and also i checked /usr/sap/<SID>/SYS/exe/run/R3trans -d it showing rc <0000>.

The logfile for ALORDC.SAV is

#----

---

#---- MASKING file ALORDC.LOG from /usr/sap/put/log

#---- TIME: 20080826165921

#----

---

tp_exec_statement: DROP SYNONYM "RSS_CTS_SERIAL"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_CTS_SERIAL" FOR SAPC01."CTS_SERIAL"

tp_exec_statement: DROP SYNONYM "RSS_DD12L"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_DD12L" FOR SAPC01."DD12L"

tp_exec_statement: DROP SYNONYM "RSS_E070"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E070" FOR SAPC01."E070"

tp_exec_statement: DROP SYNONYM "RSS_E070A"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E070A" FOR SAPC01."E070A"

tp_exec_statement: DROP SYNONYM "RSS_E070C"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E070C" FOR SAPC01."E070C"

tp_exec_statement: DROP SYNONYM "RSS_E070M"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E070M" FOR SAPC01."E070M"

tp_exec_statement: DROP SYNONYM "RSS_E070TC"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E070TC" FOR SAPC01."E070TC"

tp_exec_statement: DROP SYNONYM "RSS_E071"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E071" FOR SAPC01."E071"

tp_exec_statement: DROP SYNONYM "RSS_E071C"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E071C" FOR SAPC01."E071C"

tp_exec_statement: DROP SYNONYM "RSS_E071E"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E071E" FOR SAPC01."E071E"

tp_exec_statement: DROP SYNONYM "RSS_E071K"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E071K" FOR SAPC01."E071K"

tp_exec_statement: DROP SYNONYM "RSS_E071KF"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E071KF" FOR SAPC01."E071KF"

tp_exec_statement: DROP SYNONYM "RSS_E07T"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_E07T" FOR SAPC01."E07T"

tp_exec_statement: DROP SYNONYM "RSS_TADIR"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_TADIR" FOR SAPC01."TADIR"

tp_exec_statement: DROP SYNONYM "RSS_TLOCK"

TPWARN- (object not found)

tp_exec_statement: CREATE SYNONYM "RSS_TLOCK" FOR SAPC01."TLOCK"

tp_exec_dbscript: 30 statement(s) successfully processed.

#----

---

#---- MASKING file ALORDC.LOG from /usr/sap/put/log

#---- TIME: 20080826171417

#----

---

tp_exec_statement: DROP SYNONYM "RSS_CTS_SERIAL"

tp_exec_statement: CREATE SYNONYM "RSS_CTS_SERIAL" FOR SAPC01."CTS_SERIAL"

tp_exec_statement: DROP SYNONYM "RSS_DD12L"

tp_exec_statement: CREATE SYNONYM "RSS_DD12L" FOR SAPC01."DD12L"

tp_exec_statement: DROP SYNONYM "RSS_E070"

tp_exec_statement: CREATE SYNONYM "RSS_E070" FOR SAPC01."E070"

tp_exec_statement: DROP SYNONYM "RSS_E070A"

tp_exec_statement: CREATE SYNONYM "RSS_E070A" FOR SAPC01."E070A"

tp_exec_statement: DROP SYNONYM "RSS_E070C"

tp_exec_statement: CREATE SYNONYM "RSS_E070C" FOR SAPC01."E070C"

tp_exec_statement: DROP SYNONYM "RSS_E070M"

tp_exec_statement: CREATE SYNONYM "RSS_E070M" FOR SAPC01."E070M"

tp_exec_statement: DROP SYNONYM "RSS_E070TC"

tp_exec_statement: CREATE SYNONYM "RSS_E070TC" FOR SAPC01."E070TC"

tp_exec_statement: DROP SYNONYM "RSS_E071"

tp_exec_statement: CREATE SYNONYM "RSS_E071" FOR SAPC01."E071"

tp_exec_statement: DROP SYNONYM "RSS_E071C"

tp_exec_statement: CREATE SYNONYM "RSS_E071C" FOR SAPC01."E071C"

tp_exec_statement: DROP SYNONYM "RSS_E071E"

tp_exec_statement: CREATE SYNONYM "RSS_E071E" FOR SAPC01."E071E"

tp_exec_statement: DROP SYNONYM "RSS_E071K"

tp_exec_statement: CREATE SYNONYM "RSS_E071K" FOR SAPC01."E071K"

tp_exec_statement: DROP SYNONYM "RSS_E071KF"

tp_exec_statement: CREATE SYNONYM "RSS_E071KF" FOR SAPC01."E071KF"

tp_exec_statement: DROP SYNONYM "RSS_E07T"

tp_exec_statement: CREATE SYNONYM "RSS_E07T" FOR SAPC01."E07T"

tp_exec_statement: DROP SYNONYM "RSS_TADIR"

tp_exec_statement: CREATE SYNONYM "RSS_TADIR" FOR SAPC01."TADIR"

tp_exec_statement: DROP SYNONYM "RSS_TLOCK"

tp_exec_statement: CREATE SYNONYM "RSS_TLOCK" FOR SAPC01."TLOCK"

tp_exec_dbscript: 30 statement(s) successfully processed.

please do the needful.

Thanks and Regards,

srini.