Fehler
+1
Fixed
Parameter 'warewolf-variable' not found in the collection.
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;
Customer support service by UserEcho
this is causing trouble to access stored procedure.
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
Hello Team,
any updates on this?
Hi,
Issue has been resolved and will be in the next release.
Thanks