Runtime Errors - DBIF_DSQL2_SQL_ERROR

[Former Member]

Dear All,

SAP SCM 7.0 , MSSQL,Windows NT ,2x AMD64 L ,562.

We are getting below errors are found while executing TA- /n/sapapo/om17 consistency check. Please do the needful. With these errors APO is not usable.

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 25.08.2011 08:38:53

Short text

An SQL error occurred when executing Native SQL.

What happened?

The error "-10709" occurred in the current database connection "LCA".

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

How to correct the error

Database error text........: "Connection failed (RTE:[5] database not running)"

Database error code........: "-10709"

Triggering SQL statement...: "EXECUTE PROCEDURE "APS_PEGAREA_CHANGE""

Internal call code.........: "[DBDS/NEW DSQL]"

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

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_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"

"/SAPAPO/SAPLOM_CORE" or "/SAPAPO/LOM_COREU01"

"/SAPAPO/OM_PEGAREA_CHANGE"

System environment

SAP-Release 701

Application server... "sap0220"

Network address...... "192.168.1.95"

Operating system..... "Windows NT"

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

Hardware type........ "2x AMD64 Level"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 0

Shortdump setting.... "full"

Database server... "SAP0220"

Database type..... "MSSQL"

Database name..... "E06"

Database user ID.. "e06"

Terminal.......... "inp-kapgateg"

Char.set.... "C"

SAP kernel....... 701

created (date)... "Feb 24 2009 23:27:20"

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

Database version. "SQL_Server_8.00 "

Patch level. 32

Patch text.. " "

Database............. "MSSQL 9.00.2047 or higher"

SAP database version. 701

Kindly Suggest

[Former Member]

WIP ...

[markus_doehr2]

> We are getting below errors are found while executing TA- /n/sapapo/om17 consistency check. Please do the needful. With these errors APO is not usable.

>

> Database error text........: "Connection failed (RTE:[5] database not running)"

> Database error code........: "-10709"

Well - the error message says it all - you livecache is not running.

Start transaction LC10 and start it.

Markus

[Former Member]

HI Marcus,

TA- LC10 , its below status shows Live cache is running and even though we are getting the below runtime error .

liveCache Version KERNEL 7.7.04 BUILD 029-123-196-543

DBMServer Version DBMServer 7.7.04 Build 029-123-196-543

Operating System Windows Server 2003 family

Operational State

Started On 25.08.2011 09:29:55

Last Start/Stop Action Start of: 25.08.2011 09:29:49

Automatic Log Backup OFF Database Trace OFF

Command Monitor OFF

Resource Monitor OFF

Defective indexes detected

Now We are getting the below runtime error .

Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

Date and Time 26.08.2011 07:45:52

Short text

A table is unknown or does not exist.

What happened?

Error in the ABAP Application Program

The current ABAP program "/SAPAPO/SAPLDM_LC_SQL" had to be terminated because

it has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

A table is referred to in an SAP Open SQL statement that either does not

exist or is unknown to the ABAP Data Dictionary.

The table involved is "/SAPAPO/STOCKANC " or another table accessed in the

statement.

o correct the error

robably the only way to eliminate the error is to correct the program.

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

nternal call code.........: "[RSQL/OPEN//SAPAPO/STOCKANC ]"

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

ind an interim solution in an SAP Note.

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

eywords:

DBIF_RSQL_TABLE_UNKNOWN" " "

/SAPAPO/SAPLDM_LC_SQL" or "/SAPAPO/LDM_LC_SQLU19"

/SAPAPO/OM_STOCKANC_SELECT"

Kindly advise for further analysis.

Thanks

Edited by: satheesh0812 on Aug 26, 2011 7:47 AM

Edited by: satheesh0812 on Aug 26, 2011 7:48 AM

[markus_doehr2]

> TA- LC10 , its below status shows Live cache is running and even though we are getting the below runtime error .

Ok...

> Defective indexes detected

You should repair those indexes!

> lease check the entries in the system log (Transaction SM21).

> nternal call code.........: "[RSQL/OPEN//SAPAPO/STOCKANC ]"

It seems that this table is unknonwn to the livecache.

Was that system working before? Did anything happen prior to this error?

Markus