COM.ibm.db2.jdbc.DB2Exception

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.

  • 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)
    via by RefuX Zanzeebarr,
  • 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)
    via by RefuX Zanzeebarr,
  • Exception while transferring cloudscape to DB2
    via by eshwar_...@rediffmail.com,
  • Data transfer from Portal 6.0 to DB2
    via by syed...@yahoo.co.in,
  • Database-transfert command
    via by fabrice SZNAJDERMAN,
  • Cloudscape to DB2 migration issue
    via by zan...@hotmail.com,
  • Migrating Portal 6.0 database to DB2
    via by Anantha,
  • JPA composite foreign key error
    via Stack Overflow by Gnegi
    ,
    • 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)
    No Bugmate found.