JIIRA Agile and every pluging not working

Question

I'm trying to install JIRA with Jira-agile in my Intranet, but after the installation, JIRA Agile, it is not working propertly. I have a yellow warning  on the top of the page saying that the installation of JIRA Agile it is not available. I have the Agile button on JIRA, but not working redirecting to 404 error page. I've checked Tomcat log and I have this error "Base table or view not found message from server: "Table 'jira.ao_e8b6cc_organization_mapping' doesn't exist"

I tried to install another plugin, (service desk) and I've got the same problem.

I have to say as well, that I installed on Windows Server 2012 R2, and W8, and I've got the same issue. It's Windows package with MySQL database.

Talking to my system administration, he said that maybe it is a firewall problem. I'm installing everything behind a router and a firewall. Do I have to open any port?

I would like to use JIRA as soon as possible with Confluence, Stash, Bamboo... but I can't until anybody help me soving this issue.

Thanks

WeAreAllJustinNow · Answer

Hi Hector - Have you opened a ticket with us here in support about this issue?  I think that is the best way to get this resolved.

Pawel Okroy · Answer

I tried this, but it is still not working. I think that it is such an error related with MySQL, because I installed JIRA without database and works well.

Here I copy full Tomcat error:

....

INFORMACIÓN: Starting ProtocolHandler ["http-bio-8080"]
nov 18, 2014 1:50:28 PM org.apache.catalina.startup.Catalina start
INFORMACIÓN: Server startup in 42299 ms
nov 18, 2014 1:52:42 PM org.apache.jasper.compiler.TldLocationsCache tldScanJar
INFORMACIÓN: Al menos un JAR, que se ha explorado buscando TLDs, aún no contenía TLDs. Activar historial de depuración para este historiador para una completa lista de los JARs que fueron explorados y de los que nos se halló TLDs. Saltarse JARs no necesarios durante la exploración puede dar lugar a una mejora de tiempo significativa en el arranque y compilación de JSP .
log4j:WARN No appenders could be found for logger (com.amazonaws.jmx.spi.SdkMBeanRegistry).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Exception in thread "WaitForAO" net.java.ao.ActiveObjectsException: java.sql.SQLException: Base table or view not found message from server: "Table 'jira.ao_e8b6cc_repository_mapping' doesn't exist"
 at net.java.ao.DatabaseProvider.hasIndex(DatabaseProvider.java:1505)
 at net.java.ao.DatabaseProvider.renderDropIndex(DatabaseProvider.java:1459)
 at net.java.ao.DatabaseProvider.renderAction(DatabaseProvider.java:250)
 at net.java.ao.DatabaseProvider.renderCreateTableActions(DatabaseProvider.java:274)
 at net.java.ao.DatabaseProvider.renderAction(DatabaseProvider.java:228)
 at net.java.ao.schema.SchemaGenerator$2.apply(SchemaGenerator.java:141)
 at net.java.ao.schema.SchemaGenerator$2.apply(SchemaGenerator.java:138)
 at com.google.common.collect.Iterators$8.next(Iterators.java:812)
 at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:97)
 at net.java.ao.EntityManager.migrate(EntityManager.java:130)
 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:44)
 at com.atlassian.jira.plugins.dvcs.activeobjects.v3.To_08_ActiveObjectsV3Migrator.upgrade(To_08_ActiveObjectsV3Migrator.java:48)
 at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl$1.doInTransaction(ActiveObjectUpgradeManagerImpl.java:81)
 at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl$1.doInTransaction(ActiveObjectUpgradeManagerImpl.java:76)
 at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)
 at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:34)
 at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
 at com.sun.proxy.$Proxy43.doInTransaction(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
 at com.sun.proxy.$Proxy43.doInTransaction(Unknown Source)
 at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21)
 at sun.reflect.GeneratedMethodAccessor300.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
 at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
 at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
 at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at com.sun.proxy.$Proxy4695.execute(Unknown Source)
 at com.atlassian.activeobjects.internal.SalTransactionManager.inTransaction(SalTransactionManager.java:48)
 at com.atlassian.activeobjects.internal.AbstractLoggingTransactionManager.doInTransaction(AbstractLoggingTransactionManager.java:19)
 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.executeInTransaction(EntityManagedActiveObjects.java:270)
 at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl.upgrade(ActiveObjectUpgradeManagerImpl.java:75)
 at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl.upgrade(ActiveObjectUpgradeManagerImpl.java:41)
 at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.upgrade(AbstractActiveObjectsFactory.java:87)
 at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:62)
 at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39)
 at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.createActiveObjects(ActiveObjectsServiceFactory.java:136)
 at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.access$000(ActiveObjectsServiceFactory.java:51)
 at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$1$1.get(ActiveObjectsServiceFactory.java:65)
 at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$1$1.get(ActiveObjectsServiceFactory.java:61)
 at com.atlassian.activeobjects.osgi.DelegatingActiveObjects$MemoizingSupplier.get(DelegatingActiveObjects.java:156)
 at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.count(DelegatingActiveObjects.java:118)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
 at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
 at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
 at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at com.sun.proxy.$Proxy6374.count(Unknown Source)
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl.waitForAO(MessagingServiceImpl.java:213)
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl.access$900(MessagingServiceImpl.java:69)
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl$7.run(MessagingServiceImpl.java:863)
 at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Base table or view not found message from server: "Table 'jira.ao_e8b6cc_repository_mapping' doesn't exist"
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
 at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1163)
 at com.mysql.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2214)
 at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
 at net.java.ao.DatabaseProvider.getIndexes(DatabaseProvider.java:551)
 at net.java.ao.DatabaseProvider.hasIndex(DatabaseProvider.java:1493)
 ... 85 more
log4j:WARN No appenders could be found for logger (com.amazonaws.jmx.spi.SdkMBeanRegistry).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

WeAreAllJustinNow · Answer

Hi Hector,

Based on the information you've provided about the error message, you may be running into an issue with your MySQL database.   This error can pop up with MySQL databases that are created using utf8_bin collation which is case sensitive.  If a table is created with lower case letters, but the SQL statement calling the table is in uppercase letters, this situation can arise.  Our suggested resolution for this issue is to add the lower_case_table_names = 1 configuration in the my.cnf file (this is a MySQL configuration file).

If this doesn't cover your issue, please feel free to raise a ticket with Atlassian support at support.atlassian.com and we'll be more than happy to assist you.  You will want to let us know what you have done to fix the issue thus far.  Providing us with a Support Zip will also help.

Thanks!