Login Error on SAPNW7.0ABAPTrialSP12

[Former Member]

Hi,

I just installed SAPNW7.0 ABAPTrial SP12 on a standalone XP laptop.

Installation went without any error.

But when I try to login to system by selecting NSP from logon pad and hit LOGON button it gives me this runtime error:

Runtime Errors DBIF_RSQL_INVALID_REQUEST

Date and Time 2008-05-11 02:07:19

Short text

Invalid request.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Error analysis

An invalid request was made to the SAP database interface in a statement

in which the table "DOKTL " was accessed.

The situation points to an internal error in the SAP software

or to an incorrect status of the respective work process.

For further analysis the SAP system log should be examined

(transaction SM21).

For a precise analysis of the error, you should supply

documents with as many details as possible.

How to correct the error

Start the work process involved and repeat the action that lead to the

error.

If the error position is in a program that you can change, you can try

to create preliminary solution: Reformulate the database command by

varying the properties such as individual record access instead of

input/output via internal tables, the structure of the selection

conditions (WHERE clause), nested SELECT loops instead of FOR ALL

ENTRIES and other such variations.

Please check the entries in the system log (Transaction SM21).

Check the entries in the developer trace of the work process involved

(transaction ST11).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_INVALID_REQUEST" " "

"SAPMSYST" or "SAPMSYST"

"FILL_INFO_TAB"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File

(Unconverted)".

2. Corresponding system log

Display the system log by calling transaction SM21.

Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which

actions and input led to the error.

System environment

SAP-Release 700

Application server... "localhost"

Network address...... "127.0.0.1"

Operating system..... "Windows NT"

Release.............. "5.1"

Hardware type........ "2x Intel 80686"

Character length.... 8 Bits

Pointer length....... 32 Bits

Work process number.. 0

Shortdump setting.... "full"

Database server... "localhost"

Database type..... "ADABAS D"

Database name..... "NSP"

Database user ID.. "SAPNSP"

Char.set.... "English_United State"

SAP kernel....... 700

created (date)... "Jan 29 2007 00:33:09"

create on........ "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"

Database version. "SQLDBC 7.6.2.014 CL 152175 "

Patch level. 95

Patch text.. " "

Database............. "MaxDB 7.6, MaxDB 7.7"

SAP database version. 700

Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2"

Memory consumption

Roll.... 8112

EM...... 1045296

Heap.... 0

Page.... 0

MM Used. 523136

MM Free. 520824

User and Transaction

Client.............. 000

User................ " "

Language key........ "E"

Transaction......... "SESSION_MANAGER "

Transactions ID..... " "

Program............. "SAPMSYST"

Screen.............. "SAPMSYST 0020"

Screen line......... 3

Information on where terminated

Termination occurred in the ABAP program "SAPMSYST" - in "FILL_INFO_TAB".

The main program was "SAPMSYST ".

In the source code you have the termination point in line 2556

of the (Include) program "SAPMSYST".

Contents of system fields

Name Val.

SY-SUBRC 0

SY-INDEX 0

SY-TABIX 0

SY-DBCNT 1

SY-FDPOS 0

SY-LSIND 0

SY-PAGNO 0

SY-LINNO 1

SY-COLNO 1

SY-PFKEY

SY-UCOMM

SY-TITLE System Program

SY-MSGTY

SY-MSGID

SY-MSGNO 000

SY-MSGV1

Internal notes

The termination was triggered in function "HandleRsqlErrors"

of the SAP kernel, in line 764 of the module

"//bas/700_REL/src/krn/runt/absapsql.c#6".

The internal operation just processed is "SQLS".

Internal mode was started at 20080511020719.

Internal call code.........: "[RSQL/OPEN/DOKTL ]"

Active Calls in SAP Kernel

Lines of C Stack in Kernel (Structure Differs on Each Platform)

SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

Callstack without Exception:

App : disp+work.EXE (pid=640)

When : 5/11/2008 2:7:19.671

Threads : 2

Computer Name : LOCALHOST

User Name : SYSTEM

Number of Processors: 2

Processor Type: x86 Family 6 Model 14 Stepping 8

Windows Version : 5.1 Current Build: 2600

State Dump for Thread Id 290

eax=ffffffff ebx=000004c4 ecx=07d7d994 edx=07d80040 esi=000004c4 edi=00000000

eip=7c90eb94 esp=043cdd7c ebp=043cdde0 iopl=0 nv up ei ng nz ac po cy

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000297

function : KiFastSystemCallRet

7c90eb94 c3 ret

7c90eb95 8da42400000000 lea esp,[esp] ss:043cdd7c=7c90e9c0

7c90eb9c 8d642400 lea esp,[esp] ss:101dcd8b=6f6f4c20

7c90eba0 90 nop

7c90eba1 90 nop

7c90eba2 90 nop

7c90eba3 90 nop

7c90eba4 90 nop

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

043cdde0 7c802532 000004c4 0001d4c0 00000000 043cde18 ntdll!KiFastSystemCallRet

043cddf4 00fec10a 000004c4 0001d4c0 00000001 002fb718 kernel32!WaitForSingleObject

043cde18 0056a476 0056a4af 002fb718 002fb718 002fb718 disp+work!strncpy_sRFB

043cde60 00856ffb 043ce348 043ce34c 00000003 00000000 disp+work!PrBinAll

043ce2e4 007c760a 012fd148 0130fd00 000002fc 01ca3524 disp+work!ab_rabax

043ce320 007a85c8 012fd148 000002fc 01ca3524 043ce348 disp+work!zdate_stamp

043ce3c0 007a963c 00000001 6c7ea0e4 0000003b 00000000 disp+work!zdate_stamp

043ce3f8 007b2f09 0000000c 00000003 000000b4 00000000 disp+work!zdate_stamp

043ce430 00692657 00000003 3b8d62e8 00000000 043ce498 disp+work!zdate_stamp

043ce498 007c5e6a 00000000 3b8d62e8 043ce4e8 3b8d9840 disp+work!ab_popExtriState

00000000 00000000 00000000 00000000 00000000 00000000 disp+work!zdate_stamp

State Dump for Thread Id c88

eax=066ffeb8 ebx=00000103 ecx=00007616 edx=066ffec6 esi=00000000 edi=00000000

eip=7c90eb94 esp=066ffebc ebp=066fff00 iopl=0 nv up ei pl zr na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246

function : KiFastSystemCallRet

7c90eb94 c3 ret

7c90eb95 8da42400000000 lea esp,[esp] ss:066ffebc=7c90da69

7c90eb9c 8d642400 lea esp,[esp] ss:1250eecb=????????

7c90eba0 90 nop

7c90eba1 90 nop

7c90eba2 90 nop

7c90eba3 90 nop

7c90eba4 90 nop

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

066fff00 010e70d5 000006bc 00000000 04ef0000 049237c0 ntdll!KiFastSystemCallRet

066fff80 002bb381 00000000 04ef0000 0491cd70 00368d70 disp+work!haSHA1Input

066fffb4 7c80b683 00368d70 04ef0000 0491cd70 00368d70 MSVCR71!endthreadex

066fffec 00000000 002bb312 00368d70 00000000 00000000 kernel32!GetModuleFileNameA

List of ABAP programs affected

Index Typ Program Group Date Time Size Lang.

0 Prg SAPMSYST 0 2006-11-23 14:47:25 93184 E

1 Typ RSYST 0 2004-07-20 13:13:03 10240

2 Prg SAPMSSYD 0 2006-11-23 14:47:21 17408 E

3 Prg SAPFSYSCALLS 0 2005-03-07 18:01:13 6144 E

4 Typ DOKIL 0 1997-04-07 18:29:04 3072

5 Typ DOKTL 0 1997-04-07 18:29:07 3072

6 Typ SYST 0 2004-09-15 17:25:35 27648

7 Typ USR02 0 2005-02-16 19:03:39 7168

8 Typ TLINE 0 1995-01-18 17:05:44 2048

I try to copy all the error info expert Please suggest what is going wrong here or how can I fix this.

[former_member906139]

Hello,

Please update your SAP kernel. And take backup of old kernel before updating.

Regards,

Abhay

[Former Member]

Hi Friend,

Did you find the solution to this problem?

If you found it, please call me, ok?

Thanks and best regards,

Henrique Bachour

[Former Member]

Hi,

This may not be a solution to the issue you are looking at but you can atleast proceed with your work. If your SAP Management Console shows that NSP is green and working then try logging in through browser this shall work:

http://localhost:8000/sap/bc/gui/sap/its/webgui?sap-client=000

Regards,

Abhishek Ghosh

[Former Member]

Hi. Can you say your compyter name ? Also in windows folder under system32/drivers/etc find the file hosts and provide information from it. Check the event log in your XP mashine , are you see any error? Your network card works properly (or you install loopback adapter) ?.

Are you have any antivirus , firewall software? Disable all, restart the pc, and try again.

Regards

[Former Member]

Hello Sergo,

Thank you for your reply.

my computer name is localhost.

It's a standalone XP pro laptop and I connect with internet via wireless connection. It's not connected with any Local Network.

Here's how my host file looks like

1. Copyright (c) 1993-1999 Microsoft Corp.*

#

1. This is a sample HOSTS file used by Microsoft TCP/IP for Windows.*

#

1. This file contains the mappings of IP addresses to host names. Each*

2. entry should be kept on an individual line. The IP address should*

3. be placed in the first column followed by the corresponding host name.*

4. The IP address and the host name should be separated by at least one*

5. space.*

#

1. Additionally, comments (such as these) may be inserted on individual*

2. lines or following the machine name denoted by a '#' symbol.*

#

1. For example:*

#

1. 102.54.94.97 rhino.acme.com # source server*

2. 38.25.63.10 x.acme.com # x client host*

1. 127.0.0.1 localhost*

192.168.1.101 localhost

By default IP was 127.0.0.1 localhost

but I changed it to 192.168.1.101 localhost as this IP was in my TCP/IP properties, did I do it correct?

I've Kaspersky Antivirus running and Windows Firewall on. I'm going to try disable both and restart.

Can you please tell me how to check event log in my XP machine.

Thanks for your time

Asif

[Former Member]

Are you read this befor install the trial version? -->

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80fd9a0a-e306-2a10-c896-b84c77c1...

"If no DHCP server is available on your network (which dynamically determines the IP address) or your computer is not connected to any network, you need to install the virtual interface adapter MS Loopback Adapter. The procedure to install a loopback adapter is documented within the download package".

Also i'm first view the pc with name "localhost" ,,,,,,,,,

I'm not assured, but it not so good....

First try to back : 127.0.0.1 localhost, and try again. If not helps, I on your place, first delete this trial version, after rename the PC, after install again with MS Loopback Adapter to, but it's only if not helps steps above. About event log : press right mouse on "My computer", choose manage --> event viewer. Regards. Do not forget award helpful answers.

[Former Member]

Hello Sergo,

I've followed all the steps. but still giveing the same error.

Question > Loopback adaptor TCP/IP properties IP address should it be 127.0.0.1 but when I try to type this IP it doesn't accept that

gives error

Error

IP addresses starting with 127 are not valid because they are reserved for loopback addresses. Please specify some other valid value between 1 and 223.

and when I open DBM Command line Interface from START>PROGRAM>MAXDB>Command Line Tools

the prompt comes up

and ask for these info

Enter server name: LOCALHOST

Enter database name: NSP

Enter user for authorization: SAPNSP

Enter password:

But I don't know the password as during the installation process it didn't ask for the password to set anywhere!!!

What could be the password..I tryed pass or password didn;t work

I can STOP START without any problem from START>PROGRAM>SAP NW 7.0 ABAP TRIAL VERSION>NSP> Start Application Server or Stop Application Server

and then when I try to login same error coming up.

Please give me some assistance. I followed every steps from the instructions

Asif

[Former Member]

Yes, the "IP addresses starting with 127 are not valid because they are reserved for loopback addresses" and the name for 127.0.0.1 "loopback address" are "localhost", becose i'm say rename PC name, in this are problem....

P.S. Also can you provide information in your "connection type"? The Application sever , system number , system ID.

About SAPNSP user are you try with password sap ? Regards.

[Former Member]

Hello,

This issue is caused by incorrect mapping of the IP address

in the etc\hosts file. Please correct it as per note 520658.

A restart of the server is required after making the IP address change.

Best regards,

Warren

[Former Member]

Hi Asif. Are you resolve your problem? Regards.