The error:
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource EmpacTrinidadAdapter:EmpacTrinidadAdapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
Integration Server: 8.2.1.0
Java: default IBM 1.6 JVM
JDBC Adapter: WmJDBCAdapter_6.5_Fix28
Oracle Driver: ojbc6.jar (11.2.0.2.0)
Oracle Database: 9.2.0.1.0
The Oracle database is located in Trinidad. The webMethods server is in Canada.
This same Adapter and driver can connect successfully to local Oracle 10 and Oracle 11 databases.
A quick google search reveals the following link:
http://forums.oracle.com/forums/search.jspa?objID=f83&q=ORA-01882
which suggests adding -Duser.timezone=somevalue.
You need to edit Integration Server’s startup script
C:\SoftwareAG\IntegrationServer\bin\server.bat
and append that additional definition to the end of the JAVA_OPTS setting.
We have several database connecting to the Integration server as datasource from diffrent time zone… US and Trinidad. I don’t think hard code the timezone in the server.bat will help.
Unfortunatly your problem is related to Oracle (not wM suite) and the link just gives a pointer to a one possible solution. I would suggest posting your question (in a reworded manner) to some of the Oracle forums and see if anyone has a good suggestion.