My requirement:
Submit > Review > Verify > Status
Created a Lifecycle:
Submit > In Verification > Verified > Pending > Closed v vRejected Unverified
Created a Workflow:
Start > Review DOC > Verify DOC > Approve > Pending v v Rejected Unverified
I have Created a new ItemType called “Docs”.
Included
“Properties”
“RelationshipTypes”
“Views - Forms”
“Lifecycles - ‘Docs’”
Trying to create a workflow related to “Lifecycle - Docs”......
I have defined all “activity” and “promotions” based on the “Lifecycle - Docs”....
When i click “save,unlock&close” it shows following error….
Cannot insert the value NULL into column 'CONTROLLED_ITEMTYPE', table 'InnovatorSolutions.innovator.ACTIVITY_TEMPLATE_TRANSITION'; column does not allow nulls. INSERT fails. The statement has been terminated. in SQL: INSERT INTO [ACTIVITY_TEMPLATE_TRANSITION] ( [BEHAVIOR],[CONFIG_ID],[CONTROLLED_ITEMTYPE],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[EVENT],[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],[RELATED_ID],[SORT_ORDER],[SOURCE_ID],[STATE],[TEAM_ID] ) 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 )
What is this error? I am new to Aras?
Anybody plz help me…...
I had understood the error....
Cannot insert the value NULL into column ‘CONTROLLED_ITEMTYPE’, table ‘InnovatorSolutions.innovator.ACTIVITY_TEMPLATE_TRANSITION’; column does not allow nulls. INSERT fails.‘CONTROLLED_ITEMTYPE’ should not null.
How can i add value for the column?
yeah... I have found what i did wrong.
On activity "Pending".... I had defined "Promotions"....
In "Promotions" Tab i Missed "ItemType" So, I got an Error.
