Transfer Error

[James Chan]

Does anybody know how to deal with this error:An error has occurred: DAO.Field[3163]
The field is too small to accept the amount of data you attempt to add. Try inserting or pasting less data ......


Above happened as i transfered data from DBMS to EAP which  created by new project operation.

[Geert Bellekens]

I've had that issue too.
It is due to a difference in lenght between columns in the access database and the dbms database.

What you can do:
Check on which part of the transfer you get this error. That should give you an indication of which table to look for.
Try also the dbError.txt in the application folder to find if there is more information logged there.
If you know which table is having the issue try to compare the columns between the access table and the dbms table. I can image there might be differences in the pdata, or notes columns.
Then find out which elements have a too long text in those fields, and adjust the text.

Geert

[James Chan]

Thanks, Geert.

I think EA should support creating a scaling BASE EAP file for DBMS repository transfering.

[Paolo F Cantoni]

Thanks, Geert.

I think EA should support creating a scaling BASE EAP file for DBMS repository transferring.

Hi James,

It has nothing to do with scaling per se... The actual defections of the various technologies are inconsistent...

I've developed a set of definitions for both .EAP and MS SQL Server that ARE consistent but that makes them non standard.

So you're left with a  choice - a standard set that doesn't work or a non-standard set that does...

Paolo