DBIF_REPO_SQL_ERROR

[Former Member]

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.

[former_member618758]

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

[Former Member]

could you solve the problem?

regards

flo

[waldo]

Hi there.

Great note the 392892, but the 607689 said: "The requested SAP Note is either in reworking or is released internally only"

Regards

[former_member189546]

Hello,

Noot 607689 is only for Msql 2000

from the note.

THIS OSS NOTE DOES NOT APPLY FOR SQL SERVER 7.0 BUT ONLY FOR

SQL SERVER 2000. FOR SQL SERVER 7.0 SPECIFIC OSS NOTE CHECK

OSS NOTE #565708.

Normally this is a network issue.

Nest time you have the dump try a niping check from the application server with the problem

Application server....... "sapprods"     to the database.

500235 Network Diagnosis with NIPING

regards,

John Feely