Bix Command Line Script
Hi,
While running the extracts through BIX Command line script, we're facing the following errror:
11:58:26,619 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <SOME CLASS NAME> WHERE pxObjClass like ? AND pxCreateDateTime >= ? AND pxUpdateDateTime >= ? AND (pxCreateDateTime >= ?) AND (pxUpdateDateTime >= ?) AND (pxCreateOperator <> ?) AND (pxUpdateOperator <> ?)
11:58:26,626 [ main] ( internal.access.ExtractImpl) ERROR - 2/18/2014 12:00 AM is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
11:58:26,629 [ main] ( internal.access.ExtractImpl) ERROR - 2/18/2014 12:00 AM is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
11:58:26,638 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
We run our script with date argument passed in YYYYMMDDTHHmmss.SSS ( 20150824T000000.000 ) format.
No where in the script we pass this date "2/18/2014 12:00 AM". Even in application(portal) all options are unchecked or empty.
Can you help resolve this error? Thanks a lot for reading. Will appreciate if someone can help.