Discussion

1
Replies
367
Views
gladborn Member since 2014 3 posts
TCS
Posted: August 24, 2015
Last activity: August 25, 2015
Closed

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.

Reporting
Moderation Team has archived post
Share this page LinkedIn