missing references rows issue

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

missing references rows issue

Sashi Maddali
Hi

 

I'm a newbie to dbltutils. I was using version 1.0 jar to copy data to MS
SQL database. While executing my scripts I'm getting
org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
because of missing referenced rows exception. I heard that newer version
DBUtils 1.3 version has a fix for this issue. Is that true? How can I check
out 1.3 source files so that I can test JAR'ing version 1.3. I have access
to trunk only.

 

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.
Reply | Threaded
Open this post in threaded view
|

Re: missing references rows issue

Thomas Dudziak
Hi Sashi,

I think you are confusing DdlUtils with DbUtils. There is no 1.3
version of DdlUtils, the trunk version is 1.1 at the moment.

As for the error you're seeing, if it says that there are 8 rows not
written because of missing referenced rows, that means that you have a
foreign key relationship between the table of those 8 rows and some
other table, and these 8 rows reference rows in that other table that
are not included in the data file.
If you set the verbosity attribute of the ant task to debug, then
DdlUtils should print out whenever it defers insertion of a row
because its foreign key dependency is not satisfied.

Tom

On Wed, Jan 20, 2010 at 10:13, Sashikanth Maddali
<[hidden email]> wrote:

> Hi
>
>
>
> I'm a newbie to dbltutils. I was using version 1.0 jar to copy data to MS
> SQL database. While executing my scripts I'm getting
> org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
> because of missing referenced rows exception. I heard that newer version
> DBUtils 1.3 version has a fix for this issue. Is that true? How can I check
> out 1.3 source files so that I can test JAR'ing version 1.3. I have access
> to trunk only.
>
>
>
> 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.
>
Reply | Threaded
Open this post in threaded view
|

RE: missing references rows issue

Sashi Maddali
Thanks for your response Tom. I appreciate your time in helping us.

Sorry for my typo. I'm using ddlutils-1.0 version. It's how I'm using ddlutils in our project. I'm making two xml files, one of data and other for schema. They are successfully created using ddlutils.
Now I'm trying to recreate schema and load data files using ddlutils again. While loading data back to database it's throwing an exception. I'm using MS SQL Server database. Below is the stack trace.
With stack trace I understand that there are few referenced rows are not loaded. But I'm not sure why ddlutils omitting few rows while uploading data?

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 8 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.java: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(InternalAntRunner.java:423)
        at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
Caused by: C:\InIndividual\trunk\Utilities\Build\BuildScript\buildDatabase.xml:105: org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written because of missing referenced rows
        at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:115)
        at org.apache.tools.ant.Task.perform(Task.java:348)
        at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:62)
        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.taskdefs.MacroInstance.execute(MacroInstance.java:391)
        ... 16 more

Thanks
Sashi

-----Original Message-----
From: Thomas Dudziak [mailto:[hidden email]]
Sent: Thursday, January 21, 2010 10:47 PM
To: [hidden email]
Subject: Re: missing references rows issue

Hi Sashi,

I think you are confusing DdlUtils with DbUtils. There is no 1.3
version of DdlUtils, the trunk version is 1.1 at the moment.

As for the error you're seeing, if it says that there are 8 rows not
written because of missing referenced rows, that means that you have a
foreign key relationship between the table of those 8 rows and some
other table, and these 8 rows reference rows in that other table that
are not included in the data file.
If you set the verbosity attribute of the ant task to debug, then
DdlUtils should print out whenever it defers insertion of a row
because its foreign key dependency is not satisfied.

Tom

On Wed, Jan 20, 2010 at 10:13, Sashikanth Maddali
<[hidden email]> wrote:

> Hi
>
>
>
> I'm a newbie to dbltutils. I was using version 1.0 jar to copy data to MS
> SQL database. While executing my scripts I'm getting
> org.apache.ddlutils.io.DataSinkException: There are 8 rows still not written
> because of missing referenced rows exception. I heard that newer version
> DBUtils 1.3 version has a fix for this issue. Is that true? How can I check
> out 1.3 source files so that I can test JAR'ing version 1.3. I have access
> to trunk only.
>
>
>
> 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.
>

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.