4 Replies Latest reply: May 16, 2013 6:07 PM by John Feely RSS

DBIF_REPO_SQL_ERROR

Ryan DosSantos
Currently Being Moderated

Hello all,

 

I am recieving the following in my Production system. Any help would be really appreciated. The dump is as follows:

 

DBIF_REPO_SQL_ERROR                                                                               

SQL error 11 occurred when accessing program "CX_SY_OPEN_SQL_DB=============CP                                                                               

What happened?                                                                               

What can you do?                                                                               

Make a note of the actions and input which caused the error.                                                                               

To resolve the problem, contact your SAP system administrator.                                                                               

You can use transaction ST22 (ABAP Dump Analysis) to view and administer                             

termination messages, especially those beyond their normal deletion                                  

date.                                                                               

Error analysis                                                                               

How to correct the error                                                                               

Database error text........: "[11] [DBNETLIB][ConnectionRead (recv()).]General                       

network error. Check your network documentation."                                                   

Triggering SQL statement...: "CX_SY_OPEN_SQL_DB=============CP "                                     

Internal call code.........: "[REPO/*/RDIN/LOAD/CX_SY_OPEN_SQL_DB=============C                      

P ]"                                                                               

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

You may able to find an interim solution to the problem                                              

in the SAP note system. If you have access to the note system yourself,                              

use the following search criteria:                                                                               

"DBIF_REPO_SQL_ERROR" C                                                                               

"SAPLVS01 " or " "                                                                               

"KNVI_GENERIC_READ_LAND"                                                                               

If you cannot solve the problem yourself, please send the                                            

following documents to SAP:                                                                               

1. A hard copy print describing the problem.                                                         

   To obtain this, select the "Print" function on the current screen.                                

-                                                                               

2. A suitable hardcopy prinout of the system log.                                                    

   To obtain this, call the system log with Transaction SM21                                         

   and select the "Print" function to print out the relevant                                         

   part.                                                                               

3. If the programs are your own programs or modified SAP programs,                                   

   supply the source code.                                                                               

To do this, you can either use the "PRINT" command in the editor or                               

   print the programs using the report RSINCL00.                                                                               

4. Details regarding the conditions under which the error occurred                                 

   or which actions and input led to the error.                                                                               

System environment                                                                               

SAP Release.............. "620"                                                                               

Application server....... "sapprods"                                                               

Network address.......... "192.168.0.10"                                                           

Operating system......... "Windows NT"                                                             

Release.................. "5.0"                                                                    

Hardware type............ "4x Intel 801586"                                                        

Character length......... 8 Bits                                                                   

Pointer length........... 32 Bits                                                                  

Work process number...... 0                                                                        

Short dump setting....... "full"                                                                               

Database server.......... "SAPPRODD"                                                               

Database type............ "MSSQL"                                                                  

Database name............ "P11"                                                                    

Database owner........... "p11"                                                                               

Character set............ "English_United State"                                                                               

SAP kernel............... "620"                                                                    

Created on............... "Sep 29 2003 21:45:11"                                                   

Created in............... "NT 5.0 2195 Service Pack 2 x86 MS VC++ 12.00"                           

Database version......... "SQL_Server_7.00 "                                                                               

Patch level.............. "1091"                                                                   

Patch text............... " "                                                                               

Supported environment....                                                                          

Database................. "MSSQL 7.00.699 or higher, MSSQL 8.00.194"                               

SAP database version..... "620"                                                                    

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

User, transaction...                                                                               

Client.............. 500                                                                           

User................ "DAYANARA"                                                                    

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

Transaction......... "VF01 "                                                                       

Program............. "SAPLVS01 "                                                                   

Screen.............. "SAPMV60A 0102"                                                               

Screen line......... 38                                                                               

Information on where termination occurred                                                                               

The termination occurred in the ABAP program "SAPLVS01 " in                                        

"KNVI_GENERIC_READ_LAND".                                                                         

The main program was "SAPMV60A ".                                                                               

The termination occurred in line 0 of the source code of the (Include)                             

program " "                                                                               

Kind Regards,

Ryan.

  • Re: DBIF_REPO_SQL_ERROR
    George Chang
    Currently Being Moderated

    Hello Ryan,

     

    From the log you have:

     

    Database error text........: "[11] [DBNETLIB][ConnectionRead (recv()).]General

    network error. Check your network documentation."

     

    There's an indication for a network related cause, you can have a look at SAP Note 392892  DBIF_RSQL_SQL_ERROR (SQL-Fehler 0 oder 11)   which addresses this cause, also you have sql server 7 you can also have a look at note 607689  SQL Server 2000: Database Error 601  and make sure most recent Hotfix

    is there.

     

    Thanks,

    George

Actions