0 Replies Latest reply on Dec 21, 2005 10:51 AM by Vignesh C K

    Blob storage of JMS Messages

    Vignesh C K Newbie

      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
      Vignesh.kc@ge.com