# error in uploading address-hierarchy

**URL:** <https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982>\
**Category:** Bahmni\
**Created:** [March 19, 2018, 3:31am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982 "2018-03-19T03:31:59Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 3:31am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/1 "2018-03-19T03:31:59Z")

</div>

Hello guys, please help. I have this error several times. I uploaded the file address-hierarchy.cvs in the demo. it went through fine. But when I uploaded in my system it gave the error below. I would like to know how to go around this error and also how to upload my file successfully.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 3:37am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/2 "2018-03-19T03:37:50Z")

</div>

Please kindly give the details of the OpenMRS module and Refapp versions and the error log at [pastebin.com](http://pastebin.com) to make troubleshooting easy

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:03am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/3 "2018-03-19T04:03:06Z")

</div>

Thank you for replying

 ![2018-03-18 (1)](https://talk.openmrs.org/uploads/default/original/2X/9/90c3e709998a6092f54fc661a6a033d78bbe48a1.png)

this is what i get when I uploaded in the demo but when I upload in my system I get this error

 ![2018-03-18](https://talk.openmrs.org/uploads/default/original/2X/7/733d639fe7cfe6a9c50bd4e5b14cfeda7784c789.png)

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:09am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/4 "2018-03-19T04:09:08Z")

</div>

The file I had uploaded was like this

 ![2018-03-18 (2)](https://talk.openmrs.org/uploads/default/original/2X/1/15381927737362c87bd1727dae9121c89c8dd600.png)

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:19am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/5 "2018-03-19T04:19:32Z")

</div>

@ezechiel

1.Where did you get the csv file from

2.Are you sure all the data was correctly written into the database?

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:21am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/6 "2018-03-19T04:21:51Z")

</div>

@tendomart I wrote everything using excel then i converted the file to .csv. [address-hierarchy.csv](https://talk.openmrs.org/uploads/default/original/2X/9/904a194906560e847dc7a05140ee5dd7af3a6cb0.csv) (2.9 KB)

this is a full copy.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:23am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/7 "2018-03-19T04:23:16Z")

</div>

This may happen because during upload of the module,some data was lost ,that’s why your log is saying " no row with a given identifier exists".

Also try running this command in your mysql client

{ SHOW VARIABLES like ‘max\_allowed\_packet’ } and see the output

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:25am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/8 "2018-03-19T04:25:09Z")

</div>

sorry i am not good with this, all I know is to use the terminal. Is it the same thing as mysql client?

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:29am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/9 "2018-03-19T04:29:02Z")

</div>

@tendomartsorry i am not good with this, all I know is to use the terminal. Is it the same thing as mysql client?

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:33am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/10 "2018-03-19T04:33:33Z")

</div>

if you know how to use terminal then the mysql client is accessible with

mysql -p -u root as long as mysql is installed

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:37am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/11 "2018-03-19T04:37:40Z")

</div>

But anyways @tendomart you did not specify the OpenMRS version (Refapp and module you are using in the first place)

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:39am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/12 "2018-03-19T04:39:04Z")

</div>

![2018-03-18 (3)](https://talk.openmrs.org/uploads/default/original/2X/d/ddfc9d7d2912c2ed8abbf01109566dcc5fab5e49.jpg)

I looks like I can’t login in. Not sure why

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:42am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/13 "2018-03-19T04:42:47Z")

</div>

@tendomart I am using the v.90

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:43am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/14 "2018-03-19T04:43:00Z")

</div>

@tendomart Which password did you use while configuring your mysql?It should work correctly. No one knows it but you,Try giving all details please

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:45am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/15 "2018-03-19T04:45:03Z")

</div>

@tendomart I don’t think i set up the password . The only password I set up was for root. Is it too late at this point to set it up? unless there is a default password for it.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:54am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/16 "2018-03-19T04:54:51Z")

</div>

Use that password

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:56am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/17 "2018-03-19T04:56:22Z")

</div>

That is what i used multiple times it is not going through. I am not sure either what is wrong

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 4:57am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/18 "2018-03-19T04:57:52Z")

</div>

Try leaving the password field blank

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 4:58am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/19 "2018-03-19T04:58:29Z")

</div>

I tried that too, nope it is not letting me through.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:04am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/20 "2018-03-19T05:04:16Z")

</div>

@ezechiel am afraid you may have to re-install mysql,if you have not backed up your data,you may lose it…I know no other option passwords should be jeolously and carefully kept.

[Next page](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982.md?page=2)
