disp+work --> yellow, after SQL server database homogenous copy.

[Former Member]

Hi there.

I've finished a copy of an SQL Server database (homogenous system - Same DB/Same OS only different host machine - different SID) according to note 151603.

Please note that I'm using schema system (MCOD) and the source/destination system are both SQL Server 2005.

Basically I've done:

1- Stop the SAP source system.

2- Detached source database.

3- Copied the data and log files to destination (renamed after - NEW SID).

4- Attached the target database (WITH NEW DATABASE NAME)

Follow-up procedure:

Note: 551915 (user_change.txt --> SID Changed)

And still followed till the end note 151603 (including new license).

After a reboot of the new server the SAP seems OK, however I've noticed on MMC that disp+work appears yellow with:

"J2EE status info unavailable".

I can work perfectly with SAP (SAP ECC 60), but I want to solve this error.

I've checked several log files (dev_bootstrap, dev_disp, dev_control and jvm_bootstrap.out) and it seems that the following error is the cause of this error:

Jvm_bootstrap.out:

-

---

Bootstrap MODE:

<INSTANCE GLOBALS>

determined by parameter [ID0096263].

-

---

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 occurred during DB access: cluster_data,

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(PersistenceHandler.java:108)

at com.sap.engine.core.configuration.impl.cache.CachedConfiguration.<init>(CachedConfiguration.java:62)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(ConfigurationCache.java:848)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(ConfigurationCache.java:882)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.openConfiguration(ConfigurationCache.java:748)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openConfiguration(ConfigurationHandlerImpl.java:734)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openConfiguration(ConfigurationHandlerImpl.java:693)

at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:62)

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: java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'J2EE_CONFIG'.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.sap.nwmss.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:281)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:248)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.getConfiguration(DBAccessDefault.java:578)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(PersistenceHandler.java:102)

... 15 more

[Bootstrap module]> Problem occurred while performing synchronization.

Dev_disp:

Tue May 20 21:02:50 2008

J2EE server info

start = TRUE

state = STARTED

pid = 5864

argv[0] = E:\usr\sap\TEP\DVEBMGS00\exe\jcontrol.EXE

argv[1] = E:\usr\sap\TEP\DVEBMGS00\exe\jcontrol.EXE

argv[2] = pf=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=2809

argv[5] = -DSAPSYSTEM=00

argv[6] = -DSAPSYSTEMNAME=TEP

argv[7] = -DSAPMYNAME=erptep_TEP_00

argv[8] = -DSAPPROFILE=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

DpJ2eeLogin: j2ee state = CONNECTED

Tue May 20 21:02:53 2008

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4248]

• ERROR => NiIRead: SiRecv failed for hdl 6 / sock 192

(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:2810) [nixxi.cpp 4248]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=5864)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Tue May 20 21:03:10 2008

DpEnvCheckJ2ee: switch off j2ee start flag

Dev_jcontrol:

-

---

trc file: "E:\usr\sap\TEP\DVEBMGS00\work\dev_jcontrol", trc level: 1, release: "700"

-

---

node name : jcontrol

pid : 5864

system name : TEP

system nr. : 00

started at : Tue May 20 21:02:50 2008

arguments :

arg[00] : E:\usr\sap\TEP\DVEBMGS00\exe\jcontrol.EXE

arg[01] : pf=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

arg[02] : -DSAPSTART=1

arg[03] : -DCONNECT_PORT=2809

arg[04] : -DSAPSYSTEM=00

arg[05] : -DSAPSYSTEMNAME=TEP

arg[06] : -DSAPMYNAME=erptep_TEP_00

arg[07] : -DSAPPROFILE=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

arg[08] : -DFRFC_FALLBACK=ON

arg[09] : -DFRFC_FALLBACK_HOST=localhost

[Thr 5988] Tue May 20 21:02:50 2008

[Thr 5988] *** WARNING => INFO: Unknown property [instance.box.number=TEPDVEBMGS00erptep] [jstartxx.c 841]

[Thr 5988] *** WARNING => INFO: Unknown property [instance.en.host=erptep] [jstartxx.c 841]

[Thr 5988] *** WARNING => INFO: Unknown property [instance.en.port=3201] [jstartxx.c 841]

[Thr 5988] *** WARNING => INFO: Unknown property [instance.system.id=0] [jstartxx.c 841]

**********************************************************************

JStartupReadInstanceProperties: read instance properties [E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties;E:\usr\sap\TEP\DVEBMGS00\SDM\program\config\sdm_jstartup.properties]

-> ms host : erptep

-> ms port : 3901

-> OS libs : E:\usr\sap\TEP\DVEBMGS00\j2ee\os_libs

-> Admin URL :

-> run mode : NORMAL

-> run action : NONE

-> enabled : yes

**********************************************************************

**********************************************************************

Used property files

-> files [00] : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> files [01] : E:\usr\sap\TEP\DVEBMGS00\SDM\program\config\sdm_jstartup.properties

**********************************************************************

**********************************************************************

Instance properties

-> ms host : erptep

-> ms port : 3901

-> os libs : E:\usr\sap\TEP\DVEBMGS00\j2ee\os_libs

-> admin URL :

-> run mode : NORMAL

-> run action : NONE

-> enabled : yes

**********************************************************************

**********************************************************************

Bootstrap nodes

-> [00] bootstrap : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> [01] bootstrap_ID9626300 : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> [02] bootstrap_ID9626350 : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

**********************************************************************

**********************************************************************

Worker nodes

-> [00] ID9626300 : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> [01] ID9626350 : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> [02] sdm : E:\usr\sap\TEP\DVEBMGS00\SDM\program\config\sdm_jstartup.properties

**********************************************************************

[Thr 5988] JControlExecuteBootstrap: execute bootstrap process [bootstrap]

[Thr 4188] JControlDPMessageProxy: Thread 4188 started as handler thread for R/3 dispatcher messages.

[Thr 5988] [Node: bootstrap] java home is set by profile parameter

Java Home: C:\j2sdk1.4.2_16-x64

[Thr 5988] JStartupICheckFrameworkPackage: can't find framework package E:\usr\sap\TEP\DVEBMGS00\exe\jvmx.jar

**********************************************************************

JStartupIReadSection: read node properties [bootstrap]

-> node name : bootstrap

-> node type : bootstrap

-> node execute : yes

-> java path : C:\j2sdk1.4.2_16-x64

-> java parameters : -Djco.jarm=1

-> java vm version : 1.4.2_16-b05

-> java vm vendor : Java HotSpot(TM) 64-Bit Server VM (Sun Microsystems Inc.)

-> java vm type : server

-> java vm cpu : amd64

-> heap size : 256M

-> root path : E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster

-> class path : .\bootstrap\launcher.jar

-> OS libs path : E:\usr\sap\TEP\DVEBMGS00\j2ee\os_libs

-> main class : com.sap.engine.offline.OfflineToolStart

-> framework class : com.sap.bc.proj.jstartup.JStartupFramework

-> registr. class : com.sap.bc.proj.jstartup.JStartupNatives

-> framework path : E:\usr\sap\TEP\DVEBMGS00\exe\jstartup.jar;E:\usr\sap\TEP\DVEBMGS00\exe\jvmx.jar

-> parameters : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0096263

-> debuggable : yes

-> debug mode : no

-> debug port : 60000

-> shutdown timeout : 120000

**********************************************************************

**********************************************************************

JControlStartJLaunch: program = E:\usr\sap\TEP\DVEBMGS00\exe\jlaunch.exe

-> arg[00] = E:\usr\sap\TEP\DVEBMGS00\exe\jlaunch.exe

-> arg[01] = pf=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

-> arg[02] = -DSAPINFO=TEP_00_bootstrap

-> arg[03] = -nodeId=-1

-> arg[04] = -file=E:\usr\sap\TEP\DVEBMGS00\j2ee\cluster\instance.properties

-> arg[05] = -syncSem=JSTARTUP_WAIT_ON_5864

-> arg[06] = -nodeName=bootstrap

-> arg[07] = -jvmOutFile=E:\usr\sap\TEP\DVEBMGS00\work\jvm_bootstrap.out

-> arg[08] = -stdOutFile=E:\usr\sap\TEP\DVEBMGS00\work\std_bootstrap.out

-> arg[09] = -locOutFile=E:\usr\sap\TEP\DVEBMGS00\work\dev_bootstrap

-> arg[10] = -mode=BOOTSTRAP

-> arg[11] = pf=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

-> arg[12] = -DSAPSTART=1

-> arg[13] = -DCONNECT_PORT=2811

-> arg[14] = -DSAPSYSTEM=00

-> arg[15] = -DSAPSYSTEMNAME=TEP

-> arg[16] = -DSAPMYNAME=erptep_TEP_00

-> arg[17] = -DSAPPROFILE=E:\usr\sap\TEP\SYS\profile\TEP_DVEBMGS00_erptep

-> arg[18] = -DFRFC_FALLBACK=ON

-> arg[19] = -DFRFC_FALLBACK_HOST=localhost

-> lib path = PATH=C:\j2sdk1.4.2_16-x64\jre\bin\server;C:\j2sdk1.4.2_16-x64\jre\bin;C:\Program Files\HP\NCU;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;E:\usr\sap\TEP\SYS\exe\uc\NTAMD64

-> exe path = PATH=C:\j2sdk1.4.2_16-x64\bin;E:\usr\sap\TEP\DVEBMGS00\j2ee\os_libs;C:\Program Files\HP\NCU;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;E:\usr\sap\TEP\SYS\exe\uc\NTAMD64

**********************************************************************

[Thr 5988] Tue May 20 21:02:52 2008

[Thr 5988] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx.c 1642]

[Thr 5988] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)

[Thr 5988] JControlCloseProgram: started (exitcode = 66)

[Thr 5988] JControlCloseProgram: good bye... (exitcode = 66)

Also, I've notice also that config tool (j2ee/configtool) can't connect to database, following error:

Error: Error occurred during DB access: ,

Details:

com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred during DB access: , at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.getAllRootConfigsMetaData(PersistenceHandler.java:245) at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getAllRootConfigsMetaData(ConfigurationCache.java:655) at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.getAllRootConfigsMetaData(ConfigurationHandlerImpl.java:621) at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.getAllRootConfigsInfos(ConfigurationHandlerImpl.java:1070) at com.sap.engine.services.configuration.gui.RootTreeNode.load(RootTreeNode.java:50) at com.sap.engine.services.configuration.gui.BaseTreeNode.loadDisplayException(BaseTreeNode.java:62) at com.sap.engine.services.configuration.gui.RootTreeNode.initialize(RootTreeNode.java:33) at com.sap.engine.services.configuration.gui.RootTreeNode.<init>(RootTreeNode.java:27) at com.sap.engine.services.configuration.gui.DisplayAllConfigurationsPanel.initHierarchyPanel(DisplayAllConfigurationsPanel.java:104) at com.sap.engine.services.configuration.gui.DisplayAllConfigurationsPanel.<init>(DisplayAllConfigurationsPanel.java:92) at com.sap.engine.services.configuration.gui.ConfigurationHandlerEditor.<init>(ConfigurationHandlerEditor.java:30) at com.sap.engine.services.configuration.gui.ToolLauncher.main(ToolLauncher.java:41) 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: java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'J2EE_CONFIG'. at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source) at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source) at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at com.sap.nwmss.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at com.sap.nwmss.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.sap.nwmss.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at com.sap.nwmss.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.sap.nwmss.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at com.sap.nwmss.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.sap.nwmss.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) at com.sap.nwmss.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source) at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97) at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:281) at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:248) at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.getSubConfigurations(DBAccessDefault.java:552) at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.getAllRootConfigsMetaData(PersistenceHandler.java:241)

... 16 more

I've already read note 997510 (Troubleshooting J2EE Engine 6.40/7.0 Bootstrap Issues) but it didn't solve this issue.

Can anyone help me with this mystery?! I really need some urgent help on this issue.

Kind Regards

Armando Santos

[Former Member]

Hai,

After a reboot of the new server the SAP seems OK, however I've noticed on MMC that disp+work appears yellow with:

"J2EE status info unavailable".----

---

> Check whether the all the J2EE process are working fine or not.

Also check the check in the SQL Enterprise Manager,whether the user SAP<SID>DB got enough permissions and Permit in the Databaserole or not(Public,db_owner....)

Compare with the other systems and check.

In the Security, check the SAP<SID>DB login as Permissions or not.

Thanks and Regards,