- This topic has 6 replies, 5 voices, and was last updated 7 years, 5 months ago by
.
-
Topic
-
We upgraded our Cloverleaf from 5.7 to 6.1.2. We began seeing an issue where files of messages were being co-mingled between state department of healths for reportable disease results.
We have a tcl script that loads the files into the PHINMS database through ODBC commands. We suspect that is where the problem is occurring.
Has anyone experienced a issue in differences of ODBC between versions of Cloverleaf?
Any thoughts or suggestions welcomed!!
Thanks
-
Replies
-
-
We use a lot of ODBC but we started with 5.8.4, so I’m not sure we ever had a migration issue.
Maybe you can provide more technical detail on the process used. You are going from a file to a database? And you are calling the ODBC from a TCL script – is this script run inside a thread or from a command line?
And you have multiple tables in the database, or one table with a column that identifies the different DOHs?
Peter Heggie
-
-
I am waiting on our developers to get more info – but this is wha I know so far – to answer your questions:
Maybe you can provide more technical detail on the process used. You are going from a file to a database? Yes
And you are calling the ODBC from a TCL script – is this script run inside a thread or from a command line? Thread
And you have multiple tables in the database, or one table with a column that identifies the different DOHs? (Waiting to hear on this one – I think it is one database table)
-
I’m on Rick’s team and assisting.
We’re calling odbctcl inside of a TCL script which is inside a thread as a UPOC. We are using this script to insert multiple fields into a single MSSQL table. This script runs once per file, with one state’s messages per file. Once the ODBC insert happens, the application which uses the database encrypts the payload and sends it via HTTPS to external receivers.
As of the date of our upgrade, it appears that one of the database fields (which contains the main message payload) sometimes contains messages from multiple state files. A database record could be sent to Washington (for example), but in the payload field, our receiving contact reported seeing messages for Washington and Illinois. We have verified that in SMAT, the messages look correct and are not mixed by the time they hit the ODBC script.
-
Are you using the ODBC API supplied with Cloverleaf or another? The term ODBCTcl concerns me.
What OS? The ODBC API, as far as I know, has not changed and should work in one place as well as another.
I don’t think I have ever had to use the SQLFreeHandle command. But if used certain prereqs are required.
Perhaps a call to Support or supply the code you are using.
-
-
- The forum ‘Cloverleaf’ is closed to new topics and replies.
