corp-000 3.14.5 sybase anywhere 11
store-001 3.14.4. mriadb 10.2.36
OS linux
whatever relaod node or table don nothing, sym_table_reload is see the event, but staging no output file (CSV)
any help?
by the way, DML working as expected
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
syadmin --engines corp-000 relaod-table -node 001 succesfully no err
and log no error. the sym_relod_request status ok
but just no data received.
sym_node_security inital_load_enabled=1
so anything else to check?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
yes, we did set that in symmetric-server.properties, but seems not see any change.
we found out
select initial_load_enabled from SCK.sym_node_security
= 0
we udpate to 1 and restart target symmetricDS, it set to 0 again.
by the way, DML working fine. just initial load get nothing.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After setting the value to 1, it is expected behavior for this to change back to 0. When this changes back to 0, it is also setting the initial load time to when it started. It also sets the initial load id to whatever value it was at when the load was created.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
corp-000 3.14.5 sybase anywhere 11
store-001 3.14.4. mriadb 10.2.36
OS linux
whatever relaod node or table don nothing, sym_table_reload is see the event, but staging no output file (CSV)
any help?
by the way, DML working as expected
syadmin --engines corp-000 relaod-table -node 001 succesfully no err
and log no error. the sym_relod_request status ok
but just no data received.
sym_node_security inital_load_enabled=1
so anything else to check?
On the Sybase node, set the following system property to true by adding it to symmetric-server.properties. Then restart SymmetricDS.
spring.jdbc.getParameterType.ignore=true
yes, we did set that in symmetric-server.properties, but seems not see any change.
we found out
select initial_load_enabled from SCK.sym_node_security
= 0
we udpate to 1 and restart target symmetricDS, it set to 0 again.
by the way, DML working fine. just initial load get nothing.
is it config issue? in target auto reload = true.
After setting the value to 1, it is expected behavior for this to change back to 0. When this changes back to 0, it is also setting the initial load time to when it started. It also sets the initial load id to whatever value it was at when the load was created.