AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
elma87
666 Views, 2 Replies

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

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!

 

2 REPLIES 2
Message 2 of 3
elma87
in reply to: elma87

Anyone?

Message 3 of 3
elma87
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.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost