Here is a sample query which may cause this problem.
----
xquery declare namespace xxxxxx="http://xxxxx";
<xxxxxx:Rows>
{
for $data in (
for $i in
db2-fn:sqlquery('select DATA from xxxxxx_ILLEGALACNT
where contains(DATA,''SECTION("/xxxxxx:
IllegalAcnt") " & "'')=1')/xxxxxx:IllegalAcnt
[ xxxxxx:illegalStatusCode = '08' ]
return
<xxxxxx:data>
<columns1>"{$i/xxxxxx:illegalAcntDivision/text()}"</columns1>
<key1>"{$i/xxxxxx:mngBranchNumber/text()}"</key1>
<columns2>"{$i/xxxxxx:seq/text()}","{concat($i/xxxxxx:mngBranchN
ame/text(),$i/xxxxxx:mngBranchP
art/text())}"</columns2>
<key2>"{$i/xxxxxx:acntNumber/text()}"</key2>
<columns3>"{$i/xxxxxx:cifNumber/text()}","{$i/xxxxxx:kanjiName/t
ext()}","{$i/xxxxxx:kanaName/te
xt()}","{$i/xxxxxx:noticeCrimeName/text()}","{$i/xxxxxx:freezeDa
te/text()}","{$i/xxxxxx:cancelDate/text()}"
,"{$i/xxxxxx:noticeBalance/text()}","{$i/xxxxxx:transferTime/tex
t()}","{$i/xxxxxx:victimCount/text()}","{$i
/xxxxxx:trnsAcntExistence/text()}","{$i/xxxxxx:acntCategoryName/
text()}","{$i/xxxxxx:acntGroupName/text()}"
,"{$i/xxxxxx:catchDate/text()}","{$i/xxxxxx:chargePerson/text()}
"
,"{$i/xxxxxx:toumeihan/text()}","{$i/ap50
03:oldBankName/text()}","{$i/xxxxxx:complainDivisionName/text()}
","{$i/xxxxxx:noticeTimes/text()}","{$i/ap5
003:noticeNumber/text()}","{$i/xxxxxx:noticeSendDate/text()}","{
$i/xxxxxx:comingLimit/text()}","{$i/xxxxxx:
applicationLimit/text()}","{$i/xxxxxx:dicPayDate/text()}","{$i/x
xxxxx:freezeBalance/text()}","{$i/xxxxxx:cu
rrentBalance/text()}","{$i/xxxxxx:totalDividend/text()}","{$i/xx
xxxx:dicPayAmount/text()}","{$i/xxxxxx:chan
nelName/text()}","{$i/xxxxxx:confirmDocumentName/text()}","{$i/x
xxxxx:freezeAcntName/text()}","{$i/xxxxxx:p
ersonUnknown/text()}","{$i/xxxxxx:checkDocumentName/text()}","{$
i/xxxxxx:addZipCode1/text()}","{$i/xxxxxx:a
ddNoticeAddress1/text()}","{$i/xxxxxx:addRepresentativeName1/tex
t()}","{$i/xxxxxx:fcScheduledDate/text()}",
"{$i/xxxxxx:noticeCount/text()}","{$i/xxxxxx:noticeCategoryName/
text()}","{$i/xxxxxx:illegalAcntSummary/tex
t()}","{$i/xxxxxx:lostProcessName/text()}","{$i/xxxxxx:denyReaso
n/text()}","{$i/xxxxxx:noticeReasonName/tex
t()}","{$i/xxxxxx:rightsReportExistence/text()}","{$i/xxxxxx:not
iceWithdraw/text()}","{$i/xxxxxx:noticeMany
/text()}","{$i/xxxxxx:totalDamageAmount/text()}","{$i/xxxxxx:tot
alTrnsDeducutAmount/text()}","{$i/xxxxxx:to
talDmgTrnsDeducutAmount/text()}","{$i/xxxxxx:leakAcntNumber/text
()}","{$i/xxxxxx:fcCancelAcntNumber/text()}
","{$i/xxxxxx:birthOrEstablishDate/text()}","{$i/xxxxxx:openingD
ate/text()}","{$i/xxxxxx:receiveDivisionNam
e/text()}","{$i/xxxxxx:acntCancelName/text()}","{$i/xxxxxx:illeg
alStatusCode/text()}","{$i/xxxxxx:fcCancelB
alance/text()}","{$i/xxxxxx:relationAcnt/text()}","{$i/xxxxxx:ma
inAcntId/text()}","{$i/xxxxxx:follow/text()
}","{$i/xxxxxx:useStatusName/text()}","{$i/xxxxxx:oldBranchNumbe
r/text()}","{$i/xxxxxx:oldBranchName/text()
}","{$i/xxxxxx:oldAcntNumber/text()}","{$i/xxxxxx:oldCifNumber/t
ext()}","{$i/xxxxxx:oldKanjiName/text()}","
{$i/xxxxxx:oldKanaName/text()}","{$i/xxxxxx:fcBranchNumber/text(
)}","{$i/xxxxxx:fcBranchName/text()}","{$i/
xxxxxx:fcAcntNumber/text()}","{$i/xxxxxx:fcCifNumber/text()}"</c
olumns3>
</xxxxxx:data>
)
order by $data/key1 ascending,$data/key2 ascending
return
<xxxxxx:row>{$data/columns1/text()},{$data/key1/text()},{$data/c
olumns2/text()},{$data/key2/text()},{$d
ata/columns3/text()}</xxxxxx:row>
}
</xxxxxx:Rows>
----
When the problem occured, trap file(s) will be generated in the
FODC directory, and the stack trace would look like the
following:
<StackTrace>
------FUNCTION + OFFSET------
ossDumpStackTraceEx + 0x01ef
_ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc
sqlo_trce + 0x03fb
sqloEDUCodeTrapHandler + 0x0243
address: 0x0000003D2980E7C0 ; dladdress: 0x0000003D29800000...
_Z17sqlno_union_setsNP13sqlno_globalsP9sqlno_sdbP10sqlno_ap...
_Z15sqlno_union_setP13sqlno_globalsP9sqlno_sdbP10sqlno_apcb...
_Z34sqlno_crule_xml_index_anding_plansP13sqlno_globalsP13sq...
_Z27sqlno_crule_xml_text_andingP13sqlno_globalsP13sqlno_con...
_Z30sqlno_crule_index_anding_plansP13sqlno_globalsP13sqlno_...
_Z24sqlno_crule_index_andingP13sqlno_globalsP13sqlno_contex...
_Z23sqlno_crule_access_rootP13sqlno_globalsP13sqlno_context...
_Z19sqlno_plan_with_idmP13sqlno_globalsP13sqlno_contextP20s...
_Z26sqlno_xml_replan_for_inljnP13sqlno_globalsP9sqlno_qtbP1...
_Z16sqlno_crule_joinP13sqlno_globalsP9sqlno_qtbP11sqlno_qpc...
_Z28sqlno_gen_partitions_for_QTBP13sqlno_globalsP9sqlno_sfb...
_Z18sqlno_plan_end_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_op...
_Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_...
_Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9s...
....
It's hard to tell when/which exactly xquery will cause DB2 to
trap. |
