SQL Anywhere database - Error: "Unable to recompile view" in ASA7 to ASA9 upgrade.

Author

Error: "Unable to recompile view" in ASA7 to ASA9 upgrade.

Andy

2005-06-27, 8:23 pm

Hello,
We are about to upgrade about 1700 branch stores from ASA7.0.4.3498 to
ASA9.0.2.3044. After unloading the ASA7 database using the ASA9 version of
dbunload.exe, I dbinit.exe a new ASA9 database and use dbisqlc.exe to read
reload.sql. Every time it gets to the point where it does a "call
dbo. sa_recompile_views(0
)" I get an error:

Error in file "d:\db\unload\reload.sql" at line 56135
RAISERROR executed: Unable to recompile view
" Cust_Invoice_Margin_
View"

Here is the unload command:
%ASANY9%\win32\dbunl
oad -c uid=xxx;pwd=xxx;dbf=
e:\db\pos.db -y -j 3 -r
d:\db\unload\reload.sql d:\db\unload

If we change the 0 to a 1 in the call to sa_recompile_views, we do not get
an error. What exactly does sa_recompile_views do? Is there a reason the
parameter needs to be 0 rather than 1? Is there a way to exclude this line
when doing an unload and would it cause a problem if I removed that line? I
do not get this error if I just do an unload/reload with ASA7 utilities into
an ASA7 database.

Thanks,
Andy

Bruce Hay

2005-06-27, 8:23 pm

There is something wrong with the definition of the Cust_Invoice_Margin_
View
view. Try executing the CREATE VIEW statement for that view when the
Force_view_creation option is OFF. The error you see will hopefully tell you
why the view can't be created. You'll need to ALTER or DROP the view prior
to running DBUNLOAD for the rebuild to succeed.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"Andy" <retrama@lanetsaf.moc> wrote in message
news:42c06635$1@foru
ms-2-dub...
> Hello,
> We are about to upgrade about 1700 branch stores from ASA7.0.4.3498 to
> ASA9.0.2.3044. After unloading the ASA7 database using the ASA9 version
of
> dbunload.exe, I dbinit.exe a new ASA9 database and use dbisqlc.exe to read
> reload.sql. Every time it gets to the point where it does a "call
> dbo. sa_recompile_views(0
)" I get an error:
>
> Error in file "d:\db\unload\reload.sql" at line 56135
> RAISERROR executed: Unable to recompile view
> " Cust_Invoice_Margin_
View"
>
> Here is the unload command:
> %ASANY9%\win32\dbunl
oad -c uid=xxx;pwd=xxx;dbf=
e:\db\pos.db -y -j 3 -r
> d:\db\unload\reload.sql d:\db\unload
>
> If we change the 0 to a 1 in the call to sa_recompile_views, we do not get
> an error. What exactly does sa_recompile_views do? Is there a reason the
> parameter needs to be 0 rather than 1? Is there a way to exclude this
line
> when doing an unload and would it cause a problem if I removed that line?
I
> do not get this error if I just do an unload/reload with ASA7 utilities
into
> an ASA7 database.
>
> Thanks,
> Andy
>
>

Sponsored Links