SAP Knowledge Base Article - Preview

2340761 - DS_KPI: ORA-01847: day of month must be between 1 and last day of month

Symptom

After following the instructions described in the attachment of note 1618486, to setup the Data Services additional workload metrics, you face the following error:

ORA-01847: day of month must be between 1 and last day of month

 

A similar SQL statement will be found in the logs:

 SELECT query <SELECT "ALVW_FLOW_STAT"."JOB_NAME" , "ALVW_FLOW_STAT"."JOB_KEY" , "ALVW_FLOW_STAT"."JOB_RUNID" , "ALVW_FLOW_STAT"."PATH" , "ALVW_FLOW_STAT"."OBJECT_NAME" , "ALVW_FLOW_STAT"."OBJECT_TYPE" , "ALVW_FLOW_STAT"."DATAFLOW_NAME" FROM "BODS4REPGLOBAL"."ALVW_FLOW_STAT" "ALVW_FLOW_STAT" WHERE ( to_date('2016.04.22 13:41:24', 'yyyy.mm.dd hh24:mi:ss') < to_date( "ALVW_FLOW_STAT"."END_TIME" , 'YYYY.DD.MM HH24:MI:SS')) and (to_date( "ALVW_FLOW_STAT"."END_TIME" , 'YYYY.DD.MM HH24:MI:SS') < to_date('2016.04.22 14:11:24', 'yyyy.mm.dd hh24:mi:ss') ) and ( "ALVW_FLOW_STAT"."OBJECT_TYPE" <> 'Dataflow') and not ( "ALVW_FLOW_STAT"."ROW_COUNT" like '0') and not ( "ALVW_FLOW_STAT"."START_TIME" like '0000%') and not ( "ALVW_FLOW_STAT"."END_TIME" like '0000%') and not ("ALVW_FLOW_STAT"."JOB_NAME" like 'di_job%') and not ( "ALVW_FLOW_STAT"."JOB_NAME" like 'CD_JOB%') > failed. The database error message is <SQL submitted to Oracle Server <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = <host.domain.com>(PORT = <port>)))(CONNECT_DATA =(SID=BOC4)))> resulted in error <ORA-01847: day of month must be between 1 and last day of month >. The SQL submitted is <SELECT "ALVW_FLOW_STAT"."JOB_NAME" , "ALVW_FLOW_STAT"."JOB_KEY" , "ALVW_FLOW_STAT"."JOB_RUNID" , "ALVW_FLOW_STAT"."PATH" , "ALVW_FLOW_STAT"."OBJECT_NAME" , "ALVW_FLOW_STAT"."OBJECT_TYPE" , "ALVW_FLOW_STAT"."DATAFLOW_NAME" FROM "BODS4REPGLOBAL"."ALVW_FLOW_STAT" "ALVW_FLOW_STAT" WHERE ( to_date('2016.04.22 13:41:24', 'yyyy.mm.dd hh24:mi:ss') < to_date( "ALVW_FLOW_STAT"."END_TIME" , 'YYYY.DD.MM HH24:MI:SS')) and (to_date( "ALVW_FLOW_STAT"."END_TIME" , 'YYYY.DD.MM HH24:MI:SS') < to_date('2016.04.22 14:11:24', 'yyyy.mm.dd hh24:mi:ss') ) and ( "ALVW_FLOW_STAT"."OBJECT_TYPE" <> 'Dataflow') and not ( "ALVW_FLOW_STAT"."ROW_COUNT" like '0') and not ( "ALVW_FLOW_STAT"."START_TIME" like '0000%') and not ( "ALVW_FLOW_STAT"."END_TIME" like '0000%') and not ( "ALVW_FLOW_STAT"."JOB_NAME" like 'di_job%') and not ( "ALVW_FLOW_STAT"."JOB_NAME" like 'CD_JOB%')


Read more...

Environment

SAP Solution Manager 7.1

Product

SAP Data Services 4.2

Keywords

KBA , SV-SMG-DIA-SRV-AGT , Agent Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.