I am attempting jira, but I am receiving the error below: I've restarted the server and DB. am running postgres RDS version 13. Does anyone know what's causing this issue?
When your database is not supported, you may lose some functionality. We recommend always using a supported database.
Catalina.log error
Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM public.clusteredjob WHERE JOB_ID=? (ERROR: relation "public.clusteredjob" does not exist
Position: 13))
dbconfig file
<jira-database-config>
<name>defaultds</name>
<delegator-name>default</delegator-name>
<database-type>postgres</database-type>
<schema-name>public</schema-name>
<jdbc-datasource>
<url>jdbc:postgresql://XX:5432/jiradb</url>
<driver-class>org.postgresql.Driver</driver-class>
<username>jiradbuser</username>
<password>XXXL</password>
<pool-min-size>40</pool-min-size>
<pool-max-size>40</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<connection-properties>tcpKeepAlive=true;socketTimeout=240</connection-properties>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>40</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>
~
Hi @Nachay Johnson ,
welcome to the Atlassian community!
Please verify that postgres connector lib has been placed in jira inst folder and then verify that jira server can connect to your dbms server.
Fabio
Thank you! I have postgresql-42.5.0 in my lib dir. I am able to access my dbms server from my jira server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.