Date Parsing Issue in WebCenter Content (WCC formerly UCM) 11.1.8.0 with Oracle Content Publisher (Doc ID 2012957.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

When using date range '2014-12-01 12:00 AM in a query Content Publisher translation fails with the error:

2/20/15 2:45:00 PM Logging level set to 5.
Starting update of Publication - test.
Updating DirectoryItem 'Test' (Instance='slc03tbi', Query='dDocTitle `Hello` dSecurityGroup `Public` dInDate >= `2014-12-01 12:00 AM` dInDate < `2015-02-20 12:00 AM` dExtension `docx`')
Unable to retrieve search results. Unable to parse date '2014-12-01 12:00 AM'. Failed to find text '{ts' in its proper location.
Encountered a problem executing the DirectoryItem query for '\\slc03tbi\Test' -- retaining old results.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms