Error Invalid date format (U_FMT_DATE) when launching a command

Products

• CA Automic Dollar Universe

Issue/Introduction

When launching a Dollar Universe command that requires some date parameters, such as DSINCE,DBEFORE,LSTART or LEND, the command may return an error if the U_FMT_DATE format of the node is not respected.

 

Example of the error for "uxlst prv" workload forecast command:

 

uxlst PRV TSK=* SES=* UPR=* MU=* DSINCE=20210320 DBEFORE=20210324 TSINCE=000000 TBEFORE=235959 OUTPUT=maralljobs24.xls

 

Error:

 

Invalid date format : Check the environment variable U_FMT_DATE

Environment

Release : 6.x

Component : DOLLAR UNIVERSE

Cause

Wrong U_FMT_DATE format passed to the date parameter, ie YYYYDDMM instead of default MM/DD/YYYY

Resolution

In order to find the correct syntax of the date format, see below how:

1. Load the Dollar Universe environment

Unix: . ./unienv.ksh

Windows: unienv.bat

2. Obtain the current format of U_FMT_DATE, by default you will get  mm/dd/yyyy  :

Unix: $UNI_DIR_EXEC/unigetvar U_FMT_DATE 

Windows: %UNI_DIR_EXEC%\unigetvar U_FMT_DATE 

 

3. Launch the command that was failing with the correct date range, ie for "uxlst prv" for April executions:

$UNI_DIR_EXEC/uxlst prv TSK=* SES=* UPR=* MU=* DSINCE="04/01/2021" DBEFORE="05/01/2021" TSINCE=000000 TBEFORE=235959 output=/tmp/executions_for_april.txt