|
Problem IT04066
|
Status: Closed |
RUNNING A STORED PROCEDURE CREATES AF FILE AND ERROR 9791 |
| product: |
IBM IDS EXPRESS / 5724L2305 / B15 - IDS 11.50 |
| Problem description: |
Running a stored procedure assert fails and generates error
9791. The stack looks like:
oninit :: expr2expr
oninit :: op_bind_rtn
oninit :: buildexpr
oninit :: expr2expr
oninit :: cond2expr
oninit :: sel2cb
oninit :: subq2cb
oninit :: sq2expr
oninit :: union_exist_sq2expr
oninit :: expr2expr
oninit :: op_bind_rtn
oninit :: buildexpr
oninit :: expr2expr
oninit :: cond2expr
oninit :: sel2cb
oninit :: subq2cb
oninit :: sq2expr
oninit :: subq2expr
oninit :: collsubq2expr
oninit :: expr2expr
oninit :: determine_cdt_coll_type
oninit :: tlgetcolltab
oninit :: tlgetddtab
oninit :: spgettab
oninit :: tlp2tnode + 0x714 sp=0x10bdf3a40(0x101556,
0x0, 0xffffffffffffffff, 0x10bbb88
38, 0x0, 0x0)
oninit :: tbl2tab
oninit :: sel2cb
oninit :: qblk2cb
oninit :: ip_scurparse_internal
oninit :: ip_scurstart
oninit :: ip_evalcursor
oninit :: runproc
oninit :: udrlm_spl_execute
oninit :: udrlm_exec_routine
oninit :: udr_execute
oninit :: exroutine
oninit :: execproc
oninit :: aud_execproc
oninit :: excommand
oninit :: sq_execute
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread
oninit :: th_init_initgls
oninit :: startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users running INTERSECT or MINUS operators inside Stored *
* Procedure. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IDS-12.10.xC5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IDS-12.10.xC5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2014
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
