Sonar 5.6.4: ORA-00904: "CREATED_AT": invalid identifier

sonarqube

(Lu Wang) #1

Hi!

One of our SonarQube servers is version 5.6.4. When we want to do following operation via Web UI:

  • set a leak period
  • set user notification
  • set coverage exclusion

we get failure:
ActiveRecord::JDBCError: ORA-00904: “CREATED_AT”: invalid identifier
: INSERT INTO properties (prop_key, resource_id, user_id, is_empty, text_value, clob_value, created_at, id) VALUES(‘sonar.timemachine.period1’, 1962445, NULL, NULL, ‘2018-12-04’, empty_clob(), 1544441724, ?)

I’ve checked the source code a little bit, “created_at” column doesn’t exist in table “properties” in version 5.6.4.
Is it a known issue? Is there any solution without updating the server to a higher version?

Thank in advance!

Best,
Lu


(Colin Mueller) #2

Lu,

As SonarQube 5.6 LTS is EOL, you’ll have a hard time finding support for a version earlier than our current LTS, 6.7.6, or our Latest version, 7.4

Colin


(Lu Wang) #3

Hi Colin,

Thanks for your quick reply. I will suggest to team to consider to update to LTS, 6.7.6.

Best,
Lu