DMS-E-MATHEXCEPTION IN IMPROMPTU OUIN!!!

[martine]

HI,

I USE THIS REPORT SINCE 1 YEAR AND THIS MORNING, I HAVE THIS MESSAGE?


DMS-E-MATHEXCEPTION ERROR: -51 ????

WHAT IS IT?

MARTINE

 

[CognosProfessional]

When attempting to run a report that contains grouping and summarization functions, the following error is returned:
Error -51 DMS-E-MATHEXCEPTION, An arithmetic exception was detected. [Microsoft][ODBC Microsoft Access Driver]Internal OLE Automation error.
The catalog was built against a Microsoft Access 97 Database.

Solution:
Installing Microsoft Data Access Components 2.1 SP 1a will resolve this problem. This update is available from the Impromptu 6.0 CD. On the main autorun menu, it can be found under "Additional Products & Services".

ALSO: check that the numbers from the database you are using didn't change.

ALSO: Was there an upgrade? Catalog change?

Your problem could be a number of things depending on the environment and changes made. Check it out. It would be affecting other reports too.


CP

 

[leathern]

Hi. I'm having this problem as well. I went to the Data Access Downloads page on the Microsoft site to find out if I could download the service pack from there. It looks like there are many later versions of MDAC than 2.1 . Are you saying that you need 2.1 SP 1a for it to work or do you mean anything later than that? MDAC 2.71 and 2.8 are available now.

Thanks,
Neal