500 internal server error when importing

245 views
Skip to first unread message

nctrdigit...@gmail.com

unread,
Oct 11, 2017, 3:29:09 PM10/11/17
to AtoM Users
Hi there,

I am currently playing around with AtoM on a test server and am encountering an error with the import feature. When importing a CSV file, I get the error "500 internal server error" (see attached screenshot). At first, I thought it may just be that my CSV file was not formatted, but I even tried it with the sample CSV file provided by Artefactual and am encountering the same error. I then consulted with a colleague at a different institution and it turns out they are having the same issue as of version 2.4 (the same version I have).

Is this a known error that is currently working to be fixed?

Thanks,
Jarad Buckwold
Capture.PNG

Maryna Chernyavska

unread,
Oct 11, 2017, 3:45:11 PM10/11/17
to ica-ato...@googlegroups.com
I get the same error when trying to import a csv file via web interface (also 2.4). I can do csv imports via command line which helps, but it would be nice to be able to do what seemed to work in 2.3.1.



Maryna Chernyavska, MA, MLIS
Folklore Archivist
Bohdan Medwidsky Ukrainian Folklore Archives
Kule Folklore Centre
University of Alberta

250 Old Arts Bldg., University of Alberta
Edmonton, AB  T6G 2E6


--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/5da21038-9f12-4d3f-ba39-9b0d2095fb06%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dan Gillean

unread,
Oct 11, 2017, 4:08:35 PM10/11/17
to ICA-AtoM Users
Hi both, 

Whenever you encounter a 500 error, it is useful to try to take a look at the webserver logs to see if there is more information. See: 
Please feel free to share any related error message that you find there if the following suggestions do not help to resolve the issue. 

Jarad, what version of AtoM are you using? In 2.4, CSV imports are handled by the job scheduler, so trying to restart the job scheduler is the first place to start. 

For this to work, the job scheduler and its dependencies must be installed and properly configured. See: 

If the job scheduler and the other dependencies are installed, it might be that you need to restart it. You can try the following commands, run from the root AtoM directory. 

If you have followed our installation instructions for Ubuntu 14.04, these commands can be used: 

  • sudo start atom-worker   # Starts the worker
  • sudo stop atom-worker    # Stops the worker
  • sudo restart atom-worker # Restarts the workers
  • sudo status atom-worker  # Obtain current running status
If you have installed following the Ubuntu 16.04 documentation, then try the following: 
  • sudo systemctl start atom-worker         # Starts the worker 
  • sudo systemctl stop atom-worker     # Stops the worker 
  • sudo systemctl restart atom-worker    # Restarts the workers 
  • sudo systemctl status atom-worker   # Obtains current status
If restarting the atom-worker doesn't resolve the issue, then please share the error message you find in the webserver logs, and we can go from there.

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory

On Wed, Oct 11, 2017 at 3:44 PM, Maryna Chernyavska <cher...@ualberta.ca> wrote:
I get the same error when trying to import a csv file via web interface (also 2.4). I can do csv imports via command line which helps, but it would be nice to be able to do what seemed to work in 2.3.1.



Maryna Chernyavska, MA, MLIS
Folklore Archivist
Bohdan Medwidsky Ukrainian Folklore Archives
Kule Folklore Centre
University of Alberta

250 Old Arts Bldg., University of Alberta
Edmonton, AB  T6G 2E6

On Wed, Oct 11, 2017 at 1:29 PM, <nctrdigit...@gmail.com> wrote:
Hi there,

I am currently playing around with AtoM on a test server and am encountering an error with the import feature. When importing a CSV file, I get the error "500 internal server error" (see attached screenshot). At first, I thought it may just be that my CSV file was not formatted, but I even tried it with the sample CSV file provided by Artefactual and am encountering the same error. I then consulted with a colleague at a different institution and it turns out they are having the same issue as of version 2.4 (the same version I have).

Is this a known error that is currently working to be fixed?

Thanks,
Jarad Buckwold

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAJfKj5V2kw9WVWTNzb10YN41nV%2B_T%3DcVS1HrDVHFvBcRgW1S1A%40mail.gmail.com.

Maryna Chernyavska

unread,
Oct 11, 2017, 6:06:00 PM10/11/17
to ica-ato...@googlegroups.com
Hi Dan,

Thanks for your reply. Here's some info from the server log:

142.244.5.136 - - [03/Oct/2017:17:03:06 +0000] "POST /index.php/object/importSelect HTTP/1.1" 500 878 "https://archives.ukrfolk.ca/index.php/object/importSelect?type=csv" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_1) AppleWebKit/602.2.14 (KHTML, like Gecko) Version/10.0.1 Safari/602.2.14"

We'll try restarting the job scheduler and see if it helps.

Maryna




--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.

José Raddaoui

unread,
Oct 12, 2017, 4:26:09 AM10/12/17
to AtoM Users
Hi all,

The following issue has been recently found in the 2.4 version:


This affects imports to an specified description, accessed through the links in the right column of the description index page. Maryna's error seems to be happening in the global import so it may be another issue.

Regards.

nctrdigit...@gmail.com

unread,
Oct 12, 2017, 9:17:15 AM10/12/17
to AtoM Users
Hi Dan,

Thanks for the reply. Based on José's response below, it sounds like an internal issue, but just in case, I will post the log results in case that helps anyone (or reveals an entirely separate issue I have).  See attached screen shot.

Thanks!
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.

To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
Capture.PNG

Dan Gillean

unread,
Oct 12, 2017, 11:54:28 AM10/12/17
to ICA-AtoM Users
Hi Jarad, 

Your issue definitely sounds like Gearman (the Job scheduler) is either not running or not properly installed. Please review and try the suggestions I included in my first message; I suspect this will solve your issue. 

Maryna, let us know if restarting the atom-worker helps in your case as well. As Radda noted, the issue we've identified is (at least as far as we currently know) when attempting to import a CSV to an existing description, using the Import link on the description view page. I'll do some more testing, but we did test general CSV import a lot while prepping 2.4 (since there are so many new enhancements!) so I would be surprised if this same issue was preventing all imports. 

Any further details you can provide me so I can try to reproduce are welcome! Additionally, if your import CSV is not confidential, feel free to email it to me directly and I'll try using it in my local testing. 

Regards, 



Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory

To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.

Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/92219823-9d61-49c4-b468-dc7938279be1%40googlegroups.com.

buck...@gmail.com

unread,
Oct 13, 2017, 12:48:56 PM10/13/17
to AtoM Users
Hi Dan,

You were indeed correct. The changes you suggested fixed the issue.  Thanks so much for your help.

Jarad

Dan Gillean

unread,
Oct 13, 2017, 1:30:04 PM10/13/17
to ICA-AtoM Users
Glad to hear it, Jarad! Thanks for updating the thread and letting us know. 

Regards, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory

To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.

Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/3ad15996-09a3-45a0-93e8-ba83478447b7%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages