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!

Register Log in
  • 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!

Impromptu 7.1: getting ORA-01457 on Oracle 10g

Status
Not open for further replies.
TISIBS

TISIBS

Programmer
Aug 24, 2005
14
DE
Hi,

I want to display NUMBER columns from an Oracle 10g database (Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod) in Impromptu (7.1.339.0) but I receive the following:

DMS-E-GENERAL, ... 'asynchronous open'
ORA-01457: converting column overflows decimal datatype

It helps, to use TRUNC on number columns but this is not a good solutiuon. Do I have to modify on of the *.ini files?

Thanks
Timo

 
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
186
beegeeblueboy
beegeeblueboy
dredden2
  • Locked
  • Question
COGNOS Script to modify date ranges on a Dimension
Replies
0
Views
160
dredden2
dredden2
sruthi2016
  • Locked
  • Question
Help on cognos javascript to pass parameter from one report to another dynamically
Replies
0
Views
78
sruthi2016
sruthi2016
sconti11
  • Locked
  • Question
Oracle Stored Procedure in Cognos FM????
Replies
0
Views
76
sconti11
sconti11
Gucha
  • Locked
  • Question
Cognos aggregation (summary on multiple measures on different hierarchy levels)
Replies
0
Views
107
Gucha
Gucha

Part and Inventory Search

Sponsor

Back
Top