Facing issue in Batch insert activity.

Follow

Rakesh Burde

• January 09, 2020 10:51

I am getting error like "Input string was not in a correct format."
I have created a table that has repetitive entry likes order.  I create order table that have 
column ID (Created by agile point automatically)

column  OrderId (Created by me during entity creation autoincrement) 

Column userID (Created by agile point automatically because I have created relationship)

Do I need to provide a hidden input filed for userID or OrderId ? and what is the role of column ID here.

 

0

• 

  Rakesh Burde

  • January 13, 2020 05:22

  Is the column  OrderId (Created by me during entity creation autoincrement) creating the problem?

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • January 13, 2020 05:46

  I tried to insert only one value in table. but I am getting this error
  "Cannot insert the value NULL into column 'ID', table 'DebitNote__u'; column does not allow nulls. INSERT fails. The statement has been terminated."

  0

  Comment actions Permalink
• 

  AgilePoint NX Support

  • January 14, 2020 00:32

  Hello Rakesh,

  From your post, it is clear that the "DebitNote_u" column does not allow NULL, meaning a value needs to be provided. So kindly map the control and provide the value. Also is OrderId (Created during entity creation autoincrement) a primary key? Please verify the above points.

  Thanks,

  AgilePoint Support

   

  0

  Comment actions Permalink

Please sign in to leave a comment.