Buy or Renew
Buy or Renew
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: 
cancel
Start a conversation
1446
Views
0
Helpful
4
Replies

Moving TMS DB from local to remote

Go to solution
JensLantermann
Level 1
Level 1

‎11-20-2013 11:36 PM - edited ‎03-18-2019 02:10 AM

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

Labels:
0 Helpful
1 Accepted Solution

Accepted Solutions

Go to solution
Kjetil Ree
Cisco Employee
Cisco Employee
In response to Kjetil Ree

‎11-21-2013 03:06 AM 

[...]
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

View solution in original post

0 Helpful
4 Replies 4

Go to solution
Kjetil Ree
Cisco Employee
Cisco Employee

‎11-21-2013 01:27 AM

Hi,

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

Regards,

Kjetil

0 Helpful

Go to solution
JensLantermann
Level 1
Level 1
In response to Kjetil Ree

‎11-21-2013 02:03 AM

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.

0 Helpful

Go to solution
Kjetil Ree
Cisco Employee
Cisco Employee
In response to Kjetil Ree

‎11-21-2013 03:06 AM 

[...]
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

0 Helpful

Go to solution
JensLantermann
Level 1
Level 1

‎11-22-2013 01:10 AM

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.

0 Helpful
Customers Also Viewed These Support Documents