on 01-23-2008 11:12 AM
Dear experts,
I have migrated my QA system into another system, but the sapgui showed me the error message when i login the sapgui.
ABAP/4 runtime error Error code DBIF_RSQL_TABLE_UNKNOWN
i checked the log, found there has one line marked 'update error'
X <ES> client 0 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M
M Wed Jan 23 18:21:08 2008
M calling db_connect ...
C Got ORACLE_HOME=G:\oracle\ora92 from environment
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPQ19's password
C Connecting as /@C11 on connection 0 ...
C Attaching to DB Server C11 (con_hdl=0,svchp=059AD3A4,svrhp=0A023D74)
C
C Wed Jan 23 18:21:43 2008
C Starting user session (con_hdl=0,svchp=059AD3A4,srvhp=0A023D74,usrhp=0A02C5AC)
C Now I'm connected to ORACLE
*C *** ERROR => ORA-1031 when updating table SAPUSER* [dbsloci.c 10144]
C Got SAPQ19's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=059AD3A4,usrhp=0A02C5AC)
C Now I'm disconnected from ORACLE
C Connecting as SAPQ19/<pwd>@C11 on connection 0 ...
C Starting user session (con_hdl=0,svchp=059AD3A4,srvhp=0A023D74,usrhp=0A02C5AC)
C Now I'm connected to ORACLE
C Database NLS settings: AMERICAN_AMERICA.UTF8
C Database instance c11 is running on SAPIDES with ORACLE version 9.2.0.5.0 since 20080123
B
B Wed Jan 23 18:21:44 2008
B Connection 0 opened
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBH
......................
................
........
M Wed Jan 23 18:22:43 2008
M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12270]
B
B Wed Jan 23 18:31:45 2008
*B **LOG BZA=> table DD092526V does not exist on database [dbtran#3 @ 7256] [dbtran 7256 ]A TH VERBOSE LEVEL FULL
M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12270]
A
A Wed Jan 23 18:31:46 2008
A Wed Jan 23 18:31:46 2008
A
A ABAP/4 Program SAPLSDNT .
A Source LSDNTU16 Line 481.
A Error Code DBIF_RSQL_TABLE_UNKNOWN.
A Module $Id: //bas/640_REL/src/krn/runt/absapsql.c#9 $ SAP.
A Function HandleRsqlErrors Line 776.
A Table is unknown or does not exist..
A
*B **LOG BZA=> table D010SINF does not exist on database [dbtran#3 @ 7256] [dbtran 7256 ]A TH VERBOSE LEVEL FULL
M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12270]
A Wed Jan 23 18:31:46 2008
..............
........
....
.
Has someone can give me advise ?
Thanks in advanced,
Carlos
Hello Carlos
>> I have migrated my QA system into another system
How did you migrate?
>> *B ***LOG BZA=> table DD092526V does not exist on database dbtran#3 @ 7256 dbtran 7256 *A TH VERBOSE LEVEL FULL
>> *B ***LOG BZA=> table D010SINF does not exist on database dbtran#3 @ 7256 dbtran 7256 *A TH VERBOSE LEVEL FULL
The "tables" DD092526V and D010SINF are not "really" tables.. they are just views on ddic tables and report sources.
I think that you have not created the views in your migration.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Carlos,
Firstly I am not clear if your SAP is up and running or not?
As per the message in the log
ERROR => ORA-1031 when updating table SAPUSER* http://dbsloci.c 10144
I think your SAP must not be comming up.
Try to check R3trans -d and see the return code. If return code is 0 or 4 then it is OK else send the trans.log file.
Best Wishes.
Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Carlos,
Please provide version details on the SAP system you have migrated.
It is possible you have skipped a mandatory step as part of migration tasks.
Cheers,
Nisch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Stefan,
You mean all these views should be created manually ?
Carlos Zhang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.