Salesforce

ORA-01792: maximum number of columns in a table or view is 1000

Printable View
« Go Back

Information

 
TitleORA-01792: maximum number of columns in a table or view is 1000
SummaryThe purpose of this article is to provide instructions how to fix the error "ORA-01792: maximum number of columns in a table or view is 1000" when browsing in WMS Discrete, RPWeb.
URL NameORA-01792-maximum-number-of-columns-in-a-table-or-view-is-1000
Resolution
To avoid this error, the following statement should be run to change the Oracle parameter that generates the error:
  • ALTER System SET "_fix_control" = '17376322:OFF';
ProductsSupply Chain Planner
ModuleDatabase
Version9.1
Error Message Code
  • ORA-01792: maximum number of columns in a table or view is 1000
Cause
  • Some list commands, such as those used to retrieve a list of inventory, may return a result that exceeds Oracle's maximum number of columns
  • When this occurs, Oracle generates an error (ORA-01792: maximum number of columns in a table or view is 1000)
Additional Information
  • The error received is a result of missing one of the pre-installation steps
  • For more information see, "JDA Warehouse Management 9.1.4.0 Installation Guide", section "Pre-installation and upgrade tasks for the server software", page 41
  • To verify this setting, the following can be run when connected as a sysdba user (others user will receive a table or view does not exist error).  This example shows the setting as indicated in this article:
SELECT x.ksppinm "Parameter",
       Y.ksppstvl "Session Value",
       Z.ksppstvl "Instance Value"
FROM   x$ksppi X,
       x$ksppcv Y,
       x$ksppsv Z
WHERE  x.indx = Y.indx
AND    x.indx = z.indx
AND    x.ksppinm LIKE '/_fix_control%' escape '/'
order by x.ksppinm;

Parameter
--------------------------------------------------------------------------------
Session Value
--------------------------------------------------------------------------------
Instance Value
--------------------------------------------------------------------------------
_fix_control
17376322:OFF
17376322:OFF

 
Publication StatusPublished
Powered by