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

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

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

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

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

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

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

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