on 07-10-2007 5:44 PM
Hi All,
Please help me in resolving this issue
I have installed EP 7.0 using trail version software downloaded from SDN. It went fine for couple of weeks.
Now I am facing problem while trying to start the server,
<b>jcontrol.exe</b> is stopped and
when i tried to logon to config tool I am getting the below error message.
Error occured while working with Configuration (Scanning) .
<b>Msg: Error while connecting to DB.</b>
Thanks in Advance
Kumar,
Check DB user passwords.It might be changed.
Thanks
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Just got similar problem. (EP7 with MS winserv2003 & MSSQL2005)
The database was running as I could check it with MSSQL Management Studio.
My resolution was in the config tool (start it without connecting to the DB) at the secure store I restored the mistakenly changed password for the pool user (SAP<SID>DB).
After the portal was started.
Pls. award points if my suggestion was useful.
BR.
Richard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Note 741289 - Profile parameters of the J2EE Engine are lost
check the J2EE profile parameters as per this note in the instance Profile.
Award Points if helpful.
Thanks,
Tanuj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tanuj,
I am facing the problem after modifying the profile as per Note.
Please find the Old and New Instance profile
<i><b>Old instance profile</b></i>
SAPSYSTEMNAME = JAD
SAPGLOBALHOST = Answers24
SAPSYSTEM = 14
INSTANCE_NAME = JC14
DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTI386
DIR_EXECUTABLE = $(DIR_INSTANCE)\exe
jstartup/trimming_properties = off
jstartup/protocol = on
jstartup/vm/home = C:\j2sdk1.4.2_09
jstartup/max_caches = 500
jstartup/release = 700
jstartup/instance_properties = $(jstartup/j2ee_properties);$(jstartup/sdm_properties)
j2ee/dbdriver = C:\sapdb\programs\runtime\jar\sapdbc.jar
igs/listener/rfc/disable = 1
PHYS_MEMSIZE = 512
rsdb/dbid = J2E
dbs/ada/schema = SAPJAD
#----
Jcontrol: Migrated Profile Parameter
# create at Wed Jun 27 17:10:57 2007
#----
j2ee/instance_id = ID1444558
#----
<b><i>New Instance profile modified as per Note 741289</i></b>
SAPSYSTEMNAME = JAD
SAPGLOBALHOST = Answers24
SAPSYSTEM = 14
INSTANCE_NAME = JC14
DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTI386
DIR_EXECUTABLE = $(DIR_INSTANCE)\exe
jstartup/trimming_properties = off
jstartup/protocol = on
jstartup/vm/home = C:\j2sdk1.4.2_09
jstartup/max_caches = 500
jstartup/release = 700
jstartup/instance_properties = $(jstartup/j2ee_properties);$(jstartup/sdm_properties)
j2ee/dbdriver = C:\sapdb\programs\runtime\jar\sapdbc.jar
igs/listener/rfc/disable = 1
PHYS_MEMSIZE = 512
rsdb/dbid = J2E
dbs/ada/schema = SAPJAD
#----
Jcontrol: Migrated Profile Parameter
# create at Wed Jun 27 17:10:57 2007
#----
j2ee/instance_id = ID1444558
#----
#
#--
#rdisp/j2ee_start_control = 1
#rdisp/j2ee_start = 1
#rdisp/j2ee_libpath = $(DIR_EXECUTABLE)
#exe/j2ee = $(DIR_EXECUTABLE)/jcontrol$(FT_EXE)
#rdisp/j2ee_timeout = 600
#rdisp/frfc_fallback = on
#icm/HTTP/j2ee_0 = PREFIX=/,HOST=localhost,CONN=0-500,PORT=5$$00
#icm/server_port_0 = PROT=HTTP,PORT=80$$
#----
Please let me know if anything more need to be modified.
Thanks in advance
Hi Tanuj,
I found the below error in <b>dev_jcontrol</b> file
[Thr 3508] Wed Jul 11 10:17:20 2007
[Thr 3508] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx.c 1642]
[Thr 3508] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)
[Thr 3508] JControlCloseProgram: started (exitcode = 66)
[Thr 3508] JControlCloseProgram: good bye... (exitcode = 66)
In File log_bootstrap_ID1444558.0
[Jul 11, 2007 10:17:19...] [Bootstrap module]> Problem occurred while performing synchronization.
[Jul 11, 2007 11:34:19...] -
[Jul 11, 2007 11:34:19...] Bootstrap MODE:
[Jul 11, 2007 11:34:19...] <INSTANCE GLOBALS>
[Jul 11, 2007 11:34:19...] determined by parameter [ID1444558].
[Jul 11, 2007 11:34:19...] -
[Jul 11, 2007 11:34:26...] Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:422)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
-
==[ Caused by: ]==----
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:360)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:125)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:60)
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:419)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://Answers24/J2E [Restart required].
at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:188)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:302)
... 14 more
[Jul 11, 2007 11:34:26...] [Bootstrap module]> Problem occurred while performing synchronization.
Regards,
Kumar
Hi,
997510 Troubleshooting J2EE Engine 6.40/7.0 Bootstrap Issues
940893 Analysis of errors within the startup of J2EE Engine 6.40
Also check this in the configtool
Key: jdbc/pool/<SID>/Url
Value:jdbc:oracle:thin:@<hostname>:1527:<SID>
The 1527 is the port of the Oracle lstener or if it is Sql Server it is the TCP/IP port on which it is runnning.
The same should be present in the configtool. If not it will not connect to the Database.
Award Points if helpful
Thanks,
Tanuj
Hi,
My database is <b>MaxDB</b>
Key: jdbc/pool/JAD/Url
Value: jdbc:sapdb://Answers24/J2E?timeout=0&spaceoption=true&unicode=true
Key: jdbc/pool/JAD/User
Value: SAPJADDB
From note 997510, I found the below points are relevent for my system
Database not started. Make sure the database is started and
accessible. To test whether this is the case, try to connect with
Config Tool, and an external db vendor provided tool.
<b><i>As mentioned above, I am unable to connect with Config tool.</i></b>
User or password for connection to the database are either
incorrect or the password has expired. Make sure the connection
details in Secure Store are the correct ones, if necessary change
the jdbc/pool/<SID>/Password and jdbc/pool/<SID>/User via Config Tool.
<b><i>I have no idea what values have to be given for the above Keys(jdbc/pool/<SID>/Password, jdbc/pool/<SID>/Use)</i></b>
Thanks
Kumar
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.