Agribalyse 3.0.1 import issue

[cyrillefrancois]

I face issue when importing Agribalyse from OLCA. This issue seams related to uncertainty format and more specifically on the log-normal distribution that require math.log function (negative unaccepted)

[R-Hammer]

have also an error and a fix would be great!

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Cell In [5], line 18
     11 # 'selected_methods' argument is a list of methods names that will be extracted
     12 # you can specify [] to import no method or 'all' to import all available methods
     13 # the default value is 'all' 
     14 selected_methods = ['CML-IA baseline',
     15                     'ILCD 2011 Midpoint+',
     16                     'ReCiPe 2016 Midpoint (H)']
---> 18 olca2bw.load_openLCA_IPC(project_name="Agribalyse3",
     19                         nonuser_db_name = 'Agribalyse3', 
     20                         user_databases=User_folder,
     21                         #excluded_folders=unused_folders,
     22                         #selected_methods=selected_methods,
     23                         overwrite = True)

File c:\Users\Pro\anaconda3\envs\ab_dev\lib\site-packages\openlca2bw\main.py:99, in load_openLCA_IPC(port, project_name, overwrite, nonuser_db_name, check_nonuser_exc, user_databases, excluded_folders, exclude_S, selected_methods, verbose)
     97 #Extraction data
     98 print("\nImporting processes from OpenLCA \n")
---> 99 dict_processes, list_parameters, dict_missed_providers = client.extract_list_process(databases_folders = databases_folders,exclude_S = exclude_S, update=False)
    100 #Writing data
    101 for db, list_process in dict_processes.items():

File c:\Users\Pro\anaconda3\envs\ab_dev\lib\site-packages\openlca2bw\extract.py:247, in Extraction_functions.extract_list_process(self, databases_folders, exclude_S, update)
    245 for p_id in databases_ids[db]:
...
    152         'loc': sign * return_attribute(uncertainty_dict,'mean'),
    153         'scale': return_attribute(uncertainty_dict,'sd')
    154         })

ValueError: math domain error

[cyrillefrancois]

I'm working on a new release that should fix issues. But the Agribalyse 3.0.1 database in OpenLCA has several problems:

• Some parameters are not well writen in formula. here is the list of processes have found: 81065253-ef4c-344d-b8b8-f78f2e9c0514 | Qp a63ff9e4-d389-3d19-a8c6-6602025ce4ce | Qp 4b5fe716-bf26-3a80-bae4-178932571684 | Ibas f9de40c6-c175-354d-9be4-d9092acd5238 | r 76fd6ee3-1ff4-3f12-9697-598d3749d194 | Qp 2ab3751c-3b1c-333b-87f9-3f153357ff71 | Qp 2be958e0-0931-3995-9340-86c72fbb15d1 | Qp 4e28d556-3324-373a-848d-3a6fa86c13e9 | Qp cf6d5be7-b187-3f75-b60c-322c96d2d68a | Qp
• Agribalyse rely on many Ecoinvent process and most of them are LCI results, so it's very long to import.
• Then Agribalyse database also never mention the provider in the input/output table. So to transfer into BW it needs time to find the proper provider.

I have not worked with the new Agribalyse database release recently, but it seems that it is available with the bw2package format.