MxLoader

 View Only
  • 1.  Network Timeout

    Posted 10-13-2021 13:45
    I keep hitting a network time out and get this in the log, wondering what's not set correctly???

    2021-10-13 12:22:34 [INFO] Error message dialog
    2021-10-13 12:22:34 [DEBUG] Error code : -2147012894 (2147954402)
    2021-10-13 12:22:34 [DEBUG] Error source : msxml6.dll
    2021-10-13 12:22:34 [DEBUG] Error description : The operation timed out
    2021-10-13 12:22:34 [DEBUG] Remedy : Network timeout. Check timeout settings in Config sheet.

    These are the config settings
    Advanced  
    Maximum Objects 30000
    Batch Size 0
    Split Child Rows FALSE
    Start Row 3
    Stop On Error TRUE
    Continue Sync TRUE
    Display Query Warning TRUE
    Display Summary TRUE
    Query Only FALSE
    Store Passwords TRUE
    Formatting  
    Timezone 0
    DateTime Format yyyy-mm-dd hh:mm
    Date Format yyyy-mm-dd
    Time Format hh:mm
    Logging  
    Logging Trace
    Log File Name [XLSDIR]\[XLSNAME].log
    Advanced Connection Settings
    Proxy
    Proxy User
    Proxy Password
    Resolve Timeout 10
    Connect Timeout 20
    Send Timeout 30
    Receive Timeout 600
    OS Service Context Root /meaweb/os/
    OSLC Service Context Root /maximo/oslc/
    API Service Context Root /maximo/api/
    XML Namespace http://www.ibm.com/maximo


    ------------------------------
    Paul Crocker
    BPU
    ------------------------------


  • 2.  RE: Network Timeout

    Posted 10-14-2021 12:59
    Hi Paul,

    I notice your Maximum Objects is set to 30000. For the sake of testing, change that to 100 and re-run your query. When I receive the aforementioned timeout error it's because I am querying a large data set.

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    ------------------------------



  • 3.  RE: Network Timeout

    Posted 12-16-2021 13:34
    When fetching large result set it is better to use REST service because it fetches only the attributes included in the MxSheet instead of fetching the entire object structure.

    ------------------------------
    Regards
    Bruno Portaluri (MaximoDev)
    ------------------------------