java.sql.SQLException: JZ00L: Login to Sysbase failed

[Anonymous]

Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.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(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
      at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:775)
      at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5389)
      at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:725)
      at com.sybase.jdbc4.tds.Tds.login(Tds.java:579)
      at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:442)
      at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3584)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:355)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:260)
      at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:224)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more

[Anonymous]

connection string is jdbc:sybase:TdsBSTJVMLX622.SUNTECSBS.COM:5001/SYBASE?

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are?

Here is a closed jira issue:https://jira.talendforge.org/browse/TUP-9169. Feel free to let us know if it helps.

Best regards

Sabrina

[Anonymous]

Hi Talend,
Version 6, screenshot of parameters passed us attached in the post.

Thank you,
Rajeswary S

[Anonymous]

hello,

version is TOS_DI-20170623_1246-V6.4.1, kindly help I am stuck.

regards,

rajewary s

[Anonymous]

hello,

version is TOS_DI-20170623_1246-V6.4.1, kindly help I am stuck.

regards,

rajeswary s

[Anonymous]

hello,

version is TOS_DI-20170623_1246-V6.4.1, kindly help I am stuck.

regards,

rajeswary s

[Anonymous · Accepted solution]

checked the port in Sybase server and found that it   is 5000, could connect to server post this.