Show objects locked by other user in Autocad Map 3d using Oracle FDO

[Anonymous]

Hi,

Is there a way to display locked objects in Autocad Map 3d that other user has checked out for editing (using Oracle FDO)? Other user can't distinguish which objects are being edited and who has taken them. This makes selecting possible objects for editing a very tedious task. I would be happy to hear if there is any implemented functionality in Autocad Map 3d or some other way to resolve this.

Using Autocad Map 3d 2014 and Oracle 10g.

[Anonymous]

Hi,

first of all - I haven't used FDO Oracle much. We have Industry Models based on Oracle and IMs come with their on FDO IM Oracle Provider. If you consider using IMs - with IM you can enable "jobs". These jobs prevent other users modifying data which is worked on by someone else.

With regards to FDO Oracle - have you created a Oracle schema with FDO Oracle or do you connect to an existing Oracle schema ("foreign data store" in Map speak)? The locking mechanism might only work if you have a schema wich has been created with Map.

Otherwise - have you read this? Map help:

Version Enabling

The Autodesk FDO Provider for Oracle included with AutoCAD Map 3D 2013 creates tables in the FDO data store that are not automatically version-enabled. Therefore, when you create a new Oracle data store using the default options, the resulting table is not version-enabled, so persistent locking and long transaction are not supported. (This differs from previous releases.)
Oracle Workspace Manager (OWM) is used for versioning and persistent locking support.

Have you looked at this already?

Could you explain your workflows in more detail?

Rob

[Anonymous]

Hi,

Thanks for the reply.

The Oracle schema I am using is created by Autocad and resided the F_ tables used by Autocad. I've also run the script enabling the versioning support and it's working by preventing users editing objects that are checked out by other user. However that's as far as the functionality goes. You don't get information which objects are locked and who has taken them for editing.

The xml error log file gives vague idea of the locked feature IDs but it's hardly a method for real use:

The feature or features you are attempting to edit are currently checked out by another user.

FeatureId=Schema1:spatJoin3(87)

Failed to execute Fdo command.

Schema1:spatJoin3 (87), Rev# <0>

FeatureId=Schema1:spatJoin3(86) [sId=41]

Schema1:spatJoin3 (86), Rev# <0> [sId=41]

Failed to add features to the edit set.

I would be interested to know if anyone's found a way to solve this. Visualizing the locked features is the main concern. Information about who has it locked would be great too. Oracle table seems to have the info stored in LTLOCK column but Autocad has no visibility to this column (or table).

Does Industry Model provide means for this? I haven't worked with IM before, does it save data to Oracle as real Oracle Spatial? Will the data saved be accessible for other programs with Oracle db support?

[Anonymous]

Hi,

thanks for the details.

I don't have any experience with Oracle versioning. Therefore I'm just guessing - can't you create a view on your table which somehow includes the information about the lock as well? There are for instance meta data tables (xxx_LOCK Views) which seem to contain some information about current locks. As I said - I'm just guessing....

With regards to IMs:

Does Industry Model provide means for this?

--> yes, have a look here:

http://help.autodesk.com/view/MAP/2016/ENU/?guid=GUID-BB549320-C510-422B-A0A6-1C1F8ED3D776

But IMs and Jobs specifically add significant complexity in terms of administration and admin/user workflows. So it might be not the best choice to switch to IMs just because Oracle versioning has some limitations. You would need to consider IMs and jobs very carefully.

I haven't worked with IM before, does it save data to Oracle as real Oracle Spatial?
--> yes

Will the data saved be accessible for other programs with Oracle db support?
--> yes but with jobs enabled other applications can only see data in "live" status. If data is modified in a job these modifications are not visible to any applications - until the jobs is "finished" and set to "live".

Rob

[Anonymous]

Thanks! I will check the IM if it would suit my needs better.