ERROR #5502: Error compiling SQL Table "abc123'

[bradders66]

Hi - got an issue with the above message appearing. The following text says "err:  <VALUE OUT OF RANGE>c2+14^%qaqomul' " but we believe nothing has changed within the class. Is there anyway of being able to debug this so we can ascertain whats causing the problem?  Note: Any queries on the "abc123" table seem to work but show "out of range" messages. We've even killed the ...D and ...I legs from the table (i.e. ^abc123D and ^abc123I) but still no solution?

[Ben Irwin]

I am not sure if this applies to Cache, but is almost sounds like you might have a <VALUE OUT OF RANGE> as in a big integer in a tiny integer variable.  Or maybe a decimal point in an integer.

[Andrew Makinson]

What object script code is on line c2 +14 of your class?

Sent from my iPhone

On 8 Jul 2013, at 17:07, bradders66 <pbra...@futurecode.co.uk> wrote:

Hi - got an issue with the above message appearing. The following text says "err:  <VALUE OUT OF RANGE>c2+14^%qaqomul' " but we believe nothing has changed within the class. Is there anyway of being able to debug this so we can ascertain whats causing the problem?  Note: Any queries on the "abc123" table seem to work but show "out of range" messages. We've even killed the ...D and ...I legs from the table (i.e. ^abc123D and ^abc123I) but still no solution?

--
--
Caché, Ensemble, DeepSee
 
---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[OldMster]

c2+14 is in the routine %qaqomul, which is an Intersystems supplied routine, not the class and source is probably not available.

If you killed the ^abc123D and ^abc123I globals, the only other global that could be around would be ^abc123S if you have any streams in the class.

Do you have any calculated fields in the table?  Could they be defined as an INT or Number and be calculating a number greater than 32 significant digits?

Mark

On Tuesday, July 9, 2013 10:39:26 AM UTC-5, Dom wrote:

What object script code is on line c2 +14 of your class?

Sent from my iPhone

On 8 Jul 2013, at 17:07, bradders66 <pbra...@futurecode.co.uk> wrote:

Hi - got an issue with the above message appearing. The following text says "err:  <VALUE OUT OF RANGE>c2+14^%qaqomul' " but we believe nothing has changed within the class. Is there anyway of being able to debug this so we can ascertain whats causing the problem?  Note: Any queries on the "abc123" table seem to work but show "out of range" messages. We've even killed the ...D and ...I legs from the table (i.e. ^abc123D and ^abc123I) but still no solution?

--
--
Caché, Ensemble, DeepSee
 
---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.

To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-public-cache+unsub...@googlegroups.com.

[bradders66]

On Monday, 8 July 2013 17:07:12 UTC+1, bradders66 wrote:

Hi - got an issue with the above message appearing. The following text says "err:  <VALUE OUT OF RANGE>c2+14^%qaqomul' " but we believe nothing has changed within the class. Is there anyway of being able to debug this so we can ascertain whats causing the problem?  Note: Any queries on the "abc123" table seem to work but show "out of range" messages. We've even killed the ...D and ...I legs from the table (i.e. ^abc123D and ^abc123I) but still no solution?

Just to let you know that we took this to ISC and the final answer was to kill of ^mmd then run Do $System.OBJ.CompileAll(“ckd”)