Sunday, November 28, 2010

Upgrade BI publisher

I had upgraded BI publisher from 10.1.3.4 to 10.1.3.4.1 .We wanted to upgrade as there were issues with BI and LDAP integration.So support suggested Apply Patch 10256764 i.e. a BI upgrade.Upgrade solved the issue but a new issue with scheduler popped up.Just login to BI publisher console and click on scheduler tab it throws up the error,

    java.lang.ClassCastException: oracle.toplink.exceptions.QueryException

I was pretty baffled on this issue,googled and searched on oracle .I couldn't find a similar issue or solution.Here is what that needs to be done during upgrade.

1.Create a new schema in database.
2.Navigate to Admin->System Maintenance ->Scheduler Configuration.
3.Install schema for newly created schema in database.

These steps are missed out in patch readme or upgrade steps.But if not done,it causes issues with scheduler.