Chris Wiita wrote: > That was the problem! Group ID for a user, not a group. I just changed > the owner to an actual group, and the migration script appears to have > worked now. Thanks a lot!
I have bad new for you. While we were trying to fix the original problem, we discovered some other more serious bugs in the migration tool. Most of them are related to the Array LIMS and reporters part. For example: * No reporters were assigned to plates or raw data * Merged plates were incorrectly mapped to parent plates * Plates has swapped row and column coordinates * File formats were lost * And a few more that I can't remember The 2.0 release from yesterday hopefully fixes most of the issues, but we have not had time test or verify this. We are going to do some more tests today and the next week. I have to thank you for pointing out the original problem. Otherwise we wouldn't have found the other bugs. I would also like to ask you if you have any time to spend on helping us test the migration? I am not sure we can weed out all problems with the data we have here. Don't worry if you don't have time, we will try to fix it anyway. Maybe someone else on the list can help? Send a reply to me off the list. Thank you very much. /Nicklas > > --Chris W > > Nicklas Nordborg wrote: >> Chris Wiita wrote: >> >>> Alright, that makes sense. The first time I ran the script the error >>> was different, and in repeating the script, I never noticed it was way >>> off in the first place! I turned logging, dropped both BASE2 DBs and >>> recreated them, and ran initdb.sh. It was successful. Confirmed the >>> databases were present with myphpadmin, and made no login attempts >>> (didn't want to touch the db). I ran the migrate script, and this is >>> the error. It managed to get through the UserTransfers--this is log from >>> the last user transfer, before it moves onto the next part, where it fails. >>> >>> >>>>> >>> 11:54:39,164 INFO migration:77 - UserTransfer: Assigning role Share >>> With World to user : Yuhei >>> 11:54:39,237 INFO migration:77 - RoleTransfer: getRoleIds: 251658196 >>> 11:54:39,259 INFO migration:77 - UserTransfer: Assigning role Power >>> user to use r : Ezra >>> 11:54:39,265 INFO migration:77 - UserTransfer: Assigning role Plugin >>> Administra tor to user : Ezra >>> 11:54:39,280 INFO migration:77 - UserTransfer: Assigning role File >>> Formats Admi nistrator to user : Ezra >>> 11:54:39,287 INFO migration:77 - UserTransfer: Assigning role >>> Hybridizations Vi ewer to user : Ezra >>> 11:54:39,295 INFO migration:77 - UserTransfer: Assigning role >>> Biomaterials View er to user : Ezra >>> 11:54:39,301 INFO migration:77 - UserTransfer: Assigning role Share >>> With World to user : Ezra >>> 11:54:39 0 : 18 100% 4 00:00:00 >>> 11:54:39 ------------------------------------------------- >>> 11:54:39 Creating home directories >>> 11:54:39 Left Done Items/s ETE >>> 11:54:39 18 : 0 0% >>> 11:54:39 0 : 18 100% 18 00:00:00 >>> 11:54:39 ------------------------------------------------- >>> 11:54:39,915 INFO migration:77 - Migrater: startTransfer: Group >>> 11:54:39 Group >>> 11:54:40,060 INFO migration:68 - Free memory : 360 MByte >>> 11:54:40 Left Done Items/s ETE >>> 11:54:40 1 : 0 0% >>> 11:54:40,325 INFO migration:68 - Free memory : 382 MByte >>> 11:54:40 0 : 1 100% 1 00:00:00 >>> 11:54:40 ------------------------------------------------- >>> 11:54:40,329 INFO migration:77 - Migrater: startTransfer: Wizzzard >>> 11:54:40 Wizzzard >>> 11:54:40,463 INFO migration:68 - Free memory : 383 MByte >>> 11:54:40 Left Done Items/s ETE >>> 11:54:40 16 : 0 0% >>> 11:54:40,481 INFO migration:77 - WizzzardTransfer: setSharedItemData: 15 >>> setSharedItemData : 15 >>> [EMAIL PROTECTED] bin]# >>> >>>>> >>> >>> Any ideas what may be the cause here? This BASE1 was set up before I >>> started administering this system, but it was pristine as far as I >>> know. I upgraded a few times, and there was never any issue with the >>> database (or issues at all, for that matter). Thanks for any help! >>> >> I really don't know what is going on. But, it turns out that the >> migration program is really sensitive about the correctness of the Base1 >> database. What I suspect is that in your databases there are relations >> from one item to another that no longer exists. Can you help me verify this? >> >> First, check the 'Wizzzard' table for any entry which has gid=15. Then, >> check the 'UserGroup' table and look for an entry with id=15 and >> isAccount=0. If what I suspect is true, you will not be able to find >> that in the UserGroup table. >> >> >> /Nicklas >> >> ------------------------------------------------------------------------- >> Using Tomcat but need to do more? Need to support web services, security? >> Get stuff done quickly with pre-integrated technology to make your job easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >> _______________________________________________ >> The BASE general discussion mailing list >> basedb-users@lists.sourceforge.net >> unsubscribe: send a mail with subject "unsubscribe" to >> [EMAIL PROTECTED] >> >> > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > [EMAIL PROTECTED] ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
