Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduling problem 1

Status
Not open for further replies.

bonislava

Technical User
Jun 12, 2008
4
US
I am trying to set up a report to run on schedule.But any time when i check the details of this particular run i am getting status Failed and the fowling error:
QE-DEF-0283 The connection is ambiguous. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2008-06-18-15:08:01.675-#125

What is the reason for getting the error? How i can fix it?


 
I have a related problem: I scheduled a report with COGNOS "Event Studio" 8.2. I tested the report Schedule with a Data Source that had 1 Connection. The report ran succesful.

But our requirement is the use of multiple Connection for one Data Source to change the data base for the reports.

After I added a second Connection to the Data Source I got the following Error:

CNC-ASV-0025 Agent Condition invalid: CNC-MON-0011 The Monitor Service encountered an error. QE-DEF-0283 The connection is ambiguous

Does anyone have a solution for this problem?

Thank you in advance
 
With scheduled reports you need to have a 1 on 1 between datasource / connection. With more than connection you will always be prompted to provide a connection.
Multiple connections are for interactive mode..

Ties Blom

 
Thank you "blom0344" for your quick reply which made me think about the problem from another view. I solved my problem now, which is actually 2 problems:

When you add a report in "Event Studio" working with a Data Source that has multiple Connections the Connection appears as one of the Report parameters. To provide this parameter I created a "Data Item" with the name of my Connection. I specified that Item for the Connection parameter. That causes the report to use the specified Connection when it is run by the schedule.

The second problem is to get the Schedule running. Therefore I clicked "Override the default values" in the Schedule window. COGNOS then prompts for the connection. You can then choose it and save it.

After this procedure the schedule will run automatically and the report run by the Agent of the "Event Studio" will use the Connection configured in the "Event Studio"
 




Sub Main()
Dim objImpApp As Object
Dim objImpCat As Object
Dim objUser As Object
Set objImpApp = CreateObject("CognosImpromptu.Application")
objImpApp.OpenCatalog "C:\temp\abcdmdb.cat"
Set objImpCat = objImpApp.ActiveCatalog
Set objUser = objImpCat.ActiveUserClass.UserClasses(0)
MsgBox objUser.Name
Set objUser = Nothing
Set objImpCat = Nothing
Set objImpApp = Nothing
End Sub

there comes an error like R440




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top