[HCN] Migration blues

[Peter Machell]

On 09/01/2007, at 10:34 PM, Peter Machell wrote:

> 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.

Returned to the site. Took my trusty Mac Mini running Windows XP via  
Parallels (because I don't yet have an Intel notebook). Backed up  
current databases and the conversion went through without a hitch. No  
explanation as to why it wouldn't work on either the 2003 server or  
XP workstation on-site.

As a tech who works largely with Windows, I know the appropriate  
course of action when something doesn't work - try, try then try again.

Peter.