Issue on Deprecated: SendGrid Query (java.lang.NoClassDefFoundError: Could not initialize class XcoreXsendgridX200X7627.po)

Matillion ETL
1

Recently we upgraded our Matillion ETL from version 1.68.21 to 1.75.0 we are facing this issue after this upgradation in our version 1.68.21 the job work fine but facing error on version 1.75.0 like on the screenshot. Is there any idea on this.

069Tm000007xM8XIAU_0D5Tm00000IPX7eKAH
069Tm000007xM8XIAU_0D5Tm00000IPX7eKAH1622×857 91 KB

2

Hi @HariRamK​

Thanks for your post, to fix this you need to take that version of the connector off then re-add the new version and set it back up. I am sorry for the confusion caused this is due to upgrading of Java and some of our connectors.

Kind regards, Joe

3

Just to note @HariRamK​

I will remove your posts from the AMA as that thread is for use on that subject, that being said, I am looking into the other post too.

Thanks Joe

4

@JoeCommunityManager ​

I need another help; the above comment helps me lot but there are some missing of Datasource but that exist in old version component and also there is also new configuration column called "API" it had two options "Legacy,NMC" may I know what the meaning of it is, there is no proper document for it. I will attach the screenshot for your reference:

069Tm000007xYxiIAE_0D7Tm000001ewW9KAI
069Tm000007xYxiIAE_0D7Tm000001ewW9KAI997×872 48.2 KB

Please make it quick glance it an emergency

5

That's Ok, good to hear from you,

Thanks for the answer @JoeCommunityManager​

6

Hi @HariRamK​

I spoke with the team who explained to me that The SendGrid connector uses a driver underneath to talk to the SendGrid API,

Since there are 2 types of APIs that it could talk to there are 2 Schemas that are being exposed:

  • https://cdn.cdata.com/help/BGK/jdbc/RSBSendgrid_p_Schema.htm

Once Schema is selected a different set of Data Sources would appear.

Here is the schema for CustomFields if Legacy Data Model API/Schema is selected:

  • https://cdn.cdata.com/help/BGK/jdbc/pg_legacytable-customfields.htm

However, because that table does not exist in NMC they are seeing the error:

  • https://cdn.cdata.com/help/BGK/jdbc/pg_nmcalltables.htm

Advice would be to switch to the Legacy Data Model API.

I hope that helps.

Kind regards, Joe

7

Pleasure to help

 

If you need anything else, please let me know.

 

Kind regards, Joe

8

@JoeCommunityManager​ Thank you for the Quick reply I helped me lot I finally completed my Job it looks fine.

9

Great news!