Infrastructure Map Server General

Reply
Valued Contributor
Posts: 51
Registered: ‎11-13-2006
Message 1 of 3 (423 Views)

AIMS 2013 Studio caching data in joins

423 Views, 2 Replies
09-07-2012 10:31 AM

Ok, this is frustrating beyond belief.  We have an ODBC connection that is linked to an SQL db.  When a change is made to the table, the data connection in studio doesn't reflect that change.

 

We then delete the data connection, and recreate it in studio which refreshes the ODBC connection and the correct data now appears from the database table.  Great.

 

We have an existing Data Source that joins an SDF to the ODBC connection.   That data source still shows the old data from the original data connection, even though we have confirmed that AIMS is recognizing our update now that we recreated the ODBC connection.

 

We have tried to recreate the data source to use the updated ODBC connection and the existing SDF but even after that, the secondary class table still does not update and as such the columns within that table are still the old SQL tables. 

 

That means any layers using that data source are still showing the old data table information which causes the layer to not work correctly. 

 

I have restarted the service and still it shows the cached version of data against the datasource. 

 

How do we get this to refresh??  Something so simple, yet is extremely frustrating to deal with.

 

 

Valued Mentor
Posts: 269
Registered: ‎10-06-2008
Message 2 of 3 (412 Views)

Re: AIMS 2013 Studio caching data in joins

09-09-2012 07:03 PM in reply to: frosty1_4me

Is the "existing data source" the same one that you deleted and rebuilt in Studio?

 

If not is it using differnent credentials that could result in a different view of your SQL Server database?

 

On a general note, cache invalidation does not require something nuclear like a service restart. Simply writing resource content to a Feature Source triggers the flushing of any cached information about that feature source.

 

- Jackie

Valued Mentor
Posts: 317
Registered: ‎10-10-2003
Message 3 of 3 (398 Views)

Re: AIMS 2013 Studio caching data in joins

09-12-2012 07:15 AM in reply to: frosty1_4me
Sometimes, I've had to reconnect the layer to the resource to see the changes. so you may wish to try that.

note: except in cases where you can't connect to SQL server using the OSGEO for sql provider, such as ms sql 2005, try to avoid odbc.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community