Skip to main content
Solved

Parameter not contained by this SqlParameterCollection

  • August 25, 2022
  • 1 reply
  • 147 views

Forum|alt.badge.img+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. 

Best answer by Mark Jongeling

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

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3936 replies
  • Answer
  • August 25, 2022

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings