Insert record activity. Can I get executed query?

Follow

Rakesh Burde

• February 03, 2020 07:21

I am having a form that uses batch insert and insert record activity.  But I am getting error during inserting records in DB. Frequently I am getting below error "Input string was not in a correct format." What is the best way to troubleshoot the bug? Can I get an executed SQL query? so I will check manually.

0

• 

  sysberry GmbH

  • February 03, 2020 07:33

  Hi Rakesh,
  This error is mostly because you are trying to put string to number field in DB or the length of the string is too big for the field specified in DB.

  The SQL Query you can see in SQL server profiler (SSMS Tool) or just try to understand the query specified in the configuration and then write in SQL. In most cases you should have the same query.
  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  AgilePoint NX Support

  • February 23, 2020 04:16

  Hi Rakesh,

   

  You can enable debug mode for Insert record activity and read the AgilePoint log files created at '<installation folder>\AgilePointInstance\logs\debug\' to get more information on the error occurring for your case.

   

  Reference picture:

  

   

  Thanks,

  AgilePoint Support

  0

  Comment actions Permalink

Please sign in to leave a comment.