John Mercogliano

Forum Replies Created

Viewing 15 replies – 1 through 15 (of 275 total)
  • Author
    Replies
  • in reply to: Cloverleaf and tcl hl7 package in the Cloud #121938
    John Mercogliano
    Participant

      Infor does not let you load 3rd party tools in their environment or shell scripting the way it was discussed with us.  So, it’s not that it’s not allowed in the cloud, but not allowed in their instance of cloverleaf that they provide.   So, we stuck with the on prem version for that reason when we moved to azure.

      John Mercogliano
      Sentara Healthcare
      Hampton Roads, VA

      in reply to: Cloverleaf and tcl hl7 package in the Cloud #121924
      John Mercogliano
      Participant

        When you say cloverleaf cloud are you migrating to infor’s cloud version and not just moving your data center to the cloud platform?

        John Mercogliano
        Sentara Healthcare
        Hampton Roads, VA

        in reply to: Cloverleaf and tcl hl7 package in the Cloud #121921
        John Mercogliano
        Participant

          Chris,

          This statement would be a local rule someone is enforcing. We migrated to the azure cloud and have not had any issues using third party tools.  We are not using anything that requires compiling but I know that would not be an issue.  We are on redhat.  Not sure what hl7 package you are using but if it is something you are already using I would push back hard on it.

           

          John Mercogliano
          Sentara Healthcare
          Hampton Roads, VA

          in reply to: Unable to select all the rows when creating a Database Schema. #121613
          John Mercogliano
          Participant

            Rin,

            Nothing looks out of place here.  I would recommend to resync the database schema to make sure nothing has changed.  Then try and create a schema using sql with some of the columns that won’t select using brackets. I’ve never had an issue like this so just reaching at this point.

            John Mercogliano
            Sentara Healthcare
            Hampton Roads, VA

            in reply to: sqlite3-regex.so #121608
            John Mercogliano
            Participant

              No, only for the unix command line tool.  You will still need to do enable load extension to use regexp in tcl.

              As far as the rc file, that one line I listed above is the only statement in the file.

              John Mercogliano
              Sentara Healthcare
              Hampton Roads, VA

              in reply to: sqlite3-regex.so #121603
              John Mercogliano
              Participant

                Not that I found.  You have the ability to create a .sqliterc in the users home directory, I added
                .load “sqlite3-regex.so”
                To the file so its there when I need it from the command line.

                John Mercogliano
                Sentara Healthcare
                Hampton Roads, VA

                in reply to: sqlite3-regex.so #121601
                John Mercogliano
                Participant

                  Hi Rick,

                  I found I needed to do this command. “db enable_load_extension 1” before calling the load extension. Hope this works for you.

                  John Mercogliano
                  Sentara Healthcare
                  Hampton Roads, VA

                  in reply to: Unable to select all the rows when creating a Database Schema. #121597
                  John Mercogliano
                  Participant

                    Excellent glad that worked.

                    John Mercogliano
                    Sentara Healthcare
                    Hampton Roads, VA

                    in reply to: Unable to select all the rows when creating a Database Schema. #121590
                    John Mercogliano
                    Participant

                      I would say it’s the dashes.  In sql you need to enclose a column name in brackets when there are special characters so the jdbc and/or the gui are probably having issues.

                      I’ve never had to do this, but you should be able to create a schema from sql and manually add the fields to the select statement with brackets.

                      I would tell you dba not to use dashes 😉

                       

                      John Mercogliano
                      Sentara Healthcare
                      Hampton Roads, VA

                      in reply to: GRITS 2.0 (GA DHEC) Inbound Reply #121578
                      John Mercogliano
                      Participant

                        Hi Lisa,

                        Keylget will not create the variable if the key does not exist, so this tells me that there was no response code in the userdata. If I’m understanding you correctly, they are sending two messages for each message you send.  One ack and one data message.  In that case, the data message would not have a response code and you will need to have additional logic to handle that.

                        John Mercogliano
                        Sentara Healthcare
                        Hampton Roads, VA

                        in reply to: FHIR: Xlate complaint about too many FHIR JSON Nodes #121429
                        John Mercogliano
                        Participant

                          Hi Jim,

                          I had asked this same question to infor, here is the response I got.
                          <p style=”margin: 2.25pt 0in 0in 0in;”><b>Event Note: </b>So that warning message is more an FYI message. The entire json does load and function normally. All it means is that the json is too large to auto expand the number of nodes set in the GUI. You can change the default in the GUI -> Client -> Preferences -> Xlate Config tab. The JSON Auto-expansion Level is 5 by default. If you change that to 3 or less, the message will not be displayed.</p>
                           

                          John Mercogliano
                          Sentara Healthcare
                          Hampton Roads, VA

                          John Mercogliano
                          Participant

                            That error you are getting is an indication that the vendor has closed the connection before you sent back the reply.  This can be caused by two things possibly that I’m aware of, either you are waiting on the reply from a downstream system and it is taking to long to come back or the reply proc is not copying the driver ctrl from the data message to the reply so it’s not going back on the same port it came in on.

                            John Mercogliano
                            Sentara Healthcare
                            Hampton Roads, VA

                            in reply to: https web server using java ws-server (RESTful or RAW) #120956
                            John Mercogliano
                            Participant

                              Tim,
                              I based my connection off the ws_more_samples box(https://usspvlclovertch2.infor.com/forums/topic/cl-receive-post-api/). I used the path_trxid_server connection as my template. I only had to make cosmetic changes(port, context, tls)

                              For our company we use redshield to monitor all inbound traffic. Also we have setup an Azure application gateway as the gatekeeper in the dmz so we did not have to have our cloverleaf serve visiable to the world.

                              The application gateway has our public IP/DNS and routes traffic to our internal cloverleaf server by the context path we assigned. We currently have 3 vendors using this webserver.

                              For security we use whitelisting of the vendors IP and we act as the ca and provide the vendors with a client certificate for mTls auth. Both are handled by redshield but can also be handled by the application gateway.

                              John Mercogliano
                              Sentara Healthcare
                              Hampton Roads, VA

                              in reply to: https web server using java ws-server (RESTful or RAW) #120955
                              John Mercogliano
                              Participant

                                Tim, I’ve tried to post multiple times about our setup but the forum is giving me an error and not sure why.  If this posts, send me a request to jxmercog@sentara.com and I’ll send you info.

                                John Mercogliano
                                Sentara Healthcare
                                Hampton Roads, VA

                                in reply to: Arranging field address order in Field Routing #120838
                                John Mercogliano
                                Participant

                                  Hi Jim,

                                  The field address section is editable so once you select your fields you can cut and paste to rearrange the order.

                                  John Mercogliano
                                  Sentara Healthcare
                                  Hampton Roads, VA

                                Viewing 15 replies – 1 through 15 (of 275 total)