I am running Geographics 08.05.02.11 and work in a Tax Assessor's office where we link centroids of our parcel numbers to an oracle 9i db. There are 2 Oracle Data Linkages created on each centroid when we link: 1) to a Feature table (Entity=2, MSLINK Key = 106) and 2) to a table in mscatalog called Parcel_Spatial (Entity=11, MSLINK is unique for each centroid).
Lately when I create a new centroid and try to link it to the db, the Oracle Data Linkages are not created for the centroids. Using the Review Database Attributes of Element tool and clicking on the new centroid I receive the message "The element does not satisfy the database criteria". Using the Element Information button, the Attributes tab shows a User Data Linkage but no Oracle Data Linkages.
A new database record is created in the Oracle Parcel_Spatial table, however. I can query for max(mslink), then query the parcel_number for that max(mslink) and it is indeed my new centroid.
Any help determining the problem establishing Oracle Data Linkages to my centroids would be appreciated.
Thanks.
Thank you Cooper.
Alas, I can't comment on the custom tool itself, but you may be able to assess the behavior via:
- running a MicroStation 'session debug' prior to engaging the tool/button:
DMSG OPENMSGFILE c:\yourpath\yourfile.txtSESSION DEBUG ON(execute tool / perform steps to be debugged)SESSION DEBUG OFFDMSG CLOSEMSGFILE
(the debug file will not be released, until the message file is closed)
The session debug may reveal a database error code (ORA-....) or a/the failing SQL statement prior to a noted error.
- running the commensurate GeoGraphics/MicroStation tools manually (e.g. attach feature, attach database linkage), in kind.
Your mention of Bentley Map usage would only us to suspect some change to the database... so perhaps check to see if there have been any changes thus made to the tables/tablenames, or the related definitions within mscatalog (mscatalog.entitynum in particular).