CommCare data export tool: Authentication failed. Please check your credentials


(André van Zyl) #1

Good day!

I’m having problems with the data export tool for both basic markdown and PostgreSQL exports:

“Authentication failed. Please check your credentials.”

I’m using the same authentication credentials I use for CommCare HQ.

I hope someone could indicate what I’m missing here:

# Markdown

C:\Users\andre.vanzyl\Documents\PROLIFE\CommCare Data Export Tool>commcare-export --output-format markdown  --project prolife --query prolifedata.xlsx --username my@gmail.com --password ****************
# CASES
| id | screening_id | study_number | do_not_record | contact_phone_number | a_alternative_phone_number | sex |
2018-12-11 07:19:09,854 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 1 attempts (0.0s). Waiting for retry.
2018-12-11 07:19:10,222 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 2 attempts (1.7s). Waiting for retry.
2018-12-11 07:19:10,774 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 3 attempts (2.3s). Waiting for retry.
2018-12-11 07:19:11,872 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 4 attempts (3.4s). Waiting for retry.
2018-12-11 07:19:13,371 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 5 attempts (4.9s). Waiting for retry.
2018-12-11 07:19:22,418 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 6 attempts (13.9s). Waiting for retry.
2018-12-11 07:19:29,712 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 7 attempts (21.2s). Waiting for retry.
2018-12-11 07:19:35,399 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 8 attempts (26.9s). Waiting for retry.
2018-12-11 07:20:32,970 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 9 attempts (84.5s). Waiting for retry.
2018-12-11 07:21:21,697 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 10 attempts (133.1s). Waiting for retry.
2018-12-11 07:23:57,537 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 11 attempts (287.9s). Waiting for retry.
2018-12-11 07:24:09,970 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 12 attempts (301.5s). Giving up.
Authentication failed. Please check your credentials.```

# PostgreSQL

 ```C:\Users\andre.vanzyl\Documents\PROLIFE\CommCare Data Export Tool>commcare-export --output-format sql --output postgresql://postgres:<password>@127.0.0.1/PROLIFE --project prolife --query prolifedata.xlsx --username my@gmail.com --password *******
2018-12-11 08:57:35,652 commcare_export.cli WARNING  No successful runs found, and --since not specified: will import ALL data
2018-12-11 08:57:42,283 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 1 attempts (0.0s). Waiting for retry.
2018-12-11 08:57:43,494 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 2 attempts (7.1s). Waiting for retry.
2018-12-11 08:57:44,535 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 3 attempts (8.1s). Waiting for retry.
2018-12-11 08:57:47,275 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 4 attempts (10.9s). Waiting for retry.
2018-12-11 08:57:53,466 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 5 attempts (17.1s). Waiting for retry.
2018-12-11 08:57:58,142 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 6 attempts (21.6s). Waiting for retry.
2018-12-11 08:58:10,470 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 7 attempts (34.1s). Waiting for retry.
2018-12-11 08:59:13,211 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 8 attempts (96.8s). Waiting for retry.
2018-12-11 09:00:56,685 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 9 attempts (199.5s). Waiting for retry.
2018-12-11 09:02:39,117 c:\program files\python37\lib\site-packages\commcare_export\commcare_hq_client.py WARNING  Request failed after 10 attempts (301.5s). Giving up.


Authentication failed. Please check your credentials.```

Thank you very much!

(Jos van der Ent) #2

I quickly checked my logs and I see several requests were not processed and it looks like due to the maintenance/downtime of the last days. (data export tool with python 2.7 to Postgres)
At least for this morning (now) it looks like it is running normally again.


(André van Zyl) #3

Thanks, Jos, it is working again.


(André van Zyl) #4

Hi Jos,

Are the servers down again? I’m having the same problem.

Regards,

André