Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
i need to log data that trying to send to stored procedure that may case of issue
Solved! Go to Solution.
You have to check the datatype of both and ensure they match. The SQL logs might give you some idea, not sure about that. though as it may have been checked before even attempting to send to the SQL DB.
At some point KW added a field to their standard table creation so if you aren't populating all the fields you could get this error.
Post your fields in KW and the ones in SQL
CAST means that you are trying to change one datatype into another datatype. So the datatype of a value you are trying to log doesn't match the datatype of the database field that you are trying to insert it into.
okay, how can I check data before send to Stored Procedure to avoid any issue later?
You have to check the datatype of both and ensure they match. The SQL logs might give you some idea, not sure about that. though as it may have been checked before even attempting to send to the SQL DB.
At some point KW added a field to their standard table creation so if you aren't populating all the fields you could get this error.
Post your fields in KW and the ones in SQL
so, what is the deferent, SP and data in Keepware
What about the layout of the table that holds the data? I may be mistaken but I thought this error message came from Kepware ?
that is table "id" is increment
Consider renaming the existing table in SQL server and having KW create a new table from that logging configuration and see if there is a different table configuration created.
Hello @AO_10198547,
It looks like you have some responses from a community member. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution.
Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.
Thanks,
Community Moderation Team.
Greetings,
Does this Post answers your question. For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.
In the event that this response did not answer your question, please post your current status so that we can continue to support.
Thanks for using the PTC Community!
Regards,
Mohit