Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Crucible 4.5.3 and MYSQL 5.7.21 Edited

I'm currently upgrading from Crucible 3.8.0 to 4.5.3 and migrating the SQL Server data to MYQL 5.7.21 in windows. I've granted all users as per indicated in https://confluence.atlassian.com/fisheye/migrating-to-mysql-298976838.html

 

GRANT ALL PRIVILEGES ON fisheye.* TO 'root'@'localhost' IDENTIFIED BY '<password>';

i'm stuck with the following error and think that its not about the backup i used because i was still able to migrate it via crucible 3.8.0. Will appreaciate any idea you can suggest. 


C:\Atlassian\fecru-4.5.3\bin>fisheyectl.bat restore --force --username root --password <password> --jdbcurl jdbc:mysql://localhost:3306/fisheye --dbtype mysql --file [PATH]backup_2018-10-03-0507.zip

WARN: your default encoding (windows-1252) does not support unicode.
This is likely to cause problems if any of the filenames, branch names or tag names in one of your repositories contain unicode characters.
Update your locale settings or start with the -Dfile.encoding=UTF-8 option to avoid these problems.
INFO - Using log4j configuration file: C:\Atlassian\fecru-4.5.3\log4j-client.xml
INFO - FishEye arguments: [--force, --username, root, --password, <password>, --jdbcurl, jdbc:mysql://localhost:3306/fisheye, --dbtype, mysql, --file, [path]\backup_2018-10-03-0507.zip]
Starting Spring Context...
INFO - Database started.
INFO - Using synchronous global permission cache reload policy
INFO - Starting plugin system...
ERROR - No default permission scheme exists
WARN - Exception encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quickSearchService': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectSearcher': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.cenqua.crucible.model.managers.SecureProjectManager com.atlassian.fecru.search.quicknav.ProjectSearcher.projectManager; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'secureProjectManager' defined in URL [jar:file:/C:/Atlassian/fecru-4.5.3/fisheye.jar!/com/cenqua/crucible/model/managers/impl/DefaultSecureProjectManager.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.cenqua.crucible.model.managers.ProjectManager]: : Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
Related cause: org.springframework.beans.factory.BeanCurrentlyInCreationException: Error creating bean with name 'backup': Requested bean is currently in creation: Is there an unresolvable circular reference?
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:308) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1186) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:140) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:84) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at com.cenqua.fisheye.ctl.Restore$RestoreApplicationContext.<init>(Restore.java:363) [fisheye.jar:?]
at com.cenqua.fisheye.ctl.Restore$RestoreApplicationContext.<init>(Restore.java:360) [fisheye.jar:?]
at com.cenqua.fisheye.ctl.Restore.createApplicationContext(Restore.java:351) [fisheye.jar:?]
at com.cenqua.fisheye.ctl.Restore.run(Restore.java:158) [fisheye.jar:?]
at com.cenqua.fisheye.ctl.Restore.main(Restore.java:261) [fisheye.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [?:1.8.0_151]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_151]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_151]
at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_151]
at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) [fisheyeboot.jar:?]
at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) [fisheyeboot.jar:?]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectSearcher': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.cenqua.crucible.model.managers.SecureProjectManager com.atlassian.fecru.search.quicknav.ProjectSearcher.projectManager; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'secureProjectManager' defined in URL [jar:file:/C:/Atlassian/fecru-4.5.3/fisheye.jar!/com/cenqua/crucible/model/managers/impl/DefaultSecureProjectManager.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.cenqua.crucible.model.managers.ProjectManager]: : Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:301) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1186) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
... 23 more
Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.cenqua.crucible.model.managers.SecureProjectManager com.atlassian.fecru.search.quicknav.ProjectSearcher.projectManager; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'secureProjectManager' defined in URL [jar:file:/C:/Atlassian/fecru-4.5.3/fisheye.jar!/com/cenqua/crucible/model/managers/impl/DefaultSecureProjectManager.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.cenqua.crucible.model.managers.ProjectManager]: : Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:522) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
... 39 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'secureProjectManager' defined in URL [jar:file:/C:/Atlassian/fecru-4.5.3/fisheye.jar!/com/cenqua/crucible/model/managers/impl/DefaultSecureProjectManager.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.cenqua.crucible.model.managers.ProjectManager]: : Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:747) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:185) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1115) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1018) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]

... 41 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'projectManager': Invocation of init method failed; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:407) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1546) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1021) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:964) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:862) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:811) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:739) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
... 54 more
Caused by: org.hibernate.PropertyValueException: not-null property references a null or transient value: com.cenqua.crucible.model.Project.permissionScheme
at org.hibernate.engine.internal.Nullability.checkNullability(Nullability.java:103) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
at org.hibernate.action.internal.AbstractEntityInsertAction.nullifyTransientReferencesIfNotAlready(AbstractEntityInsertAction.java:132) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
at org.hibernate.action.internal.AbstractEntityInsertAction.makeEntityManaged(AbstractEntityInsertAction.java:141) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:235) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:209) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]

... 67 more
ERROR: problem running command
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101)
at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44)
Caused by: org.springframework.context.ApplicationContextException: Application Context not initialised.
at com.cenqua.fisheye.config.SpringContext.getApplicationContext(SpringContext.java:51)
at com.cenqua.fisheye.config.SpringContext.getComponentByClass(SpringContext.java:90)
at com.cenqua.fisheye.config.RootConfig.getRepositoryManager(RootConfig.java:600)
at com.cenqua.fisheye.config.RootConfig.fullShutdown(RootConfig.java:1283)

... 6 more

1 answer

0 votes

Hi @Harvin Que,

 

I agree with you that this does not seem to be a problem with the backup. Instead, this could be related to the 4.5.3 installation directory itself.

We have an article about this:

FishEye Fails to Start: No default permission scheme exists

 

Can you check if the C:\Atlassian\fecru-4.5.3 folder was correctly unzipped?

We also want to make sure that there are no conflicts between the 3.8.0 libraries and the 4.5.3 ones. To avoid this, it is always important to unzip the new version in a new folder and make sure that the FISHEYE_INST folder (where the data is stored) does not contain any installation files.

I would also try to download the installation package and unzip it once more to a different directory.

Cheers,

Caterina - Atlassian

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Asked in Jira Service Desk

Calling all Insight users, we need your help!

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials. It would really helpful if you can ...

97 views 1 0
View question

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you