error running main report.

[jaguars_h]

hello everyone,

  I modified the exisiting sub report to add new columns.

  By modifing catalog --> adding tables --> adding columns and used in the subreport.
  ofcourse i joined the columns ..

But when i run the main report i get error

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RBI_COLUMN2, The reference to column c1 is ambiguous.

any help or direction is appreciated.

Note: I am new to Cognos/ modifying the existing report..

TIA

[jaguars_h]

Any ideas or pointers to the question is highly appreciated.

Let me know if you need more details, so can it would help you guys for response.  I am new to cognos so, could you help?

Thanks
JayaS

[cognosfreelancer]

Are you able to run the main report and sub report separately without any error. You need to isolate the error source.

Once you do please send the SQL statement being generated both Cognos and native SQL.

NKT

[jaguars_h]

Main report runs with prompts and these prompts are taken input to execute stored procedure..
So i am not able to see any sql for it..this is not working..

and sub report sql ran smoothly..individually..

[cognosfreelancer]

It appears that the stored procedure that the main report is executing has a SQL statement.

The SELECT clause of the SQL statement may include a field that exists in more than one table.

Perhaps this field is not prefixed by the table name.

The error you got is very typical of this.

Can you post the stored procedure code

NKT

[jaguars_h]

This stored procedure is also been used by existing report and works fine..& procedure not been changed recently.
Procedure does inserts records into temp table & this procedure has lot of code in it.

And i can do sent paste entire proc in mail if it helps..let me know you im/emailid

[jaguars_h]

Hear is update on this issue..no much success yet!

i am still trying to identify the solution..

I tried to do this..

1.copy the existing report from prod to dev
2. try to run the report from desktop ie cognos impromptue admin..
3 errors out with ..
Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RBI_COLUMN2, The reference to column c1 is ambiguous

so, tried to work with web..

4. publish the iwr report based on the copy from prod and it works fine.. .!!

Not able to run the report from desktop..!! any ideas..why it would fail in desktop compare web??

Thanks guys for earlier help..