[Brahim AlHawwas]

Hi Jim,

I do not even know what is the difference between SqlExecDirect and  SqlExec. I will go with the latter one as I was using the former. I actually notice that I get the echo back from SQLAllocHandle but not SqlExecDirect. I think you are hitting the cause of the problem. I would be doing that soon. I will send my feedback as well.

Is there any harm in replacing between these two functions.

[Brahim AlHawwas]

Hi Charlie,

Sorry for being late but I did not receive the email of your reply. I am wondering what might cause such hang to either the process or the thread or even to a lower level the TCL proc. I do not have any infinite loop that would terminate based on condition that might not happen and no other loop might do so in my proc. I can not see why this is happening. The watcher of the process shows engine IDLE.

By the way is there a way to check if the thread is down and start it automatically if we could not overcome this issue. Can I do that in Alert so it would execute the TCL proc assigned to an action. I did not even try to look at alerts.

I am thinking about automating the whole thing from A-Z and I have a target to have my interface running for a month at least without any interruption. That it not even a single mouse click.

[Brahim AlHawwas]

Hi Jim,

My OS is Redhat and the DB is Oracle and I am calling Functions from my schema. I am using cloverleaf 5.6 and DataDirect ODBC from Healthvision.

[Brahim AlHawwas]

Hi Charlie,

I do not think that it is related to any of your scenarios. I am connecting in a while loop that would sleep between every trial and tries certain number of times then replies with negative acknowledgment if it could not connect. I am also handling three SQL exceptions explicitly and everything, i.e. all the code in catch statement, generally.

Do not forget that the whole process hangs and not only the DB handler thread.

[Brahim AlHawwas]

Noel,

Have you tried “delay connection until needed” tick on the configurations of tcp/ip. I think this would help resolving the problem. Remember to untick the option of ” Auto reconnect” as well.

[Brahim AlHawwas]

Hi John,

Thank you for your reply.

It is not necessary at all to have the long trip pf reply. I mean from C to D. I am for sure going to have the principle of multiple processes as I have been already directed to do so. You told me that you do the ACK in D thread of your case and it sends it through TCPIP to C which handles the ACK. The main point for me is this:

I have tried to generate HL7 reply from within TCL but it keeps yelling that “could not write message in TPS wire” error. So my problem does not seem to be the reply format or so but sending it. Other error is when I do disposition for the original mesage like set disp ” {CONTINUE $mh} {OVER $reply}”, this would complain that original message has not been handled while it is the mh var. So it basically fails to read the disposition.

I was and still quite hesitant towards having VRL reply as I have not ever seen one and it is very hard to me to do. I want the Control ID of the message in the VRL and thats as far as I know is enough. Could you tell me please how did you configure C, D -in your case- to receive, send VRL replies. If possible can you share the code you have or at least the algorithm of it.

[Brahim AlHawwas]

Silly Mistake as usual.

The issue regarding “exec setsite Mysite” is not important at all as the script is already invoked from within a site.

Sorry for that.

[Brahim AlHawwas]

Hi John,

Thank you for your reply.

To clarify the issue, I am dealing with Oracle functions so I can get back a string as a reply from Oracle. I have a TCL function on my script that I am calling validateReply that would analyze the reply. If the reply is accepted try to to generate a reply to thread A passing through thread B. This to inform A that I have succeeded calling the function and I am ready for the next message.  I am not doing a reply for B because it is HRL which is not the original message in which I am afraid to lose some info when failure occurs on XLT.

Another thing is I am having if else where the condition is connected. In this situation I am shutting down the thread through “exec hcicmd -p processA -c “dbhandler pstop” “when the proc can not connect to DB. I want to send back a reply to A from C telling it I have failed keep the message in Recovery DB. This should follow the same concept of previous one.

I am also worried about when having multiple sites. This is because in TCL I could not execute” exec setsite mySite”. It does not complain but it does not take any effect. I have one site in production so It is not big deal for now. Would be brilliant if you know work around.

[Author]

Replies