After migrate database from 2.0 SPS 03 Revision 36 to 2.0. SPS 04 Revision 45 operation status is not permanently not OK. Actual stale, which is reported for user SYSTEM in Eclipse Administration Console:HXE 2.0 SPS 04 Revision 45 (02/2020): Operatio...
We have no idea, how to configure Remote source with adapter name "POSTGRESQL (GENERIC ODBC)" in HXE 2.0 SPS 04 Revision 45.
Creating always ends with error "SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Credential not f...
We have problem with datetime fields, when we work with HXE using ngdbc.jar (in eclipse or in own application).
Problem is in hours, when summer time is starting/ending.
For example this select shown different data, than are entered:
select to_...
Now we have always correct results after setting java parameter -Duser.timezone=GMT.
Note: It's fully independent on server's timezone.
Thank you very much
Jan
We think, this problem is in statement CASE. In Eclipse (in SQL Console) this example always ends with errors:
drop procedure save_log_1;
create procedure save_log_1(v_origin varchar(255), v_value varchar(5000)) as
CURSOR c_cursor1 (p_nid int...
I tried this command in Windows for timezone Australia/Sydney with automatic move time at start/end summer time:
java -jar $driver -u <user>,<pw> -n <hanahost> -i 90 -c "select to_seconddate('2017-10-01 02:00:00') as \"2017-10-01 02:00:00\", to_sec...
I found dependency on time zone parametr "move time at the start summer time and back":
Windows - Australia time zone (GMT+10:00 Sydney, ...): no problem
Windows - CET (GMT+01:00 Prague, no move time at start summer time): no problem
Windows - ...
