Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
Migrator error |
Tue, Sep 16 2008 3:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
B5 migrator from DBISAM V4 generates --------------------------- Dialtomdi --------------------------- ElevateDB Error #1011 An error occurred with the value --------------------------- OK --------------------------- The old migrator (I'm not sure how old but its date is 11/07/2008 (in English) didn't Roy Lambert |
Tue, Sep 16 2008 6:00 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< B5 migrator from DBISAM V4 generates >> Okay, I'll check it out and see what I can find. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 16 2008 6:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
This may be related to my other post about nulls in primary keys. At the time I had b4 installed in D6 and was using the b5 migrator. The error about primary keys was using b5 in D6 with a b4 migrator and I'm now trying a matched pair of b5 in D6 with a b5 migrator. Each run with all the data conversion, restructuring etc takes a couple of hours so I'll let you know. Roy Lambert |
Tue, Sep 16 2008 6:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Nope still get the error with the matched pair - interestingly enough at a table earlier in the conversion process than the other error.
Roy Lambert |
Tue, Sep 16 2008 2:09 PM | Permanent Link |
"Terry Swiers" | Roy,
> B5 migrator from DBISAM V4 generates > > --------------------------- > Dialtomdi > --------------------------- > ElevateDB Error #1011 An error occurred with the value Any chance that you have a binary or graphic blob in the table? I had this same error migrating a couple of databases and at a glance it seems to to be whenever it hits a table with a binary blob field in it. I'm not positive about this as I have not had a chance to verify it, but thought I would throw it out. -- --------------------------------------- Terry Swiers Millennium Software, LLC http://www.1000years.com http://www.atrex.com Atrex Inventory Control/POS - Big business features without spending big business bucks! Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) --------------------------------------- |
Tue, Sep 16 2008 8:49 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Terry,
<< Any chance that you have a binary or graphic blob in the table? I had this same error migrating a couple of databases and at a glance it seems to to be whenever it hits a table with a binary blob field in it. I'm not positive about this as I have not had a chance to verify it, but thought I would throw it out. >> Yes, you are correct. It is the conversion of BLOBs from binary to SQL constants that is causing a problem. During the conversion to our new cross-platform TEDBStringBuilder for improving the handling of .NET string concatenation (and Win32 also), a bug was introduced into this functionality. This normally would be caught by the testing, but unfortunately the migrators were also not set up to automatically be recompiled with the new version for testing due to the fact that I wanted to ensure that older migrators still worked with newer versions. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 16 2008 11:14 PM | Permanent Link |
"Terry Swiers" | Tim,
> Yes, you are correct. It is the conversion of BLOBs from binary to SQL > constants that is causing a problem. Thanks for the confirmation. That will save me a lot of time tracking down the cause of the issue. And given that I don't have to do any conversions for a while, I'll just wait for the next update for a fix. -- --------------------------------------- Terry Swiers Millennium Software, LLC http://www.1000years.com http://www.atrex.com Atrex Inventory Control/POS - Big business features without spending big business bucks! Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) --------------------------------------- |
Wed, Sep 17 2008 2:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Nice catch from Terry - that's almost certainly it since it stopped on a table (emails) with BLOBs with all sorts of stuff in. Roy Lambert |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |