stored proc throwing error message'' The Allocation currency values do not balance to zero [SQLSTATE 42000] (Error 50000). The step failed.''

Question

thanks 

Answer 1

This is application error, not SQL Server:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/9e7f61cb-c32c-47ce-9d9a-7257ade2424b

---

Kalman Toth SQL 2008 GRAND SLAM
Paperback: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 2

We have already discussed this in the Security forum, and you have been told that this an application error, and that you need to find the programmer who wrote the code, or contact the vendor of this is a vendor app.

It's great that you post the code this time, but the problem is with the data. It could be the programmer put in an incorrect check, but it could also indicate that you have bad data.

In any case, resolving this problem is far beyond the capabilities of this forum.

Why do ask here, rather than locally? What is your role in your organisation?

---

Erland Sommarskog, SQL Server MVP, [e-mail]