Hi,

I've dumped our Live company and am now trying to import the dump into the test conmpany using ttaad4227m000.

When I start I keep getting errors for the tables that are trying to be created saying "write error 2552"

I'm using my usual superuser account, nothing has changed since the last time (that I can think of!). If I try to create a table (empty) with ttaad4230m000 it creates fine, but when I try to popualte it with data from a dump I get the write error.

Any ideas ? ..
Thanks !
sumesh:confused:

Hi Sumesh,
First of all did you check the error file of the Live Co. Dump? Were there any errors in it? Secondly, what are the options you have checked while using the session ttaad4227m000? Last but not least are they(Live co & Test co) off the same VRC package?

sk

Dear SK

The options checked are
1) append if table exists
2)Ignore referential integrity
3)Ignore domain constraint
4)field seperator "|"

and PVRC of both the companies is same.

Thanks
Sumesh

Did you try changing the company number of those tables before importing?

sk

Since your importing with append, maybe the error just means "table already exists", this would explain why you can create a new table thru ttaad4100.
First identify what the error means (if that is a Baan error 2552 then it translates into SQL server error 1552).

Victor,
If the table already exists, shouldnt the "Append If Table Exist" option take care of that instead of giving errors?

sk