How to create itemtype Requirement using C#? Getting error that cannot pass null value in column.
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.
