Exception while inserting data back Sashikanth Maddali Tue Jan 26 11:00:49 2010
Hi I'm using ddlutils-1.0.jar (built checking out latest code from SVN, ran ANT JAR and collected jar file from dist folder). Below are the steps I'm doing. 1. Using MS SQL Server 2005 database 2. With the help of ddlutils created two xml files one for DB Schema and another for data from MS SQL Server 2005 3. Now I have two xml files 4. Now again with the help of ANT and ddlutils re-creating schema and data back into the same database (MS SQL server from which these files created before) 5. I'm getting below exception [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec4 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=7855bba3caed4543b07d92c2eac21241 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec5 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=89d2272bdd4540ad98a04ac4a29ef239 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec6 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=902769f777c248eba6a992ca4275ba35 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec7 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=98996ee1b4a54eddb57ee847698a4258 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec8 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=c40a35f55356411982f8b49bf32b0654 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21ec9 is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=d6d16dc6d8f8473b8769d079349fae24 [ddlToDatabase] Row BENEFIT_ELEMENT:ID=2c99fde5264d965501264d998dd21eca is still not written because it depends on these yet unwritten rows [ddlToDatabase] BENEFIT_DESCRIPTOR:ID=f032756a426e47f1b3b57f07a2a44ebc BUILD FAILED C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:530: The following error occurred while executing this line: C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:105: org.apache.ddlutils.io.DataSinkException: There are 7880 rows still not written because of missing referenced rows at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper .java:541) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:394) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.j ava:41) at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets (EclipseDefaultExecutor.java:32) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunn er.java:423) at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRun ner.java:137) I tried my best to investigate on where I'm going wrong. When I start working on this requirement, we were using ddlutils-1.0.jar which is downloaded from internet. Now I'm using ddlutils version 1.1 which is checked out from SVN and build locally. I looked at generated data file (created from SQL Server 2005 database) too. It looks good to me. Is that because of data reading from MS SQL Server 2005 or is that because of too many rows are waiting for other rows to be inserted and the waiting rows increased to a stage where ddlutils cannot handle them? Any point/hint to solve my problem is greatly appreciated. Thanks Sashi Confidentiality and HIPAA/GLBA Statement: This email, together with any attachments, is intended only for the use of the individual or entity to which it is addressed. It may contain information which is confidential or prohibited from any disclosure under the HIPAA Privacy Rule, Cal-GLBA or other federal or state laws. If you are not the intended recipient, you are hereby notified that any dissemination or copying of this message or attachment is strictly prohibited. If you have received this email in error, please notify the original sender and delete this email and any attachments. Thank you.