Change the <force_preparedstatement_reload> directive's value to falseOpen your agent.xml file in a text editing application. Then, locate the <force_preparedstatement_reload> directive and change its directive(s) nested within the <task> directive(s) and change each value to false per the example shown below: <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> <config> <agent> <share/> <subscribe> <task instances="4"> <task_name>ivanname>mssql_test_subscribe</task_name> <message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.test_2" use_basic_consume="true" user="admin">amqps://test.perspectium.net</message_connection> <instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="admintestuser">https://mycompany.service-now.com> <handler>com.perspectium.replicator.sql.SQLSubscriber</handler> <decryption_key>Thekey>This cowis jumpedmy overdecryption thekey moon and the sun<for testing</decryption_key> <database_type>mysql</database_type> <database_server>localhost</database_server> <database_port>1433</database_port> <database_user>root</database_user> <database_password/> <database_parms>characterEncoding=UTF-8 & useSSL=false</database_parms>params/> <database_max_column_size>251</database_max_column_size> <database>psp_repl</database> <temporal> <columns> <column column_type="93" column_size="32" type="from">psp_from</column> <column column_type="93" column_size="32" type="to">psp_to</column> </columns> <max_datetime>2030-12-31 00:00:00</max_datetime> </temporal><force_preparedstatement_reload>false</force_preparedstatement_reload> </task> </subscribe> <max_reads_per_connect>4000</max_reads_per_connect> <polling_interval>5</polling_interval> <skip_message_set_processing/> </agent> </config> |
|