Insert record activity. Can I get executed query?

追蹤

Rakesh Burde

• 2020年02月03日 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

  • 2020年02月03日 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

  評論操作 永久連結
• 

  AgilePoint NX Support

  • 2020年02月23日 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

  評論操作 永久連結

請登入寫評論。