topic Data Agent troubleshoot in Data & Schema Discussions

Data Agent troubleshoot

RADSr — Sat, 30 Jul 2022 13:48:08 GMT

Data agent is enabled and has been running up until update ( you can see where this is going ).

After update ( several jumps to 2022.7.3 ) of cluster and data agent:

Agent service is running

Agent status is a green checkmark

External data source which uses data agent tests successfully

Creating a new table w/ source I can write, execute ( and view result set ), and validate a data source.

Loading the new table - and existing tables - using the external data source fails.

This last bit is what is throwing me. Obviously Incorta can connect to the DB as it is bringing results back to the editing window when I hit "execute," but it's still barking when trying to load data:

==== snip from loader log ========

Caused by: com.incorta.connector.errors.DiscoveryException: Error of type SQLException while discovering columns from datasource [SQL_Anywhere_17] due to: Not implemented at com.incorta.connector.sql.SQLDataSet.queryNullBatch(SQLDataSet.java:837) at

=== end snip =========

I do have a ( sev 1 ) support ticket open, but posting on the chance that somebody who's gone through an update may have seen and resolved this. Maybe a java update?

Re: Data Agent troubleshoot

RADSr — Sat, 30 Jul 2022 19:33:38 GMT

So here's the solution ( tempting fate because it's in process 😉 ) - there had been similar issues w/ this ecosystem pre-me, the support ticket(s) had been submitted under an organization which wasn't the customer so I had/have no insight into that history.

One of those issues had to do w/ the custom connector and required a custom .jar file which was overwritten by the update process.

Support ( awesome job! ) rapidly confirmed the steps I'd taken, investigated further, and engaged the development team to deliver a new customer .jar.

I'm writing this on a Saturday, so even extra kudos to everyone involved! ( if some of you Incorta employees know the correct Exec VP of Support to "@" with this positive feedback please feel free to do so ).

Re: Data Agent troubleshoot

JoeM — Mon, 01 Aug 2022 02:38:29 GMT

Mentioning our support leader @FadiB !

Re: Data Agent troubleshoot

FadiB — Mon, 01 Aug 2022 09:46:33 GMT

Thank you very much for sharing the feedback on the team @RADSr !