SurendraThotaMSBIProfessional

Hi All some times when we run the backup or restore of big databases  it will take time and we need to know the status of that task then please run the below query which will the percentage complete . select   T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)                  , R.cpu_time, R.total_elapsed_time, R.percent_complete from     sys.dm_exec_requests R                         cross apply sys.dm_exec_sql_text(R.sql_handle) T  

Hi All when we restore the MDS DB from one environment to another Environment and the versions are not same in those  environments  in this we case , after restoration is finished we connect to Master Data services configuration manager and then select the restored DB , it automatically enable Upgrade Database option , then go with that option . once everything is configured , when try to connect using Master data maestro tool we are getting I am getting the fallowing error  The execute permission was denied on the object ‘udpSystemget’ database MDS , schema mdm . Cannot find the object 'tblStgBatch', because it does not exist or you do not have permission. Cannot find the object 'tblUserMemberCount', because it does not exist or you do not have permission. Then I started debugging the issue I ran the MDS configuration manager  also it required upgrade database option and I did it , it is successful , and I am also able to browse MDS APP , there is no iss

Hi All when we restored the MDS database in sql server and configured the Master data services configuration manager  and all the settings went well . when we try to access the Master data services web service we are able to access the web service but when we click on any feature we are getting the [HttpWebRequest_WebException_RemoteServer] Arguments : NotFound  Debugging resouce strings are unavailable  as shown below then we try to browse the  MDS services http://localhost/MDS/Service/Service.svc we got the fallowing error Server Error in '/MDS_PreProd' Application. Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element. Description: An unhandled exception