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