JIIRA Agile and every pluging not working

[Pawel Okroy]

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

[Pawel Okroy]

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]

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.

[WeAreAllJustinNow]

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!

[Jose M.]

Recently there was a problem with Agile described by Atlassian as

This is essential with regard to the previous information from Atlassian: Important note for customers with large scale instances: Do not upgrade to JIRA Agile 6.4.x, 6.5.x or 6.6.0.

We are aware of performance issues related to JIRA Agile 6.4.x, 6.5.x or 6.6.0 that are affecting instances with a large number of issues (300,000+), projects (100+), boards (100+), or open sprints (100+). This is our top priority and we will be addressing this in the next release of JIRA Agile.

But this should be fixed with v6.6.13

[Pawel Okroy]

Thanks Jose M, but I think that this is not my problem. I want to start using JIRA, but it looks like there is a problem with the installation of the plugins, something is not finishing ok....

[Jose M.]

Yes, looks like more complicated. i have moved my answer to a comment.