71
« on: October 17, 2017, 02:14:49 PM »
I have not been able to recreate your problem on our 9.5.0.7 and 9.5.0.9 test systems. I tested with AGs using old style dates, new style dates, and a combination of both.
arsdoc query -v -h ondenu2 -f CHECKSP -i "WHERE ACCTNO = '140060161' AND ODDAT_ENDDATE BETWEEN '2014-12-01' AND '2014-12-31'"
2017-10-17 17:00:44.207600: ARS6108I Starting arsdoc. Version: 9.5.0.7
2017-10-17 17:00:44.211632: ARS6165I QRDARS/ARSDOC query -v -h ondenu2 -f CHECKSP -i WHERE ACCTNO = '140060161' AND ODDAT_ENDDATE
BETWEEN '2014-12-01' AND '2014-12-31'
2017-10-17 17:00:44.239080: ARS6062I Searching for folder 'CHECKSP' ...
2017-10-17 17:00:44.589280: ARS6084I Search successful
2017-10-17 17:00:44.589576: ARS6063I Searching for documents in 'CHECKSP' ...
2017-10-17 17:00:44.589808: ARS6117I Querying database with SQL string 'WHERE ACCTNO = '140060161' AND ODDAT_ENDDATE BETWEEN '201
4-12-01' AND '2014-12-31''
2017-10-17 17:00:44.970520: ARS6084I Search successful
MYRTLE BEACH BLANKET ,140060161,651-0086375,12/19/14,513324.960000,01
MYRTLE BEACH BLANKET ,140060161,651-0086375,12/19/14,513324.960000,01
MYRTLE BEACH BLANKET ,140060161,651-0086375,12/19/14,513324.960000,01
2017-10-17 17:00:44.973776: ARS6026I arsdoc completed.
If I use other date formats or separators I receive the message: ARS6007E The server failed during a search operation.
The system log contains message 13, DB Error: Syntax of date, time, or timestamp value not valid. -- SQLSTATE=22007, SQLCODE=-180, File=arsdoc.c, Line=2997
If you have the AG set to log Query messages, you can check the actual query that is run. In my case, the after query message 226s (one per AG), contain this"
Application Group Query: Name(CHECKSP005) Agid(9838) Time(0.013) Hits(1) Count() SegStart() SegStop() Tables(1) Sql(WHERE ACCTNO = '140060161' AND ODDAT_ENDDATE BETWEEN '2014-12-01' AND '2014-12-31') SqlR() FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()
and
Application Group Query: Name(CHECKSP004) Agid(9835) Time(0.032) Hits(2) Count() SegStart() SegStop() Tables(2) Sql(WHERE ACCTNO = '140060161' AND ODDAT_ENDDATE BETWEEN '2014-12-01' AND '2014-12-31') SqlR() FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()
The messages show the query used, the number of tables searched, and the number of hits returned.