Environment

Opsb Suite 2022.11 P2

Situation

The user is not able to fetch Server Availability Reports in Optic DL/BVD. No data is showing in the report.

Data flow across tables for Operations Agent data:

opsb_agent_node -> opsb_sysinfra_node -> opsb_sysinfra_avail -> opsb_sysinfra_avail_1h -> opsb_sysinfra_avail_1d

The user checked and found opsb_agent_node and opsb_sysinfra_node are still having data but no data coming to the "opsb_sysinfra_avail " table. 

Checking opsb_sysuptm.log, the user found the below error:

2024/03/12 07:48:24 /taskexecutor/conf-local/configuration-store/d7674c65-a5a9-410f-96dd-0bf181056c01/opsb_sysuptm.pl main::try {...} 968 ERROR BatchLoading select data failed with dbi error ERROR 2992: Date/time field value out of range: "0"

HINT: Perhaps you need a different "datestyle" setting

(SQL-22008) [state was 22008 now 01000]

ERROR 2992: Date/time field value out of range: "0"

HINT: Perhaps you need a different "datestyle" setting

(SQL-01000) for argexecsqlarr=2023-10-06 14:00:00 2023-10-06 14:00:00 2024-03-12 12:00:00 2024-03-12 12:00:00 0

2024/03/12 07:48:24 /taskexecutor/conf-local/configuration-store/d7674c65-a5a9-410f-96dd-0bf181056c01/opsb_sysuptm.pl main::catch {...} 1033 ERROR BatchLoading Vertica DB batch loading failed with error execute failed due to ERROR 2992: Date/time field value out of range: "0"

HINT: Perhaps you need a different "datestyle" setting

(SQL-22008) [state was 22008 now 01000]

ERROR 2992: Date/time field value out of range: "0"

HINT: Perhaps you need a different "datestyle" setting

(SQL-01000) at /taskexecutor/conf-local/configuration-store/d7674c65-a5a9-410f-96dd-0bf181056c01/opsb_sysuptm.pl line 969.

Read the complete knowledge article for resolution