AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Member
elma87
Posts: 3
Registered: ‎06-27-2012
Message 1 of 3 (352 Views)
Accepted Solution

Oracle FDO Provider in MAP 3D not reflecting database structure changes

352 Views, 2 Replies
06-27-2012 12:53 AM

Hello,

 

We are having problems with FDO Oracle Provider. Map3D 2012 id not able to see changes made on Oracle table (via SQL Developer). For example, when we delete, update or add a column in table, MAP 3D throws an error like this (Note that SIFRA1 does not exist in this table):

 

 Property SIFRA1 has no database mapping

 

 

Also, tables that are deleted in oracle are still visible in fdo oracle provider.

For Example: Table MBUS_RHI1 does not exist in our database but it is still listed

 

 MBS RHI1 does not exist in db

 

 

How can we fix this? We tried updating MAP 3D to SP1 and SP2 but problem persists. Where does MAP 3D store information about database structure?

 

Can someone please help us! We are desperate!

Thanks in advance!

 

Member
elma87
Posts: 3
Registered: ‎06-27-2012
Message 2 of 3 (326 Views)

Re: Oracle FDO Provider in MAP 3D not reflecting database structure changes

06-29-2012 12:51 AM in reply to: elma87

Anyone?

Member
elma87
Posts: 3
Registered: ‎06-27-2012
Message 3 of 3 (315 Views)

Re: Oracle FDO Provider in MAP 3D not reflecting database structure changes

06-29-2012 05:11 AM in reply to: elma87

Since this was mapping issue and autodesk did not reflect database changes I needed to change it manually.

First you need to connect to your Oracle database via Oracle FDO provider. Then go to map explorer tab (in task pane), right click on ypur database and choose edit schema.

 

 

In Shema Editor you can make desired changes.

If you are not able to do edit property you can just delete it and create a new one.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.