Identifying message related to error from the errors db

[Rehman Masood]

Hi Guys, We have a thread that takes messages from a file as an input. Somehow, this file got a few bad messages (essentially, in the OBX segment, there was a carriage return that put the message out of whack). For example,

Quote:

MSH|..

PID|..

OBR|..

OBX|..|..|..|..|text here and then something odd happens

this is continuation of OBX segment but on a different line, notice the positioning of this line

Engine interpreted the above as the first being full message, and then throwing a input data in bad format (I think the error code was 307). Is there a way by looking at the hcidbdump -e -m XX output for the error to identify which message in the input file was bad. I was able to find the culprit ones but would like to know if there was a way I could have easily identified which error in the errors db related to which message.

Thanks![/quote]

Topic

[David Barr]

hcidbdump -e -m XX -L should show you the contents of the message. You should probably be able to use the MSH to match it up with the message from your original file.

[Jim Kosloskey]

Rehman,

In the DB Admin GUI you can select ‘Error DB’ then select a ‘Message State’ of 307 and the appropriate display format – that should get you only the messages that failed with the 307.

The command would have this in it: hcidbdump -e -s 307

The above command would change depending on the display options and any further selection options such as thread, etc.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Rehman Masood]

Thanks Guys, I probably wasn’t clear in my initial post, but here is what I am dealing with,

Quote:

E:healthvisioncis5.8integrators1_test>hcidbdump -e -m 47340446 -L

msg: 0x00FA1A24

   msgType           : DATA

   msgClass          : ENGINE

   msgState          : input data validation failure (307)

   msgPriority       : 5120

   msgRecoveryDbState: Log:update (3)

   msgFlags          : 0x8002

   msgMid            : [0.0.47340446]

   msgSrcMid         : midNULL

   msgSrcMidGroup    : midNULL

   msgHostId         : 3148155885

   msgOrigSrcThread  : fr_uhs_res

   msgOrigDestThread : to_coderyte_res

   msgSrcThread      : fr_uhs_res

   msgDestThread     : to_coderyte_res

   msgXlateThread    :

   msgSkipXlate      : 0

   msgSepChars       :

   msgNumRetries     : 0

   msgGroupId        : 0

   msgDriverControl  : {FILENAME {E:/s1_test/fr_uhs_res/queue/201106022359rawra

dres.DAT}}

   msgRecordFormat   :

   msgRoutes         :

   msgUserData       :

   msgStaticIsDirty  : 0

   msgVariableIsDirty: 0

   msgTimeStartIb    : 1307553351.058(Wed Jun 08 12:15:51 2011)

   msgTimeStartOb    : 1307553351.058(Wed Jun 08 12:15:51 2011)

   msgTimeCurQueStart: 0.000(Wed Dec 31 18:00:00 1969)

   msgTimeTotalQue   : 2.360

   msgTimeRecovery   : 1307553353.418(Wed Jun 08 12:15:53 2011)

   msgEoConfig       : 0x00000000

   msgData (BO)      : 0x00FA1B0C

   message           : ”

Done. 1 messages selected.

As you can see, there is nothing that helps me identify which message this is. All I have is the name of input file. Is there some flag in here that can help me with which message # in the file engine is referring to?

[Rehman Masood]

Here is the errors db. Looking at the sequence of message id’s, it is safe to assume that the errors where length=0 was related to the previous or after message?

Code:

E:healthvisioncis5.8integrators1_test>hcidbdump -e
                       C
                       l T
                       a y F
                       s p w
Created  Message Id     s e d Prio State Length Source          Dest
——– ————– – – – —- —– —— ————— —————
12:15:51 [0.0.47340447] E D N 5120   307      8 fr_uhs_res      to_coderyte_res
12:15:51 [0.0.47340446] E D N 5120   307      0 fr_uhs_res      to_coderyte_res
12:15:51 [0.0.47340445] E D N 5120   307    134 fr_uhs_res      to_coderyte_res
12:15:51 [0.0.47340444] E D N 5120   307      0 fr_uhs_res      to_coderyte_res
12:15:51 [0.0.47340440] E D N 5120   307      8 fr_uhs_res      to_coderyte_res
12:15:51 [0.0.47340439] E D N 5120   307      0 fr_uhs_res      to_coderyte_res
05:40:00 [0.0.47315009] E D N 5120   304   1007 fr_ptkeeper_adt to_epic_adt

[Author]

Replies