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):
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
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!
Solved! Go to Solution.
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.