BI Publisher (MOSC)

MOSC Banner

Unparseable Date in Schedule Trigger

edited Jun 12, 2018 5:06AM in BI Publisher (MOSC) 3 commentsAnswered

Hello, we are using Oracle Business Intelligence 11.1.1.7.150120 on Linux 64-bit.

In one of our BI Publisher reports with Schedule Trigger, I had to add additional criteria/where-conditions and hence I modified the schedule trigger sql text, validated from SQL Developer by running it with appropriate parameters and the query runs fine.

Now, when I schedule the report with this schedule trigger selected, I see the following error for this job from the Job History page:

::FAILED_TO_EXECUTE_TRIGGER::[INSTANCE_ID=server.domain.com.1442425076323] [JOB_ID=36009]::

Unparseable date: ""::

java.text.ParseException: Unparseable date: ""

at java.text.DateFormat.parse(DateFormat.java:337)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center