Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
purehyun
purehyun Contributor.
Contributor.
‎2016-09-08 07:17
3377 views

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

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

Labels (2)
0 Likes
Reply
4 Replies
pprofili
Outstanding Contributor.. pprofili Outstanding Contributor..
Outstanding Contributor..
‎2016-09-08 13:59

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

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

0 Likes
Reply
purehyun
purehyun Contributor.
Contributor.
‎2016-09-19 03:16

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

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?

0 Likes
Reply
pprofili
Outstanding Contributor.. pprofili Outstanding Contributor..
Outstanding Contributor..
‎2016-09-19 13:59

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

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.

0 Likes
Reply
Janam
Regular Contributor.. Janam Regular Contributor..
Regular Contributor..
‎2019-01-18 07:21

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

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

0 Likes
Reply
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.