Talend 6.0 Retrieve Schema

[Anonymous]

Hello,

I am facing issue while  clicking on Retrieve schema from metadata option using access DB in Talend 6.0

New views which are created in access database are not showing in Retrieve Schema therefore its difficult to add those views in Talend Job.

Please look into this issue.

Thanks & Regards

Sanjoy

[Anonymous]

Hello Richard,

Thanks for your reply

I have tried to edit connection but I am not able to do so and also getting error. I am also try to do revert context but nothing
happen when I am clicking on Revert Context.
I have attached the error message screenshot with this post.

Best Regards
Sanjoy

image_2019_02_28T06_54_31_936Z.png

[Anonymous]

Can you just create a new database connection and test that?

[Anonymous]

Hello Richard,

I have tried with creating new connection also but its giving same error.
Is Talend 7.1 has support office 365? As I have Access DB.
I checked its showing 2003 and 2007 in Talend site as access support.

Thanks.

Regards,

Sanjoy Ganguly

[Anonymous]

Have you tried entering your connection parameters without using Context variables? Previously you had Context variables being used. Since I could not see the values of the Context variables, it made it hard for me to figure out what could be the cause. If you get an error can you copy and paste the all of the text of the error. That way I stand a better chance of being able to figure out what has gone wrong.

[Anonymous]

Hello Richard,

I am sending you the error which I am getting while connecting to database connection. Also attached the screenshot of context file.

Could you please check and let me know what's the issue that I am not able to connect to database which I can do in Talend 6.0 version.

Please find the connection error

_________________________________________________________________________________

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/util/ErrorHandler
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4189)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/util/ErrorHandler
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)
... 9 more
Caused by: java.lang.ClassNotFoundException: com.healthmarketscience.jackcess.util.ErrorHandler
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 13 more

____________________________________________________________________________

Thanks & Regards
Sanjoy

image_2019_03_05T11_11_09_489Z.png
image_2019_03_05T11_11_34_609Z.png

[Anonymous]

OK, it looks like you are missing some Jars. Can you follow the instructions here (https://help.talend.com/reader/JkApNmyPZxs2i5tmdbS9Jg/_~m6mbqKFYcZD8fJz2BXlA) and check to see whether the jackcess and ucanaccess Jars are all installed (search the modules). 

Also I noticed that your Context variables did not hold a value for login. 

[Anonymous]

Hello Richards,

Hope you are doing well.

I have checked your link and but I am not able to install the jar for connection.
In the link its given to do following step for connection jar but I am not able to do find the check button in Metadata connection set up.
click the Check button in a Metadata connection setup wizard in the Studio if one or more external modules
required for the connection are missing in the Studio.
I can run the job without error but I am not able to do connection nor retrieve schema as its giving me error.
Could you please guide me to install the missing jar for connection or could you able to find me the check button in Metadata connection set wizard?

Thanks & Regards
Sanjoy

[Anonymous]

In the top right corner of the modules window there is a green arrow pointing down. Highlight the jar that you want to download and click on that arrow. That should do it for you.

[Anonymous]

Hello Richard,

Hope you are doing well.

Thanks a lot,I am able to do the connection in Talend 7.1, but still I am not able to retrieve schema for views in Talend 7.1 also.
I can retrieve table schema but not view schema. So if I create any table in access database I can retrieve that table in Talend but if I create any views in access database I am not able to get that new view in retrieve schema list.Could you please help me on this as its the samething happen in talend 6.0 also.

I am attaching the screenshot of creating new table and new view in access database and trying to retrieve the new table and view in Talend 7.1 but I am not able to retrieve view.

Looking forward to your response.

Thanks & Regards
Sanjoy

picturemessage_f2s51ley.zbt.png
picturemessage_fv2tg30h.mbb.png
picturemessage_2jofbkd0.if2.png

[Anonymous]

Hi @sanjoygr8,

In your screenshots I can see several views which appear in both the Access DB and your Talend schema listing. So seeing views does not appear to be the problem here. An example of a view which can be seen in both is the R1_VCP_INFO view. I strongly suspect that this is an Access user permissions issue. Unfortunately I cannot test this out myself, but I can offer some guidance. Can you see who owns the R1_VCP_INFO view? Who wrote it? Can you see any differences between that view and the view that you cannot see? Are you creating the new view in Access after you have synchronised with Talend and expecting it to automatically re-synchronise with Talend?....it won't do that

Regards

Richard