com.sybase.jdbc3.jdbc.SybSQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Attempting to run encoding test (admin/encodingtest.action) and it fails with a database error as follows (running jConnect 6.0 against ASE 15.0.1): Cause: com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s). at com.sybase.jdbc3.tds.Tds.a(Unknown Source) Stack Trace: [hide] com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s). at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.retrieveLowerDatabaseTestString(EncodingTestAction.java:117) at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.execute(EncodingTestAction.java:65) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) The patch provided in CSP-5887 does not work for Confluence 2.5.1 A new patch is required.
    via by Mei Yan Chan [Atlassian],
  • Attempting to run encoding test (admin/encodingtest.action) and it fails with a database error as follows (running jConnect 6.0 against ASE 15.0.1): Cause: com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s). at com.sybase.jdbc3.tds.Tds.a(Unknown Source) Stack Trace: [hide] com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s). at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.retrieveLowerDatabaseTestString(EncodingTestAction.java:117) at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.execute(EncodingTestAction.java:65) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) The patch provided in CSP-5887 does not work for Confluence 2.5.1 A new patch is required.
    via by Mei Yan Chan [Atlassian],
  • Error while inserting record in database
    via Stack Overflow by amicngh
    ,
    • com.sybase.jdbc3.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600. at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,