[HCN] Migration blues

[Peter Machell]

On 08/01/2007, at 10:12 PM, Peter Machell wrote:

> Tried to migrate a site from MDW2 and PS3 today and failed.  (Yes  
> it's a migration, not an upgrade)
>
> Didn't do anything different, I've done probably 30 sites now, but  
> the migration fell over each time it hit progress notes. No error,  
> no nothing, just a partial database, restore from backup and try  
> something else. Moved it all to a different PC in case it was  
> something weird with the server - same result.
>
> Sent the log to support (there was no detail in it though). Spoke  
> to someone later who was pretty definitive that what I had to do  
> was upgrade the database server before I started. Explained to him  
> that I'd done this - they were on PS3.40 this morning and PS3.54  
> before I migrated. Anyway I'll be back tomorrow and hope that a re- 
> upgrade works.
>
> Keep your fingers crossed for me. More details to follow if it  
> doesn't work.

Returned to the site. Ran updatedbs on MD2 and re-installed HCN  
common database to re-update the PS database. Migration failed again.  
Called and got through to level 2 or better, went through all the  
logs, no ideas. Took the data and tried it at the workshop on a  
Windows 2000 virtual machine, success. Interestingly when I restored  
the Pracsoft backup then tried to start it upgraded the database  
(that was already on 3.5.2). Only other difference, apart from the  
OS, was that I didn't upgrade MDRef first. Helpdesk was going to call  
to discuss but didn't. Going back tomorrow to try again.

Peter.