Issue creating multiversion view

Question

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,

A

AdnanYounas · Answer

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

JoshuaBixby · Answer

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.

AdnanYounas · Answer

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.