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(s) nested within the <task> directive(s) and change each value to false per the example shown below: Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> |
<task_name>mssql_test_subscribe</task_name> |
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.test" use_basic_consume="true" user="admin">amqps://test.perspectium.net</message_connection> |
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="testuser">https://mycompany.service-now. | com>
com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler> |
<decryption_key>This is my decryption key for testing</decryption_key> |
<database_type>sqlserver</database_type>
<database_server>localhost</database_server> |
<database_port>1433</database_port> |
user>root<user>testuser</database_user> |
password/>
password>testpassword</database_password>
<database_ | params _column_size>251</database_column_max | _column
<database>psp_repl</database> |
<force_preparedstatement_reload>false</force_preparedstatement_reload> |
<max_reads_per_connect>4000</max_reads_per_connect> |
<polling_interval>5</polling_interval> |
<skip_message_set_processing/> |
|