0
Answered

SQL Bulk Insert

ahmad zikri 7 years ago in Studio / Sources updated by Gandalf 7 years ago 5

I've been trying to use SQL Bulk Insert service however with Oracle i unable to choose table:

Image 330

database
Answer
Gandalf 7 years ago

Hi Ahmad

The bulk insert is for Microsoft SQL server.

0
Fixed

Object reference not set to an instance of an object.

Anonymous 7 years ago in Studio updated by Gandalf 7 years ago 1
Email Address : No Email Provided Steps to follow : Launched Warewolf. Error indicating localhost not connected is displayed. Clicked OK. Right click localhost, click on Version. Popup for version displays. Close popup for version. Right click localhost, click on Version. (second time) Warewolf Hangs. Force close Warewolf. Relaunch Warewolf. Error displays. at Warewolf.Studio.Core.PopupViewManageEffects.AddBlackOutEffect(Grid blackoutGrid) at Warewolf.Studio.Views.SplashPage.Show(Boolean isDialog) at Dev2.Studio.ViewModels.MainViewModel.ShowAboutBox() at Warewolf.Studio.ViewModels.EnvironmentViewModel.ShowServerVersionAbout() at Microsoft.Practices.Prism.Commands.DelegateCommand.<>c__DisplayClass6.<.ctor>b__2(Object o) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass2.<.ctor>b__0(Object arg) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.d__7.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.b__6_0(Object state) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Fixed

Critical : Warewolf Must Restart. All open tabs will be saved. Please take the time to report this error to the community.

Anonymous 7 years ago in Studio updated by anonymous 7 years ago 5
Server Version : 0.0.6152.14896

Studio Version : 0.0.6152.15730

Email Address : pieter.terblanche@dev2.co.za

Steps to follow : Right click on a folder in the Explorer, then select Open which will expand the folder. Then collapse the folder and right click again on the same folder. Notice this error occurs.

at System.Windows.Rect.set_X(Double value)
at Infragistics.Controls.Menus.XamContextMenu.GetTargetRect()
at Infragistics.Controls.Menus.XamContextMenu.SetPopupPosition()
at Infragistics.Controls.Menus.XamContextMenu.Popup_Opened(Object sender, EventArgs e)
at System.Windows.FrameworkElement.RaiseClrEvent(EventPrivateKey key, EventArgs args)
at System.Windows.Controls.Primitives.Popup.OnOpened(EventArgs e)
at System.Windows.Controls.Primitives.Popup.CreateWindow(Boolean asyncCall)
at System.Windows.Controls.Primitives.Popup.OnIsOpenChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
at System.Windows.Controls.Primitives.Popup.set_IsOpen(Boolean value)
at Infragistics.Controls.Menus.XamContextMenu.OnContextMenuOpened()
at Infragistics.Controls.Menus.XamContextMenu.OnIsOpenChanged(DependencyObject target, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
at Infragistics.Controls.Menus.XamContextMenu.set_IsOpen(Boolean value)
at Infragistics.Controls.Menus.ContextMenuService.PositionContextMenu(XamContextMenu contextMenu, Point p, UIElement parentElement)
at Infragistics.Controls.Menus.ContextMenuManager.OpenContextMenu(Object sender, Point p)
at Infragistics.Controls.Menus.ContextMenuManager.Element_MouseRightButtonUpImpl(Object sender, Func`2 getPosition)
at Infragistics.Controls.Menus.ContextMenuManager.Element_MouseRightButtonUp(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Fixed

Critical : Warewolf Must Restart. All open tabs will be saved. Please take the time to report this error to the community.

Anonymous 7 years ago in Studio updated by anonymous 7 years ago 5
Server Version : 0.0.6151.20090

Studio Version : 0.0.6151.20100

Email Address : BB

Steps to follow : 1. Dropped comment onto design surface and clicked inside it

at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)
at System.Activities.Presentation.Model.ModelItemCollectionImpl.CopyTo(ModelItem[] array, Int32 arrayIndex)
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at System.Activities.Presentation.View.VariableHelper.FindDeclaredVariables(ModelItem element, IList`1 scopeList)
at System.Activities.Presentation.View.VariableDesigner.Populate(ModelItem workflowElement)
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged()
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyPropertyKey key, Object value)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelectedCore(ModelItem primarySelection)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelected(Selection newSelection)
at System.Activities.Presentation.ContextItemManager.SubscribeProxy`1.SubscribeContext(ContextItem item)
at System.Activities.Presentation.SubscribeContextCallback.Invoke(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.OnItemChanged(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.SetValue(ContextItem value)
at System.Activities.Presentation.View.Selection.Union(EditingContext context, ModelItem itemToAdd)
at Dev2.Studio.ViewModels.Workflow.WorkflowDesignerViewModel.ViewPreviewMouseDown(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Answered

Oracle Database Source

ahmad zikri 7 years ago in Studio / Sources updated by anonymous 7 years ago 1

Hi. Why when I create Oracle database source the database choices are limited to HR, SCOTT, OE, PM, SH and IX

There should be user that i create as database. For example, there be include 'SPBO2' as if in normal oracle query it will be SELECT * FROM SPBO2.TABLENAME

Thank you

database
Answer
anonymous 7 years ago

Hi,


The databases are limited to the databases that the that you have logged in with has access to, using the following command


SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'))


Thanks

0
Fixed

Critical : Warewolf Must Restart. All open tabs will be saved. Please take the time to report this error to the community.

Anonymous 7 years ago in Studio updated by Gandalf 7 years ago 1
Server Version : 0.0.6149.19322

Studio Version : 0.0.6149.19332

Email Address : BB

Steps to follow : 1. Drag on a switch
2. Drag on a Comment and connect it on the drop
3. Click the comment and drag it
OBSERVE: This error

at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)
at System.Activities.Presentation.Model.ModelItemCollectionImpl.CopyTo(ModelItem[] array, Int32 arrayIndex)
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at System.Activities.Presentation.View.VariableHelper.FindDeclaredVariables(ModelItem element, IList`1 scopeList)
at System.Activities.Presentation.View.VariableDesigner.Populate(ModelItem workflowElement)
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged()
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyPropertyKey key, Object value)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelectedCore(ModelItem primarySelection)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelected(Selection newSelection)
at System.Activities.Presentation.ContextItemManager.SubscribeProxy`1.SubscribeContext(ContextItem item)
at System.Activities.Presentation.SubscribeContextCallback.Invoke(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.OnItemChanged(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.SetValue(ContextItem value)
at System.Activities.Presentation.View.Selection.Union(EditingContext context, ModelItem itemToAdd)
at Dev2.Studio.ViewModels.Workflow.WorkflowDesignerViewModel.ViewPreviewMouseDown(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Fixed

Object reference not set to an instance of an object.

Anonymous 7 years ago in Studio updated by Gandalf 7 years ago 1
Server Version : 0.0.6149.19322 Studio Version : 0.0.6149.19332 Email Address : BB Steps to follow : Saving a new policy. Was using latest dev. at Warewolf.Studio.ViewModels.EnvironmentViewModel.d__294.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() at Warewolf.Studio.ViewModels.EnvironmentViewModel.d__289.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() at Warewolf.Studio.ViewModels.ExplorerViewModelBase.d__50.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() at Warewolf.Studio.ViewModels.ExplorerViewModelBase.d__49.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() at Warewolf.Studio.ViewModels.ExplorerViewModel.<b__21_0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.b__6_0(Object state) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Fixed

Destination array was not long enough. Check destIndex and length, and the array's lower bounds.

Anonymous 7 years ago in Studio updated by Gandalf 7 years ago 1
Server Version : 0.0.6148.29055

Studio Version : 0.0.6148.29065

Email Address : BB

Steps to follow : 1. Dragged two new windows out.
2. Saved 1
Error: window stayed open and design surface dissapeared to a new docked window.
3. Created a new workflow and dragged it out.
Error: this stack trace. I think that the workspace needs to know about the state and position of the window.

at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)
at System.Activities.Presentation.Model.ModelItemCollectionImpl.CopyTo(ModelItem[] array, Int32 arrayIndex)
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at System.Activities.Presentation.View.VariableHelper.FindDeclaredVariables(ModelItem element, IList`1 scopeList)
at System.Activities.Presentation.View.VariableDesigner.Populate(ModelItem workflowElement)
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged()
at System.Activities.Presentation.View.VariableDesigner.OnVariableScopeChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyPropertyKey key, Object value)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelectedCore(ModelItem primarySelection)
at System.Activities.Presentation.View.VariableDesigner.OnItemSelected(Selection newSelection)
at System.Activities.Presentation.ContextItemManager.SubscribeProxy`1.SubscribeContext(ContextItem item)
at System.Activities.Presentation.SubscribeContextCallback.Invoke(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.OnItemChanged(ContextItem item)
at System.Activities.Presentation.EditingContext.DefaultContextItemManager.SetValue(ContextItem value)
at System.Activities.Presentation.View.Selection.SelectOnly(EditingContext context, ModelItem itemToSelect)
at System.Activities.Presentation.WorkflowViewElement.OnMouseDown(MouseButtonEventArgs e)
at System.Windows.UIElement.OnMouseDownThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
0
Answered

PostgreSQL and MySQL

Anonymous 7 years ago updated by Pieter 7 years ago 8

Hello,

I have a question regarding PostgreSQL and MySQL. I have a database in MySQL for now and a stored procedure to insert data. Despite the fact everything is good, and user have authenticated access over procedure, Warewolf seems cannot list the procedure.

Here are the details of procedure:

DELIMITER $$
CREATE PROCEDURE rfidautomatic_INSERT(IN uid varchar(45))
BEGIN
insert into webtest.rfid_uid (rfiduid) values (uid);
END
DELIMITER ;

tool
+1
Fixed

Parameter 'warewolf-variable' not found in the collection.

Anonymous 7 years ago in Studio / Designer updated by anonymous 7 years ago 9

When calling a MySql stored procedure, We are getting bug:


<FatalError><Message> An internal error occurred while executing the service request </Message><InnerError>Parameter 'rfiduid' not found in the collection.

at MySql.Data.MySqlClient.MySqlParameterCollection.GetParameterFlexible(String parameterName, Boolean throwOnNotFound)
at MySql.Data.MySqlClient.StoredProcedure.GetAndFixParameter(String spName, MySqlSchemaRow param, Boolean realAsFloat, MySqlParameter returnParameter)
at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Dev2.Services.Sql.MySqlServer.ExecuteReader[T](IDbCommand command, CommandBehavior commandBehavior, Func`2 handler)
at Dev2.Services.Execution.DatabaseServiceExecution.MySqlExecution(ErrorResultTO errors, Int32 update)</InnerError><InnerError><InnerError>Parameter 'rfiduid' not found in the collection.
at MySql.Data.MySqlClient.MySqlParameterCollection.GetParameterFlexible(String parameterName, Boolean throwOnNotFound)
at MySql.Data.MySqlClient.StoredProcedure.GetAndFixParameter(String spName, MySqlSchemaRow param, Boolean realAsFloat, MySqlParameter returnParameter)
at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Dev2.Services.Sql.MySqlServer.ExecuteReader[T](IDbCommand command, CommandBehavior commandBehavior, Func`2 handler)
at Dev2.Services.Execution.DatabaseServiceExecution.MySqlExecution(ErrorResultTO errors, Int32 update)</InnerError></InnerError></FatalError>

-----------------------------------------------------------------------------------------------

Procedure:


CALL`rfidautomatic_INSERT`('rfiduid'rfidautomatic_INSERTDELIMITER $$
CREATE DEFINER=`webtest`@`%` PROCEDURE `rfidautomatic_INSERT`(IN `rfiduid` VARCHAR(45))
BEGIN
insert into rfid_uid (rfiduid) values (rfiduid);
END$$
DELIMITER ;

);


------------------------------------------------------------------------------------

Table:

CREATE TABLE `rfid_uid` (

`rfidno` int(11) NOT NULL AUTO_INCREMENT,
`rfiduid` varchar(45) NOT NULL,
PRIMARY KEY (`rfidno`),
UNIQUE KEY `rfid_uid_UNIQUE` (`rfiduid`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

database debug designer