4 Replies Latest reply: Jul 27, 2012 11:20 AM by mudi RSS

    debug [nQSError: 27005] Unresolved column

    mudi
      In nqserver.log i have a lot of errors like:

      [2012-07-27T10:00:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: db58cb579794228a:-21bc1da7:138c38f67d1:-8000-000000000000337f] [tid: a147c700] [nQSError: 27005] Unresolved column: "report"."variables".
      [2012-07-27T10:00:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: db58cb579794228a:-21bc1da7:138c38f67d1:-8000-000000000000337f] [tid: a147c700] [nQSError: 27005] Unresolved column: "report"."variables". [[
      [nQSError: 43113] Message returned from OBIS.
      ]]

      Errors comes from a dashboard that contains several reports, section conditions, dashboard prompts.

      Is it possible to identify exact object (specific report / dashboard prompt ...) causing this error?
        • 1. Re: debug [nQSError: 27005] Unresolved column
          ReddyG
          Cause:The column name was misspelled or the user does not have access rights to this
          column.
          Response: Verify the spelling of the column name, and be sure the user has access rights
          to the column. Correct any problems and retry the action
          • 2. Re: debug [nQSError: 27005] Unresolved column
            mudi
            Hi User,

            The problem is that I can't localize reference to column "report"."variables" in repository and in reports. I did a text search in OBIEE web catalog and in repository (MDS XML format) but there is no such object.

            I text-searched for all combinaations that came to my mind: [report.variables ; report"."variables ; report"."variables ; report"".""variables]

            Repository pases Global Consistancy Check.

            I am looking for a way to link the issue with exact report (or other object) causing it. I need a foothold for debugging.

            Regards,
            Mudi
            • 3. Re: debug [nQSError: 27005] Unresolved column
              ReddyG
              u have passed global consistency mean there is no errors...did u changed/renamed any column in RPD recently and by any chance forgotten to change same in Reports as well?this may be happen if u renamed any thing and if Alias notreferenced/not created for that presentation column... plz check.
              • 4. Re: debug [nQSError: 27005] Unresolved column
                mudi
                It was not the case. Repository and report was ok. To find where is the issue I needed to add objects to new dashboard individually and see when error shows up.

                The problem seems to be OBIEE 11.1.1.6 bug. Issue occurs in dashboard prompt when I add any "Variable Prompt" and sepeify choice list with custom values. Then when I use it in dashboard and click "Apply" all works fine, but there is an error added to BI server log file: Unresolved column: "report"."variables".
                Reproduced it in totally new dashboard prompt with just one "Variable Prompt".

                Workaround: created dedicated database table "VALUES_LIST" and filled with all combo box values needed in reports, added it to repository, and now use only "Column Prompt" in all dashbaord prompts. Not perfect solution but want to have logs clear before going live...