webinspect can not proceeding after Scan was finished and changed "importing".

[purehyun]

Recently(from 05. Sep.), WebInspect Enterprise Scan Reult can not proceeding after Scan was finished and changed "importing".

And it occurs as described below.

Why Scan Status is changed from "importing" to "completed"?

We can not proceed anymore WebInspect's WebSite  Security checks.

Please, Let's me know  a way to solve it.

[Scan Log]​

헤더 1

2016-09-08 13:03:56,250 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.b - Scan started 2016-09-08 13:03:56,250 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.d - Scan 178c037c-8b64-437e-b018-d63139d8a41e started 2016-09-08 13:05:03,160 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.a - WebInspect log message (severity Info): Info:Process Unused Custom Parameter Rules Start: 2016-09-08 13:05:03,160 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.a - WebInspect log message (severity Info): Info:Process Unused Custom Parameter Rules Stop, 0 sessions created: 2016-09-08 13:05:07,229 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Auditor.verifyScanThread[67]] r5.a - WebInspect log message (severity Info): Info:Verify Audit Start: 2016-09-08 13:05:07,401 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Auditor.verifyScanThread[67]] r5.a - WebInspect log message (severity Info): Info:Verify Audit Stop: 2016-09-08 13:05:11,245 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.a - WebInspect log message (severity Info): Info:Scan Complete, ScanID:178c037c-8b64-437e-b018-d63139d8a41e: 2016-09-08 13:05:11,792 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.c - Scan complete 2016-09-08 13:05:11,792 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.f - Stopping scan visualization queues... 2016-09-08 13:05:11,792 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.g - Scan 178c037c-8b64-437e-b018-d63139d8a41e completed 2016-09-08 13:05:11,948 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.a - Exporting scan 178c037c-8b64-437e-b018-d63139d8a41e 2016-09-08 13:05:12,901 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] r5.a - Finished exporting scan 178c037c-8b64-437e-b018-d63139d8a41e 2016-09-08 13:05:12,901 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] uz.a - Initiating upload of scan 178c037c-8b64-437e-b018-d63139d8a41e from source 'D:\ProgramData\HP\HP WebInspect\EnterpriseServer\logs\Export\178c037c-8b64-437e-b018-d63139d8a41e.scan' to url 'https://XX.XX.XX.XX/WIE/SensorUpload/scandata.scan?scanId=178c037c-8b64-437e-b018-d63139d8a41e' 2016-09-08 13:05:12,901 INFO  [178c037c-8b64-437e-b018-d63139d8a41e:Scanner.threadProc_DoScan[118]] uz.a - Upload for scan 178c037c-8b64-437e-b018-d63139d8a41e added to upload queue 2016-09-08 13:05:12,901 INFO  [upload] uz.b - Starting transfer for scan 178c037c-8b64-437e-b018-d63139d8a41e (previous transfer state was Queued) 2016-09-08 13:05:12,901 INFO  [upload] uz.b - Creating new BITS session to upload scan 178c037c-8b64-437e-b018-d63139d8a41e 2016-09-08 13:05:13,073 INFO  [upload] uz.b - Upload of scan 178c037c-8b64-437e-b018-d63139d8a41e completed

[pprofili]

Hyunmi,

You will need to look at the corresponding logs on the WIE Server to get the whole picture.  It certainly seems from the log you provided that the sensor successfully uploaded the scan to the server, so something clearly occurred at the server - possibly related to writing the scan to the WebInspect Enterprise database.  The relevant log can be found at C:\ProgramData\HP\WIE\Manager\ManagerWS_trace.log

[purehyun]

Thank you for your answer!

I found the relevant log at C:\ProgramData\HP\WIE\Manager\ManagerWS_trace.log.

When the webinspect scan is completed, stacked in the queue is proceeding sequentially.

That is, the first webinspect scan is fininshed,  it was an error occurred while exporting webinspect scan results.

And then after other webinspect scan is completed, it is stacked  in standby queue.

[ManagerWS_trace.log]

헤더 1

2016-09-08 09:06:37,945 INFO  [ScanImportProcessor] Importing WebInspect.NET.Native scan file 'D:\WIEData\ScanImports\SensorImport\d2cc16f4-6012-4e59-ae53-6f800c7b8bc3.scan' 2016-09-08 09:21:47,617 ERROR [ScanImportProcessor] 데이터베이스에 'SessionLink_d2cc16f460124e59ae536f800c7b8bc3_PK'(이)라는 개체가 이미 있습니다. 제약 조건을 만들 수 없습니다. 이전 오류를 참조하십시오. System.Data.SqlClient.SqlException (0x80131904): 데이터베이스에 'SessionLink_d2cc16f460124e59ae536f800c7b8bc3_PK'(이)라는 개체가 이미 있습니다. 제약 조건을 만들 수 없습니다. 이전 오류를 참조하십시오.   위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   위치: System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)   위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)   위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)   위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()   위치: SPI.Amp.Repository.Storage.DBCommand.Exec()   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.a(ScanBasic A_0, String A_1, DataTable A_2, DBConnection A_3)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.w(XmlReader A_0, ScanBasic A_1, DBConnection A_2)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.a(XmlReader A_0, String A_1, ScanBasic A_2, DBConnection A_3)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.a(Scan A_0, CallerIdentity A_1, XmlReader A_2, DBConnection A_3)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.b(Scan A_0, CallerIdentity A_1, XmlReader A_2, DBConnection A_3)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.a(String A_0, CallerIdentity A_1, Scan A_2, DBConnection A_3)   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.Import(Scan scan, List`1 overrideScanIdList, CallerIdentity creator, String scanFileName, DBConnection connection) ClientConnectionId:94f5c49f-177f-45b8-99df-9f04ad00831f Error Number:2714,State:5,Class:16 2016-09-08 09:21:48,492 ERROR [ScanImportProcessor] Unable to import web scan d2cc16f4-6012-4e59-ae53-6f800c7b8bc3 System.Data.SqlClient.SqlException (0x80131904): 데이터베이스에 'SessionLink_d2cc16f460124e59ae536f800c7b8bc3_PK'(이)라는 개체가 이미 있습니다. 제약 조건을 만들 수 없습니다. 이전 오류를 참조하십시오.   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.Import(Scan scan, List`1 overrideScanIdList, CallerIdentity creator, String scanFileName, DBConnection connection)   위치: gl.a(Scan A_0, List`1 A_1, ScanResultsInfo A_2, String A_3, String A_4, cg A_5, CallerIdentity A_6, DBConnection A_7) ClientConnectionId:94f5c49f-177f-45b8-99df-9f04ad00831f Error Number:2714,State:5,Class:16 2016-09-08 09:21:49,226 ERROR [ScanImportProcessor] Unable to import results of scan d2cc16f4-6012-4e59-ae53-6f800c7b8bc3 System.Data.SqlClient.SqlException (0x80131904): 데이터베이스에 'SessionLink_d2cc16f460124e59ae536f800c7b8bc3_PK'(이)라는 개체가 이미 있습니다. 제약 조건을 만들 수 없습니다. 이전 오류를 참조하십시오.   위치: Amp.Impl.Shared.ImportExport.WebInspectFormatImporter.Import(Scan scan, List`1 overrideScanIdList, CallerIdentity creator, String scanFileName, DBConnection connection)   위치: gl.a(Scan A_0, List`1 A_1, ScanResultsInfo A_2, String A_3, String A_4, cg A_5, CallerIdentity A_6, DBConnection A_7) ClientConnectionId:94f5c49f-177f-45b8-99df-9f04ad00831f Error Number:2714,State:5,Class:16 2016-09-08 09:21:49,711 INFO  [ScanImportProcessor] Scan d2cc16f4-6012-4e59-ae53-6f800c7b8bc3 import not completed

1. "SessionLink_d2cc16f460124e59ae536f800c7b8bc3_PK" is there is internally generated, Why this happen?

2. Where it does occur at webinspect enterprise db or webinspect sensor db?

3. How do you solve this?

[pprofili]

The issue is occurring when importing into the WebInspect Enterprise database.

Have a look under  D:\WIEData\ScanImports\SensorImport.  There should be a "Failed" subfolder containing the .scan file.  See if you are able to import it using the "Import" functionality in the WIE Web Console.  If it fails again, try importing into a newly created Project Version.

[Janam]

Hi, 

I have the .scan file residing in the mentioned folder. I tried importing that file in newly created project as well, but no luck. File is failed to import. The size of file is around 2.6GB. Can you please help. 

I have WI Enterprise version 17.10