Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Errors after upgrading to 5.4.4 - Workbox

Rajeev Kapur
Rajeev Kapur May 6, 2014

Trying an upgrade to 5.4.4 from 5.1.5, after the upgrade the workbox plugin reports below errors in the logs. 

Caused by: java.sql.SQLException: Violation of UNIQUE KEY constraint 'U_AO_9412A1_AOUSER_USERNAME'. Cannot insert duplicate key in object 'dbo.AO_9412A1_AOUSER'. The duplicate key value is (8a

It appears to be this issue https://jira.atlassian.com/browse/CONF-32046, I have asked support about the impact of the workarounds, but has anyone else had this error?



 


 

					
				
			
			
			
				
			
			
			
			
			
			
		

		
		
	

	
	


	

		
	
		

	
	

	
		

			
		
			
					
		
	
				
		
			
					
		
	
				
		
	
		

	
	


		

	

		

			

	
		

			
		
			
Answer
		
			

     Watch  

		
			

      Like    Be the first to like this  


		
			
    
		
			
229 views
		
	
		

	
	

	
		

			
		
			
		
	
		

	
	


		

	



		

	

	

	






		
			











  


  

    

      2 answers
    


      

  
    
  
        1 accepted
      



  

  


  





      



        



	

	

	 
	
	
	 
	
	

	

	

	
		

			

			
	

	

		


	

	
		

			

				
					
		

			
 

			

				

					

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

			

	

		

			

	
		
			




 
      
 0  votes  
 
 
     Answer accepted  
 
 
 
 
  
 
 
 
 

		
			

 
 Bruna Griebeler  
 
 Bruna Griebeler 
 Rising Star 
 
 
  
 Rising Star 
 
 Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders. 
 
 Get recognized 
 
 
   May 7, 2014         
 

		
	
	


		

	

		

			

	
		
			

		

	
		

			
				
					
					
						
Hi Rajeev

As a reporter of that bug, I remember that we had some customers with this issue.
They did the 2nd workaround and it worked fine to them. Of course, is always prudent to create a database backup since you'll perform a delete query, but it works just fine.

Kind Regards

					
				
			
			
			
				
			
			
			
			
			
			
		

		
		
	

	
	


	

		
	
	


		

	

		

			
		

	



		

	
				

			

			
 

		

	
				
				
			

		

	

	

	



	

	


	

	
	
	

	
		

	       	
	 

	
		
	

	       	
		

	



        



    

      Reply
    

      
 


      



        



	

	

	 
	
	
	 
	
	

	

	

	
		

			

			
	

	

		


	

	
		

			

				
					
		

			
 

			

				

					

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

			

	

		

			

	
		
			




 
      
 0  votes  
 
 
 
 
 
  
 
 
 
 

		
			

 
 Rajeev Kapur  
 
 Rajeev Kapur  May 16, 2014         
 

		
	
	


		

	

		

			

	
		
			

		

	
		

			
				
					
					
						
Followed the advice in https://jira.atlassian.com/browse/CONF-32046which does work.

					
				
			
			
			
				
			
			
			
			
			
			
		

		
		
	

	
	


	

		
	
	


		

	

		

			
		

	



		

	
				

			

			
 

		

	
				
				
			

		

	

	

	



	

	


	

	
	
	

	
		

	       	
	 

	
		
	

	       	
		

	



        



    

      Reply
    

      
 
  
    
  




  




 
Suggest an answer
 
 Log in or Sign up to answer 
 
  
		
			

		
			

		
	
	


		

			

	
		
			
		
			
		
			

   
 Confluence 
  
 Confluence 
  
 
TAGS
   


		
			

		
			
  
 
 
 
 AUG Leaders 
 
 
 
Atlassian Community Events
 
 
 
 
 
     
     See all events