When I setup jobs for Thumbnails, Indexing, and File Property Extraction, I do not get any results or apparent errors.
Upon loggingservice.log examination, the following errors are seen in the logs: pwise.database.odbc - Error 241 "ODBC ERROR: 22007: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.
pwise.database - Executing statement 'insert into dms_asyncstatus (o_compguid,o_docguid,o_docsignal,o_filesignal,o_asyncstamp) values ('681014dc-859b-4c25-ac5b-a813548a5ee9','f80814f9-24a4-4e63-a962-28bc9dfad905','3','3','26/03/2014T16:13:36')'
Snippet from Chapter on Database setup in PW SS4RU PW Implementation Guide
5. When SQL Server is your database, make sure that when configuring your ODBC datasource you turn
OFF the setting, Use regional settings when outputting currency, numbers, dates times.