[Info-ingres] E_RD000F on attempt to refresh or remove a registered table

[Martin Bowes]

Hi All.

II 10.2.0 (a64.lnx/100) + p15151

I have a registered table (c_box_worklist) within a STAR ddb.
register table "c_box_worklist" as link from "lust"."c_box_worklist"
with node = 'vlabdev.ctsu.ox.ac.uk', database = 'test_ldbc', dbms =  'INGRES' ;

If I do:

1.       register c_box_worklist as link with refresh;

E_SC0206

2.       remove c_box_worklist;

E_RD000F The information block is out of date.

E_SC0206

The errlog shows:

E_RD000F_INFO_OUT_OF_DATE     The information block is out of date.

E_PS0904_BAD_RDF_GETDESC      RDF error occurred when getting description for an object.

E_PS0007_INT_OTHER_FAC_ERR    PSF detected an internal error when calling other facility.

E_SC0215_PSF_ERROR    Error returned by PSF.

I have tried flushing the RDF cache with both trace points rd001 and rd010 but the error persists.

And for further fun...The same table is registered into other ddbs, where the refresh works without error.

All the databases involved reside on a single host.

Anyone got any ideas what the problem may be?

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170622/dc861d7e/attachment.html>