Max Drown (Infor)

Forum Replies Created

Viewing 15 replies – 1 through 15 (of 1,276 total)
  • Author
    Replies
  • in reply to: Basic Tutorial for Using SQLite With Cloverleaf #121222

    If I’m understanding the question correctly ….

    First grab all of the OBR segments from the message:

    set obx_segs [lsearch -all -inline -regexp $msg {^OBX}]

    Then, loop across the segments and execute the inserts:

    foreach obx $obx_segs {
        # Do the database insert
    }

    — Max Drown (Infor)

    in reply to: Basic Tutorial for Using SQLite With Cloverleaf #121216

    Paste the code here, please. I don’t see the attachment.

    — Max Drown (Infor)

    in reply to: Basic Tutorial for Using SQLite With Cloverleaf #121215

    Paste the code here, please. I don’t see the attachment.

    — Max Drown (Infor)

    in reply to: Primary Site/Master Site – called TCL proc #120985

    A site can only have one master site. The root level is still available.

    The heircharchy is always local site –> master site (either set at the root level or site level) –> root

    — Max Drown (Infor)

    in reply to: Primary Site/Master Site – called TCL proc #120981

    When you use the Site Preferences option to choose a different site as the master site, it overrides the root master site. The hierarchy will still be local site –> master site –> root. When making a change to Site Preferences, the entire site should be restarted including both daemons and all processes. You do not need to restart the hostserver.

     

    C:\cloverleaf\cis2022.09\integrator\site_test>setsite site_demo

    C:\cloverleaf\cis2022.09\integrator\site_test>showroot
    HCI root is C:\cloverleaf\cis2022.09\integrator
    HCI master site is site_master
    HCI site is site_demo

    C:\cloverleaf\cis2022.09\integrator\site_test>setsite site_test

    C:\cloverleaf\cis2022.09\integrator\site_test>showroot
    HCI root is C:\cloverleaf\cis2022.09\integrator
    HCI master site is site_epic
    HCI site is site_test

     

     

    — Max Drown (Infor)

    in reply to: FTP logging #120978

    On the cURL Options tab (protocol properties), add this name:value

    CURLOPT_VERBOSE 1

    — Max Drown (Infor)

    in reply to: Calling a web service on a Route #120937

    I’ll take a stab at explaining here. If you need more details, send me your email address and I’ll contact you.

    Most likely your delay is caused by the lag between when the query goes out and the response comes back in. The response arrives before the Await Replies timeout, so the query is not resent, but a queue does build up in state 11.

    One way to fix this is to use a “round-robin” trix ID with n identical outbound WS client threads. For example, the thread names would be query_1, query_2, …, query_5 and the trxid would route the messages to query_1, query_2, …, query_n. This effectively sends n messages out at a time. This is an asynchronous message flow which is obviously much faster.

    In CIS 2022.09.02 (much improved in CIS 2022.09.02) we added multi-threaded WS clients. You can configure a client for asynchronous message flow. In theory, you no longer need the “round robin” trxid or the multiple OB client threads because the WS client will handle the asynchronous traffic itself. The thread will send out a configurable number of queries and wait on acks for each query independently.

    You’ll find these settings under the Bus section of the WS client protocol properties.

    — Max Drown (Infor)

    in reply to: Calling a web service on a Route #120934

    In CIS 2022.09.02, we added/improved Multi-threaded WS clients which will do as you describe I believe.

    — Max Drown (Infor)

    in reply to: Data Masking in SMATDB #120933

    There is no option in GM that will mask fields. Please consider entering an enhancement request through the Infor Support Portal.

    You do not need Advanced Security to block access to SMAT DB or ERROR DB. The GM roles have an option to enable or disable those tools.

    — Max Drown (Infor)

    in reply to: High Availability On Azure Hosted #120907

    I found this in my notes for Azure shared disk testing from Oct. 14, 2021.

    CISF: doesn’t support FIFO queues, cannot use this filesystem.

    NFS: TPS is slow, cannot handle the volume.

    Again note that the technology may have changed since I did this testing.

    — Max Drown (Infor)

    in reply to: High Availability On Azure Hosted #120905

    I tested the performance of Azure shared disks about a year or so ago. All of them were too slow for Cloverleaf (or had other showstopper issues) except for the Azure Premium shared disk. The premium shared disk was fast enough for Cloverleaf. Things may have changed since then, so take this information with a grain of salt.

    If you would like to do some testing on your own, I’ll share the Cloverleaf site I used for performance testing. Shoot me an email if you need it.

    — Max Drown (Infor)

    in reply to: Delete Segment Using Xlate (Second FT1) #120739

    1(1).FT1(0)

    The trailing (0) is the iteration of the segment in this case. The 0 means the 1st iteration, it’s hardcoded.

    So, try this instead: 1(1).FT1

    That would get rid of all FT 1 segments.

    If you are looping and want to get ride of specific segments only, the use an iteration variable like (%s1) and 1(1).FT1(%s1)

    — Max Drown (Infor)

    in reply to: Call a shell script (.sh) from a tps proc #120695

    Always use the tcl catch command when calling exec.

    — Max Drown (Infor)

    You may need to add all of the IP addresses or hostnames that Cloverleaf can appear to be using to the outside to the export server address in hciserveradmin. This could include a VIP, real IPs, etc. They are deleted with a space in this field. Then restart the hostserver (hcisss).

    For example, add the VIP, HA1, HA2, etc. IP addresses.

    — Max Drown (Infor)

    in reply to: Iterate With VRL #119897

    Lane, I sent a BOX to Support with an example that might help. Trying to attach it here, too.

    Attachments:
    You must be logged in to view attached files.

    — Max Drown (Infor)

Viewing 15 replies – 1 through 15 (of 1,276 total)