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.
<pre>
| <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 ISSU
| ES ICE MAKER DOESN'T MAKE VERY MUCH ICE AN PROMISED TIME = 12/09 1245-1745
11 MR571208 TBX25PRYARW
| W 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 ALT
| ERNATE PHONE NUMBER PRIOR TO ARRIVAL. 125 12
| I CB_ADDRESS 0 641817 BRENDA PAREL R 6520 TRAILRIDE
WAY CITRUS HGTS CA 95621 9166221537 0000 916728
| 5804 A
| I CB_SEARCH_RESULTS 0 641858 PI 0999 ACK
01/01/2004 12/09/2005 00:00 B0700 LIGHTS ON CONTROL PANEL C
| ONTROL PANEL LIGHTS ARE OFF-KEEPS CHIRPING 30 0700-1200
41 GG758272 PDW9280JSS 01/01/1900 00:0
| 0 Y N N A 01/01/1950 01/01/1950
C 01/01/1900 00:00 SENT:U 087747 BURRISS
MICHAEL 12512155 1
| 1/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
916789706
| 8 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 **T
| PTP 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 916722
| 3727 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 - 0
| 155 **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 0
| 8/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
916787
| 5988 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
91677
| 34756 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 0
| 1/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 PROMISE
| D 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 12
| 5 12
| I CB_ADDRESS 0 642960 BERT KOPPEL R 4212 SLOAN DR
NORTH HIGHLAND CA 95660 9999999999 0000 916331065
| 2 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 916787
| 0161 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.
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/L
inux
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=3913797#3913797
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913797
-------------------------------------------------------
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
