SQL Arithmetic Exception – Error Code 802

Asked By joey keen 190 points N/A Posted on - 08/22/2012

Hello,

I'm using TC 4.0.1.12 (portable ver) on Windows. Most everything is going well, omit for this one job so far. I've made one entry couturier 95,000,000 as deal capital. The syllabus handles this without problems at the dimension of accounting and in all reports object for Reports: Batch type.

Here, when I try to do, the collection identify, I get this: SQL error: arithmetic Exception, numeric overflow or string truncation. Error code -802. Arithmetic overflow or division by zero has occurred. If I undo the collection for this substance, and reenter as a small product, say 9,500,000, the assemblage type estimation entirety satisfactory. Hope you can fix this job.

• Status: Open
• Question Views: 1529
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB Reporting Tools

Answered By Carl Jack 10 points N/A #147145

SQL Arithmetic Exception – Error Code 802

Hello Joey,

What seems to be the issue in your case is that you are possibly confronted with the following bug: http://tracker.firebirdsql.org/browse/CORE-3353.

Note that the bug stated above has been resolved in Firebird 2.5.1. What usually is the issue with the bug is that BLOB parameters in a LIKE-condition are described as a VARCHAR(30) parameter. In a case of UTF8 connection, usually the characterset is treated as VARCHAR(5) by Jaybird and because of the specific behavior of Jaybird only up to 6 characters will be allowed if it is a like pattern which ends in %. So you will just need perform an upgrade.

Regards,

Carl

 

 

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/27/2012
• Question Category: DB Reporting Tools