./init_sptooldb_v5.0.csh SPTOOL_SRC_HOME = /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/src PERL_DBI = Pg New database: SPTOOL_DB = sptoolv5_0alpha_t1 SPTOOL_USER = farzad PERL_BIN = /usr/bin POSTGRES_BIN = /usr/bin /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/speciate5.0_exports/export_profiles_2019_0826.txt_clean /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/speciate5.0_exports/export_species_properties_2020_0313.txt_clean Database sptoolv5_0alpha_t1 created CREATE SCHEMA Shared schema created GRANT Create permissions granted on sptoolv5_0alpha_t1 GRANT All permissions granted on shared schema Defining custom functions and initializing tables. ...working Speciation Tool functions and tables successfully defined in sptoolv5_0alpha_t1. Importing mechanisms /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/mechanism_forImport_11Feb2020_speciate5_0_withSOAALK_13mar2020_v0.csv Using transactions - import of data will abort on any error. Reading data from /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/mechanism_forImport_11Feb2020_speciate5_0_withSOAALK_13mar2020_v0.csv... 1000 lines processed 2000 lines processed 3000 lines processed 4000 lines processed 5000 lines processed 6000 lines processed 7000 lines processed 8000 lines processed 9000 lines processed 10000 lines processed 11000 lines processed 12000 lines processed 13000 lines processed 14000 lines processed 15000 lines processed 16000 lines processed 17000 lines processed 18000 lines processed 19000 lines processed 20000 lines processed 21000 lines processed 22000 lines processed 23000 lines processed 24000 lines processed 25000 lines processed 26000 lines processed 27000 lines processed 28000 lines processed 29000 lines processed 30000 lines processed 31000 lines processed 32000 lines processed 33000 lines processed 34000 lines processed 35000 lines processed 36000 lines processed 37000 lines processed 38000 lines processed 39000 lines processed 40000 lines processed 41000 lines processed 42000 lines processed ...finished, imported 42685 lines. Importing PM mechanisms /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/mech_pm_ae5_ae6_ae8.txt Using transactions - import of data will abort on any error. Reading data from /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/mech_pm_ae5_ae6_ae8.txt... ...finished, imported 51 lines. Importing mechanism descriptions /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/sptool_mechanism_description_speciate5_0_04mar2020_v0.csv Using transactions - import of data will abort on any error. Reading data from /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/sptool_mechanism_description_speciate5_0_04mar2020_v0.csv... parse() failed on argument: "RACM2_AE7", “Regional Atmospheric Chemistry Mechanism version 2 (RACM2) for CMAQ AERO7 aerosol scheme”, Y,"Ramboll Greg Yarwood provided mechanism per spreadsheet Mechanism_mappings_for_SPECIATE5_25June2020.xlsx on 29Jun2020","","" Parse failed at record 11 ERRORS: Terminating import. Correct the formatting problem and rerun. ERROR: perl script failed for importing mechanism descriptions file /home/farzad/SPTOOL/Speciation-Tool-Speciation_Tool_5.0/import_data/sptool_mechanism_description_speciate5_0_04mar2020_v0.csv