R3trans -d gives 0012 error 2EETW000 sap_dext called with msgnr "32":

[former_member636576]

Hi experts, We (for some reason) are unable to start our QAS system.

For starters the sid is <PRD> # su - prdadm [YOU HAVE NEW MAIL] prdsap:prdadm 1> startsap all Checking PRD Database ------------------------------ ABAP Database is not available via R3trans Starting SAP-Collector Daemon ------------------------------ 20:48:15 26.10.2020 LOG: Effective User Id is root *********************************************************************** * This is Saposcol Version COLL 20.95 700 - AIX v11.65 5L-64 bit 090118 * Usage: saposcol -l: Start OS Collector * saposcol -k: Stop OS Collector * saposcol -d: OS Collector Dialog Mode * saposcol -s: OS Collector Status * The OS Collector (PID 1650858) is already running ..... ************************************************************************ saposcol already running Running /usr/sap/PRD/SYS/exe/run/startdb Trying to start PRD database ...

Log file: /home/prdadm/startdb.log /usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12 DB startup failed

Here are the r3trans results : prdsap:prdadm 2> R3trans -x This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00). unicode enabled version R3trans finished (0000). prdsap:prdadm 3> R3trans -d This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00). unicode enabled version 2EETW000 sap_dext called with msgnr "32": 2EETW000 ---- db call info ---- 2EETW000 function: db_ntab 2EETW000 fcode: NT_RDTDESCR 2EETW000 tabname: TADIR 2EETW000 len (char): 5 2EETW000 key: TADIR 2EETW000 retcode: 32 R3trans finished (0012).

The value of the dbs_ora_schema is SAPSR3

The trans log says :ORA-00942: table or view does not exist

R3trans check finished with return code: 12 *** ERROR: Startup of database failed Notify Database Administrator. /usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12...this is the start db logtrans.txtstartdb.txtstartsap.txt

Can you please tell me what sql queries/logs/troubleshooting approach to take?

I have attached the trans,startdb and startsap logs in text format

[dasistdochscheisse]

Are you really using Oracle 10? How old is this system?

Janos is right, the SAPUSER table is empty. Either recreate it or setup SSFS. The Notes 1639578 and 1639578 describe the procedure. You need to have a 7.20 kernel in use 😉

[janos_mucsi-besze]

Hi,

I see that SAPUSER table is empty, this is shown in the trans.txt you attached:
...
ERROR => ORA-1403 when accessing table SAPUSER
...

Then R3trans is trying to connect using the default password which is 'sap'. And it is also failing.

Can it be that you updated the SAP Kernel and now you are using ABAP SSFS, which is a complete 'new' approach, slightly different from the OPS$ mechanism?
But this is several Years old now, you should know about this.

[janos_mucsi-besze]

Please also verify if this system was copied using any method, and with that the schema owner did change. You can verify the owner of the tables with below command e.g.:
SQL> select owner,table_name from dba_tables where table_name = 'SVERS';

If the schema owner is set correctly using the appropriate env. variables for sidadm and orasid, the select executed by R3trans should succeed.