Migration of old (5.3) job to TOS 8.0 is throwing errors

[jtalend]

From TOS 5.3 I exported the job (and its dependencies) to a zip file, and imported it into TOS 8.0.

After saying OK on the one-way auto upgrade, most of the components are without properties or code.

So then I tried to build the job and it is giving me this error.

java.lang.NoClassDefFoundError: org/talend/designer/runprocess/maven/MavenJavaProcessor

at org.talend.designer.runprocess.DefaultRunProcessService.createJavaProcessor(DefaultRunProcessService.java:342)

at org.talend.designer.runprocess.DefaultRunProcessService.createCodeProcessor(DefaultRunProcessService.java:204)

at org.talend.designer.runprocess.RunProcessService.createCodeProcessor(RunProcessService.java:77)

at org.talend.designer.runprocess.ProcessorUtilities.getProcessor(ProcessorUtilities.java:330)

at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1102)

at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1006)

at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1877)

at org.talend.repository.ui.wizards.exportjob.handler.BuildJobHandler.generateJobFiles(BuildJobHandler.java:202)

at org.talend.repository.ui.wizards.exportjob.handler.AbstractBuildJobHandler.prepare(AbstractBuildJobHandler.java:379)

at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager$1.run(BuildJobManager.java:263)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2338)

at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:297)

at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:211)

at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJobs(BuildJobManager.java:126)

at org.talend.repository.ui.wizards.exportjob.JobScriptsExportWizardPage.buildJobWithMaven(JobScriptsExportWizardPage.java:1549)

at org.talend.repository.ui.wizards.exportjob.JobScriptsExportWizardPage$9.run(JobScriptsExportWizardPage.java:1434)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: java.lang.ClassNotFoundException: An error occurred while automatically activating bundle org.eclipse.jdt.debug (274).

... 18 more

----------

Any suggestions?

[Anonymous]

Hi

Can you please upload the Studio Support logs? (Please go to Studio Help -> Support logs -> Save it with a name as .zip file).

Regards

Shong

[jtalend]

The zip file with the support logs is attached.

Thanks

[Anonymous]

Hello,

Please have a look at this online documentation about:

https://help.talend.com/r/en-US/8.0/installation-guide-windows/compatible-java-environments

java.version=18.0.2 is not list in the compatible java environments table, please try to use java 11 instead to see if it works for you.

Best regards

Sabrina

[jlolling]

In which way you have exported the jobs? The correct is in the Studio starting from the Node JobDesign-> right mouse key -> Export Items.

Is this the way you have done this?

[jtalend]

I switched to OpenJDK11 and that seemed to work, but now in one of the metadata/connections to an MS SQL Server db I am getting this error.

In the modules view I can see that mssql-jdbc.jar is installed. Any suggestions? Thanks

[Anonymous]

Hello,

Which mssql server database version are you trying to connect from the studio? You did install a more recent version of the JDBC driver?

As Microsoft MS SQLServer drivers are delivered for both Java 8 and Java 11. So you must take the Java 11 version that you are currently running.

Best regards

Sabrina

[jtalend]

Got farther after intalling mssql-jdbc.jar 12.4.2, but now am getting a connection error:

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'mxxxxx'. ClientConnectionId:81f8b8dc-56ec-44ab-9158-c6257658c09f

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1170)

   at

jdbc:sqlserver://1X.XX.1X.X;DatabaseName=prod;encrypt=true;trustServerCertificate=true

Any suggestions?

[Anonymous]

Hello,

Please make sure your user or password is correct without wrong spelled.

If your database running on a remote machine, TCP/IP network protocol has to be enabled (activate).

Best regards

Sabrina