locked
Import LTRAR failed RRS feed

  • Question

  • Hi 

    I am currently using Visual Studio 2015 Enterprise for load and performance testing. We archived a batch of results from our centralised SQL server using the Export option in the "Open and Manage Load Test Results" window.

    We are now trying to import one of the .ltrar archives back into SQL server and are getting an error:

    "Import load test result failed. Unable to import load test results. Please install sql server and try again".

    How do we resolve this? We do not have local instances of SQL server installed on our laptops, we are connecting to a LoadTest2010 instance which is deployed to a server. The export from the server is fine and saves to an archive, the import back into the server is the issue.

    Friday, September 9, 2016 3:01 PM

Answers

  • You have confirmed that your load test database contains some test results and that they can be exported. You have not made it clear whether these results can be imported back into the database? Is it the case that all imports fail or just the old LTRAR files?

    Do you have other computers with Visual Studio installed, can the file be imported on them?

    One thought. LTRAR files compress significantly. Are your files compressed? Try opening the LTRAR file in Notepad or with a hex viewer. Does the file contain sections of easily readable strings? The LTRAR file I have just looked at contains the string "Microsoft.VisualStudio.QualityTools" several times. The compressed version of the same file has no easily readable strings (at least not in the first few thousand bytes). However the first two bytes of the compressed file are the letters "PK".

    Regards

    Adrian

    • Proposed as answer by Oscar_Wu Tuesday, September 13, 2016 6:33 AM
    • Marked as answer by Oscar_Wu Thursday, September 22, 2016 2:01 AM
    Monday, September 12, 2016 12:42 PM

All replies

  • Does the computer and SQL database have other test result that you can open? Can you run a small load test and does it save results into the database correctly? Can you export those results and import them back in? These questions are to establish whether the database can be accessed at all.

    Regards

    Adrian

    Saturday, September 10, 2016 7:27 AM
  • Hi MirenSookdeo,

    According to your description, please make sure you could connect to the database successfully before load test. Please refer to the following step to confirm this condition:
    click the Manage Test Controller button on the load test tool bar->click the ellipsis to choose server name->click Test Connection to check whether could connect to the database successfully. Please refer to the following steps:

    Sincerely,

    Oscar


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey.

    Monday, September 12, 2016 3:18 AM
  • Hi Adrian

    Yes we can open all test results and successfully export any of them. The DB can be accessed via VS and SSMS so that seems fine. Once we try and import an exported file back to the DB, we are seeing this issue.

    Miren

    Monday, September 12, 2016 12:06 PM
  • Hi

    Yes, we are able to successfully connect to the DB and the load test saves to the DB correctly. We are also able to export to ltrar from the DB because there is a connection. 

    Thanks

    Monday, September 12, 2016 12:08 PM
  • You have confirmed that your load test database contains some test results and that they can be exported. You have not made it clear whether these results can be imported back into the database? Is it the case that all imports fail or just the old LTRAR files?

    Do you have other computers with Visual Studio installed, can the file be imported on them?

    One thought. LTRAR files compress significantly. Are your files compressed? Try opening the LTRAR file in Notepad or with a hex viewer. Does the file contain sections of easily readable strings? The LTRAR file I have just looked at contains the string "Microsoft.VisualStudio.QualityTools" several times. The compressed version of the same file has no easily readable strings (at least not in the first few thousand bytes). However the first two bytes of the compressed file are the letters "PK".

    Regards

    Adrian

    • Proposed as answer by Oscar_Wu Tuesday, September 13, 2016 6:33 AM
    • Marked as answer by Oscar_Wu Thursday, September 22, 2016 2:01 AM
    Monday, September 12, 2016 12:42 PM
  • Hi MirenSookdeo,

    According to the Adrian’s reply, please feel free to let us know your latest results, thank you very much.

    Sincerely,

    Oscar


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey.

    Monday, September 19, 2016 9:48 AM