Wrong date format in Business Objects WEBI job

book

Article ID: 105790

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

The  date provided in a Business Objects WEBI job is malformed:
The data entered is i.e. "20180331", but it's interpreted as "12/31/20180331".

 

Cause

The Business Objects RESTful API, which is used to schedule WEBI jobs allows the following date formats:

MM/dd/yyyy hh:mm:ss a 
MM/dd/yyyy HH:mm:ss 
MM/dd/yyyy 
yyyy-MM-dd'T'HH:mm:ssZ 
yyyy-MM-dd'T'HH:mm:ss 


 

Environment

Release:
Component: ARAOBJ

Resolution

In this case the wrong date format was used.

20180331 is not an allowed date format.

This was resolved using:  2018-03-31T00:00:00.000Z


This can lead to the following error message:

WSR 00102 The request body is malformed.