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.

Atlassian JIRA | Tom Davies [Atlassian] | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    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.

    Atlassian JIRA | 10 years ago | Mei Yan Chan [Atlassian]
    com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s).
  2. 0

    Issue using Sqoop to import data from Sybase

    Stack Overflow | 4 years ago | dipeshtech
    java.io.IOException: SQLException in nextKeyValue
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    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.

    Atlassian JIRA | 10 years ago | Mei Yan Chan [Atlassian]
    com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s).

    Root Cause Analysis

    1. 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()
    2. com.sybase.jdbc3
      Tds.a
      1. com.sybase.jdbc3.tds.Tds.a(Unknown Source)
      1 frame