Full Optimize Problem

[Former Member]

Hi Guys,

I am getting the following error when doing a full optimize with database compression:"Error message:Arithmetic overflow error converting numeric to data type numeric.

The statement has been terminated."

I am guessing this has a lot to do with the performance issues i am having with system at the moment. Everything is slow at the moment and I am getting SendGovener issues as well.

Any help will be appreciated.

Regards,

AvdB

[sorin_radulescu]

Hi,

It seems that one of your dimension is not correct process with ful process or you have bad data into fact table .

Did you have working this system before?

One of other problems can be that installation was not correct or you applied a QFE for windows which change the regional settings for one of users from HKEY_USERS - ...

These reg settings are not anymore Englisg US how it is required.

Regards

Sorin

[Former Member]

(Hi, I'm helping Gert Andries)

Thanks Sorin,

Yes, we successfully 'Full' Processed all the dimensions within the Application.

Yes, the system was working before so I doubt it's an installation problem.