Receiving "Unable to load code table..because result sizes exceeds the allowed parameter" error using the lookup function in MetaMatrix
Issue
-
I'm receiving an error message when using the lookup function in my query:
select lookup('audit.valuelist','value','list_id',39) option debug Error: Unable to load code table for requestID 9401.1 of and nodeID of -1 because result sizes exceeds the allowed parameter - MaxCodeTableRecords.
Environment
-
MetaMatrix Enterprise Server 5.5.x
-
MetaMatrix Lookup/Code Tables
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.