Table exists but not present on the Tables & Columns

[rafael_merces1]

Hi All,

We have a custom table on our system that we are able to see on sys_db_object, but not on "Tables & Columns" module. Therefore we are not able to create any module nor report on this table, even though it is shown as existent and active (for instance, if we type table_xpto.list it shows a list of records and table_xpto.do the form to do the insertion).

Also, there is another custom table that has reference to this table. If we enter on the schema map of this 2nd table, we are able to see out table_xpto there.

Have any of you experienced this strange behaviour? Any thoughts of what could be the problem?

Thanks,

[rob_pastore]

Does it exist in the Dictionary table?  

[rafael_merces1]

The collection entry for the table no. The entries for the fields, on the other hand, exist.

[ismar1]

Hi!

I have no explanation regarding this "problem" but we recently ran into the very same problem. For us it occured somewhere between importing update set and in the process something went wrong. To resolve this issue we had to drop the table through background script, then re-commit the update set which held the create table part inside the update set. But doing it this way will result in dataloss and that is something you probably do not wish to experience. I would recommend to send a HI-incident request.

var drpTbl = new TableUtils();
drpTbl.drop('tblName');

[rafael_merces1]

Hi Ismar, thanks for your feedback.

We have opened a ticket on Hi and will wait their feedback. I will post later if they find anything.