I am in the process of moving approximately 70 users from a BDE application to ElevateDB.  The delphi application I wrote to accomplish this has worked on several with the exception of one

If I use the EDBManager

MIGRATE DATABASE FROM "BDE"
USING
"BlankNullStrings" = TRUE,
"Collation" = 'UNI',
"ConvertPrimaryToUnique" = True,
"DatabaseName" = 'C:\Program Files (x86)\EFAP\EFAPdata',
"TablePasswords" = '',
"Transliterate" = FALSE
WITH DATA

I get:.  It get a 202 error Module execution error 1011.   
The session log Error:  An error occurred with the module edbmigratebde (Module execution error: ElevateDB Error #1011 An error occurred with the parameter Notes (A conversion error occurred with the value))

Is there a way to identify the actual table or record that is generating this error?   I assumed the migrator processed the tables in alphabetical order, but emptying the suspect table did not resolve.
The migrator does work without data.   

I'm a relatively new user, so any suggestions would be appreciated.  Thanks  Bob

On 6/20/2022 3:58 PM, R Casey wrote:
> I get:.  It get a 202 error Module execution error 1011.
> The session log Error:  An error occurred with the module edbmigratebde (Module execution error: ElevateDB Error #1011 An error occurred with the parameter Notes (A conversion error occurred with the value))
>
> Is there a way to identify the actual table or record that is generating this error?   I assumed the migrator processed the tables in alphabetical order, but emptying the suspect table did not resolve.
> The migrator does work without data.

Have not migrated for a long time but don't think there is an easy way
to isolate the table is nothing else is logged.

If you can just do a test migrate with subset of tables at a time it
might help.

Looks like issue is with "notes" and specifically conversion - any
chance you have just few tables with notes and could they contain things
like BOM or other non printable characters or such ?

Raul

I'm with Raul - memories of BDE say look for corrupted blob files, especially if the content is non textual (eg jpgs).

Roy Lambert

That was exactly the problem.  I was thrown off because it was the table preceding the one that I thought was the issue.  I don't know which is better ElevateDB or the support I get on this forum    As I've told Roy previously, I'm an accountant...not a programmer but the support here makes it look like I know what I am doing.
I only wish I'd made the switch sooner

Thanks
Bob

R

>I only wish I'd made the switch sooner

That would have been silly. If you'd made the switch earlier we wouldn't have had time to make all the mistakes we've made and learn from them so we could pass wisdom along <VBG>

Roy

ps

<<make all the mistakes we've made>>

Me especially!