Project

General

Profile

Actions

Bug #6745

closed

Error message when loading rudder

Added by Alexis Mousset almost 9 years ago. Updated almost 9 years ago.

Status:
Rejected
Priority:
N/A
Assignee:
-
Category:
-
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

Rudder v.3.0.7~rc1~git201506110128

error while fetching compliances <- StatementCallback; bad SQL grammar [select
            E.pkid, NNN.nodeid, NNN.nodeconfigids
        from expectedreports E
        inner join (
          select NN.nodejoinkey, NN.nodeid, NN.nodeconfigids
          from (
            select N.nodejoinkey, N.nodeid, N.nodeconfigids, generate_subscripts(N.nodeconfigids,1) as v
            from expectedreportsnodes N
          ) as NN
          where NN.nodeconfigids[v] IN ('425559125')
        ) as NNN
        on E.nodejoinkey = NNN.nodejoinkey
      ]; nested exception is org.postgresql.util.PSQLException: ERROR: function generate_subscripts(text[], integer) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 249

Related issues 1 (0 open1 closed)

Related to Rudder - Bug #6662: rudder-reports has not sufficient dependency to postgresql's versionReleasedMatthieu CERDA2015-05-22Actions
Actions #1

Updated by Alexis Mousset almost 9 years ago

  • Status changed from New to Rejected

It seems to happen because PostgreSQL is in version 8.3

Actions #2

Updated by Alexis Mousset almost 9 years ago

  • Related to Bug #6662: rudder-reports has not sufficient dependency to postgresql's version added
Actions

Also available in: Atom PDF