DBIF_RSQL_INVALID_REQUEST

[Former Member]

Dear ALL,

Since yesterday whenever any user is trying to login to the production server,the following error is coming The current ABAP/4 program terminated due to an internal error in the database interface.

An invalid request was made to the SAP database interface abap dump in DBIF_RSQL_INVALID_REQUEST

But whenever we are going back(by pressing function key F3),we are able to loging. And in sm50 most or all the work process showing stop

Can anyone suggest what can be wrong and how to correct it. SAP ecc5 and oracle 9i on windows 2003

-

---

trc file: "dev_disp", trc level: 1, release: "640"----

---

Tue Dec 02 13:17:09 2008

kernel runs with dp version 130000(ext=102000) (@(#) DPLIB-INT-VERSION-130000-UC)

length of sys_adm_ext is 524 bytes

sysno 00

sid PRD

systemid 561 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 129

intno 20020600

make: multithreaded, Unicode, 64 bit

pid 5176

***LOG Q00=> DpSapEnvInit, DPStart (00 5176) http://dpxxdisp.c 1098

shared lib "dw_xml.dll" version 129 successfully loaded

Tue Dec 02 13:17:10 2008

shared lib "dw_xtc.dll" version 129 successfully loaded

shared lib "dw_stl.dll" version 129 successfully loaded

shared lib "dw_gui.dll" version 129 successfully loaded

shared lib "dw_mdm.dll" version 129 successfully loaded

Tue Dec 02 13:17:15 2008

WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds*

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings http://dpxxtool2.c 3893

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpIPCInit2: start server >rfcl-sap-vir_PRD_00 <

DpShMCreate: sizeof(wp_adm) 51328 (1316)

DpShMCreate: sizeof(tm_adm) 35937968 (17960)

DpShMCreate: sizeof(wp_ca_adm) 80000 (80)

DpShMCreate: sizeof(appc_ca_adm) 160000 (80)

DpShMCreate: sizeof(comm_adm) 1248000 (624)

DpShMCreate: sizeof(vmc_adm) 0 (512)

DpShMCreate: sizeof(wall_adm) (416064/346352/64/192)

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000D110050, size: 38247056)

DpShMCreate: allocated sys_adm at 000000000D110050

DpShMCreate: allocated wp_adm at 000000000D111C30

DpShMCreate: allocated tm_adm_list at 000000000D11E4B0

DpShMCreate: allocated tm_adm at 000000000D11E4E0

DpShMCreate: allocated wp_ca_adm at 000000000F364390

DpShMCreate: allocated appc_ca_adm at 000000000F377C10

DpShMCreate: allocated comm_adm_list at 000000000F39ED10

DpShMCreate: allocated comm_adm at 000000000F39ED30

DpShMCreate: allocated vmc_adm_list at 000000000F4CF830

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000F4CF860

DpShMCreate: allocated wall_adm at 000000000F4CF870

MBUF state OFF

Tue Dec 02 13:17:16 2008

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 1226 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 2.6 2.6 4.0) http://dpxxdisp.c 1466

***LOG Q0K=> DpMsAttach, mscon ( rfcl-sap-vir) http://dpxxdisp.c 9915

use SAPLOCALHOST=<rfcl-sap-vir> as internal hostname

DpStartStopMsg: send start message (myname is >rfcl-sap-vir_PRD_00 <)

DpStartStopMsg: start msg sent

Tue Dec 02 13:17:17 2008

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

Tue Dec 02 13:17:19 2008

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

Tue Dec 02 13:17:20 2008

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet http://dpxxmbuf.c 1025

DpMsgAdmin: Set patchno for this platform to 129

Release check o.K.

Tue Dec 02 13:17:40 2008

MBUF state ACTIVE

DpModState: change server state from STARTING to ACTIVE

Tue Dec 02 13:32:11 2008

***LOG Q0I=> NiPRead: recv (10054: WSAECONNRESET: Connection reset by peer) http://ninti.c 789

Network error of client T92, NiBufReceive (-6: NIECONN_BROKEN), dp_tm_status=3

Tue Dec 02 13:32:17 2008

***LOG Q0I=> NiPGetHostByAddr: address 220.226.53.183 not found: gethostbyaddr http://ninti.c 379

WARNING => NiAddrToHost took 6 seconds http://dpxxdisp.c 16611

Client address of T92 is 220.226.53.183(220.226.53.183)

***LOG Q04=> DpRTmPrep, NiBufReceive () http://dpxxdisp.c 9632

RM-T92, U127, 600 , 13:25:51, M0, W1, ZVR2, 2/2

The log are as follwing.

stderr

Thr 924 Tue Dec 09 09:14:04 2008

Thr 924 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 924 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604Thr 4924 Tue Dec 09 09:14:04 2008

Thr 4924 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 4944 Tue Dec 09 09:14:04 2008

Thr 4944 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 4924 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604Thr 4944 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604

-

---

trc file: "dev_rd", trc level: 1, release: "640"----

---

Tue Dec 02 13:17:17 2008

***LOG S00=> GwInitReader, gateway started ( 4304) http://gwxxrd.c 1627

relno 6400

patchlevel 0

patchno 126

intno 20020600

pid 4304

unicode active

gateway runs with dp version 130000(ext=102000) (@(#) DPLIB-INT-VERSION-130000-UC)

Tue Dec 02 13:17:18 2008

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Bind service sapgw00 (datagram) to port 3300

Bind service sapgw00 (datagram) to port 3300

Bind service sapgw00 (socket) to port 3300

Tue Dec 02 13:17:19 2008

GwPrintMyHostAddr: my host addresses are :

1 : 777 vir (HOSTNAME)

2 : 7777 COM (LOCALHOST)

3 777 -02 (NILIST)

MtxInit: -2 0 0

DpSysAdmExtCreate: ABAP is active

DpShMCreate: sizeof(wp_adm) 51328 (1316)

DpShMCreate: sizeof(tm_adm) 35937968 (17960)

DpShMCreate: sizeof(wp_ca_adm) 80000 (80)

DpShMCreate: sizeof(appc_ca_adm) 160000 (80)

DpShMCreate: sizeof(comm_adm) 1248000 (624)

DpShMCreate: sizeof(vmc_adm) 0 (512)

DpShMCreate: sizeof(wall_adm) (416064/346352/64/192)

DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000167D0050, size: 38247056)

DpShMCreate: allocated sys_adm at 00000000167D0050

DpShMCreate: allocated wp_adm at 00000000167D1C30

DpShMCreate: allocated tm_adm_list at 00000000167DE4B0

DpShMCreate: allocated tm_adm at 00000000167DE4E0

DpShMCreate: allocated appc_ca_adm at 0000000018A37C10

DpShMCreate: allocated comm_adm_list at 0000000018A5ED10

DpShMCreate: allocated comm_adm at 0000000018A5ED30

DpShMCreate: allocated vmc_adm_list at 0000000018B8F830

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0000000018B8F860

Tue Dec 02 13:22:53 2008

***LOG Q0I=> NiPGetServByName: service 'sapgw01' not found: getservbyname http://ninti.c 463

Please help how to solve the problem becase for time being if i restart the sever it work but how long since yesterday this problem happened 2 times.

Regards,

Shiva

[Former Member]

Hello Shiva,

Verify your instance profile you will see path for this dll with the profile parameter "snc/gssapi_lib" check is dll is existing at the mentioned path and correct your self.

Thanks,

Kiran.

[Former Member]

Hello Shiva,

Please try to read your log. Your log clearly showing error message

-

---

Thr 924 Tue Dec 09 09:14:04 2008

Thr 924 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 924 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604Thr 4924 Tue Dec 09 09:14:04 2008

Thr 4924 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 4944 Tue Dec 09 09:14:04 2008

Thr 4944 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

http://sncxxdl.0340Thr 4924 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604Thr 4944 *** ERROR => SncPDLInit()==SNCERR_INIT, Adapter (#0) sncgss64.dll not loaded

http://sncxxdl.0604

-

---

This is SNC configuration error. Correct your SNC configuration. Your system will start working.

Check your instance profile and find the path for the dll "sncgss64.dll" it seems it could not find this dll.

Thanks,

Kiran.

[Former Member]

Dear all,

Thanks a lot every one.

I am using sap ecc5 SAP GUI release 640 and there is free space in table spaces. The kernel release patch level is 129. The LICENSE is up-to-date.

Please guide how to SNC configuration error. Correct your SNC configuration.

Please suggest how to solve the problem it happen today also if I restart the sever the problem is solved for time being.

Thanks,

Shiva

[Former Member]

Are you trying to read the note 967124, as i'm wrote before?

Try to search in note ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

Regards.

[Former Member]

Hi,

I am try to solve the problem.

about search in note ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS not able to find any not till now.the snote 967124 it is about 6.20/6.40 SAP Patch Collection Installation on Windows.

There is one more thing when problem happeneds same time in sm21

Time Ty. Nr Cl. User Tcod MNo Text

08:01:07 BTC 030 BY0 > ORA-12560: TNS:protocol adapter error

Details

Recording at local and central time........................ 10.12.2008 08:01:07

Task................ 06872 / Background Processor No. 30

User................

Client..............

Terminal............

Session............. 0

Transaction code....

Program name........

Problem class....... X Miscellaneous

Development class... SBAC

but as i have sayed that time we a login byf3 when abap dump .

Please help

[Former Member]

about search in note ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS not able to find any not till now.the snote 967124 it is about 6.20/6.40 SAP Patch Collection Installation on Windows.

Are you have

SAP ecc5 and oracle 9i on windows 2003

?

Are you trying for example to read this note ?? Strikingly ...

Or do you want to say that your ECC 5.0 is not 6.40?

P.S. About 12560

Note 441518 - ORA-12560 composite SAP Note

Regards.

[Former Member]

Hello Kiran,

I have check my instance profile as you suggested the profile parameter "snc/gssapi_lib" in not here so i have to add this ?

Second this i have read the there sap note 128617and 89384.

As per note

By setting the profile parameter

rsdb/rclu/cachelimit =0

this parameter is also not here in my system

in all instance profiles, you can deactivate the size restriction for

cluster records (the entry of this parameter in the profile DEFAULT.PFL is

not sufficient, since no default value is provided for it).The R/3 System

must be restarted after editing the instance profiles.

Note:If the contents of cluster tables are to be transferred into other R/3

Systems, the profile parameters must also be changed in these systems so

that oversized cluster records can also be read there.

For tp and R3trans (thus for transport and client copies) the environment

variable RCLU_CACHELIMIT must be set to value 0. (for client copies,

exports and imports in the user

environment <sid>adm).

As of Release 4.6A, this size restriction no longer applies.

The program R3check will output the error number "(31)" for the affected

cluster keys even after setting the profile parameter or the environment

variable. This can then be ignored.

AS/400 Environment variables are set as follows in the AS/400: ADDENVVAR

ENVVAR(RCLU_CACHELIMIT) VALUE(0).

You can check this with the command WRKENVVAR. NT.

Please refer to Note 31559 for setting the environment variables.

Please guide.

.

Regards,

Shiva,

[Former Member]

Hai,

Have you checked your filesystems, this dump also occurs if your archive directory gets filled, 'Archive struck' conditions.

Regards,

Yoganand.V

[Former Member]

Hi shiva,

Please let me know your SAP GUI release and its patch number? Are you facing the same problem from every terminal or any perticular terminal?

Reinstalling the SAP GUI properly may solve your problem.

Regards

Aditya

[Former Member]

Post dev_w0 log, also check tablespaces are not full? Say your DB OS SAP version and patches, are you do any changes after this you see this errors ?

P.S. check dump in st22

P.P.S. about

Thr 4924 *** ERROR => SncPDLInit(): DlLoadLib("sncgss64.dll")=DLENOACCESS

try to read in Note 967124 - 6.20/6.40 Patch Collection Installation: Windows

Regards.

[Former Member]

Hai,

Check your license for the system.

Login with SAP* and goto SLICENSE and check the validity of the license, if you find the validity has been expired in case of Temporary license, request new license from SMP which will be mailed to you within 10 or 15 mins.

Then apply the license using SLICENSE tcode and restart your system.

Regards,

Yoganand.V