[Yamil Velez]

Thank you Jim,

That worked, thank you again

[Yamil Velez]

Hi Jim

   Can you get some more details how you setup the database, so the heavy lifting can be done by a store procedure.    Right now I have an inbound thread call orthosecure thats sends raw to my database thread that is called orthodatabase. From the database thread I go out to my outbound thread called picis ort out also in raw format.   Where do you have your tcl  proc?  and can you give send me a sample tcl proc?

Thank you for all your help

Yamil

[Yamil Velez]

Hi Jim

Thanks for the quick reply

   We have Cloverleaf version 6.0 with Data Integrator.   I was able to establish a connection with the SQL database, which contains the two fields SCL # and the Booking #.  I would like to first get the inbound msg and then path copy the fields over in the xlate.  In the outbound tab of the outbound receiver, I would like to put a TCL code that would put the booking # from the inbound msg in a variable.  Then I would like to query the SQL database to see if the booking # exist. If it does then I would like to take the SCL from the SQL database and put that in the outbound msg and send the msg to the outbound system. If the booking number does not exist I would like to store the msg to file so users can fix it later.

Do you think this is possible?   Other way I was thinking if possible,  Can I do a lookup to a database just like a table in a xlate?

Thanks again for your help

[Yamil Velez]

Thank you all for the great suggestion and help

[Yamil Velez]

Hi David

  The problem is that I need to start the semi colon replace from field 5 onward.  I need to keep the semi colons before that field.   How can I guid my regsub to start in field 5

Thanks

Yamil

[Yamil Velez]

Hi Jim

 My answers are below your question.  Hopefully they help

You indicate this only happens when the VPN threads slow down. I am assuming by that you mean they take longer to acknowledge a message.

(Yes they take longer to process messages)

During that period do you get some serious queue depths?

(Yes, some queues get as high as 600)

Do you have any idea why they slow down – do they all slow down at the same time (might indicate some sort of network or internet issue)? Does one slow down first then that starts the others slowing down?

(These threads slow down when the hospital Internet gets max out, running 100 utilization,  They start to collect and thus causing the other connections to slow down.   When we do a top command at the Cloverleaf server System load is greater 2.17)

Do all of these connections exist in the same process, in the same site?

(We have three sites production, prod_orders_results and cis_pacs.  In production we have 2 vpn connection.  In prod_orders-results we have 3 vpn connection.   In cis_pacs , we have know known.   The sites most effect are production and prod_orders_result)

Are there any sleeps in Tcl procs realted to these integrations?

(These threads are constantly getting ADT messages throughout the day,  I do not believe they go to sleep)

I really do not have any ideas specifically related to VPN connections slowing down the engine. We do not have many (maybe one) VPN connectikons here and do not experience that.

[Yamil Velez]

Good Morning Jim

   Any idea what is causing this, it has became a norm and any solution will be welcome.

Thanks again for your help

Yamil

[Yamil Velez]

These are TCP/IP connection and when we brought down one of the threads that we suspected as the offender.  There was a slight improvement.

[Yamil Velez]

Hi Jim

   Just for more infomation we are using Cloverleaf 5.6 and it is hosted on Linux Red Hat 5.2.

[Yamil Velez]

All threads are being affected, and our network team reported that they had reach 100 percent utilitization on the internet.

[Yamil Velez]

In our instance none of the connection were in opening state or did they ever disconnect and we still had message latacy up to 40 minutes.

[Yamil Velez]

Thanks Scott for the addition information

Yamil

[Yamil Velez]

Thank you very much Micheal,  this the answer I was hoping I get.

Thank you again

Yamil

[Yamil Velez]

Hi Dave

   I am wondering if I can perform search functions in the backend using hcidbdump -r -L.  Is there is a way to grab the file as display by command hcidbdump -r -L and putting the output in a file to do a search?

Thanks

Yamil

[Yamil Velez]

Hi James

   Is there a way to look at the message ID in ultralong format in the background without using the GUI

Thanks

Yamil

[Author]

Replies