search

phoenixctms / ctsms

Phoenix CTMS - the ultimative CTMS/PRS/CDMS.
http://www.phoenixctms.org
GNU Lesser General Public License v2.1
53 stars 35 forks source link

Import error during eCRF Data Import #325

Closed codonAG closed 1 week ago

codonAG commented 1 week ago

We tried an import of the eCRF data and get following error message error

The user my_department_cron exists and I set the password for the user on the web page. users

The password is also setted in the config.job.cfg `phoenix@phoenixctms:/ctsms/bulk_processor/CTSMS/BulkProcessor/Projects/ETL/EcrfImporter$ cat config.job.cfg

general settings:

working_path = /ctsms/bulk_processor/output/ecrf_importer

enablemultithreading = 1

gearman/service listener config:

jobservers = 127.0.0.1:4730

Phoenix PostgreSQL connectivity - "ctsms" db:

ctsms_host = 127.0.0.1 ctsms_port = 5432 ctsms_databasename = ctsms ctsms_username = ctsms ctsms_password = ctsms

ctsms REST-API connectivity:

ctsmsrestapi_uri = http://127.0.0.1:8080/rest ctsmsrestapi_username = my_department_cron ctsmsrestapi_password = ctsmsrestapi_realm = api

sending email:

emailenable = 0 erroremailrecipient = warnemailrecipient = completionemailrecipient = doneemailrecipient =

smtp_server= smtpuser= smtppasswd=

logging:

fileloglevel = OFF screenloglevel = OFF screenlogstderr = 0 emailloglevel = INFO phoenix@phoenixctms:/ctsms/bulk_processor/CTSMS/BulkProcessor/Projects/ETL/EcrfImporter$ ^C phoenix@phoenixctms:/ctsms/bulk_processor/CTSMS/BulkProcessor/Projects/ETL/EcrfImporter$ cat config.job.cfg

general settings:

working_path = /ctsms/bulk_processor/output/ecrf_importer

enablemultithreading = 1

gearman/service listener config:

jobservers = 127.0.0.1:4730

Phoenix PostgreSQL connectivity - "ctsms" db:

ctsms_host = 127.0.0.1 ctsms_port = 5432 ctsms_databasename = ctsms ctsms_username = ctsms ctsms_password = ctsms

ctsms REST-API connectivity:

ctsmsrestapi_uri = http://127.0.0.1:8080/rest ctsmsrestapi_username = my_department_cron ctsmsrestapi_password = ctsmsrestapi_realm = api

sending email:

emailenable = 0 erroremailrecipient = warnemailrecipient = completionemailrecipient = doneemailrecipient =

smtp_server= smtpuser= smtppasswd=

logging:

fileloglevel = OFF screenloglevel = OFF screenlogstderr = 0 emailloglevel = INFO `

rkrenn commented 1 week ago

ok, pls check if the user "my_department_cron" exists (and exists exactly 1 time). the error message "error loading user" indicates it fails to lookup the particular apiuser, see https://github.com/search?q=repo%3Aphoenixctms%2Fbulk-processor%20error%20loading%20user&type=code

pls avoid posting passwords here directly.

codonAG commented 1 week ago

the user exists only once.

rkrenn commented 1 week ago

ok let us know if the issue also persits on a vanilla deployment, we will then investigate if there is a problem with the factory setup.

codonAG commented 1 week ago

How can I take a vanilla deployment?

rkrenn commented 1 week ago

just install it from scratch ( https://www.phoenixctms.org/installation/ ) separately, and try your setup+import there.

rkrenn commented 1 week ago

verified, works (see below). if you need further assistance with adjusting configs or upgrading phoenix instances, contact sales@phoenixctms.org.

closing ticket.

grafik