Too Many Columns: ERROR: target lists can have at most 1664 entries

[Ben Wagner]

Hello Gurus,

  I've encountered the below error when updating an existing schema.  This is from trying to view it's report page from and existing item.

2017-06-07 08:55:13,992 [http-apr-9080-exec-3] ERROR org.nrg.xdat.turbine.modules.screens.SecureScreen - 

org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries

The schema consists of:

<xs:complexType name="fileStatData" >

<xs:attribute name="fileName" type="xs:string" use="required"/>

<xs:attribute name="fileDate" type="xs:date" use="required"/>

<xs:attribute name="fileTime" type="xs:time" use="required"/>

</xs:complexType>

And then:

<xs:complexType name="afq100Data">

<xs:complexContent>

<xs:extension base="xnat:mrAssessorData">

<xs:annotation>

<xs:documentation>AFQ Statistics 100 Nodes</xs:documentation>

</xs:annotation>

<xs:sequence>

<xs:element name="subject" type="xs:string" minOccurs="0" maxOccurs="1"/>

<xs:element name="t1" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/><!--T1 for VTK overlay-->

<xs:element name="dt6File" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/>

<xs:element name="MoriGroupsFile" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/>

<xs:element name="CC_Ant_FrontalFile" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/>

<xs:element name="CC_MotorFile" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/>

<xs:element name="CC_OccipitalFile" type="afq:fileStatData" minOccurs="0" maxOccurs="1"/>

[SNIPPED]

When I added more fileStatData elements the number of columns sharing and table info increased.  I at one point had 140 references to each of the following fields.  I've brought it back some, but I still have 1344 columns for non-data items.

    112 activation_date

    112 activation_user_xdat_user_id

    112 insert_date

    112 insert_user_xdat_user_id

    112 last_modified

    112 meta_data_id

    112 modified

    112 origin

    112 row_last_modified

    112 shareable

    112 xft_version

    113 status

Any ideas how to lessen this load?

Ben