Why are DBconnect 3 sometime unable to write records, read timed out, unable_to_write_batch

[dailv1808]

I have DBconnect 3.1.5 running on a 8.1 instance.

sometime i got errors below and it will stop ingesting data.

[codebuilder]

That generally means your query is running too long or returning too many results, and you've exhausted the allocated memory or hit a config limit.

[dailv1808]

Thanks your response. In my case, I thinks it returning too many results. is there any way to fix it?

[codebuilder]

You can limit results by adding "maxrows" to your dbxquery.

maxrows=1000 for example. You can test with different values until you find one that doesn't cause the issue.

[dailv1808]

Error in HF (DBC3 is installed)

[dailv1808]

i tried many  different values  "maxrows" from 1000 to unlimit, and fetch size value from 300 to 1000, 3000, 30000,.. But it still got above errors.

[isoutamo]

Another thing what you could try with this is extend time-out.
R. Ismo

[dailv1808]

some time i got HEC service error

[dailv1808]

i change timeout to 300 seconds, it still got errors.