# Problems with loadData

**URL:** <https://forum.liquibase.org/t/problems-with-loaddata/2130>\
**Category:** General Discussion\
**Created:** [October 2, 2012, 2:58am UTC](https://forum.liquibase.org/t/problems-with-loaddata/2130 "2012-10-02T02:58:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeffrey.crump](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jeffrey.crump](https://forum.liquibase.org/u/jeffrey.crump)\
**Post date:** [October 2, 2012, 2:58am UTC](https://forum.liquibase.org/t/problems-with-loaddata/2130/1 "2012-10-02T02:58:00Z")

</div>

I’m trying to use to load up a CSV into my database. &nbsp;No rows are being added to my table, and I can’t figure out why. &nbsp; Running with logLevel=debug, I see this:

DEBUG 10/1/12 3:45 PM:liquibase: Reading ChangeSet: db-changelog.xml::1::jcrump::(Checksum: 3:a587c9a71db292dedc440ac8aa894f1e)

DEBUG 10/1/12 3:45 PM:liquibase: Data loaded from /Users/jcrump/dev/eco/1.0.0/ECO.ECO\_SECTION\_RULE\_MAP.csv into ECO\_SECTION\_RULE\_MAP

INFO 10/1/12 3:45 PM:liquibase: ChangeSet db-changelog.xml::1::jcrump ran successfully in 18ms

which is the right file, table and everything, yet it doesn’t appear to be actually doing any updates.

When I use the updateSQL command, I see it tries to update the changelog (which is does successfully) but it doesn’t actually&nbsp;

– &nbsp;\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

– &nbsp;Update Database Script

– &nbsp;\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

– &nbsp;Change Log: db-changelog.xml

– &nbsp;Ran at: 10/1/12 3:56 PM

– &nbsp;Against: [devuser1@192.168.212.79](mailto:devuser1@192.168.212.79)@jdbc:mysql://c1-dbdev101:3306/D1\_ECO

– &nbsp;Liquibase version: 2.0.5

– &nbsp;\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

– &nbsp;Lock Database

– &nbsp;Changeset db-changelog.xml::1::jcrump::(Checksum: 3:a587c9a71db292dedc440ac8aa894f1e)

– &nbsp;Add rule definitions.

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES (‘jcrump’, ‘Add rule definitions.’, NOW(), ‘Load Data’, ‘EXECUTED’, ‘db-changelog.xml’, ‘1’, ‘2.0.5’, ‘3:a587c9a71db292dedc440ac8aa894f1e’, 1);

– &nbsp;Release Database Lock

INFO 10/1/12 3:56 PM:liquibase: Successfully released change log lock

“Add rule definitions” is the comment in my changeSet entry:

&nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; Add rule definitions.&nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<column name=“RULE\_ID” &nbsp;header=“RULE\_ID” type=“VARCHAR(36)” index=“1”/\>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<column name=“INSERT\_BY” header=“INSERT\_BY” type=“VARCHAR(32)” &nbsp;index=“4” /\>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp;

I know it’s finding the right file, and I know the types are right because I can use successfully with data copied right out of the CSV:

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<column name=“RULE\_ID” &nbsp;type=“VARCHAR(36)” value=“RULE1a”/\>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<column name=“RULE\_NUM” &nbsp;type=“INT” value=“1”/\>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<column name=“UPDATE\_TIME” &nbsp;type=“TIMESTAMP” value=“2012-07-17 19:25:52”/\>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Does anyone have any suggestions as to how I can troubleshoot this? &nbsp;It’s extremely frustrating.

Thanks,

Jeff

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [October 2, 2012, 2:58am UTC](https://forum.liquibase.org/t/problems-with-loaddata/2130/2 "2012-10-02T02:58:00Z")

</div>

I have the same Problem.  
  
Have you solved the problem Jeff ?

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 2, 2012, 2:58am UTC](https://forum.liquibase.org/t/problems-with-loaddata/2130/3 "2012-10-02T02:58:00Z")

</div>

If you run with logLevel=DEBUG what output do you see? Also, what liquibase version are you on?  
  
Nathan