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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by RefuX Zanzeebarr, 1 year ago
[IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622
via Atlassian JIRA by RefuX Zanzeebarr, 1 year ago
[IBM][CLI Driver][DB2/NT] SQL0107N The name "SP_PERMUSERNAME_IDX" is too long. The maximum length is "18". SQLSTATE=42622
via Google Groups by zan...@hotmail.com, 2 years ago
[IBM][CLI Driver][DB2/6000] SQL0204N "DB2INST1.ICMUT01082001" is an undefined name. SQLSTATE=42704
via Google Groups by fabrice SZNAJDERMAN, 2 years ago
[IBM][CLI Driver][DB2/LINUX] SQL0108N The name "PK15" has the wrong number of qualifiers. SQLSTATE=42601
via Google Groups by Clive Gallagher, 2 years ago
[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
via Google Groups by Clive Gallagher, 2 years ago
[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
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.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 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)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.