search

keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
82 stars 32 forks source link

The data from the scan is not being written to the repository database. #18

Closed keif888 closed 6 years ago

keif888 commented 6 years ago

This issue is split from #17 The data from the scan is not being written to the repository database. The object and RunScan tables are blank. No errors showing up to indicate there is an issue. Repo is on a 2017 server.

keif888 commented 6 years ago

Unable to replicate. Tested from Windows 10 client machine with SSDT 15.4 installed and subsequently with SSDT 15.7 installed. Analysing either SQL Server Db's or SSIS packages on file system are writing to SQL 2017 repository.

lowerider21 commented 6 years ago

Here is my take on this. The lock up for me was happening in the SSIS packages. Therefore it never completed. It appears the scan waits till the end to write the data to the repo. If it locks up, it never gets to that step. Therefore no data written. I have been able to run the scan with .26 release and it is writing data to the repo on 2017.

keif888 commented 6 years ago

Closed, as caused by already fixed issue.