|
Home > Archive > SQL Anywhere database > June 2005 > Problem with Unload/Reload process
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with Unload/Reload process
|
|
|
| I am attempting to unload a ASA6 db, create a new ASA9 db,
and read the data into this database using the "read"
command. I've done this a thousand times without trouble!
However, I now have an "unknown error" followed by a
transaction rollback and a disconnect.
I've isolated to this...
I can take the "Add foreign key defs" section out of the
reload.sql doc and it will read fine. More specifically, it
seems to have a problem with a certain table... i cannot add
an index or a foreign key to it.
It sounds to me like there is some corrupt data in this
tabe... but you are the experts! Can somebody please
provide me with feedback of possible problems and/or work
arounds?
| |
| Greg Fenton 2005-06-11, 3:24 am |
| Josh wrote:
> I am attempting to unload a ASA6 db, create a new ASA9 db,
> and read the data into this database using the "read"
> command. I've done this a thousand times without trouble!
>
Are you using the 9.x dbunload to unload the ASA6 database? If not, you
should.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| The issue is actually resolved. I was doing an unload by
use of Sybase Central 6. The problem was trying to apply a
foreign key to a table that contained data with broken
relationships. I had to delete the records with the broken
relationships, then it worked fine.
Just a FYI note, ASA6 allowed this broken link foreign key
to happen, ASA9 did not like it! In other words, I had to
delete the records that caused the problem in ASA9 before
the "add foreign key statement" succesfully went through,
but I did not have to delete the data in ASA6.
> Josh wrote:
>
> Are you using the 9.x dbunload to unload the ASA6
> database? If not, you should.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Greg Fenton 2005-06-13, 1:23 pm |
| Josh wrote:
> The issue is actually resolved. I was doing an unload by
> use of Sybase Central 6. The problem was trying to apply a
> foreign key to a table that contained data with broken
> relationships. I had to delete the records with the broken
> relationships, then it worked fine.
>
For future reference, the suggested practice for unloading/reloading is
to use the newest version's tools for the whole process. The 9.x tools
"know" the 6.x format, so 9.x's unload is more appropriate as the
reload.sql it creates will be using 9.x features (6.x's unload obviously
knows nothing about 9.x).
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|