SubRES_Transformation

[JozefO]

Hi dear forum. Please Can you help me to solve this issue ? 
Please see attached.

Thank you
Jozef

[Ravinder]

Hi dear forum. Please Can you help me to solve this issue ? 
Please see attached.

Thank you
Jozef

Dear Jozef,

Could you please share the log file with us?

To find the latest log file, navigate to the Help menu and select the "Error Log" option to access the logs folder directly.

[Antti-L]

As Josefo has not responded, I tried to reproduce the error, and it was easy:  I simply named a SubRes file as "SubRes_Horná_Nitra_Novák_Substitution.xlsx", and I immediately got a similar error.  Extract from the log below:

Exception data:
    Severity: ERROR
    SqlState: P0001
    MessageText: Table temp_merge_vd_scen_to_veda_data_Hornß_Nitra_Novßk_Substitution does not exist.
    Hint: TABLE NOT FOUND.
    Where: PL/pgSQL function veda_front_end.usp_sync_remove_duplication_in_veda_data_scen(character varying,character varying) line 16 at RAISE
SQL statement "SELECT veda_front_end.usp_sync_remove_duplication_in_veda_data_scen(in_model_name , str_final_table_name)"
PL/pgSQL function veda_front_end.usp_sync_move_vd_scen_table_to_main_veda_data(character varying,character varying,character varying,character varying,boolean) line 121 at PERFORM
    File: pl_exec.c
    Line: 3873
    Routine: exec_stmt_raise

Maybe the extended Latin alphabet is not quite supported? 

[JozefO]

As Josefo has not responded, I tried to reproduce the error, and it was easy:  I simply named a SubRes file as "SubRes_Horná_Nitra_Novák_Substitution.xlsx", and I immediately got a similar error.  Extract from the log below:

Exception data:
    Severity: ERROR
    SqlState: P0001
    MessageText: Table temp_merge_vd_scen_to_veda_data_Hornß_Nitra_Novßk_Substitution does not exist.
    Hint: TABLE NOT FOUND.
    Where: PL/pgSQL function veda_front_end.usp_sync_remove_duplication_in_veda_data_scen(character varying,character varying) line 16 at RAISE
SQL statement "SELECT veda_front_end.usp_sync_remove_duplication_in_veda_data_scen(in_model_name , str_final_table_name)"
PL/pgSQL function veda_front_end.usp_sync_move_vd_scen_table_to_main_veda_data(character varying,character varying,character varying,character varying,boolean) line 121 at PERFORM
    File: pl_exec.c
    Line: 3873
    Routine: exec_stmt_raise

Maybe the extended Latin alphabet is not quite supported? 

Hello, I think its not the issue that i used extended latin alphabet. I tried it again after restart Veda and its seems it working. Veda synchronized SubRES file with name (Nováky_Coal_Substitution_Horná_Nitra) without errors now. 
Its weird why previous try shows error with this name of file. 

Also BROWSER in Veda is able to read diacritics and punctuation marks like (á, č, ž, ô, ť, ň...) but in RESULTS Veda shows name like this ( Tepláreň - Browser), ( Tepl%re! - Results).

Thank you.