Stored Procedure - Error during package is created

  • 20 October 2016
  • 3 replies
  • 0 views

Badge +2

During package is created from developent sever, it has ‘Index was out of range issue’ 

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

 

Host server log file continuesly generate error message 

"354179678","2016-10-19 13:04:16","Error","General","0","ErrorMessage","SourceCode.Runtime.Services.Forms","0 EventingMappingFactory.Generate: Unable to retrieve View Guid","anonymous","0.0.0.0","THIK2D02:C:Program Files (x86)K2 blackpearlHost ServerBin","354179678","3dca538018e34d769721fb9dc07d800a",""

 

 

Deployment server package Error in detail –

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

   at System.Collections.Generic.List`1.get_Item(Int32 index)

   at SourceCode.Management.Controls.Tree.TreeNodeAdv.get_NextNode()

   at SourceCode.Management.Controls.Tree.TreeNodeAdv.get_NextVisibleNode()

   at SourceCode.Management.Controls.Tree.TreeViewAdv.<get_VisibleNodes>d__0.MoveNext()

   at SourceCode.Management.Controls.Tree.TreeViewAdv.CreateRowMap()

   at SourceCode.Management.Controls.Tree.TreeViewAdv.UnsafeFullUpdate()

   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()


3 replies

Badge +9

HI,

Can you execute the stored procedure in

1. in the visual studio itself

2. stored procedure smartobject in the sql server tster utility.

 

Badge +2

Execute the stored procedure in smartobject in the sql server tster utility.

-- Works Sucessfully without any error.

 

 

some pointers

- Initialzing of view doesent generate error (initilizing of SMO of stored procedure)

- error is generated when its calling Update 'Another' SMO with value of dropdown list (SP)

 

when we remove dependency, Update SMO has missing control of store procedure drop down list

 

package With dependency, host server generate error

"354179678","2016-10-19 13:04:16","Error","General","0","ErrorMessage","SourceCode.Runtime.Services.Forms","0 EventingMappingFactory.Generate: Unable to retrieve View Guid","anonymous","0.0.0.0","THIK2D02:C:Program Files (x86)K2 blackpearlHost ServerBin","354179678","3dca538018e34d769721fb9dc07d800a",""

 

Badge +9

HI,

can you post your stored procedure?

Reply