Monday, January 14, 2013

Altering SQL procedures in an SAP system

The other day I was stupified by a note from SAP. I had an SQL error 8115

SQL 8.115: [Microsoft][SQL Server Native Client 10.0][SQL server]
Arithmetic overflow error converting numeric to data type varchar.

This was caused by dbacockpit. And I even found a nice note about it, number 1638567, which states that I just had to be on a certain release level (and lets face it, who is ?), but if all else fails, I could just go to transaction SE38 and fix it in the report MSSPROCS.

Now the problem was the this report no longer showed me the MSSQL procedures (!)

But I found that it was still possible to change the procuderes by going to transaction DB02, and expanding the "configuration" view. Under here there's a menuitem "SQL Script Maintenance". Here I found the script I needed "sap_dbcc_opentran", and just pressed change. Voila. 


There was the magic number that I needed to change. And presto.... Gone was the error.
It's still weird though, that SAP doesn't update their notes with relevant information about how to implement their changes. Espcially, if they remove previously available options.

No comments:

Post a Comment