bulkload otherID error

[DerekSikes]

Issue Documentation is http://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html

Describe the bug
A clear and concise description of what the bug is.

Upload a file to bulkload other IDs and get this error

An error occurred while processing this page!
Message: Error invoking external process
Detail: psql:/usr/local/webroot/temp/excopy_ffdss_20200625090643256_338.sql:73: ERROR: permission denied for sequence sq_cf_temp_oids_key CONTEXT: COPY cf_temp_oids, line 2: "UAM:Ento,catalog number,151002,BoLD barcode ID,PHLA001-20,"
Check the Arctos Handbook for more information on errors.

This message has been logged as 0DF8157A-9998-4BFA-904B6FBEBAB370B9 Please contact us with any information that might help us to resolve this problem. For best results, include the error and a detail description of how it came to occur in the Issue.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

** Data**
If this involves external data, attach the actual data that caused the problem. Do not attach a transformation or subset. You may ZIP most formats to attach, or request a Box email address for very large files.

See attached data
BulkloadOtherId.csv.zip

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

PS - can we get this form changed to use GUIDs instead of having to split GUIDs into GUID-prefix and separate 'catalog number' etc. (I suspect an issue already exists for this)

Priority
Please assign a priority-label.
High

[dustymc]

Should be fixed.

#2292, just needs prioritized

[DerekSikes]

Got past the validation step and clicked 'load valid' and got this error *An error occurred while processing this page!* Message: ERROR: insert or update on table "coll_obj_other_id_num" violates foreign key constraint "fk_collobjconthist_ctidref" Detail: Key (id_references)=() is not present in table "ctid_references". Where: SQL statement "INSERT INTO coll_obj_other_id_num( COLLECTION_OBJECT_ID, OTHER_ID_TYPE, OTHER_ID_PREFIX, OTHER_ID_NUMBER, OTHER_ID_SUFFIX, ID_REFERENCES ) values ( collection_object_id, other_id_type, part_one, part_two::numeric, part_three, ID_REFERENCES )" PL/pgSQL function parse_other_id(bigint,character varying,character varying,character varying) line 122 at SQL statement Detail: Check the Arctos Handbook <http://handbook.arctosdb.org/documentation/understanding-errors.html> for more information on errors. This message has been logged as CCBC79A1-2302-4C77-B3BDF7FB1306A79E Please contact us <https://github.com/ArctosDB/arctos/issues/new?assignees=&labels=contact&template=contact-arctos.md&title=error feedback> with any information that might help us to resolve this problem. For best results, include the error and a detail description of how it came to occur in the Issue.

…

On Thu, Jun 25, 2020 at 6:59 PM dustymc ***@***.***> wrote: Should be fixed. #2292 <#2292>, just needs prioritized — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2838 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACFNUMZ4KHE7N4JED37FYE3RYQFJZANCNFSM4OI5CVOQ> .

-- +++++++++++++++++++++++++++++++++++ Derek S. Sikes, Curator of Insects Professor of Entomology University of Alaska Museum 1962 Yukon Drive Fairbanks, AK 99775-6960 dssikes@alaska.edu phone: 907-474-6278 FAX: 907-474-5469 University of Alaska Museum - search 400,276 digitized arthropod records http://arctos.database.museum/uam_ento_all <http://www.uaf.edu/museum/collections/ento/> +++++++++++++++++++++++++++++++++++ Interested in Alaskan Entomology? Join the Alaska Entomological Society and / or sign up for the email listserv "Alaska Entomological Network" at http://www.akentsoc.org/contact_us

[dustymc]

Data please

[dustymc]

Nevermind, I looked up - fixed, patched, and your data loaded.