Re: view composer not starting

Octavius · ‎07-30-2012

Hi,

I am having a problem with VMview Composer not running on the vCenter server. The service will not start and the logs have the error:

2012-07-30 08:49:52,093 | 6 | INFO | Sim.WebService.SimServer - SVI service is starting.

2012-07-30 08:50:04,828 | 6 | FATAL | Sim.WebService.SimServer - Invalid SVI database schema version.

VMware.Sim.ServiceCore.Exception.SimDaoException: No valid versioning data is found in the database

Not too sure where to go next on this but I have a nagging feeling it is an authentication issue.

Any help is appreciated.

Thanks

The following error is in the logs:

-----------Sim Web Service Log Start-----------

Build: 481620

Os Type: win64-x64

API Version: 2.1

Product Version: 2.7.0.4529

2012-07-30 08:49:52,093 | 6 | INFO | Sim.WebService.SimServer - SVI service is starting.

2012-07-30 08:50:04,828 | 6 | FATAL | Sim.WebService.SimServer - Invalid SVI database schema version.

VMware.Sim.ServiceCore.Exception.SimDaoException: No valid versioning data is found in the database.

Server stack trace:

at VMware.Sim.ServiceCore.Persistence.DoMgrFactory.CheckSchemaVersion()

at VMware.Sim.WebService.SimServer.Init()

at VMware.Sim.WebService.SimServer.<SimStart>b__2()

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)

at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)

at VMware.Sim.WebService.SimServer.WorkerFunction.EndInvoke(IAsyncResult result)

at VMware.Sim.WebService.SimServer.SimStart(String[] args)

at VMware.Sim.WebService.SimServer.OnStart(String[] args), Machine Name: vcen01, Timestamp: 30/07/2012 07:50:04, App Domain Name: SviWebService.exe, Thread Identity: , Windows Identity:xxxxx\xxxxx, OS Version: Microsoft Windows NT 6.1.7601 Service Pack 1, reason: EmptyDbSchemaVersion

2012-07-30 08:50:04,843 | 6 | INFO | Sim.WebService.SimServer - SVI service started successfully.

2012-07-30 08:50:04,859 | 7 | INFO | Sim.WebService.SimServer - SVI service status Running.

2012-07-30 08:50:06,859 | 7 | INFO | Sim.WebService.SimServer - SVI service is stopping.

2012-07-30 08:50:07,187 | 7 | INFO | Sim.WebService.SimServer - SVI service stopped successfully.

------------Sim Web Service Log End-------------

mittim12 · ‎07-31-2012

Did you perform an update that may have updated the composer database and then went back to an older version of composer?

KWittusen · ‎08-01-2012

Hi,

I have the exact same problem, cant start VMware composer service it only stops all the time. Read somewhere that reinstalling the composer could help, but i tried this and it said something about the database and it had to do a reinitalization or something like that, i allowed that and everything started.

I was very happy and connect to administration portal and suddenly i could open all my pools and so on, but when i tryied to add more computers to the pool it would not compose any, something wrong with databas.

If you find any solution to this let me know.

I wont post the logfile since it looks the same.

mittim12 · ‎08-01-2012

Do you have the exact verbiage it used when it errored out after trying to add more computers to the pool?

Octavius · ‎08-02-2012

Hi

Thanks for the replies. I am not aware of any upgrades, but I have only just been given this server to look after. Looking at logs from earlier in the month I noticed other issues which may give a clue. I beleive the previous admin fixed this older error but following a reboot of the server our issue above began.

Cheers

------------Sim Web Service Log Start-----------

Build: 481620

Os Type: win64-x64

API Version: 2.1

Product Version: 2.7.0.4529

2012-07-01 21:04:30,702 | 6 | INFO | Sim.WebService.SimServer - SVI service is starting.

2012-07-01 21:04:34,160 | 7 | ERROR | NHibernate.Util.ADOExceptionReporter - ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'SVI_VERSION'.

2012-07-01 21:04:34,176 | 7 | FATAL | ServiceCore.Persistence.TranCollector -

TranId:96024831-3fd2-4a36-93cb-c4c95a84d84d, queries:QueryCriteria method before, type:SimDbVersionDo,

Stack Trace:

GetStackTrace

Add

QueryCriteria

EnumerateAll

GetDbSchemaVersion

CheckSchemaVersion

Init

<SimStart>b__2

_PrivateProcessMessage

AsyncProcessMessage

ThreadPoolCallBack

Run

PerformWaitCallbackInternal

PerformWaitCallback

Stack Trace:

GetStackTrace

Log

QueryCriteria

EnumerateAll

GetDbSchemaVersion

CheckSchemaVersion

Init

<SimStart>b__2

_PrivateProcessMessage

AsyncProcessMessage

ThreadPoolCallBack

Run

PerformWaitCallbackInternal

PerformWaitCallback

2012-07-01 21:04:34,176 | 7 | FATAL | ServiceCore.Persistence.SimDaoHelper - Log and throw: Hibernate threw exception during QueryCriteria.

NHibernate.ADOException: could not execute query

[ SELECT this_.VERSION as VERSION17_0_, this_."DATE" as column2_17_0_, this_."COMMENT" as column3_17_0_ FROM SVI_VERSION this_ ]

[SQL: SELECT this_.VERSION as VERSION17_0_, this_."DATE" as column2_17_0_, this_."COMMENT" as column3_17_0_ FROM SVI_VERSION this_] ---> System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'SVI_VERSION'.

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)

at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)

at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)

at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)

at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

--- End of inner exception stack trace ---

at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)

at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)

at NHibernate.Impl.CriteriaImpl.List(IList results)

at NHibernate.Impl.CriteriaImpl.List[T]()

at VMware.Sim.ServiceCore.Persistence.SimDaoGeneric`2.QueryCriteria(ICriteria criteria)

2012-07-01 21:04:34,191 | 7 | FATAL | ServiceCore.Persistence.SimDaoHelper - A DAO exception is thrown:

VMware.Sim.ServiceCore.Exception.SimDaoException: Hibernate threw exception during QueryCriteria. ---> NHibernate.ADOException: could not execute query