R3trans error retcode: 32

[Former Member]

Hi Everybody

Did somebody had an error like this with R3trans -d

=====================================================================

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 8 0.212642

4 ETW000 [dev trc ,00000] SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFOR

4 ETW000 45 0.212687

4 ETW000 [dev trc ,00000] M, REFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COMPCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0

4 ETW000 23 0.212710

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 535 0.213245

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

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000 23699 0.236944

==================================================================

The system is installed as export /import with the R3load tools, OS:Win2k3 64bit, Oracle 10.2, NW04s BW, MS Clustered!

- R3trans -x is working fine. (latest from Feb. 2008)

- NLS_LANG is correctly set

- Enviroment Variable should be fine too.

- tnsping is fine

Tnx for your help.

Murat

[stefan_koehler · Accepted solution]

Hello Murat,

i haven't seen such a situation until yet... but it seems like the table DDNTT does not contain a searched value.

SQL Returncode 1403 means "no data found".

Please can you execute the following sql statement and post the result:

> shell> sqlplus "/ as sysdba"

> SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'DDNTT';

> SQL> SELECT COUNT(*) FROM SAPSR3.DDNTT;

If both commands are returning a result... please do the following:

> shell> sqlplus "/ as sysdba"

> SQL> shutdown immediate;

> shell> cd /oracle/<SID>/102_64/dbs/

> shell> cp -p spfile<SID>.ora spfile<SID>.ora.save

> shell> sqlplus "/ as sysdba"

> SQL> ALTER SYSTEM SET EVENT=’10046 trace name context forever, level 12’ SID='*' SCOPE=spfile;

> SQL> startup

After that rerun the R3trans -d command and check for an oracle tracefile under:

/oracle/<SID>/saptrace/usertrace/

There you will find the value of the bind variable :A0 ... after that you can check DDNTT for this value by hand...

If you don't know how to find the bind values.. please upload the trace file to a filehoster like rapidshare and we will check it for you.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan

tnx for your tip, but it didn't help.

The System was part of an uc migration do the DDNTT is empty!

===========================================================

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'DDNTT';

OWNER

-

---

SAPBIW

SQL> SELECT COUNT(*) FROM SAPBIW.DDNTT;

COUNT(*)

-

---

0

===========================================================

the error is still the same

[stefan_koehler · Accepted solution]

Hello Murat,

that is the problem.

The table DDNTT contains no entry .. but this is the activate nametab which stores all ddic objects.. and in your case it is empty... so the ORA-1403 is absolutely normal.

>> The System was part of an uc migration do the DDNTT is empty!

I don't understand this statement... please check sapnote #932779 - this note describes the context of the ddic tables in a unicode migration

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan

it looks like regarding Note 932779 the entry DDNTT_2B is missing in the .TOC file.

The DDNTT contains no data, where the DDNTT_CONV_UC contains data.

Something went wrong while the conversion!!

We have to investigate it closer. I will let you know later...

tnx

Murat

[Former Member · Accepted solution]

Hi Murat,

I know that I am bit late, but can anyone please let me know how to resolve this error, as I am getting same error and not getting any solution for this.

Thanks,

Amit