Hi - Help ...
There are several derived Classes,
and when I rebuild the indices in the SQL Manager
I can access via SQL Query different Tables/Classes ???
The Class Tree (unfortunately not easy available from any tool I know ;-)):
NLSObject
| | |
Object ObjectType DocumentType
DOCID DOCID DOCID
|
PlantStructureType
There are Unique Indices on DOCID
So there are at least 2 Entries in ObjectType and DocumentType
which I can not access via SQL Query:
SELECT * FROM GAS.ObjectType where DOCID = 30
or SELECT * FROM GAS.PlantStructureType where DOCID = 30
SELECT * FROM GAS.DocumentType where DOCID=41
When I rebuild the Indices for ObjectType (not for PlantStructureType !?)
I get the DOCID 30 Row,
but not the DOCID 41 Row from the other Table...
When I rebuild the Indices for DocumentType
I get the DOCID 41 Row,
but not the DOCID 30 Row from the other Table...
gosh ...
what can I do ?
- recompile whole project - done
- rebuild indices - there are dependencies ?
- restart cache database - done
what else ?
some more details:
Class GAS.DocumentType Extends GAS.NLSObject
Property DOCID As %Numeric;
Index DOCIDIndex On DOCID [ Unique ];
Class GAS.ObjectType Extends GAS.NLSObject
Property ObjectType As ObjectType;
Index DOCIDIndex On DOCID [ Unique ];
Class GAS.PlantStructureType Extends GAS.ObjectType
There are also some additional Classes to build Relations between this
Classes...
But it worked before ?
The only thing I did, was changing an additional derived Class,
where I first accidentally forgot to change some Types after "Copy Class".
I had data in it but neede to delete by SQL and reload - index rebuild an so
on...
But it was just:
Class GAS.SiteStructureType Extends GAS.ObjectType [ ClassType =
persistent, ProcedureBlock ]
{
Property ObjectType As SiteStructureType; // was first PlantStructureType
so what to do ???
drop all the tables and load again ???
or have the indices to have different names ???
???
brg
werner
