cancel
Showing results for 
Search instead for 
Did you mean: 

I am unable to save a secured connection.

Former Member
0 Kudos

Hi,

I am unable to save a secured connection. I get the following error:

'CMS query failed'

Previous error: The query returned no objects.

I am able to create a shared connection and save it.

Please help resolve this issue.

Thanks

senthil

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

1.What is the BusinessObjects version you are using at your end ?

2. Are you logging as an Administrator in BusinessObjects Universe Designer.

-


Additional Information:

Process for verifying connection and in Universe Designer:

1. Launch Designer

2. Import the affected universe

3. Go to FILE > PARAMETERS

4. On the Definition tab, under the Connection: drop down, select EDIT

5. Observe and record the Login Parameters

6. Click NEXT

7. On the Perform A Test screen, click NEXT

8. Observe and record the Advanced Parameters

9. Click NEXT

10. Observe and record and Customer Parameters

11. Perform the same operation for the remaining tabs (Summary, Strategies, Controls, SQL, Links, and Parameter).

12. Click Finish. Do not close the universe parameters box at this time.

We are now going to create a new connection using the parameter information just discovered.

13. On the Definition tab, under the Connection: drop down, select NEW

14. Click NEXT on the "Welcome to the New Connection Wizard" box

15. Make the appropriate database middleware selection and click NEXT

16. Match the Login Parameters information with the data recorded in step 5above. NOTE: You will have to give this a different name.

17. Click TEST CONNECTION and ensure the connection works.

18. Click NEXT

19. Add the advanced parameters and click NEXT.

20. Add custom parameters and click NEXT.

21. Continue to modify the remaining tabs to match the data that was recorded earlier. When complete, click OK to close the Universe Parameters box.

22. Save the changes to the universe by selecting FILE > SAVE

23. Export the changes by selecting FILE > EXPORT

24. Ensure the correct domain is chosen and click OK

25. Click OK on the Universe successfully exported dialogue box.

26. Close designer.

Please revert back in case of any further queries.

Regards,

Deepti Bajpai

Former Member
0 Kudos

Hi Senthil,

Can you let me know, when do you exactly get this error message?

Is it at the time when you save the Universe with Secure Connection or when you test the Secured Connection.

Have tried creating a new connection or a new all new DSN and then test with Secured Connection?

Regards,

Ekta Sriastava