Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

HP-UX

FACT(s) (Environment):

Progress 8.2C

FACT(s) (Environment):

Oracle 7.3.4

FACT(s) (Environment):

Oracle DataServer

SYMPTOM(s):

Error code <number> returned from fdfnd. (1410)

Error code -9742 returned from fdfnd (1410)

Error 1410 running Container Maintenance program from MFG/PRO

The dataserv.lg file contains a message shortly before the code fails.

Select list too long -- cursor changed to no-lookahead

CAUSE:

For lookahead cursor, dataserver has to allocate a buffer sufficient to hold two rows from the result set. The tables involved are too wide. Each join row is bigger than 16K, but dataserver can only allocate 32K for this buffer. Thus the dataserver changed this to a nolookahead cursor.

FIX:

Use field lists to retrieve only those fields that the application requires. In this case, it will only retrieve only 13 fields instead of 431.