Facing issue in Batch insert activity.

追蹤

Rakesh Burde

• 2020年01月09日 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

  • 2020年01月13日 05:22

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

  0

  評論操作 永久連結
• 

  Rakesh Burde

  • 2020年01月13日 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

  評論操作 永久連結
• 

  AgilePoint NX Support

  • 2020年01月14日 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

  評論操作 永久連結

請登入寫評論。