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]

Please check if you have big numbers into database.

Did you perform any stress test or did you try to input random data into database.

It seems that you have some big numbers into db which sum of them is going over max of decimal number.

Can you check this please.

The installation can be corupted or reg setting as well can be corrupted by an windows update.

Did ypu perform any windows update?

Regards

Sorin

[Former Member]

The biggest number in signeddata is "991084035708471.0000000000"

The smallest number is "-987525210338215.0000000000"

The sum of all the data is "1038830088274756.3931219156"

What is the maximum that is allowed?

I see automatic updates are enabled on this server. It's asking me to install 20 updates, which I have not done. How do I determine whether a previous update corrupted something?

Thank you!

[Former Member]

see abopve thread, May be the errror is due to your Signed Data format.

Sam