zazuko / cube-creator

A tool to create RDF cubes from CSV files
GNU Affero General Public License v3.0
12 stars 2 forks source link

Auto-fill Shared Dimension Mapping fails - unknown error #1372

Closed FabianCretton closed 1 year ago

FabianCretton commented 1 year ago

Véronique and myself tried a few 'auto-fill' today, with municipalities, without success: image

Cube Creator version 1.13.3 (4325eba) Last trial - Project: https://int.cube-creator.lindas.admin.ch/app/cube-projects/cube-project!!fabdemosdmunicipalityfrom-scratch-1vn3pg03mly/metadata

Can you identify what is happening as we do not get any useful information ?

tpluscode commented 1 year ago

The problem is with the query which attempts to match and insert the new mapping entries in one go. Given large enough datasets (in this case 1600 unmapped values and 2100 municipalities) the query times out

Separating the query which finds municipalities appears to help. Will have a fix soon