Discussion


TCS
IN
Last activity: 5 Sep 2015 13:22 EDT
Help on Unix Bix Reporting Script
Hi ,
While runing the Bix Command through command line, we 're facing the following error for few extract Rulesets:
15:49:27,262 [ main] ( internal.access.ExtractImpl) ERROR - 8/17/2015 02:50 PM is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
15:49:31,988 [ 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
15:49:31,989 [ 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
Our script takes the datetime as argument in this format: 20150901T000000.000 only. Despite the error it does generate XSD files, but not XML files which we require. I'm unable to find out the exact reason for this error and will really appreciate if you can help.
Thanks a lot for reading. I highy regard any kind of input from you that can lead us in right direction.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Areteans Technology
IN
https://community.pega.com/sites/default/files/help_v718/procomhelpmain.htm
You can toggle around the commmand line parameters as found in the above link to further debug the failure. Especially --f, and -i can help you.
From the above exception looks like, the system assumes it is extracting date property but the value contains DateTime . See all the date,datetime values in the extract and filters of extract.If you do not get further help, remove all datetime in extract and run it once .


TCS
IN
I tried running the extracts without any datetime parameters( and without any filter criteria), even then also we're unable to generate the xml files. Please help!!


Areteans Technology
IN
paste the logs when you run the extract from commad line.. Can you run the same sucessfully from designed studio ?


PEG
IN
Can you check whether the data being tried to fetch is corrupted or not?
Post your query https://mesh.pega.com/community/pegaproductsupport to get better responses.


TCS
IN
Hi Ashok,
Thanks a lot for replying. Yes we can run the extracts sucessfully from designed studio.
We see the below errors(in our log file ) while running from command line:
13:02:35,647 [ main] ( internal.access.ExtractImpl) ERROR - 20150817T000000.000 is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
13:02:36,253 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
log4j:ERROR Faile13:02:36,254 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
Below is the log file generated while running from command line:
Hi Ashok,
Thanks a lot for replying. Yes we can run the extracts sucessfully from designed studio.
We see the below errors(in our log file ) while running from command line:
13:02:35,647 [ main] ( internal.access.ExtractImpl) ERROR - 20150817T000000.000 is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
13:02:36,253 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
log4j:ERROR Faile13:02:36,254 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
Below is the log file generated while running from command line:
13:01:18,109 [ main] ( internal.access.DatabaseImpl) INFO - Bytes input per interaction warning threshold: 50M
13:01:18,110 [ main] ( internal.access.DatabaseImpl) INFO - Database product: Oracle
13:01:18,110 [ main] ( internal.access.DatabaseImpl) INFO - Database version: Oracle Database 11g Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
13:01:18,111 [ main] ( internal.access.DatabaseImpl) INFO - Driver: Oracle JDBC driver
13:01:18,111 [ main] ( internal.access.DatabaseImpl) INFO - Driver version: Proprietary information hidden.0
13:01:18,658 [ main] (ternal.dictionary.ClassMapImpl) INFO - Reading the class group definitions
13:01:18,926 [ main] (ternal.dictionary.ClassMapImpl) INFO - Read 39 class group definitions
13:01:18,926 [ main] (ternal.dictionary.ClassMapImpl) INFO - Reading the class definitions
13:02:13,090 [ main] (ternal.dictionary.ClassMapImpl) INFO - Read 10302 class definitions
Using Java 5 BigDecimal implementation
13:02:35,132 [ main] (rnal.access.CacheContainerImpl) INFO - Using the Dynamic Cache Probation Policy - cache after 2 accesses AND with a blob increment of 102400.
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,140 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,143 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,152 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,155 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,159 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:35,159 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:35,159 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:35,162 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:35,163 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:35,170 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:35,620 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is: (pxUpdateDateTime >= ?)
13:02:35,620 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxCreateDateTime >= ? AND pxCreateDateTime <= ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? AND (pxUpdateDateTime >= ?)
13:02:35,647 [ main] ( internal.access.ExtractImpl) ERROR - 20150817T000000.000 is an invalid Date Format. Please Enter the Enter Date in MM/DD/YYYY Format
13:02:36,253 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
log4j:ERROR Faile13:02:36,254 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:36,696 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:37,145 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:37,145 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:37,156 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:37,646 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:37,646 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,653 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:37,654 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:38,089 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:38,089 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:38,097 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:38,584 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:38,585 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,594 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO 13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:38,595 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:39,045 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:39,045 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:43,495 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:43,496 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:43,944 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:43,944 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:43,953 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:44,396 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:44,396 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:44,404 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:44,405 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:44,844 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:44,844 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:44,856 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:45,394 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:45,394 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:45,402 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:45,402 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:45,402 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:45,402 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,402 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:02:45,403 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:02:45,869 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:02:45,869 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:02:45,881 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:00,239 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:00,239 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:00,747 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is: (pxCreateDateTime >= ?) AND (pxUpdateDateTime >= ?) AND (pxCreateOperator <> ?) AND (pxUpdateOperator <> ?)
13:03:00,747 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxCreateDateTime >= ? AND pxCreateDateTime <= ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? AND (pxCreateDateTime >= ?) AND (pxUpdateDateTime >= ?) AND (pxCreateOperator <> ?) AND (pxUpdateOperator <> ?)
13:03:00,749 [ 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
13:03:00,750 [ 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
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:00,789 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:01,336 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is: (pxCreateOperator <> ?) AND (pxUpdateOperator <> ?)
13:03:01,336 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxCreateDateTime >= ? AND pxCreateDateTime <= ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? AND (pxCreateOperator <> ?) AND (pxUpdateOperator <> ?)
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:01,348 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:01,349 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:01,820 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:03:01,820 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:01,831 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:02,307 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:03:02,307 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:02,316 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:02,859 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:03:02,859 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------
13:03:02,868 [ main] ( internal.access.ExtractImpl) INFO - bix/useHistoryClasses setting has been disabled
13:03:03,411 [ main] ( internal.access.ExtractImpl) DEBUG - Where Condition is:
13:03:03,411 [ main] ( internal.access.ExtractImpl) DEBUG - sql statement is: SELECT count(pzInsKey) FROM <Some Extract Name > WHERE pxObjClass like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ?
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - ------- Module Versions of Extract Classes ---------
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - ExtractImpl : $Id: ExtractImpl.java 18081 2011-12-08 11:07:44Z [email protected] $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - ExtractParameters : $Id: ExtractParameters.java 16561 2011-11-02 14:00:45Z BB $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLSelector : $Id: SQLSelector.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGenerator : $Id: SQLGenerator.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorOracle : $Id: SQLGeneratorOracle.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2 : $Id: SQLGeneratorDb2.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorDb2ZOS : $Id: SQLGeneratorDb2ZOS.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorApache : $Id: SQLGeneratorApache.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - SQLGeneratorMSSQL : $Id: SQLGeneratorMssql.java 32553 2012-08-06 17:25:10Z ML $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - PropertyData : $Id: PropertyData.java 12722 2011-08-05 11:15:08Z RK $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - NodeData : $Id: NodeData.java 12721 2011-08-05 11:14:38Z RK $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - IOData : $Id: IOData.java 12723 2011-08-05 11:15:29Z RK $
13:03:03,420 [ main] ( internal.access.ExtractImpl) INFO - FilterData : $Id: FilterData.java 12724 2011-08-05 11:16:38Z RK $
13:03:03,421 [ main] ( internal.access.ExtractImpl) INFO - TransformFinder : $Id: TransformFinder.java 70764 2013-10-08 06:47:07Z PS $
13:03:03,421 [ main] ( internal.access.ExtractImpl) INFO - ParUtils : $Id: ParUtils.java 16651 2011-11-03 17:13:59Z KH $
13:03:03,421 [ main] ( internal.access.ExtractImpl) INFO - DatabasePreparedStatement : $Id: DatabasePreparedStatement.java 17680 2011-11-28 10:52:29Z cp $
13:03:03,421 [ main] ( internal.access.ExtractImpl) INFO - DatabaseUtilsCommonImpl : $Id: DatabaseUtilsCommonImpl.java 16561 2011-11-02 14:00:45Z BB $
13:03:03,421 [ main] ( internal.access.ExtractImpl) INFO - --------------------- End --------------------------