cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem when sync SDM and BC_COMPVERS

Former Member

on ‎05-26-2008 9:28 AM

0 Kudos

Dear All,

I got problem when run following command:

sdm.bat systemcomponentstate "mode=sync"

And return following error:

Synchronization of all Deployments with the system omponent state failed (Could not initialize CVersManager. No synchronization is possible. Can not load mandatory table BC_COMPVERS, desc == null).

Successfully executed. Return code: 0

I already change it to standalone mode. Please help! Thanks in advance.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185954
Active Contributor
‎05-26-2008 12:03 PM
0 Kudos

Hello,

Which version of J2EE do you have ?

Also, have you tried running in debug mode.

activate the debug mode as described in Note 914580

Then attach the current .log files (slutil.log and sdm.log) of the day in question from the directory program\log post the log here.

Regards,

Siddhesh

Show replies
Show replies
Former Member
‎05-26-2008 2:24 PM
0 Kudos

I tried and message is talking about CVERS cannot update table BC_COMPVERS.

I will post the log tomorrow as I'm not in office now.

Former Member
‎05-27-2008 4:52 AM
0 Kudos

slutil.log:

May 26, 2008 4:32:46 PM  com.sap.sl.util.components.impl.ComponentFactory: 16:32:46 /Applications/SL/UTIL entering class com.sap.sl.util.components.impl.ComponentFactory
May 26, 2008 4:32:46 PM  com.sap.sl.util.components.impl.ComponentFactory: 16:32:46 /Applications/SL/UTIL entering class com.sap.sl.util.components.impl.ComponentFactory
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersFactory: 16:32:48 /Applications/SL/UTIL entering class com.sap.sl.util.cvers.impl.CVersFactory
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersFactory:   slutiltrace, entering createCVersManager(dataSource)
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: 16:32:48 /Applications/SL/UTIL entering class com.sap.sl.util.cvers.impl.CVersManager
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, --> entering CVersManager (DataSource)
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory: 16:32:48 /Applications/SL/UTIL entering class com.sap.sl.util.cvers.impl.TableDescriptionFactory
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory:   slutiltrace, currentTableDescription = null
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescription: 16:32:48 /Applications/SL/UTIL entering class com.sap.sl.util.cvers.impl.TableDescription
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescription:   slutiltrace, TableDescription name='BC_SCVERSION'
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_SCVERSION'.
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load table description for table BC_SCVERSION exc: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_SCVERSION'.
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, --> entering closeConnection CVersManager
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, <--- exiting closeConnection CVersManager
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory:   slutiltrace, currentTableDescription = null
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescription:   slutiltrace, TableDescription name='BC_COMPVERS'
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load table description for table BC_COMPVERS exc: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load mandatory table BC_COMPVERS, desc == null Exc=java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager:   slutiltrace, stack trace: Exc=java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
	at com.sap.sl.util.cvers.impl.TableDescriptionFactory.getTableDescription(TableDescriptionFactory.java:137)
	at com.sap.sl.util.cvers.impl.CVersManager.loadTable(CVersManager.java:74)
	at com.sap.sl.util.cvers.impl.CVersManager.loadDBStructure(CVersManager.java:161)
	at com.sap.sl.util.cvers.impl.CVersManager.openDBSource(CVersManager.java:193)
	at com.sap.sl.util.cvers.impl.CVersManager.<init>(CVersManager.java:266)
	at com.sap.sl.util.cvers.impl.CVersFactory.createCVersManager(CVersFactory.java:48)
	at com.sap.sdm.app.cvers.wrapper.CVersFactory.createCVersManager(CVersFactory.java:69)
	at com.sap.sdm.app.cvers.deplobs.impl.CVersSyncerImpl.sync(CVersSyncerImpl.java:52)
	at com.sap.sdm.control.command.cmds.SystemComponentState.execute(SystemComponentState.java:96)
	at com.sap.sdm.control.command.decorator.AssureOneRunningSDMOnly.execute(AssureOneRunningSDMOnly.java:61)
	at com.sap.sdm.control.command.decorator.SDMInitializer.execute(SDMInitializer.java:52)
	at com.sap.sdm.control.command.decorator.GlobalParamEvaluator.execute(GlobalParamEvaluator.java:60)
	at com.sap.sdm.control.command.decorator.AbstractLibDirSetter.execute(AbstractLibDirSetter.java:46)
	at com.sap.sdm.control.command.decorator.ExitPostProcessor.execute(ExitPostProcessor.java:48)
	at com.sap.sdm.control.command.decorator.CommandNameLogger.execute(CommandNameLogger.java:49)
	at com.sap.sdm.control.command.decorator.AdditionalLogFileSetter.execute(AdditionalLogFileSetter.java:65)
	at com.sap.sdm.control.command.decorator.AbstractLogDirSetter.execute(AbstractLogDirSetter.java:54)
	at com.sap.sdm.control.command.decorator.SyntaxChecker.execute(SyntaxChecker.java:37)
	at com.sap.sdm.control.command.Command.exec(Command.java:42)
	at SDM.main(SDM.java:21)
May 26, 2008 4:32:48 PM  com.sap.sl.util.cvers.impl.CVersManager: stack trace: 
[EXCEPTION]
 java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
	at com.sap.sl.util.cvers.impl.TableDescriptionFactory.getTableDescription(TableDescriptionFactory.java:137)
	at com.sap.sl.util.cvers.impl.CVersManager.loadTable(CVersManager.java:74)
	at com.sap.sl.util.cvers.impl.CVersManager.loadDBStructure(CVersManager.java:161)
	at com.sap.sl.util.cvers.impl.CVersManager.openDBSource(CVersManager.java:193)
	at com.sap.sl.util.cvers.impl.CVersManager.<init>(CVersManager.java:266)
	at com.sap.sl.util.cvers.impl.CVersFactory.createCVersManager(CVersFactory.java:48)
	at com.sap.sdm.app.cvers.wrapper.CVersFactory.createCVersManager(CVersFactory.java:69)
	at com.sap.sdm.app.cvers.deplobs.impl.CVersSyncerImpl.sync(CVersSyncerImpl.java:52)
	at com.sap.sdm.control.command.cmds.SystemComponentState.execute(SystemComponentState.java:96)
	at com.sap.sdm.control.command.decorator.AssureOneRunningSDMOnly.execute(AssureOneRunningSDMOnly.java:61)
	at com.sap.sdm.control.command.decorator.SDMInitializer.execute(SDMInitializer.java:52)
	at com.sap.sdm.control.command.decorator.GlobalParamEvaluator.execute(GlobalParamEvaluator.java:60)
	at com.sap.sdm.control.command.decorator.AbstractLibDirSetter.execute(AbstractLibDirSetter.java:46)
	at com.sap.sdm.control.command.decorator.ExitPostProcessor.execute(ExitPostProcessor.java:48)
	at com.sap.sdm.control.command.decorator.CommandNameLogger.execute(CommandNameLogger.java:49)
	at com.sap.sdm.control.command.decorator.AdditionalLogFileSetter.execute(AdditionalLogFileSetter.java:65)
	at com.sap.sdm.control.command.decorator.AbstractLogDirSetter.execute(AbstractLogDirSetter.java:54)
	at com.sap.sdm.control.command.decorator.SyntaxChecker.execute(SyntaxChecker.java:37)
	at com.sap.sdm.control.command.Command.exec(Command.java:42)
	at SDM.main(SDM.java:21)
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersFactory:   slutiltrace, entering createCVersManager(dataSource)
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, --> entering CVersManager (DataSource)
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory:   slutiltrace, currentTableDescription = null
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescription:   slutiltrace, TableDescription name='BC_SCVERSION'
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_SCVERSION'.
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load table description for table BC_SCVERSION exc: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_SCVERSION'.
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, --> entering closeConnection CVersManager
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: slutiltrace, <--- exiting closeConnection CVersManager
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory:   slutiltrace, currentTableDescription = null
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescription:   slutiltrace, TableDescription name='BC_COMPVERS'
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.TableDescriptionFactory: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load table description for table BC_COMPVERS exc: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: Can not load mandatory table BC_COMPVERS, desc == null Exc=java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager:   slutiltrace, stack trace: Exc=java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
	at com.sap.sl.util.cvers.impl.TableDescriptionFactory.getTableDescription(TableDescriptionFactory.java:137)
	at com.sap.sl.util.cvers.impl.CVersManager.loadTable(CVersManager.java:74)
	at com.sap.sl.util.cvers.impl.CVersManager.loadDBStructure(CVersManager.java:161)
	at com.sap.sl.util.cvers.impl.CVersManager.openDBSource(CVersManager.java:193)
	at com.sap.sl.util.cvers.impl.CVersManager.<init>(CVersManager.java:266)
	at com.sap.sl.util.cvers.impl.CVersFactory.createCVersManager(CVersFactory.java:48)
	at com.sap.sdm.app.cvers.wrapper.CVersFactory.createCVersManager(CVersFactory.java:69)
	at com.sap.sdm.app.cvers.deplobs.impl.CVersProxyImpl.updateCVers(CVersProxyImpl.java:134)
	at com.sap.sdm.persistency.RepositoryPersistor.persistRepository(RepositoryPersistor.java:54)
	at com.sap.sdm.control.command.cmds.SystemComponentState.execute(SystemComponentState.java:118)
	at com.sap.sdm.control.command.decorator.AssureOneRunningSDMOnly.execute(AssureOneRunningSDMOnly.java:61)
	at com.sap.sdm.control.command.decorator.SDMInitializer.execute(SDMInitializer.java:52)
	at com.sap.sdm.control.command.decorator.GlobalParamEvaluator.execute(GlobalParamEvaluator.java:60)
	at com.sap.sdm.control.command.decorator.AbstractLibDirSetter.execute(AbstractLibDirSetter.java:46)
	at com.sap.sdm.control.command.decorator.ExitPostProcessor.execute(ExitPostProcessor.java:48)
	at com.sap.sdm.control.command.decorator.CommandNameLogger.execute(CommandNameLogger.java:49)
	at com.sap.sdm.control.command.decorator.AdditionalLogFileSetter.execute(AdditionalLogFileSetter.java:65)
	at com.sap.sdm.control.command.decorator.AbstractLogDirSetter.execute(AbstractLogDirSetter.java:54)
	at com.sap.sdm.control.command.decorator.SyntaxChecker.execute(SyntaxChecker.java:37)
	at com.sap.sdm.control.command.Command.exec(Command.java:42)
	at SDM.main(SDM.java:21)
May 26, 2008 4:32:49 PM  com.sap.sl.util.cvers.impl.CVersManager: stack trace: 
[EXCEPTION]
 java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Invalid object name 'BC_COMPVERS'.
	at com.sap.sl.util.cvers.impl.TableDescriptionFactory.getTableDescription(TableDescriptionFactory.java:137)
	at com.sap.sl.util.cvers.impl.CVersManager.loadTable(CVersManager.java:74)
	at com.sap.sl.util.cvers.impl.CVersManager.loadDBStructure(CVersManager.java:161)
	at com.sap.sl.util.cvers.impl.CVersManager.openDBSource(CVersManager.java:193)
	at com.sap.sl.util.cvers.impl.CVersManager.<init>(CVersManager.java:266)
	at com.sap.sl.util.cvers.impl.CVersFactory.createCVersManager(CVersFactory.java:48)
	at com.sap.sdm.app.cvers.wrapper.CVersFactory.createCVersManager(CVersFactory.java:69)
	at com.sap.sdm.app.cvers.deplobs.impl.CVersProxyImpl.updateCVers(CVersProxyImpl.java:134)
	at com.sap.sdm.persistency.RepositoryPersistor.persistRepository(RepositoryPersistor.java:54)
	at com.sap.sdm.control.command.cmds.SystemComponentState.execute(SystemComponentState.java:118)
	at com.sap.sdm.control.command.decorator.AssureOneRunningSDMOnly.execute(AssureOneRunningSDMOnly.java:61)
	at com.sap.sdm.control.command.decorator.SDMInitializer.execute(SDMInitializer.java:52)
	at com.sap.sdm.control.command.decorator.GlobalParamEvaluator.execute(GlobalParamEvaluator.java:60)
	at com.sap.sdm.control.command.decorator.AbstractLibDirSetter.execute(AbstractLibDirSetter.java:46)
	at com.sap.sdm.control.command.decorator.ExitPostProcessor.execute(ExitPostProcessor.java:48)
	at com.sap.sdm.control.command.decorator.CommandNameLogger.execute(CommandNameLogger.java:49)
	at com.sap.sdm.control.command.decorator.AdditionalLogFileSetter.execute(AdditionalLogFileSetter.java:65)
	at com.sap.sdm.control.command.decorator.AbstractLogDirSetter.execute(AbstractLogDirSetter.java:54)
	at com.sap.sdm.control.command.decorator.SyntaxChecker.execute(SyntaxChecker.java:37)
	at com.sap.sdm.control.command.Command.exec(Command.java:42)
	at SDM.main(SDM.java:21)

sdmlog:

<!LOGHEADER[START]/>
<!HELP[Manual modification of the header may cause parsing problem!]/>
<!LOGGINGVERSION[1.5.3.7185 - 630]/>
<!NAME[C:\usr\sap\BWD\DVEBMGS00\SDM\program\log\sdmlog20080526.log]/>
<!PATTERN[sdmlog20080526.log]/>
<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %s: %m)]/>
<!ENCODING[UTF8]/>
<!LOGHEADER[END]/>
May 26, 2008 4:25:04 PM  Info: 
May 26, 2008 4:25:04 PM  Info: ==============================================
May 26, 2008 4:25:04 PM  Info: =   Starting to execute command 'jstartup'   =
May 26, 2008 4:25:04 PM  Info: ==============================================
May 26, 2008 4:25:04 PM  Info: Starting SDM - Software Deployment Manager...
May 26, 2008 4:25:04 PM  Info: tc/SL/SDM/SDM/sap.com/SAP AG/7.0013.20070717141415.0000
May 26, 2008 4:25:05 PM  Info: SDM operation mode successfully set to: Integrated
May 26, 2008 4:25:06 PM  Info: Initializing Network Manager (50017)
May 26, 2008 4:25:06 PM  Info: Checking if another SDM is running on port 50018
May 26, 2008 4:25:06 PM  Info: 
May 26, 2008 4:25:06 PM  Info: SDM operation mode successfully set to: Standalone
May 26, 2008 4:25:08 PM  Warning: Caught CVersProxyAccessException while saving repository: CVersAccessException: Can not load mandatory table BC_COMPVERS, desc == null
May 26, 2008 4:25:08 PM  Info: Operationmode for JStartupFramework set to "standalone".
May 26, 2008 4:25:08 PM  Info: Successfully executed. Return code: 0
May 26, 2008 4:26:14 PM  Info: 
May 26, 2008 4:26:14 PM  Info: ==========================================================
May 26, 2008 4:26:14 PM  Info: =   Starting to execute command 'systemcomponentstate'   =
May 26, 2008 4:26:14 PM  Info: ==========================================================
May 26, 2008 4:26:14 PM  Info: Starting SDM - Software Deployment Manager...
May 26, 2008 4:26:14 PM  Info: tc/SL/SDM/SDM/sap.com/SAP AG/7.0013.20070717141415.0000
May 26, 2008 4:26:15 PM  Info: SDM operation mode successfully set to: Standalone
May 26, 2008 4:26:16 PM  Info: Initializing Network Manager (50017)
May 26, 2008 4:26:16 PM  Info: Checking if another SDM is running on port 50018
May 26, 2008 4:26:16 PM  Info: Sync all deployed components with the system component version store.
May 26, 2008 4:26:16 PM  Warning: Synchronization of all Deployments with the system component state failed (Could not initialize CVersManager. No synchronization is possible. Can not load mandatory table BC_COMPVERS, desc == null).
May 26, 2008 4:26:16 PM  Info: Successfully executed. Return code: 0
May 26, 2008 4:32:46 PM  Info: 
May 26, 2008 4:32:46 PM  Info: ==========================================================
May 26, 2008 4:32:46 PM  Info: =   Starting to execute command 'systemcomponentstate'   =
May 26, 2008 4:32:46 PM  Info: ==========================================================
May 26, 2008 4:32:46 PM  Info: Starting SDM - Software Deployment Manager...
May 26, 2008 4:32:46 PM  Info: tc/SL/SDM/SDM/sap.com/SAP AG/7.0013.20070717141415.0000
May 26, 2008 4:32:47 PM  Info: SDM operation mode successfully set to: Standalone
May 26, 2008 4:32:48 PM  Info: Initializing Network Manager (50017)
May 26, 2008 4:32:48 PM  Info: Checking if another SDM is running on port 50018
May 26, 2008 4:32:48 PM  Info: Sync all deployed components with the system component version store.
May 26, 2008 4:32:48 PM  Warning: Synchronization of all Deployments with the system component state failed (Could not initialize CVersManager. No synchronization is possible. Can not load mandatory table BC_COMPVERS, desc == null).
May 26, 2008 4:32:49 PM  Warning: Caught CVersProxyAccessException while saving repository: CVersAccessException: Can not load mandatory table BC_COMPVERS, desc == null
May 26, 2008 4:32:49 PM  Info: Activated system component state synchronizations
May 26, 2008 4:32:49 PM  Info: Successfully executed. Return code: 0

Former Member
‎05-27-2008 8:25 AM
0 Kudos

Problem solved, SDM user should use SAP<SID>DB instead of <SID>

Former Member
‎06-30-2008 5:04 PM
0 Kudos

I just ran into this error after applying support packages and JAVA patches. How do you change the SDM to user the different schema?

Former Member
‎07-03-2008 2:50 AM
0 Kudos

Start your SDM GUI and login, highlight CONFIG_DB, and in the right hand side part, click Configuration. In Username field, change the value to SAP<SID>DB.

Ask a Question