Informix Error -12090: Smart Large Objects: create: invalid column parameters.
Cause and resolution
Smart Large Objects: create: invalid column parameters.
The database server received a smart-large-object create specification that has invalid values in the column portion. Either the application programmer forgot to call the ifx_lo_def_create_spec function or the mi equivalent with create specification, or the create specification data structure has been corrupted.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12090 fires when a smart-large-object create specification has invalid values in its column portion — per the official guidance.
- The application forgetting to call
ifx_lo_def_create_spec(or themiequivalent), per the official guidance — the first named case. - The create specification data structure being corrupted, per the official guidance — the second named case.
Solutions / Resolution
- Call
ifx_lo_def_create_spec(or themiequivalent) to initialize the create specification, per the official guidance. - Check for corruption of the create specification data structure, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond invalid column-portion values.
Diagnostic Checks
- Check whether
ifx_lo_def_create_specwas called before populating the create specification, and check for structure corruption if it was.
Related Errors / Related Topics
- -12088 — "Smart Large Objects: create: number of estimate bytes < -1." A related create-specification validity error, on the estimated-bytes field specifically.
- -12089 — "Smart Large Objects: create: size limit of smart large object < -1." A related create-specification validity error, on the size-limit field specifically.
The create specification's column portion had invalid values — confirm
ifx_lo_def_create_spec was called and check for structure corruption.