Pentaho

Hi,

For one of the job which requires connectivity to Atlassian JIRA database, we are facing the below driver issue.

Full stack trace:

2023/04/27 06:37:18 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred, processing will be stopped: <o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - Error occurred while trying to connect to the database<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - <o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - org.gjt.mm.mysql.Driver<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Error initializing step [Table input]
After doing some research over the internet, I figured out adding jtds-1.2.5.jar to /opt/SIT/data-integration/lib helped. The above highlighted message is not seen.
But we are facing the below exception:

2023/04/27 10:55:34 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred, processing will be stopped:
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Error occurred while trying to connect to the database
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 -
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Communication link failure: Bad handshake
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Error initializing step [Table input]
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Step [Table input.0] failed to initialize!
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to prepare for execution of the transformation
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleException:
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - We failed to initialize at least one step.  Execution can not begin!

<o:p></o:p>Reaching out for help to check if I have added the correct jar file to the Pentaho libraries or if I am missing anything here ?

Let me know if you need any other details.<o:p></o:p>

Hi Saikrishna,
are you using MySQL or SQL Server as DBMS?

First error is occurred when JDBC driver is not on classpath and you defined MySQL database connection. jtds.jar is open source JDBC driver for SQL Server.

And second error looks like problem with TLS/SSL connection. Are you enabled TLS connection on server?

Hi,

For one of the job which requires connectivity to Atlassian JIRA database, we are facing the below driver issue.

Full stack trace:

2023/04/27 06:37:18 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred, processing will be stopped: <o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - Error occurred while trying to connect to the database<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - <o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - org.gjt.mm.mysql.Driver<o:p></o:p>

2023/04/27 06:37:18 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Error initializing step [Table input]
After doing some research over the internet, I figured out adding jtds-1.2.5.jar to /opt/SIT/data-integration/lib helped. The above highlighted message is not seen.
But we are facing the below exception:

2023/04/27 10:55:34 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred, processing will be stopped:
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Error occurred while trying to connect to the database
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 -
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - Communication link failure: Bad handshake
<o:p></o:p>2023/04/27 10:55:34 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Error initializing step [Table input]
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Step [Table input.0] failed to initialize!
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to prepare for execution of the transformation
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleException:
<o:p></o:p>2023/04/27 10:55:34 - T_SLA01_STG_SYS_AVAILABILITY - We failed to initialize at least one step.  Execution can not begin!

<o:p></o:p>Reaching out for help to check if I have added the correct jar file to the Pentaho libraries or if I am missing anything here ?

Let me know if you need any other details.<o:p></o:p>