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

[Former Member · Accepted solution]

Hi Andries,

Just try to perform full optimization on each entity first (mainly to Account and Entity Dimension). Then perform optimization to the application. Also check your both these dimensions.

just let me know if the problem doesnt resolve.

Ajay

[Former Member · Accepted solution]

Hi,

Do you mean that i should do a full process of each of the dimensions that are used in the Application?

Regards,

AvdB