LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

DB Query WARN: month value out of range: 72 [0,11]

  • 1.  DB Query WARN: month value out of range: 72 [0,11]

    Employee
    Posted 12-27-2017 11:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: john610

    The node below runs successfully in 6.1 and errors in 6.1.4.

    WARN: month value out of range: 72 [0,11]
    Error Code: brain.node.JJulianCalendar.cpp.425

    ERROR: Node execution terminated while processing data by error:
    month value out of range: 72 [0,11]
    Error Code: lae.node.executionTerminated

    Are we missing a setting?



    node:CSG_Tech_Query
    bretype:core::DB Query
    editor:Label=CSG Tech Query
    editor:sortkey=57289b6c1ca25ba0_2
    output:@40fd2c7444283da6/=
    inclock:/=Temp_Table_Load
    inclock:/=Temp_Table_Load_2
    prop:DbInterface={{^NDW_DBInterface^}}
    encrypted:simple=nFZhmIpYZmvjMtRGF8lNF8JPgXna3GsCc jTuaoWuhWE2I1v1+o==
    prop:DbService={{^NDW_DBService^}}
    prop:DbUser={{^NDW_DBUser^}}
    prop:SqlQuery=<<EOX
    SELECT CAST('Order' AS VARCHAR (20)) (NAMED WO_TYPE ),
    sub_acct_no_OHI (NAMED ACCOUNT_NUMBER ),
    cust_acct_no_OHI (NAMED CUSTOMER_ACCT_NUMBER ),
    HSE_KEY_OHI (NAMED HOUSE_KEY ),
    order_no_OHI (NAMED WO_NUM ),
    JOB_TYP_OJB,
    SYS_OHI,
    PRIN_OHI,
    AGNT_OHI,
    CYC_CHG_DTE_OHI,
    LS_CHG_DTE_OHI,
    CONNECT_DTE_OHI,
    DISCO_DTE_OHI,
    BILL_FROM_DTE_OHI,
    BILL_START_DTE_OHI,
    BILL_STOP_DTE_OHI,
    BILL_THRU_DTE_OHI,
    ENTRY_DTE_OHI,

    --CREATE_OP_ID_OOR,
    CREATE_OP_ID_OCR,
    --DUE_DTE_OOR,
    DUE_DTE_OCR,
    --COMPL_DTE_OOR,
    COMPL_DTE_OCR,

    CREATE_DTE_OJB,
    CREATE_DTE_OHI,
    SCHED_DTE_OJB,
    COMPL_DTE_OJB,
    SALESREP_OHI,
    ENTRY_OP_ID_OHI,
    CREATE_OP_ID_OJB,
    SERV_CDE_OHI,
    BILL_CDE_OHI,
    CAMP_CDE_OHI,
    DSC_CDE_OHI,
    BILL_AMT_OHI,
    DISCO_RSN_SBB,

    --ORD_COMMENTS_OOR,
    ORD_COMMENTS_OCR,

    JOB_COMMENTS_OJB,
    PRODUCT_NAME,
    PRODUCT_TIER_CD,
    PRODUCT_CATEGORY,
    GL_ACCOUNT_NUM,
    GL_ACCOUNT_DESC,
    CURRENT_DATE (NAMED LOAD_DT ),
    IR_TECH_OJB,

    --CREATE_DTE_OOR,
    CREATE_DTE_OCR,
    --CREATE_TME_OOR,
    CREATE_TME_OCR,
    --LS_CHG_DTE_OOR,
    LS_CHG_DTE_OCR,
    --LS_CHG_TME_OOR,
    LS_CHG_TME_OCR,

    LS_CHG_TME_OHI,
    TME_EST_ALA,
    E_MAIL_ADDR_CUS (NAMED EMAIL_ADDRESS ),
    JOB_STAT_OJB,
    JOB_SEQ_NO_OJB,
    JOB_CLASS_OJB
    FROM NDW_EXT_TEMP.OHI_TABLES ohi

    --JOIN NDW_JRNL_VIEWS.OOR_ORDER_OPEN_CL OOR
    --ON order_no_OHI = order_no_OOR

    JOIN NDW_JRNL_VIEWS.OCR_ORDER_COMP OCR
    ON ORDER_NO_OHI = ORDER_NO_OCR

    --LEFT
    JOIN NDW_JRNL_VIEWS.ojb_jobs ojb
    ON ohi.sys_OHI = ojb.sys_ojb
    AND ohi.prin_OHI = ojb.prin_ojb
    AND ohi.agnt_OHI = ojb.agnt_ojb
    AND ohi.order_no_OHI = ojb.order_no_ojb
    --AND ohi.job_seq_no_OHI = ojb.job_seq_no_ojb
    and ohi.hse_key_ohi = ojb.hse_key_ojb


    JOIN NDW_JRNL_VIEWS.SBB_BASE_CL sbb
    ON ohi.sub_acct_no_OHI = sbb.sub_acct_no_sbb

    LEFT JOIN NDW_JRNL_VIEWS.CUS_BASE cus
    ON sbb.HSE_KEY_SBB = cus.HSE_KEY_CUS
    --AND E_MAIL_ADDR_STAT_CUS = 'E'

    join NDW_EXT_TEMP.XHS_TECH tmp --temp table from XHS report
    on sub_acct_no_OHI = tmp.ACCOUNT_NUMBER

    --WHERE oor.create_dte_OOR >= CURRENT_DATE - 42
    --AND oor.ord_stat_OOR = 'C'
    --AND oor.ord_class_OOR = 'S';

    WHERE OCR.COMPL_DTE_OCR >= CURRENT_DATE - 42
    AND ocr.ord_stat_OCR = 'C'

    EOX
    editor:XY=80,140
    end:CSG_Tech_Query