PURL & SKU Update failed

[msutharh]

Facing issue while updating SKU/PURL. Downloaded the latest PURL & SKU from the PLC site and update it manually but it gives the below error.

Delete all the folders under "G:\ProgramData\Flexera Software\FlexeNet Manager Platform\DataImport\Content\" but the same error.

Can anyone help me to resolve this?

[2021-04-01 11:17:52,253] [INFO ] Cabinet PURL-Oracle.cab
[2021-04-01 11:17:52,253] [INFO ]
[2021-04-01 11:17:52,253] [INFO ] Extracting G:\ProgramData\Flexera Software\FlexeNet Manager Platform\DataImport\Conten
t\SKU\.temp-extract\PURL-Oracle\SKU.sql
[2021-04-01 11:17:52,253] [INFO ] Extraction completed successfully.
[2021-04-01 11:17:52,253] [INFO ] Extraction completed in 6s 124ms
[2021-04-01 11:17:52,253] [INFO ] Importing (using SkuRecognitionImporter) "G:\ProgramData\Flexera Software\FlexeNet Man
ager Platform\DataImport\Content\SKU\.temp-extract" into group ""
[2021-04-01 11:17:52,269] [INFO ] Executing command: G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\DotNet\bi
n\ShadowHost.exe "G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe" -ie "G:\ProgramDa
ta\Flexera Software\FlexeNet Manager Platform\DataImport\Content\SKU\.temp-extract"
[2021-04-01 11:34:26,382] [ERROR] Unexpected error occured
[2021-04-01 11:34:26,382] [ERROR] ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentImportExcepti
on: Could not import G:\ProgramData\Flexera Software\FlexeNet Manager Platform\DataImport\Content\SKU\.temp-extract --->
ManageSoft.Compliance.Logic.Core.API.ImportRecognitionExecuteException: Error occurred when running the command to exec
ute the population script
'' using command 'G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe "G:\ProgramFiles\F
lexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe" -ie "G:\ProgramData\Flexera Software\FlexeNet Manage
r Platform\DataImport\Content\SKU\.temp-extract"'.

Error code returned by command: 1
at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.SkuRecognitionImporter.Import(String groupName,
DirectoryInfo ContentFolder)
at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentImport.Run(EARLImportMode mode, String gr
oupName)
--- End of inner exception stack trace ---
at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentImport.Run(EARLImportMode mode, String gr
oupName)
at ManageSoft.Compliance.Console.RecognitionImportTool.ImportSku()
[2021-04-01 11:34:26,382] [ERROR] Could not import G:\ProgramData\Flexera Software\FlexeNet Manager Platform\DataImport\
Content\SKU\.temp-extract
[2021-04-01 11:34:26,382] [ERROR] Error occurred when running the command to execute the population script
'' using command 'G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe "G:\ProgramFiles\F
lexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe" -ie "G:\ProgramData\Flexera Software\FlexeNet Manage
r Platform\DataImport\Content\SKU\.temp-extract"'.

Error code returned by command: 1
[2021-04-01 11:34:26,460] [DEBUG] Existing task execution id: 270750 for sessionID: d71c768f-80cd-45e2-a666-99bd3f9a73f
9, EventTypeId: 177
[2021-04-01 11:34:26,679] [DEBUG] Update the step with execution ID: 270750, EventTypeID: 177, StepID: 28, EventID: 1896
3123, SessionUID: d71c768f-80cd-45e2-a666-99bd3f9a73f9
[2021-04-01 11:34:26,851] [ERROR] ARL/SKU/EOSL tasks (Import, Extract) have failed. Please check the ARL/SKU log files f
or the detailed error message.
PS G:\ProgramFiles\Flexera Software\FlexNet Manager Platform\DotNet\bin>

[ChrisG]

Check to see if there are any other log files in the same directory as the file containing the logging quoted above. In particular, look for logging in another file that covers activity between 11:17:52 and 11:34:26. If you can find something along these lines, it may give some more details about what has gone wrong.

[msutharh]

nothing found in log files. Here I am attaching log files.

[kclausen]

@msutharh - You are receiving the following error shown in your ImportPURL log file.  This will require a Support ticket to resolve the data issue in your environment.

2021-04-01 11:34:26,220 [Console.ImportPURL ] [ERROR] Msg 50000, Level 14, State 1, Server INMUMFLXPRDDBS, Line 930
2021-04-01 11:34:26,220 [Console.ImportPURL ] [INFO ] -----------------------------------------------
2021-04-01 11:34:26,220 [Console.ImportPURL ] [ERROR] Violation of PRIMARY KEY constraint 'PK_LicenseDefinitionUsageRight'. Cannot insert duplicate key in object 'dbo.LicenseDefinitionUsageRight'. The duplicate key value is (93115D37E8134E4A7013ED83BA1B1030, 48929E33182EA72B48264895FDA5AD8C). Line 24
2021-04-01 11:34:26,220 [Console.ImportPURL ] [INFO ] Removing unused SoftwareLicenseUseRightProposal records that point to orphaned license definitions

[msutharh]

@kclausenThanks for the information. support ticket has already logged (Case ID : 02378219).

[ChrisG]

One thing to check is that the files in the H:\Content Libraries\ directory have been downloaded/updated more recently than around 9 March. If you have older files, you may be getting affected by the problem affecting the PURL release version 476 discussed in the comments on the following post: FlexNet Manager Platform / Suite – SKU, PURL & Bundle updates (Release #476).