Skip to Content
avatar image
Former Member

How to resolve Database error occured while repointing a report to universe?

Hi,

I was repointing a report in web intelligence. i selected the universe in Tools>Change source and perform further steps, on running the query a database error occurred as seen in the attached image.

error.png

Kindly help me in resolving the error.

error.png (28.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 30, 2016 at 09:44 AM

    Hi Neha Jaiswal,

    can you check database connection at Universe level?

    At Universe Level: File ----> Parameters ----> Test

    conneciton-testing.png

    If you get this error, then need to create proper connection to database.

    Thanks,

    Pavan Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2016 at 11:18 AM

    Check the database connection at universe? See if its working?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 03, 2017 at 08:48 AM

    Hi Pawan,

    I'm working in Web Intelligence application in BI launchpad 4.1. There I can not find parameter option. Also in Universe Design Tool according to the screenshot you have attached, "parameter" option was disabled for me.

    Please let me know how to check for database connection in BI launchpad.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 02:50 PM

    Hi Neha ,

    Check whether universe is valid or not . Create a new report on the universe and see the data is fetching or not .

    if not, it appears you are using BW as datasource , run your BEx in RSRT and see . I think , you might missing roles required to refresh BEx or some authorization issues ..

    Thank you

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded