Part creation does not work in SP12
Althouth most other methods work using SOAP with the server but part creation fails with the followign errors. "Cannot insert the value NULL into column 'ITEM_NUMBER'"
Soap input and response both are given here. I have tried various combinations of other attributes such as id, keyed_name, etc etc but no success. It always complained about item_number and item_number was always supplied.
Request SOAP Message:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../" xmlns:m="">http://www.aras-corp.com/">
<SOAP-ENV:Header/>
<SOAP-ENV:Body>
<Item action="add" item_number="paertffff876565" type="part"/>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Response SOAP Message:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Cannot insert the value NULL into column 'ITEM_NUMBER', table 'InnovatorSolutions.innovator.PART'; column does not allow nulls. INSERT fails.
The statement has been terminated. in SQL: INSERT INTO [PART] ( [CONFIG_ID],[COST],[COST_BASIS],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[HAS_CHANGE_PENDING],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MAKE_BUY],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[THUMBNAIL],[UNIT],[WEIGHT],[WEIGHT_BASIS] ) 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 )]]></faultstring><detail><af:legacy_detail><![CDATA[Cannot insert the value NULL into column 'ITEM_NUMBER', table 'InnovatorSolutions.innovator.PART'; column does not allow nulls. INSERT fails.
The statement has been terminated. in SQL: INSERT INTO [PART] ( [CONFIG_ID],[COST],[COST_BASIS],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[HAS_CHANGE_PENDING],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MAKE_BUY],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[THUMBNAIL],[UNIT],[WEIGHT],[WEIGHT_BASIS] ) 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 )]]></af:legacy_detail><af:exception message="Cannot insert the value NULL into column 'ITEM_NUMBER', table 'InnovatorSolutions.innovator.PART'; column does not allow nulls. INSERT fails.
The statement has been terminated. in SQL: INSERT INTO [PART] ( [CONFIG_ID],[COST],[COST_BASIS],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EFFECTIVE_DATE],[GENERATION],[HAS_CHANGE_PENDING],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MAKE_BUY],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELEASE_DATE],[STATE],[SUPERSEDED_DATE],[TEAM_ID],[THUMBNAIL],[UNIT],[WEIGHT],[WEIGHT_BASIS] ) 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 )" type="Aras.Server.Core.InnovatorDatabaseException"><af:innerException message="Cannot insert the value NULL into column 'ITEM_NUMBER', table 'InnovatorSolutions.innovator.PART'; column does not allow nulls. INSERT fails.
The statement has been terminated." type="System.Data.SqlClient.SqlException" /></af:exception></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
