topic Issue creating multiversion view in Geodatabase Questions

Issue creating multiversion view

AdnanYounas — Mon, 24 Nov 2014 04:43:25 GMT

Hi,

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the MV view using command line but I am getting the following error.

Error: Underlying DBMS error (-51).

Error: Unable to create MV view ....................

Any help/suggestion will be highly appreciated.

Thanks,

Re: Issue creating multiversion view

JoshuaBixby — Tue, 25 Nov 2014 16:26:53 GMT

I bit more information about the database would be helpful. For example, what version of SDE and what DBMS and version? Also, are we talking about two feature classes in the feature dataset? A feature class and a table? What command and syntax are you using to try to create it from the command line?

Re: Issue creating multiversion view

AdnanYounas — Wed, 26 Nov 2014 04:32:44 GMT

Thank-you Joshua for your attention. The ArcSDE version 10.2 and database Oracle 11g.

We are talking about two feature classes in a dataset (actually there are three feature classes and one table but we are interested in two only).

The command syntax used was: sdetable -o create_mv_view -T View_Name -t Table_Name -i Service -u User_Name -p Password

I even tried with different options available like database name etc. getting same error.

Re: Issue creating multiversion view

JoshuaBixby — Mon, 01 Dec 2014 16:07:09 GMT

Do you have access to the SDE schema tables? Have you looked to see if there are possibly entries for the view even though it doesn't exist? Have you tried creating the view with a slightly different name? I know in the past, if I had an mv_view that I didn't clean up completely, I would sometimes get this error message when trying to recreate the view.

Re: Issue creating multiversion view

AdnanYounas — Thu, 22 Jan 2015 06:17:33 GMT

I do have access to the SDE schema tables and I couldnt see any entries for specific view I was creating.

I did try a different name that didnt work either.

I ended up creating a view in a crude way i.e. manually it was not the best option but worked in my case!

Thanks