cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error - 602

Former Member
0 Kudos

Hello,

I'm using DEMOSYSTEM(NetWeaver 7.01) and logged in as BCUSER. There is no BASIS team ,it is a single system user(trail version in my PC)

when I'm creating a custom function module as Z group(name starts with Z) it throwing me the error like this SQL error "-602" occurred when accessing program "SAPLPA_AKB" part "LREF"

My database details are

System:MaxDB

Release:7.7.06.007

Thanks

Jean

Accepted Solutions (0)

Answers (1)

Answers (1)

thorsten_zielke
Contributor
0 Kudos

Hi,

please post more information from the short dump - the info above is a bit vague.

Thorsten

Former Member
0 Kudos

Hello Thorsten,

Thanks for your reply,

Please note this is the standalone system I don't have any basis team,I have to face A-Z .

Here is my detailed Error description.

  

Runtime Errors DBIF_REPO_SQL_ERROR

--------------------------------------------------------------------------------------------------

Short text

SQL error "-602" occurred when accessing program "SAPLPA_AKB " part "LREF".                  

----------------------------------------------------------------------------------------------------

System environment                                                                               

    SAP-Release 701

    Application server... "sapnw"                                                                

    Operating system..... "Windows NT"

Release.............. "5.2"                                                                  

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

    Character length.... 16 Bits                                                                 

    Pointer length....... 32 Bits                                                                

    Work process number.. 0                                                                      

    Shortdump setting.... "full"                                                                 

    Database server... "sapnw"                                                                   

    Database type..... "ADABAS D"

    Database name..... "NSP"                                                                     

    Database user ID.. "SAPNSP"                                                                  

    Terminal.......... "sapnw"                                                                   

    Char.set.... "C"

    SAP kernel....... 701                                                                        

    create on........ "NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00"                             

    Database version. "SQLDBC 7.6.5.011 CL 196300 "                                              

    Patch level. 29                                                                              

    Patch text.. " "                                                                            

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

    SAP database version. 701                                                                    

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

     NT 6.0"                                                                                     

    Memory consumption                                                                           

    Roll.... 8176

    EM...... 18814032                                                                            

   Heap.... 0

    Page.... 73728                                                                               

   MM Used. 9264104

    MM Free. 1185720

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

User and Transaction                                                                             

  1. Client.............. 001
  2. User................ "BCUSER"

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

  1. Transaction......... " "

Transactions ID..... "D9A408DFD8AFF1BDA83A000C29BC6989"                                                                                                                                    

  1. Program............. "SAPLPA_AKB"
  2. Screen.............. " "                                                                     

Screen line......... " "

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

Information on where terminated

The termination occurred during generation of the ABAP/4 program "SAPLPA_AKB".               

-

The termination occurred in line 0

of the source code of program "????????????????????????????????????????" (when               

calling the editor 00).

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

Internal notes

The termination was triggered in function "repo_write"                                       

of the SAP kernel, in line 247 of the module

"//bas/701_REL/src/krn/gen/cgsave2.c#1".

The internal operation just processed is " ".

Internal call code.........: "[REPO/*/WRBL/LREF/SAPLPA_AKB ]"                                

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

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=2208)

Threads   : 2

Computer Name       : SAPNW

User Name           : SAPServiceNSP

Number of Processors: 2                                                                          

Processor Type: x86 Family 6 Model 37 Stepping 5

Windows Version     : 5.2 Current Build: 3790

State Dump for Thread Id 8a4

eax=00000000 ebx=0000049c ecx=028e70d8 edx=028e7268 esi=0000049c edi=00000000

eip=7c82860c esp=0571118c ebp=057111fc 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

7c82860c c3               ret

7c82860d 8da42400000000 lea     esp,[esp]              ss:0571118c=7c827d29            

7c828614 8d642400 lea     esp,[esp]              ss:12edf7cb=????????            

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

057111fc 77e61c7d 0000049c 0001d4c0 00000000 05711234 KiFastSystemCallRet

05711210 01123c60 0000049c 0001d4c0 00000001 781c1c58 WaitForSingleObject                        

05711234 00590f12 00590f4b 781c1c58 781c1c58 781c1c58 NTDebugProcess [ntstcdbg.c (501)]

05711238 00590f4b 781c1c58 781c1c58 781c1c58 01e8def8 NTStack [dptstack.c (1368)]

05711254 00590f7f 781c1c58 00000000 008dac67 781c1c58 CTrcStack2 [dptstack.c (353)]

05711260 008dac67 781c1c58 00000000 005f0059 00300030 CTrcStack [dptstack.c (182)]

05711288 008de39d aa8ffd12 02b7f2c0 05bc3e80 015ce670 rabax_CStackSave [abrabax.c (7147)]

05711b3c 0083fe83 015ce670 01556818 000000f7 05bc4910 ab_rabax [abrabax.c (1250)]

05711bdc 00a6d572 00000001 015ce670 000000f7 05bc4910 ab_repoerr [abdberr.c (122)]

05711c14 00a6d5b7 00000000 00000001 05711cc0 00aac77b repo_write [cgsave2.c (247)]

05711c24 00aac77b 5235c095 00000008 00000000 00000000 cg_putnbytes [cgsave2.c (272)]

05711f84 00a6d349 05715b64 00000000 00000000 00000000 sc_save [cgenvi.c (1031)]                  

05712308 00861e85 05715b64 00000001 00000000 00000000 cg_generate [cgmain2.c (715)]

05712350 005b7b00 05715b64 00000000 00000000 05718830 ab_gabap [abgen.c (1704)]

05715bc0 0086274b 00000041 057188f8 00000000 00000000 dy_gen_abap [dynpabsv.c (309)]

057187fc 006cf61b 057188f8 00000000 00000000 00000000 ab_genprog [abgen.c (1455)]                

0571884c 006cfc8a 057188f8 00000000 00000001 0000000d newload [abload1.c (336)]

05718874 006cfd1a 057188f8 00000001 05718888 00000000 ab_LoadProgOrTrfo [abload1.c (159)] 0571888c 007a93e9 057188f8 00000001 00000000 4e2e8930 ab_LoadProg [abload1.c (77)]               

057189cc 00735973 00000001 4e2e6fba 0000000d 00009aef ab_link [ablink.c (381)]

0571cfa4 006ff8ff 00000003 51b34020 00000000 0571d014 ab_jfunc [abfunc.c (666)]

0571d014 0083f485 00000000 51b34020 0571d0cc 51b3538a ab_extri [abextri.c (552)]

0571d028 008b9983 00000000 78180a71 005d45ba 51b3503c ab_xevent [abrunt1.c (281)]

0571d034 005d45ba 51b3503c 00000011 51b35324 00000000 ab_dstep [abdynpro.c (492)]

0571d164 005d76b5 51b34020 51b34020 0571d228 00000000 dynpmcal [dymainstp.c (2464)]              

0571d178 005d6ef5 51b34020 51b34020 00000003 0571d228 dynppai0 [dymainstp.c (1001)]

0571d194 005a6946 51b34020 00000001 00000001 00000001 dynprctl [dymainstp.c (360)]

0571fcfc 00497d59 00000002 004a30f6 00000002 00000000 dynpen00 [dymain.c (1686)]

0571fd04 004a30f6 00000002 00000000 00000003 00000002 Thdynpen00 [thxxhead.c (4902)]

0571fef4 004a4ad8 00000000 7813e457 002b7080 05710000 TskhLoop [thxxhead.c (3951)]

0571ff18 004248d7 04f10fac 00000000 00000000 0571ff7c ThStart [thxxhead.c (1182)]

0571ff2c 0040106e 00000003 002b7080 00000001 00000000 DpMain [dpxxdisp.c (1140)]                 

0571ff7c 012e6862 00000003 002b7080 002b78a8 aa8f103a nlsui_main [thxxanf.c (64)]

0571ffc0 77e6f22b 00000000 00000000 7ffd8000 00000000 __tmainCRTStartup [crtexe.c (594)]

0571fff0 00000000 00401094 00000000 00000000 00000000 ProcessIdToSessionId                       

State Dump for Thread Id 968                                                                     

eax=fffffffe ebx=00000103 ecx=0801fee8 edx=7c82860c esi=00000000 edi=00000000

eip=7c82860c esp=0801feb0 ebp=0801fef4 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                                                                   

7c82860c c3 ret                                                            

7c82860d 8da42400000000 lea     esp,[esp]              ss:0801feb0=7c827119            

7c828614 8d642400 lea     esp,[esp]              ss:157ee4ef=????????            

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

0801fef4 01228aa2 00000698 00000000 a7ff1082 00000000 KiFastSystemCallRet

0801ff78 781329bb 00000000 029c1dba 00000000 00000000 SigIMsgFunc [signt.c (678)]                

0801ffb0 78132a47 00000000 77e6481f 05a97520 00000000 endthreadex                                

0801ffec 00000000 781329e1 05a97520 00000000 00000000 endthreadex                                

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

Database Interface Information

----------------------------------------------------------------------------------------------------

CEwriteLob() of C_0258, rc=1, rcSQL=-602 (POS(1) System error: BD Bad file)                  

[dbsdbsql.cpp#1901]                                                                          

CELOB_WRITE on connection 0, rc=-602 (POS(1) System error: BD Bad file) [dbslsdb.cpp#7688]     

C1sc_p=05ADEA10,no=258,idc_p=05AF768C,con=0,act=1,slen=90,smax=256,#vars=4,stmt=0E0E0D38,      

  table=REPOLOAD                       [dbsc.c#1066]                                           

C1UPDATE "REPOLOAD" SET "QDATA" = ? WHERE "PROGNAME" = ? AND "R3STATE" = ? AND "MACH" = ?  ;

[dbsc.c#2258]

BE***LOG BYL=> DBQ action required because of database error            [dbsh#1104]            

B1SQL code: -602, SQL text: POS(1) System error: BD Bad file [dbsh.c#1112]                     

BE***LOG BY4=> sql error -602   performing PUT on table REPOLOAD   [dbrepolo#873]               BE***LOG BY0=> POS(1) System error: BD Bad file [dbrepolo#873]                                 

----------------------------------------------------------------------------------------------------

thorsten_zielke
Contributor
0 Kudos

Hello Jean,

it seems that a database error occurs during the following update statement:

UPDATE "REPOLOAD" SET "QDATA" = ? WHERE "PROGNAME" = ? AND "R3STATE" = ? AND "MACH" = ?  ;

LOG BYL=> DBQ action required because of database error

SQL code: -602, SQL text: POS(1) System error: BD Bad file

LOG BY4=> sql error -602   performing PUT on table REPOLOAD

LOG BY0=> POS(1) System error: BD Bad file

Please run a 'check data' to verify the database integrity (for details see SAP note 940420) and let me know the result.

Thorsten