OVER disp in Write TPS UPoC

[Daniel Lee]

I’m using QDXi 3.8.1P on AIX 5.1 and have a UPOC thread that writes to a MsSQL db.

Every time I get an HL7 message I open the database connection, do the write, and then close the connection again.  (our db admin perfers this over leaving the connection open)  Since the database is not sending back ACK’s how do I deal with DB connection issues?  I have it warning me via email, but then it just skips the transaction and goes onto the next one resulting in dozens of skipped messages until the connectivity problem is resolved.

I’ve tried using the Recv33 procs in my upoc thread and then in my Write TPS proc I’m Continuing the message and also pushing the message back on the displist with a disposition of “OVER” after a sucessful write to mimic an ACK, but Cloverleaf does not allow an OVER disposition in a Write TPS UPoC.

Any suggestions?

Topic