on 07-29-2015 1:44 PM
I was performing System Refresh using backup/restore method.While running sapinst on DB host I was getting below error
Database Environment :-MS SQL Server 2014 (MS SQL 12.0)
Solution:-
SAPINST expects only tables in schema of your DB. I found that We have user tables in schema 'dbo'.
Run this statement to find out what tables SAPNST has a problem with:
use <DB SCHEMA NAME>
go
select * from sys.tables where schema_id = schema_id('dbo')
You can export them or Delete them.I deleted them and went ahead with the installation.
Use below command to delete them
drop table dbo.sap_dblocks ,dbo.sap_mon_para,dbo.sap_tsize_sample,dbo.sap_mon_text,dbo.sap_tabstats,dbo.sap_tr2_tracedefs
Now check again if theye are indeed deleted or not.
What is the question here or was it just a article to share the knowledge?
Regards.
Nirmal.K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.