Hi guys,
I keep getting the error "Unable to convert XML record into jBASE record"
when LISTing records in jsh.
After further investigation I realised the issue is with records containing
many multivalues.
Secondly, the error occurs when SELECT or LIST encounters a record with
such MVs. What's strange is if I log into T24 and read the record directly
(e.g. AC S 67113) it displays fine.
ACCOUNT.NUMBER.... 67113 HITACHI USD
------------------------------------------------------------------------------
29 AMNT.LAST.CR.CUST. 20,000.00
30 TRAN.LAST.CR.CUST. 220 Inward Telex Payment
34 DATE.LAST.CR.BANK. 17 APR 2014
35 AMNT.LAST.CR.BANK. 198.01
36 TRAN.LAST.CR.BANK. 381 Credit Interest
46. 1 CAP.DATE.CHARGE 31 MAR 2014
47. 1 CAP.DATE.CR.INT 21 APR 2014
47. 2 CAP.DATE.CR.INT 20 APR 2014
47. 3 CAP.DATE.CR.INT 19 APR 2014
47. 4 CAP.DATE.CR.INT 18 APR 2014
47. 5 CAP.DATE.CR.INT 17 APR 2014
47. 6 CAP.DATE.CR.INT 16 APR 2014
47. 7 CAP.DATE.CR.INT 15 APR 2014
47. 8 CAP.DATE.CR.INT 14 APR 2014
47. 9 CAP.DATE.CR.INT 13 APR 2014
47.10 CAP.DATE.CR.INT 12 APR 2014
But if I do
LIST FBNK.ACCOUNT WITH @ID EQ '67113'
the I get the error
LIST FBNK.ACCOUNT WITH @ID EQ '67113'
ERROR! Select processing detected record error
On the XMLDriver.log the error is more verbose:
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - JQL: LIST FBNK.ACCOUNT WITH @ID EQ '67113'
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - SELECT: SQL:1:Part: SELECT t.RECID,t.XMLRECORD.getClobVal()
FROM FBNK_ACCOUNT t WHERE NUMCAST(RECID)=67113
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - comShortXmlToJbase: Key = 67113. Unable to convert XML
record into jBASE record
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - comConvertXmlToJbase: comShortXmlToJbase failed
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - comReadAndConvert: comConvertXmlToJbase failed, KEY=67113
R14.118877 - 13316 - (jmainfunction.b,0) - Tue Oct 04 18:52:24 - FBNK.ACCOUNT
- FBNK_ACCOUNT - drvRead: drvREAD - Read with key 67113 failed
If I JED the record and remove the number of MVs (or reduce to let's say 4)
on field 47 to 50 the error disappears. Leading me to believe the error is
with conversion of multivalues.
After JED:
LIST FBNK.ACCOUNT WITH @ID EQ '67113'
@ID................ 67113
@ID................ 67113
ACCOUNT.NUMBER..... 67113
CUSTOMER........... 128022
CATEGORY........... 1001
ACCOUNT.TITLE.1.... HITACHI USD
ACCOUNT.TITLE.2....
SHORT.TITLE........ HITACHI USD
MNEMONIC........... HITACHIUSD
POSITION.TYPE...... TR
CURRENCY........... USD
CURRENCY.MARKET.... 1
LIMIT.REF..........
ACCOUNT.OFFICER.... 55
OTHER.OFFICER......
POSTING.RESTRICT...
RECONCILE.ACCT.....
INTEREST.LIQU.ACCT.
INTEREST.COMP.ACCT.
INT.NO.BOOKING.....
REFERAL.CODE.......
WAIVE.LEDGER.FEE...
LOCAL.REF..........
Env: R14 Model Bank
Windows
Oracle 11g
TAFC 14 - Major 14.0 , Minor 0.0 , Patch (Change 114406)
All above are 64 bit
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
