xsysys
asked on
How to migrate from ASA 8.0 to 10.0 Database?
Hi,
We are trying to convert some of our client databases from ASA8 TO ASA10 and we are facing different problems with different databases. Can you help us in solving the problems faced?
When we just create a new database in ASA8 and tried to migrate to ASA10, we were successful in doing so with out any problems.
But we faced the following problems in converting existing databases in ASA8 to ASA10:
A. After few steps of execution the following error occurs
Creating new database
***** SQL error: Syntax error near '(end of line)' on line 1
The database <database name> could not be unloaded.
The database <database name> could not be unloaded.
For another existing db:
B. All the tables were loaded and new database is created but the following error occurs after that:
Creating indexes
***** SQL error: There is already a variable named '@ls_report'
The database <database name> could not be unloaded.
The database <database name> could not be unloaded.
Can you let us know if any trouble shooting document available with respect to this migration?
We are trying to convert some of our client databases from ASA8 TO ASA10 and we are facing different problems with different databases. Can you help us in solving the problems faced?
When we just create a new database in ASA8 and tried to migrate to ASA10, we were successful in doing so with out any problems.
But we faced the following problems in converting existing databases in ASA8 to ASA10:
A. After few steps of execution the following error occurs
Creating new database
***** SQL error: Syntax error near '(end of line)' on line 1
The database <database name> could not be unloaded.
The database <database name> could not be unloaded.
For another existing db:
B. All the tables were loaded and new database is created but the following error occurs after that:
Creating indexes
***** SQL error: There is already a variable named '@ls_report'
The database <database name> could not be unloaded.
The database <database name> could not be unloaded.
Can you let us know if any trouble shooting document available with respect to this migration?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As we were working from our side to solve the below migration problems, we could find that the error ***** SQL error: Syntax error near '(end of line)' on line 1
Was due to one of our stored procedure (Still we could not trace the exact problem in stored procedure) but when we delete this stored procedure in ASA8 and migrate, we could migrate the database to ASA 10.
***** SQL error: There is already a variable named '@ls_report' => the error was occurring as in a stored procedure duplicate variable was declared i.e. the same variable was declared twice!
Solution: - When we remove one of the declarations and then migrate the database, we could migrate the database.