Skip to Content
0

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

Dec 30, 2016 at 09:07 AM

88

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Pavan Kumar Pullapanthula Dec 30, 2016 at 09:44 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Dec 30, 2016 at 11:18 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Neha Jaiswal Jan 03, 2017 at 08:48 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Jan 05, 2017 at 02:50 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded