How to create itemtype Requirement using C#? Getting error that cannot pass null value in column.

Bhoomi Gupta — Fri, 17 Jul 2020 14:24:19 GMT

Hello,

I am currently using Aras Innovator 12.0 and Requirement Engineering module version 12.0R1.

I am trying to create Requirement itemtype by using following C# code:

Input to the function is given in SOAP UI as:

I am getting an error on this for null value in managed_by_id while I have already given value for managed_by_id.The value given for managed_by_id is taken from aras database.(Database record was for a Requirement added through UI).

Error Message:

<s:Envelope xmlns:s="">schemas.xmlsoap.org/.../">
<s:Body>
<s:Fault>
<faultcode xmlns:a="">schemas.microsoft.com/.../faultcode>
<faultstring xml:lang="en-US">Aras Web Service Error =Exception occur during create entity , Aras Error Code =SOAP-ENV:Server and Aras Error Message =Cannot insert the value NULL into column 'MANAGED_BY_ID', table 'InnovatorSolutions.innovator.RE_REQUIREMENT'; column does not allow nulls. INSERT fails.
The statement has been terminated. in SQL: INSERT INTO [RE_REQUIREMENT] ( [CONFIG_ID],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[REQ_CATEGORY],[REQ_COMPLEXITY],[REQ_DOCUMENT_TYPE],[REQ_GROUP],[REQ_PRIORITY],[REQ_RISK],[REQ_RM_TITLE],[REQ_TIER],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[ITEM_NUMBER] ) VALUES ( @p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31 )</faultstring>
<detail>
<ExceptionDetail xmlns="">schemas.datacontract.org/.../System.ServiceModel" xmlns:i="">www.w3.org/.../XMLSchema-instance">
<HelpLink i:nil="true"/>
<InnerException i:nil="true"/>
<Message>Aras Web Service Error =Exception occur during create entity , Aras Error Code =SOAP-ENV:Server and Aras Error Message =Cannot insert the value NULL into column 'MANAGED_BY_ID', table 'InnovatorSolutions.innovator.RE_REQUIREMENT'; column does not allow nulls. INSERT fails.
The statement has been terminated. in SQL: INSERT INTO [RE_REQUIREMENT] ( [CONFIG_ID],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[REQ_CATEGORY],[REQ_COMPLEXITY],[REQ_DOCUMENT_TYPE],[REQ_GROUP],[REQ_PRIORITY],[REQ_RISK],[REQ_RM_TITLE],[REQ_TIER],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[ITEM_NUMBER] ) VALUES ( @p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31 )</Message>
<Type>com.opshub.aras.service.exception.ArasWebAPIExceptions</Type>
</ExceptionDetail>
</detail>
</s:Fault>
</s:Body>
</s:Envelope>

I am not able to find reason for such failure because of null as I am explicitly passing the value for managed_by_id.

Thanks in advance.

Ask A Question I

Fri, 17 Jul 2020 06:56:55 GMT

Ask a question in a forum.

Bhoomi Gupta さんの グループ アクティビティ

How to create itemtype Requirement using C#? Getting error that cannot pass null value in column.

Ask A Question I

Bhoomi Gupta さんのグループアクティビティ