0
Under review
Stephen 3 weeks ago in Studio / Designer • updated by Genie 5 days ago 1

Hi,


I'm trying to build a new dll and have some issues with it, when adding it to a step in warewolf workflow.


I've used this resource of creating the dll: https://warewolf.io/knowledge-base/using-dlls/


1. I've notice that different namespaces does not work well (after i fixed namespaces then methods works).


2. Then when u include my data layer on my new dll then the workflow raize an "Object Refrence Not Set",


NB* : I've tested my dll with UnitTests and the dll does work just in warewolf workflow is not working.


Did anyone else have this same issue, and what is the best practice of using the dll component in warewolf workflow.

+1
Fixed
Anonymous 7 months ago in Studio / Designer • updated by Genie 7 months 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
+1
Fixed
Anonymous 2 years ago in Studio / Designer • updated by Genie 2 years ago 2
Error wokflow : 

Why when I click an the "New service" Button shows me an error ?
Why when I try to open the workflow  "Hello world" whows me an error?

System.Windows.Markup.XamlParseException: Se produjo una excepción al establecer connectionId. ---> System.InvalidCastException: No se puede convertir un objeto de tipo 'System.Windows.Input.CommandBinding' al tipo 'System.Activities.Presentation.View.DesignerView'.



designer studio workflow
0
Declined
Anonymous 3 years ago in Studio / Designer • updated by Gandalf 2 years ago 4
Hi guys,

Just a suggestion. The Decision tool at the moment will have 2 grey lines coming out of it, (1 for the true output and 1 for the false output). This is fine for simple workflows, however as the workflows get more and more complex, there are instances where outputs from decisions will overlap each other and head toward the same assign/workflow/process etc. Is is possible that when clicked on, the decision tool itself and the output lines are highlighted as well so that somebody using the program would have an easier time following the process flow with having to open up the tools to have a look at the outputs?

Regards
designer studio
Answer
Gandalf 3 years ago
Hi

It sounds like you are trying to abstract the studio into a web page?

This is not possible with Warewolf. The studio is a desktop application that has no public interfaces at this stage.

Please let us know if this is not what you are asking.
0
Completed
Paul Cannell 3 years ago in Studio / Designer • updated by Gandalf 2 years ago 2
Rather than have to click on the settings box for a service, can we not simply dble click like you can on a decision
Answer
Gandalf 2 years ago
Nice idea Paul. We will give it some thought.
0
Completed
Paul Cannell 3 years ago in Studio / Designer • updated by Gandalf 2 years ago 2
Until I used it in the workflow. This does makes sense but typically I would design the interface to my workflow and then implement bit by bit. I may only need the 3rd input param later on and Im still testing the first bits. But I cant pass this until later.
think of it this way. When you define an interface method you dont make them parameterless you generally know what you want to achieve. Perhaps a hint popup to let us know 
Answer
Gandalf 2 years ago
We agree. There is a quite a bit that needs to be done to the variable list.

Thanks for the idea.
0
Completed
Paul Cannell 3 years ago in Studio / Designer • updated by Gandalf 2 years ago 2
I create a class library. I firstly discover that you cant return .Net basic types (string, int, bool etc) once I returned a class things were fine. Perhaps this needs to be in a hint :)
However in discovering this I rebuilt my dll a number of times. I couldnt copy it to the place I had referenced because warewolf has a handle to that DLL. Im assuming you host components like this in a separate appDomain so if you give me the ability to recycle that so I can do a build / deploy cycle without me having to shutdown warewolf would be great. If you can already do this and I just havnt figured out how, ... well then shame on me :)
Answer
Gandalf 2 years ago
Thanks Paul. We are looking into both your issues.
0
Completed
Paul Cannell 3 years ago in Studio / Designer • updated by Gandalf 1 year ago 4
Assume a simple credit matrix. Based on your income you will get 1 of 3 interest rates.
Income > 10000 goes to the 1st outcome, >8000 the 2nd and > 5000 the third.
In the current version you have to make a tree looking like the left pic in the diagram.
If you attached priorities to a decision you could make it look like the second diagram. Say your income is 9000, you will fail the first check but pass both 2 and 3, however if you have a priority you would pass the income > 8000 check and stop evaluation at that point. Maybe a useful idea? Things like risk pricing models would benefit greatly from this and the designer space would look far less cluttered
Answer
Gandalf 1 year ago
Without the pictures mentioned I am left to guess.

My guess is you are talking about bundling up individual decisions into a single decision tree activity that would act like a switch.

Is this correct?

0
Completed
Paul Cannell 3 years ago in Studio / Designer • updated by Gandalf 3 years ago 0
If I have  vars, A and B (type bool) I have something like 
if A==1
AND IF B==0
the decision reads "If A==1" in the designer canvas which is acttual misleading
Answer
Gandalf 3 years ago
Thanks Paul. The WWF designer limits the space that can be used there. We felt it was better to put in what you can rather than nothing at all as a default.

We also added the ability for you to put the text there that you want (check the bottom of the decision) so you can overide the default.