on 12-10-2012 10:35 PM
Hi,
I have the follow problem :
Transaction DB02-History-DataBase Size History, show error below :
SQL 208 : Invalid object name 'sap_get_para'. [WP3] [sap_fileszhist:BUILD_N_EXEC]
I already applied sapnote 1719979.
Environment :
SAP Solution Manager 7.1
SAPKB70210
Windows Enterprise Server 2003 - SQL Server 2008 (10.00.2531)
Any idea ?
tks
Hi,
Did you encounter this error during upgrade process?
The note #1719979 isn't valid for 7.01 and could not implemented before
you start the upgrade.
If the error appears after upgrade, please implement the code
correction from note manually.
Regards,
Aidan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
He is running 7.02 SP10 so the SAP note is valid for him. However, the SAP note is relevant only when activations are done so my guess is that the problem he is having in transaction DB02 is not solved by implementing that SAP note.
My question would be has there been an upgrade or system copy? The stored procedures (T-SQL) are created during installation, upgrade or system copy. Are you having any other issues in transaction DB02?
I think I have tracked it down. The reference to object sap_get_para is in sap_coll_core which gets called from sap_coll_list which in turn gets called from sap_fileszhist.
Can you check in SQL Studio that all of these stored procedures are recent? They should all have timestamps on the top of the script. They should be recreated on each invocation in DBA Cockpit.
My sap_coll_core has the following
IF ( EXISTS (select * from sap_get_para ('SAPMonWin','Url')
where [value] like 'http%') )
So the script won't mind if it doesn't exist. I have no idea what is going on in your system but I suspect it has something to do with the upgrade.You might have to rerun sap_coll_list in report MSSPROCS to fix the script.
I performed the following activities :
1 - In the DB02-configuration-SQL Script Maintenance, I executed again the script sap_p_status, and sap_coll_list, then the error disappeared. The only problem now :
When I click on the buttons "per week" or "per month", nothing appears. Information only appears when I click in "per day"
Any idea ?
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.