cancel
Showing results for 
Search instead for 
Did you mean: 

500 Internal Server Error

Former Member
0 Kudos

Hello Guru's,

I am getting 500 Internal Server Error when i execute a query using the query designer. I donu2019t have any issues when we run the query using u201CExecuteu201D& u201CExecute + Debugu201D option from RSRT & BEx Analyzer. We are getting same error when we run query using u201CJava Webu201D option from RSRT. I could not able to find the exact log in Default trace file. Here is the error.

Root Cause

The initial exception that caused the request to fail was:

Termination message sent

ABEND DBMAN (259): Unknown error in SQL interface

com.sap.ip.bi.base.application.exceptions.AbortMessageRuntimeException: Termination message sent

ABEND DBMAN (259): Unknown error in SQL interface

at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:160)

at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:116)

at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:156)

at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:116)

http://..

Messages

ABEND: Unknown error in SQL interface

ABEND: An exception with the type CX_RS_SY_SQL_ERROR occurred, but was neither handled locally, nor declared in a RAISING clause

ABEND: Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

ABEND: System error in program SAPLRS_EXCEPTION and form RS_EXCEPTION_TO_MESSAGE (see long text)

Full Exception Chain

Log ID 00306EF3F7D50066000000A200003AF00004501C26AA38E3

com.sap.ip.bi.base.application.exceptions.AbortMessageRuntimeException: Termination message sent ABEND DBMAN (259): Unknown error in SQL interface

Deployed SCAs

SCA Version SP Patch Compiled Deployed

ADSSAP 7.00 14 0 2007-11-18 05:51:47 PST 2008-05-17 17:23:47 PDT

BASETABLES 7.00 14 1 2008-01-30 13:22:37 PST 2008-05-17 20:15:07 PDT

BI-BASE-S 7.00 14 2 2008-03-13 09:32:33 PDT 2008-05-18 05:47:49 PDT

BI-IBC 7.00 14 0 2007-11-18 03:58:05 PST 2008-05-17 18:09:52 PDT

BI-REPPLAN 7.00 14 0 2007-11-17 05:56:51 PST 2008-05-17 18:28:54 PDT

BI-WDALV 7.00 14 0 2007-11-17 05:57:00 PST 2008-05-17 18:26:24 PDT

BIWEBAPP 7.00 14 2 2008-03-13 09:33:35 PDT 2008-05-17 20:51:02 PDT

BI_MMR 7.00 14 1 2008-02-05 12:19:39 PST 2008-05-18 05:49:00 PDT

BI_UDI 7.00 14 0 2007-11-18 06:08:52 PST 2008-05-17 17:44:33 PDT

CAF 7.00 14 1 2008-02-26 13:56:53 PST 2008-05-18 05:54:56 PDT

CAF-KM 7.00 14 1 2008-02-12 10:41:55 PST 2008-05-18 05:57:47 PDT

CAF-UM 7.00 14 0 2007-11-17 06:28:47 PST 2008-05-17 17:26:06 PDT

CORE-TOOLS 7.00 14 0 2007-11-18 06:12:27 PST 2008-05-17 11:26:51 PDT

EP-PSERV 7.00 14 1 2008-02-20 10:57:33 PST 2008-05-18 08:51:23 PDT

EP-WDC 7.00 14 0 2007-11-18 04:10:28 PST 2008-05-17 18:30:55 PDT

EPBC 7.00 14 1 2008-01-30 08:09:38 PST 2008-05-18 08:45:40 PDT

EPBC2 7.00 14 2 2008-02-27 09:43:27 PST 2008-05-18 08:52:05 PDT

EP_BUILDT 7.00 14 1 2008-03-13 14:27:00 PDT 2008-05-18 06:05:44 PDT

JLOGVIEW 7.00 14 0 2007-11-17 19:24:00 PST 2008-05-17 11:27:34 PDT

JSPM 7.00 14 0 2007-12-10 16:07:00 PST 2008-05-17 09:30:51 PDT

KM-KW_JIKS 7.00 14 0 2007-11-18 06:16:32 PST 2008-05-17 17:29:43 PDT

KMC-BC 7.00 14 2 2008-03-11 11:43:35 PDT 2008-05-18 08:54:23 PDT

KMC-CM 7.00 14 1 2008-03-11 11:44:50 PDT 2008-05-18 08:57:12 PDT

KMC-COLL 7.00 14 1 2008-03-04 11:18:00 PST 2008-05-18 09:02:17 PDT

LM-PORTAL 7.00 14 0 2007-11-17 06:05:58 PST 2008-05-17 18:34:44 PDT

LM-TOOLS 7.00 14 3 2008-02-27 13:45:28 PST 2008-05-18 12:41:16 PDT

NET-PDK 7.00 14 0 2007-11-18 04:13:24 PST 2008-05-17 18:18:17 PDT

RTC 7.00 14 0 2007-11-18 04:13:42 PST 2008-05-17 18:18:24 PDT

RTC-STREAM 7.00 14 0 2007-11-18 04:13:43 PST 2008-05-17 18:08:28 PDT

SAP-EU 7.00 14 0 2007-11-17 06:07:36 PST 2008-05-17 18:47:38 PDT

SAP-JEE 7.00 14 2 2008-02-13 09:37:11 PST 2008-05-17 21:40:34 PDT

SAP-JEECOR 7.00 14 2 2008-03-09 03:49:36 PDT 2008-05-17 22:22:20 PDT

SAP_JTECHF 7.00 14 4 2008-03-03 07:19:42 PST 2008-05-17 22:37:28 PDT

SAP_JTECHS 7.00 14 4 2008-03-03 07:21:58 PST 2008-05-18 11:04:11 PDT

UMEADMIN 7.00 14 1 2008-03-03 07:04:48 PST 2008-05-18 12:51:31 PDT

UWLJWF 7.00 14 1 2008-02-27 09:49:50 PST 2008-05-18 12:59:09 PDT

VCBASE 7.00 14 1 2008-02-18 12:29:04 PST 2008-05-18 13:03:32 PDT

VCFLEX 7.00 14 1 2008-02-25 10:25:41 PST 2008-05-18 12:59:56 PDT

VCFRAMEWORK 7.00 14 1 2008-02-18 12:30:00 PST 2008-05-18 13:01:09 PDT

VCKITBI 7.00 14 0 2007-11-18 04:03:22 PST 2008-05-17 18:08:32 PDT

VCKITGP 7.00 14 0 2007-11-18 04:15:30 PST 2008-05-17 18:08:34 PDT

VCKITXX 7.00 14 0 2007-11-18 04:15:30 PST 2008-05-17 18:08:37 PDT

WDEXTENSIONS 7.00 14 0 2007-11-17 06:09:18 PST 2008-05-17 18:50:52 PDT

Please give me your valuable suggestions.

Thanks,

Ravi.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ravi,

Along with the details of the database also let us know the way you are connecting to the database, whether it's through the DSN created in the Visual Admin or directly through the driver.

Kind Regards,

Manoj Durairaj

rudradev_devulapalli3
Active Participant
0 Kudos

Dear Ravi,

Which DB you are using as backend , Can you tell me the information of the landsacpe?

Thanks,

Regards,

Rudradev

Former Member
0 Kudos

We are running our landsacapes on NW04s UNIX/ORACLE.