This discussion is archived
4 Replies Latest reply: Jan 28, 2013 1:03 AM by Nir RSS

'timezone region not found' while updating connection pool

Nir Newbie
Currently Being Moderated
Hi Experts,

We have upgraded our weblogic server from 10.3.3.0(11.1.1.3.0) to 10.3.6.0(11.1.1.6.0)

All the data sources and connection pools were created in the previous version(11.1.1.3.0) and it worked fine.

After the upgrade has done, we tried to run a BPEL web service which is using a database connection to get some data.
Then the below error has thrown out in EM.

*<part name="summary">*
*<summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Validate_Invoice' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot acquire data source [jdbc/EBSAPPS]. Internal Exception: javax.naming.NameNotFoundException: Unable to resolve 'jdbc.EBSAPPS'. Resolved 'jdbc'; remaining name 'EBSAPPS'. You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary>*
*</part>*
*<part name="detail">*
*<detail> Exception Description: Cannot acquire data source [jdbc/EBSAPPS]. Internal Exception: javax.naming.NameNotFoundException: Unable to resolve 'jdbc.EBSAPPS'. Resolved 'jdbc'; remaining name 'EBSAPPS'</detail>*
*</part>*

Then I tried to recreate the data source and jndi name.
Then I got below error while creating connection pool,

An error occured during activation of changes. Please see the log for details.
Weblogic.Application.ModuleExeption
ORA-00604: Error occurred at recursive sql level 1ORA 1882:timezone region not found.

Database OS level timezone is - SLT
Weblogic server OS level timezone is - IST

As i remember above are the timezones there earlier also....

What can do??

Thanks in advance....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points