sylaja suseela

Forum Replies Created

Viewing 9 replies – 1 through 9 (of 9 total)
  • Author
    Replies
  • in reply to: Cloverleaf 5.8.4.0 is now available #74614
    sylaja suseela
    Participant

      Hi ,

      Could you please let me know who to apply this patch on test site only? We have test and live running on difefrent servers.

      Regards,

      Sylaja

      in reply to: FTP: Uploading to a URL without a file name! #75193
      sylaja suseela
      Participant

        Muzammil,

        Please try removing the last ‘/’ – the one at end of the path ‘/hci/home/hci/icnet_test/’.

        Regards,

        Sylaja

        in reply to: Timeout handling – avoid duplication #75002
        sylaja suseela
        Participant

          Good point Jim. Thanks.

          What is the effect/harm of setting OutBount Data -> Retries=0 in this situation?

          Regards,

          Sylaja

          in reply to: Timeout handling – avoid duplication #75000
          sylaja suseela
          Participant

            Thanks Jim,Levy,

            I think I would go with Jim’s last option – tcl to track resent count and put the message into error db.

            Regards,

            Sylaja

            in reply to: Return multiple values to an xlate #74597
            sylaja suseela
            Participant

              Hi Mike,

              The bit of ODBC code to query oracle DB is working fine. However I see an additional qyery being issued against the Oracle DB ‘SELECT TZ_OFFSET (DBTIMEZONE), TZ_OFFSET (SESSIONTIMEZONE) FROM DUAL’. These are adding on to the process count and causing issues in Oracle (max processes = 300).

              Anybody seen such queries being issued behind the scenes by odbc SQLFreeHandle functions?

              Thanks,

              Sylaja

              in reply to: Return multiple values to an xlate #74595
              sylaja suseela
              Participant

                Thanks Mike, John.

                I have successfully completed this ODBC call to Oracle from Xlate and put it live.

                Mike, I am doing similar to what you did. Many thanks for the code example.

                Regards,

                Sylaja

                in reply to: Return multiple values to an xlate #74592
                sylaja suseela
                Participant

                  Hi Mike,

                  Could you please share tcl code for doing ODBC from Xlate?

                  I want to query Oracle DB passing 2 arguments ( to be used in qry where clause) and return a single value  back to Xlate.

                  Thanks in advance,

                  Sylaja

                  in reply to: HRL Repeat Block usage. #64701
                  sylaja suseela
                  Participant

                    Thank you Jim,

                    I am trying to translate HL7 lab result message to a flat/txt file with the intension to load it into Oracle Tables.  So I wrote a VRL and XLT to translate HL7 to VRL and have just found out (after reading other posts here) that VRL’s can’t handle repeats. So I am going to write HRL but not sure how to handle the repeating ORC, OBR & OBX.

                    Before I continue I would like to hear from someone who already did a similar translation and is successful..clover ver 5.4.1

                    Regards,

                    Sylaja

                    in reply to: HRL Repeat Block usage. #64697
                    sylaja suseela
                    Participant

                      Hi Brad,

                      Have you been successful in using Repeat Block feature in HRL for cloverleaf version 5.4.1?

                      Thanks,

                      Sylaja

                    Viewing 9 replies – 1 through 9 (of 9 total)