SQL Anywhere database replication - dbxtract Force_view

Author

dbxtract Force_view_creation setting error

jclanton@propertyboss.com

2005-09-12, 3:27 am

I'm using the following dbxtract command to extract a remote database.

dbxtract -c "..." -an remote.db -v -j 5 -l 3 -ot log.txt rmtuser

At the end of the reolad, I get the following error:

....
Unloading "DBA"." setup_preferences_pr
opertytransit" into
setup_preferences_pr
opertytransit (relative to server)
Adding foreign key and index definitions
Creating functions
Creating views
***** SQL error: Invalid option 'Force_view_creation
' -- no PUBLIC
setting exists

I know the error has to do with the reloading of the nested views. The
only thing I've found is that this is an internal setting and we
shouldn't manipulate it.

I swear it's been working until the last couple of days. This error
has just cropped up and I don't understand why.

Thanks in advance for any ideas on how to fix this problem.

James

Reg Domaratzki \(iAnywhere Solutions\)

2005-09-12, 11:23 am

Is it possible that the version of ASA that you are using the run dbxtract
is a different ( i.e. lower ) version that the version of ASA that was used
to create the database?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

< jclanton@propertybos
s.com> wrote in message
news:jnp9i1lsbbr2mtk
0vjv0iiqd4fv51jvf0v@
4ax.com...
>
> I'm using the following dbxtract command to extract a remote database.
>
> dbxtract -c "..." -an remote.db -v -j 5 -l 3 -ot log.txt rmtuser
>
> At the end of the reolad, I get the following error:
>
> ...
> Unloading "DBA"." setup_preferences_pr
opertytransit" into
> setup_preferences_pr
opertytransit (relative to server)
> Adding foreign key and index definitions
> Creating functions
> Creating views
> ***** SQL error: Invalid option 'Force_view_creation
' -- no PUBLIC
> setting exists
>
> I know the error has to do with the reloading of the nested views. The
> only thing I've found is that this is an internal setting and we
> shouldn't manipulate it.
>
> I swear it's been working until the last couple of days. This error
> has just cropped up and I don't understand why.
>
> Thanks in advance for any ideas on how to fix this problem.
>
> James

jclanton@propertyboss.com

2005-09-13, 9:23 am

That's entirely possible. I have 7, 8, and 9 installed on the
machine. I'll test it out later today.

Thanks.

On 12 Sep 2005 08:09:42 -0700, "Reg Domaratzki \(iAnywhere
Solutions\)" <FirstName.LastName@ianywhere.com> wrote:

>Is it possible that the version of ASA that you are using the run dbxtract
>is a different ( i.e. lower ) version that the version of ASA that was used
>to create the database?

Sponsored Links