Hi,
We are putting a XML file in the message queue,which is persisted using
Oracle Database.
Some XML messages are not persisted , they get Broken Pipe errors on the
server logs.
On the Oracle server I get internal error codes ..
ORA-00600: internal error code, arguments: [12333], [32], [49], [50], [],
[], []
To isolate the case, I wrote a small program to insert into the
JMS_MESSAGES tables.
The data went in smooth.
Here is a sample of the XML file.
<MessagePayload><![CDATA[M162D CB_SEARCH_RESULTS ~0
| D CB_ADDRESS ~0
| U CB_SEARCH_CRITERIA ~0 12/08/2005 21:40
10 10 A
| I CB_SEARCH_RESULTS 0 641817 PR 0999 NEW
01/01/2004 12/09/2005 00:00 B1245 ICEMAKER / DISPENSER ISSUES
ICE MAKER DOESN'T MAKE VERY MUCH ICE AN PROMISED TIME = 12/09 1245-1745
11 MR571208 TBX25PRYARWW 12/25/1996 00:00 N
N N A 01/01/1950 01/01/1950 C
01/01/1900 00:00 CALL BEFORE COMING CALL ALTERNATE PHONE NUMBER
PRIOR TO ARRIVAL. 125 12
| I CB_ADDRESS 0 641817 BRENDA PAREL R 6520 TRAILRIDE
WAY CITRUS HGTS CA 95621 9166221537 0000
9167285804 A
| I CB_SEARCH_RESULTS 0 641858 PI 0999 ACK
01/01/2004 12/09/2005 00:00 B0700 LIGHTS ON CONTROL PANEL CONTROL
PANEL LIGHTS ARE OFF-KEEPS CHIRPING 30 0700-1200 41
GG758272 PDW9280JSS 01/01/1900 00:00 Y N N
A 01/01/1950 01/01/1950 C
01/01/1900 00:00 SENT:U 087747 BURRISS MICHAEL 12512155 11/21 19:02
MIKE...PLZ REVIEW BELOW CALL - M&J FEELS THIS MIGHT NEED A CONTROL OR TOUCH
PAD...WOULD LIKE IT ORDERED BEFORE SERVICE DATE...THX, K FS12Z 125 12
125 12
| I CB_ADDRESS 0 641858 MICHELLE MUSSO R 1016
AUDREY WAY ROSEVILLE CA 95661 9167897068 0000
9167897068 A
| I CB_REQUIRED_PARTS 0 WD12X10190 641858 1 0
| I CB_REQUIRED_PARTS 0 WD21X10187 641858 1 0
| I CB_REQUIRED_PARTS 0 WD34X10915 641858 2 0
| I CB_SEARCH_RESULTS 0 642238 PP 0999 NEW
01/01/2004 12/09/2005 00:00 B1300 KEY FAILED PAD FAILED
41 GH767926B ZBD6880K03SS 11/18/2005 00:00
Y N N A 01/01/1950 01/01/1950
C 01/01/1900 00:00 **TPTP 11/26/2005 16:45 **IVR CALL
AHEAD **TECH - 0155 **GO CASEID 5170955 BY L609189 125 12
| I CB_ADDRESS 0 642238 RITTER FRANK R 7644 ROBERTS DR
CITRUS HEIGHTS CA 95610 9999999999 0000 9167223727
A
| I CB_REQUIRED_PARTS 0 WD21X10216 642238 1 0
| I CB_REQUIRED_PARTS 0 WD34X11074 642238 1 0
| I CB_SEARCH_RESULTS 0 642591 PP 0999 NEW
01/01/2004 12/09/2005 00:00 B1300 28 F3 ERROR E CTM
PROMISED TIME = 11/2 28
FD362216Q JGRS15GEL3BG 05/15/1990 00:00 Y N N
A 01/01/1950 01/01/1950 C
01/01/1900 00:00 **TPTP 11/29/2005 18:05 **IVR CALL AHEAD **TECH - 0155
**CALL ALT # 9162085352 125 12
| I CB_ADDRESS 0 642591 AILEEN GRIZARD R 4945 3RD ST
ROCKLIN CA 95677 9162085352 0000 9166245339 A
| I CB_REQUIRED_PARTS 0 WB19X266 642591 1 0
| I CB_REQUIRED_PARTS 0 WB21X5301 642591 1 0
| I CB_SEARCH_RESULTS 0 642792 PR 0999 NEW
01/01/2004 12/09/2005 00:00 B0800 CONTROL PANEL NOT WKING
PROMISED TIME = 12/09 0800-1200
41 RG707315B ZBD6880K00SS 08/30/2004 00:00 N N
N A 01/01/1950 01/01/1950 C
01/01/1900 00:00 125 12
| I CB_ADDRESS 0 642792 ALEXANDER MALICK R 6025
POPLAR CT GRANITE BAY CA 95746 9167686583 0000
9167875988 A
| I CB_SEARCH_RESULTS 0 642850 PP 0999 NEW
01/01/2004 12/09/2005 00:00 B0800 VOICE RECORDING - PLEASE
TRANSCRIBE PROMISED TIME = 12/0
21 ZT615810 JKP18BA 06/22/1999 00:00 Y
N N A 01/01/1950 01/01/1950 C
01/01/1900 00:00 **TPTP 12/02/2005 10:51 **IVR CALL AHEAD **TECH
- 0110 **GO ***< 11/28/2005 12:48:59 - SPOKE WITH MRS SAID LOUD NOISE NEED
SERVICE...22001 2823 >*** 125 12
| I CB_ADDRESS 0 642850 DIANE PETERSON R 1319
RIDGECREST WAY ROSEVILLE CA 95661 9163004756 0000
9167734756 A
| I CB_REQUIRED_PARTS 0 WB1K5198 642850 1 0
| I CB_REQUIRED_PARTS 0 WB26K5069 642850 1 0
| I CB_REQUIRED_PARTS 0 WB2X8351 642850 1 0
| I CB_SEARCH_RESULTS 0 642868 PR 0999 NEW
01/01/2004 12/09/2005 00:00 B1300 LEAKING WATER
PROMISED TIME = 12/09 1300-1700 41
GSD4060JSS 01/01/1900 00:00 N N N A
01/01/1950 01/01/1950 C 01/01/1900
00:00 125 12
| I CB_ADDRESS 0 642868 ALDBRFON R 6942
GREENBACK LN CITRUS HGTS CA 95621 9999999999 0000
9169916635 A
| I CB_SEARCH_RESULTS 0 642936 PR 0999 NEW
01/01/2004 12/09/2005 00:00 B1300 NO HEAT
PROMISED TIME = 12/09 1300-1700 27 UNK
JVM1653SH 02/26/2005 00:00 N N N A
01/01/1950 01/01/1950 C 01/01/1900
00:00 125 12
| I CB_ADDRESS 0 642936 F & R CHIGAZOLA R 7636
MARIPOSA GLEN WAY CITRUS HEIGHTS CA 95610 9169551155 0000
9167220248 A
| I CB_SEARCH_RESULTS 0 642960 PP 0999 NEW
01/01/2004 12/10/2005 00:00 B0800 LIGHT NOT WORKING
PROMISED TIME = 12/03 0800-1200 27 HH901449
JVM1490SH01 09/12/2005 00:00 Y N N A
01/01/1950 01/01/1950 C 01/01/1900
00:00 FROM: RELIFORD, RUBEN E (GE CONSUMER & INDUSTRIAL) SENT: NONE TO:
CONS/IND, PARTS PHX01 (GE CONSUMER & INDUSTRIAL) SUBJECT: 125 12 641805 0187
TECH NOTE PARTS HAVE NOT ARRIV 125 12
| I CB_ADDRESS 0 642960 BERT KOPPEL R 4212 SLOAN DR
NORTH HIGHLAND CA 95660 9999999999 0000 9163310652
A
| I CB_REQUIRED_PARTS 0 WB06X10317 642960 1 0
| I CB_REQUIRED_PARTS 0 WB08X10050 642960 1 0
| I CB_SEARCH_RESULTS 0 643130 PR 0999 NEW
01/01/2004 12/10/2005 00:00 B0800 LEAKING WATER & ICEMAKER NOT
OPERATING PROMISED TIME = 12/10
0800-1200 11 MZ237540 TPS24BPDABS 12/14/2000
00:00 N N N A 01/01/1950 01/01/1950
C 01/01/1900 00:00 125 12
| I CB_ADDRESS 0 643130 CLYDE MCCALEB R 9771 SWAN LAKE
DR GRANITE BAY CA 95746 9167658787 0000
9167870161 A]]></MessagePayload>
What could be the problem ?
One intresting feature i noticed was the storage of messages by JBoss.
Looks like it writes something encrypted into the MESSAGEBLOB column,
there could be terminator in the text I had which caused the connection to
close.
Here are the version information.
JBoss : [Server] JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2
date=200505022023)]
| JBoss Host : Linux myLinuxBox 2.4.21-9.ELsmp #1 SMP Thu Jan 8 17:08:56 EST
2004 i686 i686 i386 GNU/Linux
| Java_Version :jdk1.5.0_03
| Oracle: 9.2.0.5, running on HP-UX.
| Oracle Driver :ojdbc14_g.jar
Not sure on that, please let me know your comments.
(I also made another confusing post here related to this
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=74261)
Thanks
Vignesh
[EMAIL PROTECTED]
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3913630#3913630
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913630
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
