Automic Workload Automation

 View Only
  • 1.  Where in the database are the connection and read timeout settings?

    Posted Nov 30, 2023 04:32 PM

    When defining an API CONNection object (Rest or SOAP), I can define the Connection Timeout and the Read Timeout values.  But I cannot find these in the database.  Can anyone point me to the right table/columns?



    ------------------------------
    Thanks,
    Doug
    ------------------------------


  • 2.  RE: Where in the database are the connection and read timeout settings?
    Best Answer

    Posted Dec 01, 2023 06:37 AM

    Hi Doug,

    try this:

    select OH_Client, OH_Name, OCV_VName, OCV_Value
     from OCV
     inner join OH on (OCV_OH_Idnr = OH_Idnr)
     where OH_Name = 'CONN.<yourname>'
     and OH_DeleteFlag = 0
     order by OCV_VName;

    best,
    Peter



    ------------------------------
    Automic Certified Professional/Expert & Broadcom Knight

    For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
    ------------------------------



  • 3.  RE: Where in the database are the connection and read timeout settings?

    Posted Dec 04, 2023 11:24 AM

    Thanks, Peter, that was exactly it.  Appreciate your help!



    ------------------------------
    Thanks,
    Doug
    ------------------------------



  • 4.  RE: Where in the database are the connection and read timeout settings?

    Posted Dec 04, 2023 04:15 PM

    For anyone interested, what I was contemplating with this request was a quality assurance test.  Knowing that over time, performance of jobs change, I don't want to be surprised when a job to creep towards the connection timeout.  Its my chance to either fix the integration or adjust the timeout.  So here's the query I came up with.

    /* jobs with connection attributes, allowing compare of ERT to connection timeout values */
    SELECT TO_CHAR(ocv.ocv_value) connectionName
        ,oh.oh_name
        ,oh.oh_ert
        ,TO_CHAR(ocv1.ocv_value) AS connectTimeout
        ,TO_CHAR(ocv2.ocv_value) AS readTimeout
    FROM uc4adm.oh oh
    -- ocv the first time to get the jobs connection name
    INNER JOIN uc4adm.ocv ON oh.oh_idnr = ocv.ocv_oh_idnr
        AND ocv.ocv_connection = 1
    -- use the ocv to loop back to OH to get that connection
    LEFT JOIN uc4adm.oh oh2 ON TO_CHAR(ocv.ocv_value) = oh2.oh_name
        AND oh2.oh_deleteflag = 0
        AND oh.oh_client = oh2.oh_client
    -- ocv the second time to get the connection's connect timeout
    LEFT JOIN uc4adm.ocv ocv1 ON oh2.oh_idnr = ocv1.ocv_oh_idnr
        AND ocv1.OCV_VNAME = 'connectTimeout'
    -- ocv the third time to get the connection's read timeout
    LEFT JOIN uc4adm.ocv ocv2 ON oh2.oh_idnr = ocv2.ocv_oh_idnr
        AND ocv2.OCV_VNAME = 'responseTimeout'
    WHERE oh.oh_otype = 'JOBS'
        AND oh.oh_deleteflag = 0
       AND oh.oh_client = 200
    ORDER BY TO_CHAR(ocv.ocv_value), oh.oh_name



    ------------------------------
    Thanks,
    Doug
    ------------------------------