COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622

Atlassian JIRA | RefuX Zanzeebarr | 1 decade ago
  1. 0

    Some times it feel like I am your DB2 tester :P Got this error for: SP_PERMGROUPNAME_IDX and SP_PERMUSERNAME_IDX 2006-01-29 14:20:51,196 ERROR [atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask] createIndex Failed to create index:create index sp_permusername_idx on SPACEPERMISSIONS (PERMUSERNAME) COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896) at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.createIndex(AdditionalIndexes1UpgradeTask.java:64) at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.doUpgrade(AdditionalIndexes1UpgradeTask.java:34) at bucket.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:103) at bucket.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:63) at bucket.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:27) at com.atlassian.confluence.upgrade.ConfluenceUpgradeServletContextListener.contextInitialized(ConfluenceUpgradeServletContextListener.java:14) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307) at org.apache.catalina.core.StandardHost.install(StandardHost.java:788) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)

    Atlassian JIRA | 1 decade ago | RefuX Zanzeebarr
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622
  2. 0

    Some times it feel like I am your DB2 tester :P Got this error for: SP_PERMGROUPNAME_IDX and SP_PERMUSERNAME_IDX 2006-01-29 14:20:51,196 ERROR [atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask] createIndex Failed to create index:create index sp_permusername_idx on SPACEPERMISSIONS (PERMUSERNAME) COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896) at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.createIndex(AdditionalIndexes1UpgradeTask.java:64) at com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.doUpgrade(AdditionalIndexes1UpgradeTask.java:34) at bucket.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:103) at bucket.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:63) at bucket.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:27) at com.atlassian.confluence.upgrade.ConfluenceUpgradeServletContextListener.contextInitialized(ConfluenceUpgradeServletContextListener.java:14) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307) at org.apache.catalina.core.StandardHost.install(StandardHost.java:788) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)

    Atlassian JIRA | 1 decade ago | RefuX Zanzeebarr
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622
  3. 0

    Exception while transferring cloudscape to DB2

    Google Groups | 8 years ago | eshwar_...@rediffmail.com
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1216N G* *raphic data and graphic functions are not supported for this database. SQLSTATE* *=56031*
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Data transfer from Portal 6.0 to DB2

    Google Groups | 10 years ago | syed...@yahoo.co.in
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1216N Graphic data and graphic functions are not supported for this database. SQLSTATE=56031
  6. 0

    Database-transfert command

    Google Groups | 1 decade ago | fabrice SZNAJDERMAN
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0108N The name "PK15" has the wrong number of qualifiers. SQLSTATE=42601

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. COM.ibm.db2.jdbc.DB2Exception

      [IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622

      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException()
    2. COM.ibm.db2
      DB2Statement.execute
      1. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      2. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
      3. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
      4. COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source)
      5. COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source)
      5 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyStatement.execute
      1. com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896)
      1 frame
    4. com.atlassian.confluence
      AdditionalIndexes1UpgradeTask.doUpgrade
      1. com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.createIndex(AdditionalIndexes1UpgradeTask.java:64)
      2. com.atlassian.confluence.upgrade.AdditionalIndexes1UpgradeTask.doUpgrade(AdditionalIndexes1UpgradeTask.java:34)
      2 frames
    5. bucket.upgrade
      UpgradeLauncherServletContextListener.contextInitialized
      1. bucket.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:103)
      2. bucket.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:63)
      3. bucket.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:27)
      3 frames
    6. com.atlassian.confluence
      ConfluenceUpgradeServletContextListener.contextInitialized
      1. com.atlassian.confluence.upgrade.ConfluenceUpgradeServletContextListener.contextInitialized(ConfluenceUpgradeServletContextListener.java:14)
      1 frame
    7. Glassfish Core
      CatalinaService.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:3618)
      3. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
      4. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
      5. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
      6. org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:307)
      7. org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
      8. org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
      9. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
      10. org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
      11. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
      12. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
      13. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
      14. org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
      15. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
      16. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
      17. org.apache.catalina.core.StandardService.start(StandardService.java:497)
      18. org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
      19. org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
      19 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    9. Glassfish Core
      BootstrapService.start
      1. org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)
      1 frame