We got one error in the Integration today. <span style=”color: red; font-family: ‘GE Inspira’, sans-serif; font-size: 10pt; text-align: justify;”>DBMS error [ORA-01792: maximum number of columns in a table or view is 1000].</span>
Although the table had 516 columns(30 were made absent). But while merging the table with the Burst table we got the above error. We checked with the DBA and they told there are 526 columns in the Burst table. Not sure how count increased in the burst table.
Can you please put some insight in the issue.
<p class=”Body” style=”text-align: justify;”></p>
When a column is marked as absent using ColumnProperties /Absent it will still be created in the burst-table. The reason is that this column may be used in an /IntegrateExpression to calculate a value for other columns.
To get rid of these columns completely you can delete them from the channel (double click on the table, find the columns, and delete them; alternatively you can delete them directly from the HVR catalogs hvr_column table in the hub repository)
After this run HVR Initialize for the Capture and Integrate location with “Scripts and Jobs” checked as well as “Table Enrollment”
After this an Online Refresh with re-create mismatched tables option for the affected table will be necessary to get the data and layout back in sync
Oops! Looks like you're using an outdated browser...
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.