on 11-17-2009 2:01 AM
Hi guys
I installed NW711(ABAP+JAVA) windows, SQL2005.
When i tried to start the Central instance i get below error in SAP MMC> as Red color
>>sapcpe.exe could not be started
>>sapcpe.exe could not be started
>>sapcpe.exe could not be started
>>strdbs.cmd could not be started
sapstart.log
Starting Programs
(1900)CreateProcess(\\ciaj1\sapmnt\aj1\sys\exe\uc\NTAMD64\sapcpe.EXE pf=\\profilehost\sapmnt\aj1\sys\profile\AJ1_DVEBMGS50_ciaj1) failed(53)
ERROR_BAD_NETPATH: The network path was not found.
Dev_Disp
***LOG Q0I=> NiIRead P=127.0.0.1:3235; L=0.0.0:64992:recv(10054:WASCONNRESET:Connection reset by peer) [nixxi.cpp 4865]
***ERROR=> NiIRead:SiRecv failed for hdl 16/sock 1168
(SI_ECONN_BROKEN/10054; I4; ST; P=127.0.0.1:3235;L=0.0.0.0:64992)
DpJ2eeMsgProcess : j2ee state = CONNECTED (NIECONN_BROKEN)
***ERROR => Dpprockill :kill failed[dpntdisp.c 396]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
How to solve this problem.
regards
Hi,
Pls check your network path for the sapmnt and the environment variable as as the logs are complaining about not finding them.
ciaj1\sapmnt\aj1\sys\exe\uc\NTAMD64\sapcpe.EXE
profilehost\sapmnt\aj1\sys\profile\AJ1_DVEBMGS50_ciaj1
Pls check these paths through the windows explorer.
Also check the user id through which you are trying to start the CI.
I am hoping you are starting the CI using the <sid>adm user id.
Cheers Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sam
Thanks for your reply.
I verified as you said and there was spelling mistake in SAPGlobal host = ciaji instead of "ciaji".
However now my sapcpe.exe problem is solved.
But still i could not start Disp+Work.exe green.
It Says in SAP MMC "AS Java some process failed"
I checked the dev_disp file i have still the same error
***LOG Q0I=> NiIRead P=127.0.0.1:3235; L=0.0.0:64992:recv(10054:WASCONNRESET:Connection reset by peer) [nixxi.cpp 4865]
***ERROR=> NiIRead:SiRecv failed for hdl 16/sock 1168
(SI_ECONN_BROKEN/10054; I4; ST; P=127.0.0.1:3235;L=0.0.0.0:64992)
DpJ2eeMsgProcess : j2ee state = CONNECTED (NIECONN_BROKEN)
***ERROR => Dpprockill :kill failed[dpntdisp.c 396]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
Dev_jstart has below error
Process collector started with pid 4748
F ********************************************************************************
F [Thr 5076] *** LOG => Process collector started (pid 4748).
F
F [Thr 5076] Tue Nov 17 12:44:03 2009
F [Thr 5076] *** LOG => Process collector stopping (pid 4748).
F
F [Thr 4408] Tue Nov 17 12:44:03 2009
F [Thr 4408] *** LOG => Signal 13 SIGCHLD.
F [Thr 5076] *** LOG => Process collector stopped (pid 4748).
F [Thr 5076] *** LOG => Instance state is "Synchronizing binaries" (STOPPING @ 0, INACTIVE).
F [Thr 5076] *** LOG => Run level 2 completed.
F [Thr 5076] *** LOG => Instance state is "Some processes failed" (STOPPED @ 0, INACTIVE).
F [Thr 5076] *** LOG => exiting (exitcode 22002, retcode 1).
How to solve this problem.
regards
Hi all
I saw below error in log_Bootstrap.file
I checked SQLServer sevices are running and From ACC i could see DB instance is green and running.
com.sap.engine.bootstrap.SynchronizationException: Database connection initialization failed. Check if the database is running and the database properties.
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:114)
at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
----------==[ 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:413)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:157)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:48)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:127)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:262)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:39)
at com.sap.engine.bootstrap.HelperImpl.getConfigurationHandlerFactory(HelperImpl.java:38)
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:111)
at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "AJ1" requested by the login. The login failed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)
at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)
at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:674)
at com.sap.sql.connect.datasource.DBDataSourceImpl.newPooledConnection(DBDataSourceImpl.java:624)
at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:164)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:208)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:357)
Now what next...any other logs required>?
regards
Hi jaichan jai ,
This is certainly DB Connectivity Issue, hence request you to cross verify your SQL Server Configuration especially Network COnfiguration.
Please follow below nagivation path to enable protocoals and remote connection.
Check in Enterprise Manager\Your DB instance\Properties.
In General Tab click Network configuration. On window 'Enabled protocols' You must have TCP/IP and Named Pipes. Named Pipe for DB instance looks like that:
"
.\pipe\MSSQL$<instance_name>\sql\query"
Also check in tab Connections if Your remote server is checked. (Remote server connection - allow other SQL servers to connect remotley to this SQL Server using RPC must be checked".
If You have SQL Windows authentication please login as your WAS administrator and run update again.
Regards
Sekhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shekar
I checked the network Properties -> Named pipe protocols
The name of pipe is "
.\pipe\sql\query". not sure correct or not.
Looks like nothing is working for me....However i can see still DB has come problem or network has some problem.
By seeing log do you get some more specfic place to change?
please advice.
regards
Hi jaichan jai ,
For Named Pipes - entry '
.\pipe\sql\query' is correct.
As a next step to trace the problem - Please run this command from your command prompt
r3trans -d
And provide us the out of this command.
Also, please go through this URL of Microsoft to cross verify all other aspects - http://support.microsoft.com/kb/919023
Regards
Sekhar
Edited by: sekhar on Nov 18, 2009 5:41 AM
hi Sekhar
Thanks for your reply.
Below is the output of execution
OS login as Domain/administrator
displayed error as follows
C:\usr\sap\AJ1\DVEBMGS50\exe>r3trans -d
This is r3trans version 6.19 (release 711 - 22.01.09 - 11:27:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).
I have many users in Security->logins
changed properties in below user
NT AUTHORITY\SYSTEM ->user mapping with all Database AJ1,master,Tempdb etc
but still i get error log_bootstrap.log
[Nov 18, 2009 3:01:48 PM ] Component: [internal/unkown] of type [unkown]
Message: [Exception occurred:]
com.sap.engine.bootstrap.SynchronizationException: Database connection initialization failed. Check if the database is running and the database properties.
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:114)
at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
----------==[ 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:413)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:157)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:48)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:127)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "AJ1" requested by the login. The login failed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
Also i have error log under C:\Programfiles\SQLserver
ERROR LOG.
2009-11-18 15:00:00.29 Logon Error: 18456, Severity: 14, State: 16.
2009-11-18 15:00:00.29 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
Can you be more specific to find out the error location.
regards
Hi Sekhar
Thanks for your replies.
I Solved the problem as follows
In configtool, i changed the Connection pool URL
with Virtual host name, where already Physical host name was already there.
One more thing is Secure store file needs to look for Profile host instead local path..
hence i solve the problem.
Thanks for your support.
regards
Hi
As I mentioned above, you can start DB manually from the location ....mentioned below
<Drive>:\sapdb\<SID>\db\pgm\dbmstart.exe -d <SID>
Please re-start if you it's already started, and stop already running SAP instances and close MMC,
then start DB, start your SAP in newly opened MMC.
I hope this will fix your problem.
Regards
Sekhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Shekar
I restarted Database and now checked the status its running mode.
But after i restart Ciaj1 central instance, i can see below error too in all dev_W0.old...dev_W7.old files
Thread ID:3328
C Thank You for using the SLODBC-interface
C Using dynamic link library 'C:\usr\sap\AJ1\DVEBMGS50\exe\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 21
C patchcomment Wrong JTS Metadata and Substring on Unicode systems (1285992)
C ODBC Driver chosen: SQL Native Client native
C Network connection used from SANSERVER5 to DBAJ1 using tcp:DBAJ1
C
C Tue Nov 17 13:24:34 2009
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
C
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
C
C Tue Nov 17 13:24:50 2009
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
C
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
C
C Tue Nov 17 13:24:59 2009
C Network connection used from SANSERVER5 to DBAJ1 using tcp:DBAJ1
C Driver: SQLNCLI.DLL Driver release: 09.00.3042
C GetDbRelease: 09.00.3042.00
C GetDbRelease: Got DB release numbers (9,0,3042,0)
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX BC HC PRM RCT TIM MAX OPT Date Time DBHost Program
B 000 000 R/3 000000000 ACTIVE NO NO NO YES NO 000 255 255 20091117 132418 DBAJ1
B Successful reconnect for connection:
B 0: name = R/3, con_id = 000000000, state = ACTIVE , tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
B ***LOG BV4=> reconnect state is set for the work process [dblink 1965]
B ***LOG BYY=> work process left reconnect status [dblink 1966]
M ThHdlReconnect: reconnect o.k.
M
M Tue Nov 17 13:25:51 2009
M in_ThErrHandle: 1
M ThIErrHandle: new stat of W0 is WP_SHUTDOWN
M ThIErrHandle: I'm during shutdown
M PfStatDisconnect: disconnect statistics
M ThIErrHandle: entering ThSetStatError
was that something wrong with DB connectivity?
regards
hi Shekar
I restarted Database and now checked the status its running mode.
But after i restart Ciaj1 central instance, i can see below error too in all dev_W0.old...dev_W7.old files
Thread ID:3328
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
C
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
C
C Tue Nov 17 13:24:50 2009
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
C
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 1944]
C (10061) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.C
C Tue Nov 17 13:24:59 2009
C Network connection used from SANSERVER5 to DBAJ1 using tcp:DBAJ1
C Driver: SQLNCLI.DLL Driver release: 09.00.3042
C GetDbRelease: 09.00.3042.00
C GetDbRelease: Got DB release numbers (9,0,3042,0)
B Connection 0 opened (DBSL handle 0)
B ***LOG BV4=> reconnect state is set for the work process [dblink 1965]
B ***LOG BYY=> work process left reconnect status [dblink 1966]
M ThIErrHandle: entering ThSetStatError
was that something wrong with DB connectivity?
regards
Hi jaichan jai,
Please check if you have global share 'sapmnt' available and accessible.
You can perform quick check on this global share availability by accessing '
<hostname>\sapmnt' if sapmnt available as global share you will get in the list also.
As per error, this is purely share access issue. sapcpe.exe is very critical to finish which basically does the sync-up the kernel binaris.
If you see, share is available and you do not suspect any network issue then, Please change the sapcpe.exe file with file from other kernel locations and retry.
Another good idea, is please close your MMC, reopen to try with each time you try to address this issue.
Regards
Sekhar
Edited by: sekhar on Nov 17, 2009 4:44 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.