Automic Workload Automation

 View Only
  • 1.  Reporting Utility - Segmentation fault (core dumped)

    Posted Dec 06, 2021 06:59 AM
    Dear All,

    We are getting below error while running the reporting utility:

    ./ucybdbrt -C0200 -Xqueries/BAC.s.xml -Iucybdbrt.ini
    U00042224 UCYBDBRT version 21.0.1+build.38, (changelist '1637650199') started.
    U00038259 Build Date: '2021-11-23', '06:53:13'
    Segmentation fault (core dumped)

    The log file doesn't show much except:

    tail -f ucybdbrt_log_00.txt
    20211206/171233.309 - U00003535 DB INFO: 'LOCK-TYPES ='
    20211206/171233.309 - U00003535 DB INFO: 'ODBC_TRACE = 0'
    20211206/171233.317 - U00003532 UCUDB: Checking data source ...
    20211206/171236.843 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '487263731'/'542 (1000/1.841771 s)'
    20211206/171236.843 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470
    20211206/171253.522 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '20:407.261.999'
    20211206/171253.522 - U00003525 UCUDB: ===> ''
    20211206/171253.522 - U00021200 *********************************************ILM SETTINGS***********************************************
    20211206/171253.525 - U00021202 ILM installed N
    20211206/171253.525 - U00021203 ********************************************************************************************************

    This was working till 12.3.5. Then we installed 21.0 and ever since it has not. All other commands under Utility does work except the report. Any ideas?

    Regards
    Pothen


  • 2.  RE: Reporting Utility - Segmentation fault (core dumped)

    Posted Jan 12, 2022 02:01 AM
    Dear All,

    Any thoughts on how to debug or fix the above? This issue still there under the 21.x version.

    ./ucybdbrt -C0200 -Xqueries/DEMO_TEST.s.xml -Iucybdbrt.ini
    U00042224 UCYBDBRT version 21.0.1+build.38, (changelist '1637650199') started.
    U00038259 Build Date: '2021-11-23', '06:53:13'
    Segmentation fault (core dumped)

    The query file looks as below:

    cat DEMO_TEST.s.xml
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <QUERY version="21.0.">
    <file css="Standard.css" type="HTML">DEMO.TEST.AE.JP.html</file>
    <client>200</client>
    <max_rows>1000</max_rows>
    <source>STATISTICS</source>
    <reference>
    <date>NOW</date>
    <offset>-8</offset>
    </reference>
    <selection>
    <include name="PARENT_JOBPLAN_NAME" value="DEMO.TEST.JP"/>
    <include name="OBJECT_TYPE" value="JOBS"/>
    </selection>
    <output>
    <field name="OBJECT_NAME"/>
    <field name="OBJECT_TYPE"/>
    <field name="START_TIME"/>
    <field name="END_TIME"/>
    <field name="RUNTIME"/>
    <field name="RETCODE"/>
    <field name="STATUS"/>
    <field name="RUN_NUMBER"/>
    <field name="HOST"/>
    <field name="LOGIN_INFO"/>
    </output>
    </QUERY>

    Regards
    Pothen