CI not correctly loading the household_consumption table

micronutrientsupport / database-architecture

The Postgres database code for the MAPS tool

3 stars 0 forks source link

CI not correctly loading the household_consumption table #305

Closed bgsandan closed 2 years ago

bgsandan commented 2 years ago

Household consumption table is empty on DB builds.

Following message (non-failing) appears in the CI logs:

rbroth commented 2 years ago

problem is that WAFCT is not being loaded, mena s this entry isn't being loaded:

12_012,"Juice, canned or bottled, sweetened (e.g. apple)",23670.01.02,flavoured ice,Other foods,sugar (raw equivalent) and products,medium,WAFCT,"DK2(194), US28(09016)",87.9,48,203,NA,0.1,0.1,0,0,0,0,11.5,0.2,0.2,9,0.3,5,6,80,10,0.04,0.01,NA,NA,NA,0,0.02,0.02,0.1,0.03,0,0,0,NA,NA,1,0,0.01,NA

Presumably if we fix this entry there will be other entries that will break

andy-bevan commented 2 years ago

This error seems to have been fixed as it is no longer occurring on the master branch and the household_consumption table is being populated. @bgsandan Can you confirm?

bgsandan commented 2 years ago

I suspect that this issue may have gone away with the reduction in FCTs being loaded into the system. Happy to close this issue for now, but we will see if it re-rears it's head once we've properly cracked the whole FCT matching piece