cancel
Showing results for 
Search instead for 
Did you mean: 

login problem...need help...

carlos_zhang3
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Carlos,

Firstly I am not clear if your SAP is up and running or not?

As per the message in the log

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

Former Member
0 Kudos

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

carlos_zhang3
Participant
0 Kudos

Thanks Stefan,

You mean all these views should be created manually ?

Carlos Zhang

Former Member
0 Kudos

Hi,

if you have other SAP system in your landscape then you can transport this two view from there and import it in your migration using transport request

regards,

kaushal

stefan_koehler
Active Contributor
0 Kudos

Hello Carlos,

no normally this views are created by the migration (sap package SAPVIEW).

I think that this package failed or was not run.

Check this with your migration logs.

Regards

Stefan