Notification Of Expiration
I use UCM 10gR3 (10.1.3.5.1) with "SearchIndexerEngineName=DATABASE.METADATA".
I have a problem with NotificationQuery. My query is the following : NotificationQuery=dOutDate > '<$dateCurrent(7)$>' <AND> dOutDate < '<$dateCurrent(14)$>'
I get an error in Content server log when the notification run :
UCM-W303: csScheduledEventError(NotificationOfExpiration) intradoc.common.ServiceException: Parsing error at character 11 in query: "dOutDate > {ts '2010-07-01 09:03:26.713'} <AND> dOutDate < {ts '2010-07-08 09:03:26.713'}". [ Details ]
<font size="2">
<i>An error has occurred. The stack trace below shows more information.
!$UCM-W303: !csScheduledEventError,NotificationOfExpiration!syExceptionType2,intradoc.common.ServiceException,Parsing error at character 11 in query: "dOutDate > {ts '2010-07-01 09:03:26.713'} <AND> dOutDate < {ts '2010-07-08 09:03:26.713'}".
intradoc.common.ServiceException: Parsing error at character 11 in query: "dOutDate > {ts '2010-07-01 09:03:26.713'} <AND> dOutDate < {ts '2010-07-08 09:03:26.713'}".
at intradoc.search.UniversalSearchQueryParser.parseQueryEx(UniversalSearchQueryParser.java:946)
at intradoc.search.UniversalSearchQueryParser.parseQuery(UniversalSearchQueryParser.java:219)
at intradoc.search.UniversalSearchQueryParser.parse(UniversalSearchQueryParser.java:163)
at intradoc.search.DBSearchConfigCompanion.fixUpAndValidateQuery(DBSearchConfigCompanion.java:178)
at intradoc.shared.CommonSearchConfig.fixUpAndValidateQuery(CommonSearchConfig.java:1503)
at intradoc.server.ExpirationNotifier.init(ExpirationNotifier.java:187)
at intradoc.server.ScheduledSystemEvents.checkHandleEvent(ScheduledSystemEvents.java:649)
at intradoc.server.ScheduledSystemEvents.processWork(ScheduledSystemEvents.java:589)
at intradoc.server.ScheduledSystemEvents.run(ScheduledSystemEvents.java:487)
at java.lang.Thread.run(Thread.java:595)
</i>
</font>