+1
Fixed

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

Anonymous 1 year ago in Studio / Designer • updated by Genie 1 year 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 designer debug

this is causing trouble to access stored procedure.

Under review

Hi We are looking into it.

What version of MySQL?
What version of Warewolf?
Do you get the error when testing the stored proc to get the output variables or at run time?

Warewolf is Latest, MySQL is 5.77.14 and yes both design and run time testing I am getting this error

Hi,


Issue has been resolved and will be in the next release.


Thanks