ERROR: division by zero inPL/pgSQL function otg_calc_transformer_specifications()

[IsGut]

https://github.com/openego/osmTGmod/blob/features/egon/sql-scripts/functions.sql#L2502C21-L2502C33

Hi, unfortunately, this leading to error

NOTICE: v_branch.branch_id: 24907
NOTICE: v_branch.f_bus: 31814
NOTICE: v_branch.t_bus: 31815
NOTICE: v_S_long_MVA_sum_min: 0
NOTICE: v_U_OS: 380000
NOTICE: v_U_US: 110000
NOTICE: v_numb_transformers: 0
NOTICE: v_Srt: 3e+08
NOTICE: v_u_kr: 14
NOTICE: v_Z_TOS: 67.386665
NOTICE: v_X_TOS: 67.386665
NOTICE: v_Bl_TOS: -0.014839731
NOTICE: v_Bl_TOS_all: -0

ERROR: division by zero

e.g. [2024-10-19, 16:29:46 UTC] {init.py:484} ERROR - Exception raised with command 260. Check *** and code and restart with 'python ego_otg.py status2019 260'.
Traceback (most recent call last):
File "/home/ise/execution_folder/powerd-data/src/egon/data/datasets/osmtgmod/init.py", line 481, in osmtgmod
cur.execute(command)
psycopg2.errors.DivisionByZero: division by zero
CONTEXT: PL/pgSQL function otg_calc_transformer_specifications() line 54 at assignment

Executing SQL statement 260: called here https://github.com/openego/powerd-data/blob/features/auto-update-function/src/egon/data/datasets/osmtgmod/__init__.py#L484

[IsGut]

As quickfix I would suggest something like take max if min is 0, e.g.

NOTICE: v_branch.branch_id: 24485
NOTICE: v_branch.f_bus: 28165
NOTICE: v_branch.t_bus: 28166
NOTICE: v_S_long_MVA_sum_min: 0
NOTICE: v_S_long_MVA_sum_max: 1040
NOTICE: v_U_OS: 220000
NOTICE: v_U_US: 110000
NOTICE: v_numb_transformers: 0 <- leading to v_Bl_TOS_all is 0
NOTICE: v_numb_transformers_max: 6
NOTICE: v_Srt: 2e+08
NOTICE: v_u_kr: 12
NOTICE: v_Z_TOS: 29.04
NOTICE: v_X_TOS: 29.04
NOTICE: v_Bl_TOS: -0.03443526
NOTICE: v_Bl_TOS_all: -0 <- due to v_numb_transformers is 0

[IsGut]

Hi @ulfmueller @ClaraBuettner
as mentioned in our last jour fix, I faced an issue with osmtgmod. I assume for min, we don't have valid data for whole Germany, thus, Exception raised with command 260. Check *** and code and restart with 'python ego_otg.py status2019 260'. called here https://github.com/openego/powerd-data/blob/features/auto-update-function/src/egon/data/datasets/osmtgmod/__init__.py#L484

And resulting in an empty schemas.osmtgmod_results.branch_data & an empty schemas.osmtgmod_results.bus_data table

Testing with SH was working for me.

[ClaraBuettner]

We fixed this problem in #18

There were some issues with two substations, both of them are not inside Schleswig-Holstein, so the test mode worked.