Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Moving TMS DB from local to remote

Hi everybody,

yesterday we have moved the TMS DB to a remote Server. Because of the 4GB limit of the SQL Express Server.

Yesterday evening everything looks good.

We are on the Version TMS 14.2.2, with the OS Windows Server 2008 R2 Enterprise SP1.

But today morning we get the following error, when we join the TMS portal.

TMS_error.png

This error occurs at the statistic graph.

TMS_error2.png

We see the same error Page if we try to look at the existing bookings. (Booking--> List conferences)

New bookings can be done and will be connected.

I hope someone has an idea.

We are opening also a TAC Case, but maybe the forum is quicker. :-D

regards

Jens

Everyone's tags (5)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Moving TMS DB from local to remote

[...]

Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

[...]

I think we have found the problem. The SQL Server's default language must be set to English (see the TMS 14.2 installation guide page 7), but your new SQL server seems to use German.

-Kjetil

4 REPLIES
Cisco Employee

Moving TMS DB from local to remote

Hi,

There will be a full stack trace in the log-web.txt log file. Could you post it?

Regards,

Kjetil

New Member

Re: Moving TMS DB from local to remote

Here is a Part of the logfile.

2013-11-21 09:37:52,093 [6] ERROR ASP.global_asax -

Tandberg.TMS.Framework.Db.DatabaseException: Exception of type 'Tandberg.TMS.Framework.Db.DatabaseException' was thrown. ---> System.Data.SqlClient.SqlException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.HasMoreRows()

   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)

   at System.Data.SqlClient.SqlDataReader.Read()

   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)

   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.FillDataset(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.FillDataset(String connectionString, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

   at Tandberg.TMS.Framework.Db.DbHelperTransaction.FillDataset(String connectionString, CommandType commandType, String sqlString, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

   at Tandberg.TMS.Framework.Db.DbHelper.FillDataset(String spName, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

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

   at Tandberg.TMS.Framework.Db.DbHelper.HandleDatabaseException(String spName, SqlException exception, ICollection`1 parameterValues)

   at Tandberg.TMS.Framework.Db.DbHelper.FillDataset(String spName, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.GetConferences_InitConferenceDs(ConferenceQuery query, String systemIds, ConferenceDS conferenceDs)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.<>c__DisplayClass25.b__24(ConferenceDS x)

   at Tandberg.Framework.Util.ExceptionHiding.<>c__DisplayClass2`1.b__1(T x)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Func`2 initializer, Func`1 ifInitalizerFails)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Func`2 initializer)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Action`1 initializer)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Action`1 initializer)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.GetConferences(ConferenceQuery query)

   at Tandberg.TMS.Service.Conferences.ConferenceService.GetConferencesSimpleByQuery(ConferenceQuery conferenceQuery)

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.ShowConferences(SystemId systemId)

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.Show()

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.SetIDAndName(Int64 systemId, String systemName)

   at Tandberg.TMS.UI.SystemNavigator.SystemHost.ShowTab(SystemNavigatorTabs navigatorTab)

   at Tandberg.TMS.UI.SystemNavigator.SystemHost.Show(SystemId systemId, SystemNavigatorTabs tabToShow)

   at Tandberg.TMS.UI.SystemNavigator.SystemNavigator.ShowSystem(SystemId systemId, SystemNavigatorTabs selectedTab)

   at Tandberg.TMS.UI.SystemNavigator.SystemNavigator.folderPageHost_ModuleEvent(Object sender, ModuleControlEventArgs args)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireModuleEvent(ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireCustomAction(String info)

   at Tandberg.TMS.UI.SystemNavigator.FolderPage_Host.folderPageView_ModuleAction(Object sender, ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireModuleEvent(ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireCustomAction(String info)

   at Tandberg.TMS.UI.SystemNavigator.FolderPage_View.uxViewSystemButton_Click(Object sender, EventArgs e)

   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)

   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:37:55,703 [10] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:38:20,359 [10] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:39:44,007 [13] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:39:59,915 [6] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:40:38,247 [6] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:42:58,624 [6] ERROR ASP.global_asax -

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagementOverTime.GenerateStatisticOverTime(StatisticsSetupGraph statisticsSetupGraph, DataSet generatedDataFromDatabase, StatisticsQueryProperties statisticsQueryProperties, Boolean showAverage)

   at Tandberg.TMS.Service.Statistics.StatisticsDataManagement.AddNewDataSetFromSQL(StatisticsSetupGraph statisticsSetupGraph, StatisticsQueryProperties statisticsQueryProperties, StatisticsAxisFormatEnum statisticsAxisFormatEnum, Boolean export)

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.DataBindToChart()

   at Tandberg.TMS.UI.Portal.PortalStatisticsChart.Page_Load(Object sender, EventArgs e)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:44:32,256 [17] WARN  Tandberg.TMS.Framework.Db.DbHelper - procedure failed: NET_Scheduling_GetConferencesAndParticipants, underlying error: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

2013-11-21 09:44:32,256 [17] WARN  Tandberg.TMS.Framework.Db.DbHelper - Procedure parameters:

    @intUserId = -1

    @intStatusId = -1

    @strSystemIds = 290

    @dtmStartTimeUtc = 21/11/2013 00:00:00

    @dtmEndTimeUtc = 29/11/2013 00:00:00

    @intConferenceId = -1

    @bolRecurrent = False

    @textSearch =

    @OnlyRecordedConferences = False

    @ShowAdHoc = False

    @Type = All

    @bolGetParticipants = False

2013-11-21 09:44:32,256 [17] ERROR ASP.global_asax -

Tandberg.TMS.Framework.Db.DatabaseException: Exception of type 'Tandberg.TMS.Framework.Db.DatabaseException' was thrown. ---> System.Data.SqlClient.SqlException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.HasMoreRows()

   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)

   at System.Data.SqlClient.SqlDataReader.Read()

   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)

   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.FillDataset(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.FillDataset(String connectionString, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

   at Tandberg.TMS.Framework.Db.DbHelperTransaction.FillDataset(String connectionString, CommandType commandType, String sqlString, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

   at Tandberg.TMS.Framework.Db.DbHelper.FillDataset(String spName, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

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

   at Tandberg.TMS.Framework.Db.DbHelper.HandleDatabaseException(String spName, SqlException exception, ICollection`1 parameterValues)

   at Tandberg.TMS.Framework.Db.DbHelper.FillDataset(String spName, DataSet dataSet, String[] tableNames, SqlParameter[] parameterValues)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.GetConferences_InitConferenceDs(ConferenceQuery query, String systemIds, ConferenceDS conferenceDs)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.<>c__DisplayClass25.b__24(ConferenceDS x)

   at Tandberg.Framework.Util.ExceptionHiding.<>c__DisplayClass2`1.b__1(T x)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Func`2 initializer, Func`1 ifInitalizerFails)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Func`2 initializer)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Func`1 allocator, Action`1 initializer)

   at Tandberg.Framework.Util.ExceptionHiding.SafelyInitDisposable[T](Action`1 initializer)

   at Tandberg.TMS.Service.Conferences.ConferenceServiceDB.GetConferences(ConferenceQuery query)

   at Tandberg.TMS.Service.Conferences.ConferenceService.GetConferencesSimpleByQuery(ConferenceQuery conferenceQuery)

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.ShowConferences(SystemId systemId)

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.Show()

   at Tandberg.TMS.UI.SystemNavigator.SystemPortal.SetIDAndName(Int64 systemId, String systemName)

   at Tandberg.TMS.UI.SystemNavigator.SystemHost.ShowTab(SystemNavigatorTabs navigatorTab)

   at Tandberg.TMS.UI.SystemNavigator.SystemHost.Show(SystemId systemId, SystemNavigatorTabs tabToShow)

   at Tandberg.TMS.UI.SystemNavigator.SystemNavigator.ShowSystem(SystemId systemId, SystemNavigatorTabs selectedTab)

   at Tandberg.TMS.UI.SystemNavigator.SystemNavigator.folderPageHost_ModuleEvent(Object sender, ModuleControlEventArgs args)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireModuleEvent(ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireCustomAction(String info)

   at Tandberg.TMS.UI.SystemNavigator.FolderPage_Host.folderPageView_ModuleAction(Object sender, ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireModuleEvent(ModuleControlEventArgs e)

   at Tandberg.TMS.Service.Navigation.TMSModuleBase.FireCustomAction(String info)

   at Tandberg.TMS.UI.SystemNavigator.FolderPage_View.uxViewSystemButton_Click(Object sender, EventArgs e)

   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)

   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2013-11-21 09:50:42,972 [13] WARN  Tandberg.TMS.Framework.Db.DbHelper - procedure failed: NET_DatabaseManagement_GetFreeDiskSpace, underlying error: Die EXECUTE-Berechtigung wurde für das sp_OACreate-Objekt, mssqlsystemresource-Datenbank, sys-Schema, verweigert.

Die EXECUTE-Berechtigung wurde für das sp_OADestroy-Objekt, mssqlsystemresource-Datenbank, sys-Schema, verweigert.

2013-11-21 09:50:43,003 [13] WARN  Tandberg.TMS.Framework.Db.DbHelper - procedure failed: sp_helpdb, underlying error: Die tmspe                                                                                                                           -Datenbank ist nicht vorhanden. Geben Sie einen gültigen Datenbanknamen an. Mit 'sys.databases' können Sie die verfügbaren Datenbanken anzeigen.

2013-11-21 09:50:43,003 [13] WARN  Tandberg.TMS.Framework.Db.DbHelper - Procedure parameters:

    @dbname = tmspe

2013-11-21 09:51:23,410 [7] WARN  Tandberg.TMS.Framework.Db.DbHelper - procedure failed: NET_DatabaseManagement_GetFreeDiskSpace, underlying error: Die EXECUTE-Berechtigung wurde für das sp_OACreate-Objekt, mssqlsystemresource-Datenbank, sys-Schema, verweigert.

Die EXECUTE-Berechtigung wurde für das sp_OADestroy-Objekt, mssqlsystemresource-Datenbank, sys-Schema, verweigert.

2013-11-21 09:51:23,426 [7] WARN  Tandberg.TMS.Framework.Db.DbHelper - procedure failed: sp_helpdb, underlying error: Die tmspe                                                                                                                           -Datenbank ist nicht vorhanden. Geben Sie einen gültigen Datenbanknamen an. Mit 'sys.databases' können Sie die verfügbaren Datenbanken anzeigen.

2013-11-21 09:51:23,426 [7] WARN  Tandberg.TMS.Framework.Db.DbHelper - Procedure parameters:

    @dbname = tmspe


I hope this helps.

I have tried the upgrade to 14.3.1. The Upgrade was successful, but error is the same.

Cisco Employee

Re: Moving TMS DB from local to remote

[...]

Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

[...]

I think we have found the problem. The SQL Server's default language must be set to English (see the TMS 14.2 installation guide page 7), but your new SQL server seems to use German.

-Kjetil

New Member

Re: Moving TMS DB from local to remote

Hi everybody,

but the problem was that the server was on the wrong language "german".

Then the next problem was the DB Admins was not able to change that. Because there are several

databases on the server and this is a global option.

Maybe it is not supported, but our solution is to change just the language setting of the SQL-User.

Everything works fine.

thanks a lot to Kjetil.

643
Views
0
Helpful
4
Replies
CreatePlease to create content