Multi-versioned Views Not seeing data in the A & D tables

Question

We've created multi-versioned views as indicted in ArcSDE help using

"sdetable -o create_mv_view -T viewname -t table name -i sde: oracle11g -u user -p password"

The view creates fine however none of the data in the delta tables is seen in the view.

Using Oracle 11g
ArcGIS/ ArcSDE 10.0.2

Anyone know what could cause this?

We have recently loaded the data into 11g database and upgrade ArcSDE from 9.3.1 database. The views worked fine in 9.3.1. We've dropped and recreated the views using SDETABLE commands.

MatthewTownsend · Answer

ESRI confirmed that calling set_current_version against SDE.DEFAULT is behaving badly as described above.

After some investigation we found the following "fixes":
1) Don't call "sde.version_util.set_current_version('SDE.DEFAULT')" as it defaults to SDE.DEFAULT when you perform a select on a multi-version view.

2) Modify sde.version_util.set_current_version to perform a select on a multi-version view at the beginning of the procedure, thus ensuring that default is in a good state prior to running the rest of the method

3) use sde.version_util.set_default instead (added in version 10 SP4?).

MatthewTownsend · Answer

I think I have a similar issue.

If I open a SQLPlus (Oracle client app) connection and do a select on our multiversion view I get current DEFAULT data.

But if I open a SQLPlus connection and first call "sde.version_util.set_current_version('SDE.DEFAULT')" then run the same select it is missing recently added data that IS in DEFAULT.

Unfortunately, I can't see the bug in the link (NIM070728) to verify.  Is there any way I can get access to view the bug information?

Is there any work around, other than NOT calling "sde.version_util.set_current_version('SDE.DEFAULT')"?

We are using ArcGIS 10 SP4 with Oracle 11g (11.2.0.1).

Thanks.

DanaBaker · Answer

Thank you mvpurohit for the tip about NIM070728. This does appear to be the bug that is causing our problems.