We have upgraded our weblogic server from 10.3.3.0(184.108.40.206.0) to 10.3.6.0(220.127.116.11.0)
All the data sources and connection pools were created in the previous version(18.104.22.168.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.
*<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>*
*<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>*
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....
Thanks for the reply...
But it seems answers are given related to 'Application Express Listener'.
The thing is we got this issue once we upgrade the middleware tier. We cannot do anything on database side. (Remote database)
The solution should be in middleware, Weblogic server side.
Our live environment still in the 10.3.3.0 version. It works fine..
any suggestions ???
I have set the timezone value as per the above forum and it was fine.
But now i am not able to open 'Solution Editor' in IPM application (Under Tools) and error is timezone issue.
What will be the solution???