Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #11500
    Ayush Gupta
    Participant

    Hi Team,

     

    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>

    #11501
    Simon Faas
    Keymaster

    Hi,

    The error is probably caused by a query that joins the burst and target tables.

    Can you tell us

    1. How many columns are in the HVR channel for this table?
    2. How many columns in the burst table?
    3. How many columns in the target table?

    For the burst table HVR is adding some extra internal columns. Also columns can be added using ColumnProperties /Extra.

    Cheers,

    Simon

    #11503
    Ayush Gupta
    Participant

    Hi Simon,

     

    Below are the details

     

    In HVR channel : 516 columns in the table(37 are marked as absent, and 6 extra columns added other than these 516 columns).

    In the burst table : 526 columns

    In target table : 484 columns

    Please let me know if you need any more info.

     

    Thanks,

    Ayush

    #11504
    Ayush Gupta
    Participant

    Sorry Simon, 5 extra columns are added in HVR channel on target side, not 6.

    #11519
    Simon Faas
    Keymaster

    Hi,

    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

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us