Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Importing SQL_Server_Mem_Stats file from SQLLogScout fails with column Object_name does not belong to table #148

Open
PiJoCoder opened this issue Mar 24, 2022 · 0 comments

Comments

@PiJoCoder
Copy link
Contributor

PiJoCoder commented Mar 24, 2022

SQLNexus Information: 0 : Opening file C:\temp\log scout\Test 2\output\LAPTOP1_20220323T1038024382_SQL_Server_Mem_Stats.out
DateTime=2022-03-24T16:11:03.9431168Z
SQLNexus Information: 0 : First time encoutering row identifier 'running memory collector sp_mem_stats15'
DateTime=2022-03-24T16:11:03.9630198Z
SQLNexus Information: 0 : First time encoutering row identifier '-- query execution memory --'
DateTime=2022-03-24T16:11:03.9745758Z
SQLNexus Information: 0 : RowsetImportEngine Error: An unexpected error has occurred:

System.ArgumentException: Column 'Object_Name' does not belong to table tbl_Query_Execution_Memory.
at System.Data.DataRow.GetDataColumn(String columnName)
at RowsetImportEngine.TextRowsetImporter.InsertRow()
at RowsetImportEngine.TextRowsetImporter.ProcessFile()

Import cancelled.
DateTime=2022-03-24T16:11:03.9865946Z
SQLNexus Information: 0 : Flushing rowset tbl_RUNTIMES
DateTime=2022-03-24T16:11:03.9886873Z
SQLNexus Information: 0 : Flushing rowset tbl_Query_Execution_Memory
DateTime=2022-03-24T16:11:03.9901925Z
SQLNexus Information: 0 : Rowset Importer failed for file: C:\temp\log scout\Test 2\output\LAPTOP1_20220323T1038024382_SQL_Server_Mem_Stats.outexception: RowsetImportEngine.RowsetImportException: RowsetImport failed. ---> System.ArgumentException: Column 'Object_Name' does not belong to table tbl_Query_Execution_Memory.
at System.Data.DataRow.GetDataColumn(String columnName)
at RowsetImportEngine.TextRowsetImporter.InsertRow()
at RowsetImportEngine.TextRowsetImporter.ProcessFile()
--- End of inner exception stack trace ---
at RowsetImportEngine.ErrorDialog.Handle()
at RowsetImportEngine.TextRowsetImporter.ProcessFile()
at RowsetImportEngine.TextRowsetImporter.DoImport()
DateTime=2022-03-24T16:11:03.9901925Z

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant