Facing issue in insert record activity.

Follow

Rakesh Burde

• February 12, 2020 12:36
• Edited

In my process app, I have a form. I did not use Data model to map form filed with data table.
I use insert record activity for it. When I run insert record activity then I get message

"Cannot insert the value NULL into column 'ID', table 'PayableInvoice__u'; column does not allow nulls. INSERT fails. The statement has been terminated." 

So I create a process variable and assign its value = @${GUID} 

and map this filed to ID in insert record activity.

But I get error message "Invalid cast from 'System.String' to 'System.Guid'."

 

 

0

• 

  sysberry GmbH

  • February 12, 2020 21:25

  Hi Rakesh,

  the ID should be automatically created, you don't need to fill it. If you need the ID in process after the insert record activity, then you can specify to store the response in that variable inside the insert record activity.
  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  AgilePoint NX Support

  • February 23, 2020 04:52

  Hello Rakesh,

   

  Is it possible to share the export copy of Application and the Entity structure with us?

  You can create a new ticket at our Ticket system or connect with your AgilePoint point of contact to pass it on to us.

   

  Thanks,

  AgilePoint Support

  0

  Comment actions Permalink
• 

  Alan McCabe

  • March 08, 2021 19:13

  We recently faced this same issue and the support team helped with the following solution:

  1. Using an Update Process Data task, create a new variable with an appropriate name like "convertedGUID" and use the expression Guid.Parse(Convert.ToString(string_holding_the_guid)) to set it.  You will see then in your process data at run time a new variable of type "q1:guid".
  2. Now you can use this new variable in the Insert Record activity.

  0

  Comment actions Permalink

Please sign in to leave a comment.