JIIRA Agile and every pluging not working

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

4 answers

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....

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

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

0 votes
Justin Burke Atlassian Team Nov 12, 2014

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!

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.
Justin Burke Atlassian Team Nov 25, 2014

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

17,628 views 18 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you