msutharh
Intrepid explorer

PURL & SKU Update failed

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>

0 Kudos
5 Replies
ChrisG
Community Manager Community Manager
Community Manager

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.

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
0 Kudos
msutharh
Intrepid explorer

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

0 Kudos

@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

0 Kudos
msutharh
Intrepid explorer

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

0 Kudos
ChrisG
Community Manager Community Manager
Community Manager

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).

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
0 Kudos