<MAXSTRING>CompileRtns+295^%occRoutine in SQL execution

Question

Question

Ashok Kumar · Jan 8

#JSON #ObjectScript #SQL #InterSystems IRIS #InterSystems IRIS for Health

I tried executing the SQL JSON_TABLE query with large JSON string(more than 200000 characters) and I got the below error. I'm curious about this under the hood workflow and how does it reach reaches MAXSTRING.

ERROR #5002: ObjectScript error: <MAXSTRING>CompileRtns+295^%occRoutine > ERROR #5030: An error occurred while compiling class '%sqlcq.LEARNING.cls247'

Thanks!

Product version: IRIS 2024.1

$ZV: IRIS for Windows (x86-64) 2024.1.1

Discussion (2)1

Log in or sign up to continue

score 0 · Answer 1 · 2025-01-10T12:00:28-05:00

Please open a support case with WRC.

If you can provide a sample class and query triggering this error it would be very helpful.

score 0 · Answer 2 · 2025-01-10T13:40:41-05:00

Ashok Kumar · Jan 10

Hello @Eduard Lebedyuk
Sure, Will do it.

Thanks!

0 0