cancel
Showing results for 
Search instead for 
Did you mean: 

Runtime Errors & Tables missing

rainer_fux2
Participant
0 Kudos

Hello,

We have a strange problem:

We successfully installed the EHP4 upgrade for ERP 6.0 with the EHPinstaller on our central instance. We set up an distributed system, the database is on Linux with MaxDB.

After that I tried to logon with the SAPGUI on the SAP server, but I receive directly the message "SAP System Message: a table is unknown or does not exist." So a logon on the system IS NOT possible.

In the MMC Syslogs I see that there are 2 errors with starting the SAP server:

- SAP Basis System: Run-time error "DBIF_RSQL_TABLE_UNKNOWN (ERROR)

- Database: Table D010ENH does not exist in the database with ID R/3 (WARNING)

These two errors are occuring several times in the syslogs. The server nodes in die SAPMMC are running all on green.

What can I do there? Any ideas? Haven't found any notes on this problem.

Regards,

Vermeer

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

Can you check if you have missed during upgrade any of these according to SAP in attached note:

2050604 - Problem analysis in upgrade: Phase ACT_UPG

Also refer:

570911 - ICNV: Data transfer job terminates: DBIF_RSQL_INTERNAL_ERROR

Regards

Rajendra Tattu

Former Member
0 Kudos

Did anybody ever get anywhere with this?  I am having the same issue.

Thanks

Mark

former_member203438
Participant
0 Kudos

Hi Mark,

maybe your installation not done successfully but in that case u can able to all r green in ur MMC but some table are not importing in to datbase while insatlling so please check installaion log file.

Thanks

R@J..!!!

Amit_Patil
Explorer
0 Kudos

Hi Mark,

We are facing exact same problem. Did you ever get a solution for your problem? If yes, could you plesae let me know?

- Amit

Former Member
0 Kudos

Hi Vermeer,

i got the same problem on EHP6. Did you find the solution?

Thanks,

Arpad

former_member203438
Participant
0 Kudos

Hi All,

i am also facing the same problem i unable to login to SAP through SAPGUI plz share the solution i had struck at DDIC check password phase.

Thanks

R@J>>>>

Former Member
0 Kudos

Hi expert,

i m also facing the same issue is there any solution for this.

Please let me know if you have got any solution on this

Regards

Amar ghuge

markus_doehr2
Active Contributor
0 Kudos

> We successfully installed the EHP4 upgrade for ERP 6.0 with the EHPinstaller on our central instance.

So you had no activation error or the like during the upgrade?

Markus

rainer_fux2
Participant
0 Kudos

Hello Markus,

At the step MAIN_SHDRUN/ACT_UPG we accepted non-severe errors.

Regards,

Vermeer

rainer_fux2
Participant
0 Kudos

So, what I can see from the logs is, that the Views V_LNAMES and D010ENH are missing. How can I add them to the database? I am not able to connect via SAPGUI, there comes the error message a table is unknown or does not exist.

Any ideas?

Regards,

Vermeer

Former Member
0 Kudos

Can you please check your installation log? whether the table D010ENH is created and activiated during the installation?

also check the dev_w0.

rainer_fux2
Participant
0 Kudos

Hello,

<br>

In the EHPI log file TABLOC.LOG are all tables listen, as well the D010ENH and at the and it says that "tp_exec_dbscript: 3 statement(s) successfully processed."

<br>

<br>

Here the dev_w0 log:

<br>

<br>

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "701"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
M sysno      30
M sid        GB1
M systemid   562 (PC with Windows NT)
M relno      7010
M patchlevel 0
M patchno    94
M intno      20020600
M make:      multithreaded, Unicode, 64 bit, optimized
M pid        3820
M 
M  
M Thu Sep 23 15:03:31 2010
M  kernel runs with dp version 244000(ext=110000) (@(#) DPLIB-INT-VERSION-244000-UC)
M  length of sys_adm_ext is 576 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3820) [dpxxdisp.c   1349]
I  MtxInit: 30000 0 0
M  DpSysAdmExtCreate: ABAP is active
M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M  DpShMCreate: sizeof(wp_adm)		28032	(1752)
M  DpShMCreate: sizeof(tm_adm)		5912704	(29416)
M  DpShMCreate: sizeof(wp_ca_adm)		24064	(80)
M  DpShMCreate: sizeof(appc_ca_adm)	8000	(80)
M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M  DpShMCreate: sizeof(comm_adm)		552080	(1088)
M  DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M  DpShMCreate: sizeof(slock_adm)		0	(104)
M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M  DpShMCreate: sizeof(file_adm)		0	(72)
M  DpShMCreate: sizeof(vmc_adm)		0	(1864)
M  DpShMCreate: sizeof(wall_adm)		(41664/36752/64/192)
M  DpShMCreate: sizeof(gw_adm)	48
M  DpShMCreate: SHM_DP_ADM_KEY		(addr: 000000000B2C0050, size: 6612384)
M  DpShMCreate: allocated sys_adm at 000000000B2C0050
M  DpShMCreate: allocated wp_adm at 000000000B2C2270
M  DpShMCreate: allocated tm_adm_list at 000000000B2C8FF0
M  DpShMCreate: allocated tm_adm at 000000000B2C9050
M  DpShMCreate: allocated wp_ca_adm at 000000000B86C8D0
M  DpShMCreate: allocated appc_ca_adm at 000000000B8726D0
M  DpShMCreate: allocated comm_adm at 000000000B874610
M  DpShMCreate: system runs without slock table
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 000000000B8FB2A0
M  DpShMCreate: allocated gw_adm at 000000000B8FB320
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated ca_info at 000000000B8FB350
M  DpShMCreate: allocated wall_adm at 000000000B8FB360
M  rdisp/queue_size_check_value :  -> off
M  ThTaskStatus: rdisp/reset_online_during_debug 0
X  EmInit: MmSetImplementation( 2 ).
X  MM global diagnostic options set: 0
X  <ES> client 0 initializing ....
X  Using implementation view
X  <EsNT> Using memory model view.
M  <EsNT> Memory Reset disabled as NT default
X  ES initialized.
X  mm.dump: set maximum dump mem to 96 MB
M  
M Thu Sep 23 15:03:32 2010
M  ThInit: running on host vmhsapgb01
M  
M Thu Sep 23 15:03:33 2010
M  calling db_connect ...
B  create_con (con_name=R/3)
B  Loading DB library 'E:\usr\sap\GB1\DVEBMGS30\exe\dbsdbslib.dll' ...
B  Library 'E:\usr\sap\GB1\DVEBMGS30\exe\dbsdbslib.dll' loaded
B  Version of 'E:\usr\sap\GB1\DVEBMGS30\exe\dbsdbslib.dll' is "700.08", patchlevel (0.93)
B  New connection 0 created
C  
C  DBSDBSLIB : version 700.08, patch 0.093 (Make PL 0.94)
C  MAXDB shared library (dbsdbslib) patchlevels (last 10)
C    (0.093) Unknown primary key (note 1459400)
C    (0.093) Connection table corrected (note 1466271)
C    (0.092) Improved overflow error handling (note 1463647)
C    (0.084) Use SCHEMANAME instead of OWNER for MaxDB 7.8 (note 1353266)
C    (0.082) Support of  MaxDB 7.8 (note 1353266)
C    (0.047) MVCC support for MaxDB (note 1332203)
C    (0.037) NUMC conversion corrected (note 1288313)
C    (0.024) Default value for max. input variables is 2000 (note 655018)
C    (0.024) Profile parameter to define max. input variables (note 655018)
C    (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)
C  
C  
C  Loading SQLDBC client runtime ...
C  
C Thu Sep 23 15:03:34 2010
C  SQLDBC SDK Version : SQLDBC.H  7.6.0    BUILD 007-123-091-175
C  SQLDBC Library Version : libSQLDBC 7.6.5    BUILD 009-123-191-997
C  SQLDBC client runtime is MaxDB 7.6.5.009 CL 191997
C  SQLDBC supports new DECIMAL interface : 0
C  SQLDBC supports VARIABLE INPUT data   : 1
C  SQLDBC supports keepAlive indicator   : 0
C  INFO : SQLOPT= -I 0 -t 0 -S SAPR3
C  Try to connect (DEFAULT) on connection 0 ...
C  Attach to SAP DB : Kernel    7.7.04   Build 028-123-194-355
C  Database release is SAP DB 7.7.04.028
C  INFO : Database 'GB1' instance is running on 'vlhsapdbgb01'
C  DB max. input host variables  : 2000
C  DB uses MVCC support          : 0
C  INFO : SAP DB Packet_Size = 131072
C  INFO : SAP DB Min_Reply_Size = 4096
C  INFO : SAP DB Comm_Size = 126976
C  INFO : DBSL buffer size = 126976
C  INFO : SAP DB MaxLocks = 800000
C  INFO : Connect to DB as 'SAPGB1'
C  Command info enabled
C  Now I'm connected to SAP DB
C  00: vlhsapdbgb01-GB1, since=20100923150334, ABAP= <unknown> (0)
B  Connection 0 opened (DBSL handle 0)
B  Wp  Hdl ConName                        ConId     ConState     TX  HC  PRM RCT FRC TIM MAX OPT Date     Time   DBHost                        
B  000 000 R/3                            000000000 ACTIVE       NO  NO  YES NO  NO  000 255 255 20100923 150333 vlhsapdbgb01                  
C  INFO : SAP RELEASE (DB) = 701
M  db_connect o.k.
M  ICT: exclude compression: *.zip,*.cs,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.css,*.pdf,*.js,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif,*.png,*.swc,*.swf