Solved

Parameter not contained by this SqlParameterCollection

  • 25 August 2022
  • 1 reply
  • 98 views

Userlevel 1
Badge +4

I’m receiving this error message while opening the product through IAM which has rights on this column. However he gets this error. When I log in with an admin account I won't get the error.

This is probably a right problem but does anyone know how to solve this?

Stored procedure 'lay_artikel' genereerde een fout bij het afleiden van de parameters.  Informatie: Parameter 30 - extra_id (kolom): An SqlParameter with ParameterName '@extra_id' is not contained by this SqlParameterCollection. 

icon

Best answer by Mark Jongeling 25 August 2022, 09:11

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +23

Hi Maarten,

We had found out together that the datatype of the parameter @extra_id was not granted to the role Public. This caused the Windows GUI to be unsuccessful to execute the layout properly. After running the following code, the problem was resolved:

grant references on type::"extra_id" to public
go