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