Interpreting Application Error Log
Hi, I am trying to optimize a method, I am only occasionally receiving Internal Server Error from GUI interaction and when viewing the Application Error Log in IRISHealth this is what I see. <UNDEFINED>%0Ac+3^%sqlcq.QM.uEgYAnxQ4duxnAiaOpZgvilz1tlo.1 *sqldata15d : CSP Error .
I have no idea how to read this and pinpoint the issue.
Full details below.
| Namespace: | QM |
|---|---|
| Process: | 4624 06/15/2024 03:46:31 No: 2 |
| Error: | <UNDEFINED>%0Ac+3^%sqlcq.QM.uEgYAnxQ4duxnAiaOpZgvilz1tlo.1 *sqldata15d : CSP Error |
| Code Line: | |
| Comment: |
|
| Stacks | [Goto Bottom] |
| Expression | Value |
|---|---|
| $D | 0 |
| $EC | ,ZMAXSTRING,ZMAXSTRING,ZMAXSTRING,ZMAXSTRING,ZMAXSTRING,M6,ZZTRAP,ZMAXSTRING,M6,ZMAXSTRING,M6,ZINVALID BIT STRING, |
| $ES | 18 |
| $ET | |
| $H | 67006,13591 |
| $I | |TCP|1972|4624 |
| $J | 4624 |
| $K | |
| $P | |TCP|1972|4624 |
| $Roles | %All,QMDev,QMUser |
| $S | 1072906984 |
| $T | 0 |
| $TL | 0 |
| $USERNAME | ktrieu |
| $X | 870 |
| $Y | 18 |
| $ZA | 24576 |
| $ZB | |
| $ZC | 5424 |
| $ZE | <UNDEFINED>%0Ac+3^%sqlcq.QM.uEgYAnxQ4duxnAiaOpZgvilz1tlo.1 *sqldata15d : CSP Error |
| $ZJ | 2 |
| $ZM | SCAWDBY\Latin1\K\UTF8\ |
| $ZP | 6004 |
| $ZR | ^oddDEF("%Library.RegisteredObject","a","%%OID",58) |
| $ZS | 1048576 |
| $ZT | ETNERRB^%ETN |
| $ZTS | 67005,63991.1594495 |
| $ZU( 5) | QM |
| $ZU( 12) | c:\intersystems\qm\mgr\ |
| $ZU( 18) | 0 |
| $ZU( 20) | QM |
| $ZU( 23,1) | 5 |
| $ZU( 34) | 0 |
| $ZU( 39) | QM |
| $ZU( 55) | 0 |
| $ZU( 56,0) | $Id: //iris/2023.1.0/kernel/common/src/ebool.c#1 $ 0 |
| $ZU( 56,1) | 13462 |
| $ZU( 61) | 18 |
| $ZU( 61,30,n) | 387710994 |
| $ZU( 67,10,$J) | 27 |
| $ZU( 67,11,$J) | CSP Gateway |
| $ZU( 67,12,$J) | qm-test.intersystems.com.au |
| $ZU( 67,13,$J) | CSPms.dll |
| $ZU( 67,14,$J) | GRUfypNgxN |
| $ZU( 67,15,$J) | 203.63.172.98 |
| $ZU( 67,4,$J) | 0^0^0^0 |
| $ZU( 67,5,$J) | %STACK |
| $ZU( 67,6,$J) | QM |
| $ZU( 67,7,$J) | |TCP|1972|4624 |
| $ZU( 67,8,$J) | 1162140 |
| $ZU( 67,9,$J) | 170830 |
| $ZU( 68,1) | 0 |
| $ZU( 68,21) | 0 |
| $ZU( 68,25) | 0 |
| $ZU( 68,27) | 1 |
| $ZU( 68,32) | 0 |
| $ZU( 68,34) | 1 |
| $ZU( 68,36) | 0 |
| $ZU( 68,40) | 1 |
| $ZU( 68,41) | 1 |
| $ZU( 68,43) | 0 |
| $ZU( 68,5) | 1 |
| $ZU( 68,6) | 0 |
| $ZU( 68,7) | 0 |
| $ZU(131,0) | QDAPAWS-QMSERVER-TEST |
| $ZU(131,1) | QDAPAWS-QMSERVER-TEST:QM |
| $ZV | IRIS for Windows (x86-64) 2023.1 (Build 235_1U) Fri Jun 2 2023 13:30:56 EDT |
| Error | <UNDEFINED> |
| Lev | 41 |
| Line | |
| Routine | %0Ac+3^%sqlcq.QM.uEgYAnxQ4duxnAiaOpZgvilz1tlo.1 |
 |
Stacks |
|---|---|
|
1 SIGN ON |
| 2 DO | |
|
3 PARAMETER ?,?,?,? |
| 4 ERROR TRAP S $ZTRAP="+314^%SYS.SERVER" | |
| 5 DO SuperServer+60^%SYS.SERVER | |
|
6 PARAMETER ? |
|
7 NEW NEW %SYSLOG |
|
8 NEW NEW %request,%response,%session |
| 9 DO css+21^%SYS.cspServer2 | |
|
10 PARAMETER ? |
| 11 DO ProcessRequest+1^%CSP.Request.1 | |
|
12 PARAMETER ? |
|
13 NEW NEW %SYSLOG |
| 14 ERROR TRAP S $ZTRAP="+100^%SYS.cspServer2" | |
| 15 DO Request+25^%SYS.cspServer2 | |
| 16 DO Request+683^%SYS.cspServer2 | |
|
17 PARAMETER .?,?,? |
| 18 DO ProcessRequest+1^%CSP.Session.1 | |
|
19 PARAMETER .?,?,? |
|
20 NEW NEW %request,%response,%session,%cspdebug,%cspsoapservice |
| 21 NEW $ NEW $ETRAP | |
|
22 NEW NEW %SYSLOG |
| 23 ERROR TRAP S $ZTRAP="+1125^%SYS.cspServer" | |
| 24 DO CSPDispatch+274^%SYS.cspServer | |
| 25 NEW $ NEW $ROLES | |
| 26 $$EXTFUNC CSPDispatch+495^%SYS.cspServer | |
|
27 PARAMETER ? |
|
28 NEW NEW %CSPsc |
| 29 $$EXTFUNC Page+6^%CSP.ErrorLog.1 | |
|
30 PARAMETER .? |
| 31 DO OnErrorSetup+5^%CSP.ErrorLog.1 | |
| 32 PARAMETER | |
| 33 NEW $ NEW $ETRAP | |
| 34 DO HyperEventError+2^%CSP.ErrorLog.1 | |
|
35 NEW NEW ISCRequest,ISCSession,ISCReponse,ISCErrorInfo |
| 36 DO zLogError+7^%CSP.ErrorLog.1 | |
|
37 PARAMETER %00000 |
| 38 ERROR TRAP S $ZTRAP="LOGE^%ETN" | |
| 39 $$EXTFUNC LOG+7^%ETN ~s %00000("zr")=$$BACK() | |
|
40 NEW NEW %00000 |
| 41 ERROR TRAP S $ZTRAP="ETNERRB^%ETN" | |
| [Goto Top] |
Product version: IRIS 2023.1
Discussion (0)0
Comments
It looks like an <UNDEFINED> error occurs in a SQL query generated code.
Debugging generated code it's not easy/simple, I would double check SQL queries and parameters passed to the queries in the CSP page.