Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DbSl Trace: ORA-1403 when accessing table SAPUSER

Dear All,

I am installing SAP Solution manager 7.0 EHP1 on HP-UX.

DB is oracle 10.2.0.2.

At time of installation I am getting error at phase ABAP IMPORT.

I am getting below error in installtion log:

Loading of 'SAPNTAB' import package: ERROR

Import Monitor jobs: running 0, waiting 29, completed 0, failed 1, total 30.

WARNING[E] 2010-08-06 11:53:54.590

CJSlibModule::writeError_impl()

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

I checked import_monitor.java.log and import_monitor.log. Both file indicating to check SAPNTAB.log file for detail information. Below is log of SAPNTAB.log file.

SAPNTAB.log-->

__________________________________________________________

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(RFF) ERROR: /oracle/SLM/soldump/export/51036442_2/DATA_UNITS/EXP4/DATA/SAPNTAB.TOC is not from the same export as /oracle/SLM/soldump/export/51036442_2/DATA_

UNITS/EXP4/DATA/SAPNTAB.001

____________________________________________________________

Thanks and regards,

Pramod

Former Member
replied

ORA-01403: no data found

Log entries: Logon as OPS$ user to get <sapowner>'s password Connecting as /@<sid> on connection 0 ...

Now I'm connected to ORACLE

      • ERROR => ORA-1403 when accessing table SAPUSER

The main cause of ORA-01403 is that the table SAPUSER does not contain any entries. Therefore, proceed as follows:

o Use the following BRCONNECT call (BRCONNECT 6.10 or higher) to set the password consistently in SAPUSER and in the Oracle DDIC:

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

o Alternatively, you can insert it in SAPUSER manually.

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

Another possible cause is that SAPUSER contains incorrect entries. The system always uses the user name to select from SAPUSER. Therefore, you must ensure that the user name is always uppercase (SAPR3 or SAP<sid>) and that it corresponds exactly to the value of the environment variable dbs_ora_schema if SAP<sid> is used.

o If the system continues to issue ORA-01403, see the "General checks"section once again.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question