Reports

Question

Reports

ravisamigo

SSCertifiable

Points: 7440
More actions
November 11, 2010 at 10:58 pm

#74143

Dear All,
Iam facing the below error when trying to generate the report.
Instanace name -> reports ->Standard reports -> Activity-All blocking transactions.
Error: Unable to retrieve data for this report.Following error occurred.
Msg 8115,level 16,State 2
Arithmetic overflow error converting expression to data type int.
Please advise.
Thanks and Regards,
Ravichandra.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Error: Unable to retrieve data for this report.Following error occurred.
Msg 8115,level 16,State 2
Arithmetic overflow error converting expression to data type int.

please post the query tsql used to get the report data.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

ravisamigo SSCertifiable Points: 7440 More actions · Answer 2

Iam not using any query to generate report.

This is server dashboard report...instance (right click) -> reports-> standard report--> Activity-All blocking transactions, when trying this, Iam facing the error.

Please advise.

Thanks and Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 3

Can some one advise on the below query?pls

Thanks and Regards,

Ravichandra.

pjl0808 SSC Eights! Points: 834 More actions · Answer 4

Hi There,

I'm getting the same error also. I know there are at least two spids being blocked.

I did a sp_who2 and found the database where the spid was doing the blocking. Then went to that db and ran the All Blocking Transactions from that db. Worked.

Thanks

PJL