Hi Chris, Chris Jölly [mailto:[EMAIL PROTECTED] wrote: > Betreff: AW: AW: Database migration from ASCII to UNICODE > > as i further try to examine why i'm not able to import the > data i followed your suggestion > to remove the foreign key of the table which the loader > command dbload tells that theres > the ref. int. violation. after removing the foreign key the > data was imported successfully. > at least the loader tells me so and also the log file. > but: if i want to add the foreign key constraint again then > the ref. int. violation comes > up again. a check in the parent table shows that there are > many records missing. and > thats the reason for the ref. int. violation, because there > are many records in the child > table without a corresponing record in the parent table... > > unfortunately, i cannot check if the missing records aren't > exported because i'm only > able to use pages or records format for the export, not formatted. > > after another try i get the following problem in the parent > table after the import with > the foreign key deactivated: > > i want to select the data of the parent table, but get the > following error: > > General error;-2003 POS(8) Output columns too long > select * from orders > what version of the database (and thus of the Loader) do you use?
Concerning the count of records in your target database parent table - did users work on the source database while the export did run? If so could this be the reason for the referential constraint problem in the target database? If no user worked on the database I would be interested in the data file <you named it>.data0000. This file contains the count of records exported. Additionally I need the current record count of the parent table and how often this changes. Concerning the "output columns too long error" - could you provide me with the table definition, please. Sorry for the inconveniences. Regards, Steffen -- Steffen Schildberg http://www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
