Error using new version of Cognos Impromptu

[Valdyn]

Hello,

I'm working with Cognos Impromtu (7.0.716.0) to generate reports from BaanERP (7.5a.24), which runs on an Oracle database (8.1.7.3).

Recently I have installed a new version of Cognos Impromptu (7.3.650.0) on my notebook and tried to convert the reports to the new version. Nearly half of them could be converted, the rest stopped due to the following error message:

ORA-03120: two-task conversion routine: integer overflow

I've searched through the internet to find a solution for that, but I only found some error descriptions...no clear solution.

If anybody is able to help me with my problem, I would be very grateful.

Thank you for your help and take care,
Valdyn

 

[griffindm]

Just a guess, but open the reports without connecting to the database, then check under Reports | Query | Client Server, and change the type to 'Flexible processing'. Then connect and see if you get the same error.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[Valdyn]

Hello Dave,

thank you very much for your response.

The type is already set to 'Flexible processing', so unfortunately it is not the problem.

I'd be glad, if you have another idea.

Special thanks and greetings form Germany,
Martin

 

[cogrob]

I too seem to receive the ORA-03120 two-task conversion routine. Have you had any luck in resolving your situation. Thanks!

 

[griffindm]

Here is a little more advice on the problem. I have never seen it, and I'm not an Oracle DBA. Consult your local DBA for advice on the provided suggestions.

ORA-03120:two-task conversion routine:integer overflow

Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in user application.

Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767

You may also want to Limit by Table name or Owner when you edit your .oce

Two things to try (in this order):
1) Edit the OCE and turn OFF Asynchronous processing (this one usually
works, so try it first).
2) FOR TESTING ONLY: Install the SQL*Net 8.1.7 or higher Oracle 8
drivers and point your Oracle Home to them. Restart the Performance Suite
and see if it gets rid of the error.

[above from other Net postings]

I would also check your date handling in the report. If you are using integer dates they may be larger that Oracle intends for integers to handle.

Hope this helps,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[milkiel]

I was having the same problem. It ended up being the version of Oracle client that I was running (8.1.7.0). There is a db patch that worked in my case(8.1.7.4).

Hope this helps