Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Oops - An error has occurred. 500 Sorry, we had some technical problems during your last operation

Matias Dall Rasmussen December 10, 2018

Hello.
I'm trying to set up a Jira Service desk on an Azure Ubuntu 18.04 VM connecting to a postgres database in Azure. The setup goes well up until I connect Jira to the database. I test the connection before clicking next, and the test returns okay. When I press next to connect to the database, the whole thing crashes with the following log(see comment)

I haven't been able to find any answers online. Please advice

2 answers

0 votes
Alexis Robert
Community Champion
December 10, 2018

Hi @Matias Dall Rasmussen

 

are you using a Postgres Azure Database or did you install PostgreSQL on a VM ? I think the Postgres Azure Database is not yet supported by Atlassian, as per this ticket on Atlassian support site.

However, Azure SQL Server is officialy supported so you can use this instead as a database server.

 

Let me know if you have any questions, 

 

--Alexis 

Matias Dall Rasmussen December 10, 2018

Hello Alexis.
We are using a Postgres Azure Database. I just got it to work. I created a new database in on the postgres server, and edited the dbconfig.xml and replaced the DBname with the new one, and then restarted jira. I don't really understand why it works, since it's the exact same database, just called 03 instead of 02.

Like Eudor likes this
0 votes
Matias Dall Rasmussen December 10, 2018
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.propertyentry" does not exist
  Position: 68)

    com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.propertyentry" does not exist
          Position: 68)
        

 

The whole log is too long to insert

Matias Dall Rasmussen December 10, 2018

If I refresh the page, it returns that the database is locked, furthermore I'm unable to configure the settings again

Suggest an answer

Log in or Sign up to answer