Error: Procedure or function Proc_CMS_WebFarmTask_Insert has too many arguments specified.

Kaiya Karges asked on October 29, 2014 02:44

Any idea what could be causing this, or how to prevent it?


Procedure or function Proc_CMS_WebFarmTask_Insert has too many arguments specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function Proc_CMS_WebFarmTask_Insert has too many arguments specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Procedure or function Proc_CMS_WebFarmTask_Insert has too many arguments specified.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action 1 wrapCloseInAction) +1787814 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action 1 wrapCloseInAction) +5341674 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +90 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource 1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +137 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88 CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +262

Proc_CMS_WebfarmTask_Insert

Caused exception: Procedure or function Proc_CMS_WebFarmTask_Insert has too many arguments specified. ] CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) +206 CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +547 CMS.DataEngine.AbstractDataConnection.CMS.DataEngine.IDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +52 CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +391 CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +521 CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryText, QueryDataParameters parameters, QueryTypeEnum queryType, Boolean transaction) +117 CMS.WebFarmSync.WebSyncHelper.CreateTask(String taskType, String taskTarget, String taskTextData, BinaryData taskBinaryData, Int32 serverId) +1028 CMS.WebFarmSync.WebFarmService.CreateTask(String taskType, String taskTarget, String taskTextData, BinaryData taskBinaryData) +45 CMS.Helpers.WebFarmHelper.CreateTask(String taskType, String taskTarget, String taskTextData, BinaryData taskBinaryData) +59 CMS.Helpers.CacheSynchronization.LogTouchKeysTask(IEnumerable 1 keys) +99 CMS.Helpers.CacheHelper.TouchKeys(IEnumerable 1 keys, Boolean logTasks, Boolean ensureKeys) +294 CMS.DataEngine.AbstractInfo 1.TouchKeys() +96 CMS.DataEngine.AbstractInfo 1.FinalizeSaving() +98 CMS.DataEngine.AbstractInfo 1.InsertData() +192 CMS.DataEngine.GeneralizedInfoWrapper.InsertData() +53 CMS.DataEngine.AbstractInfoProvider 2.SetInfo(TInfo info) +804 CMS.WebFarmSync.WebFarmServerInfoProvider.SetWebFarmServerInternal(WebFarmServerInfo infoObj) +39 CMS.WebFarmSync.WebFarmServerInfoProvider.SetWebFarmServerInfo(WebFarmServerInfo infoObj) +54 CMS.WebFarmSync.WebSyncHelper.CreateAutomaticServer() +565 CMS.WebFarmSync.WebSyncHelper.InitWebFarm() +28 CMS.WebFarmSync.WebFarmSyncHandlers.InitWebFarm(Object sender, EventArgs e) +31 CMS.Base.AbstractHandler.CallEventHandler(EventHandler 1 h, TArgs e) +157 CMS.Base.AbstractHandler.Raise(String partName, List 1 list, TArgs e, Boolean important) +1017 CMS.Base.SimpleHandler 2.RaiseExecute(TArgs e) +143 CMS.Base.SimpleHandler 2.RaiseExecute(TArgs e) +213 CMS.Base.SimpleHandler 2.StartEvent(TArgs e) +455 CMS.DataEngine.CMSApplication.Init() +1246 CMS.DataEngine.CMSHttpApplication.Init(Object sender, EventArgs e) +31 CMS.Base.AbstractHandler.CallEventHandler(EventHandler 1 h, TArgs e) +157 CMS.Base.AbstractHandler.Raise(String partName, List 1 list, TArgs e, Boolean important) +1017 CMS.Base.SimpleHandler 2.RaiseExecute(TArgs e) +143 CMS.Base.SimpleHandler 2.RaiseExecute(TArgs e) +213 CMS.Base.SimpleHandler 2.StartEvent(TArgs e) +455 CMS.Base.ApplicationModule.BeginRequest(Object sender, EventArgs e) +49 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +237 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +114

Recent Answers


Kaiya Karges answered on October 29, 2014 19:37

Update:

Once we disabled all of the web farm settings in config->settings->versioning from a machine that was able to connect, the machine having this issue was also able to connect.

Our trial license had expired on Oct 23rd, which could have contributed to this issue.

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.