on 06-21-2008 12:27 AM
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)
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Ravi,
Which DB you are using as backend , Can you tell me the information of the landsacpe?
Thanks,
Regards,
Rudradev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.