Issue in the Dimension Set

Dear all,

We got an issue in AX while refreshing dimensions.Usually i used to click on dimension like analysis and Check and stimulate and it will be updated/refreshed.But today when was clicking on stimulate,i got an issue saying that

Cannot execute the required database operation.
The SQL database has issued an error.

Please let me know the solution for the same.