My Apps Campaign condition - result not saved (when Catalog linked with a FNMS Local application)

CharlesW · ‎Jun 12, 2020

Description

This KB article is describing a current product defect (reported in 2019 release):

Symptom:

In some circumstances, when trying to test "My Apps" by using the "License Reclamation Campaign Condition" to include only particular group or collection. Even when user add "Group and OU" and "Collection" to target users but unfortunately every time save it, close and reopen it's not there.

Root Cause:

When App Portal tries to check the application in the My Apps, it's querying the application FUID from product FlexNet Manager Suite. It works fine when the application is an 'Flexera' application which generated from ARL library. this doesn't work when linking a 'local' application which is not released from FNMS ARL library, but is created manually.

The issue is the LENGTH() of FUID from ARL title is shorter than Local ARL which causing product code fail by passing the local FUID.

Error message – CampaignConditions.log contains below error while using test for saving:

<![LOG[No campaign collection condition attached with flexera Id :  app://71551CCE-6301-428D-97A2-51156143/LOCAL-APP-128564, Campaign Type : 1]LOG]!><time="11:52:48.000+240" date="5-11-2020" component="GetCollectionConditions" context="" type="1" thread="4" file="Website"><![LOG[String or binary data would be truncated.
The statement has been terminated. Error while saving LicenseReclamation Campaign conditions :  String or binary data would be truncated.
The statement has been terminated.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at AppPortal.Infrastructure.Repositories.CampaignRepository.SaveCampaignConditions(String flexeraId, List`1 campaignConditiondProperties, CampaignType campaignType)]LOG]!><time="11:53:17.000+240" date="5-11-2020" component="SaveCampaignConditions" context="" type="1" thread="2" file="Website">

Workaround

Run the following query against the App Broker DB to increase the size of the column so that it is large enough to hold the arl:

ALTER TABLE WD_CampaignConditions MODIFY FlexeraID_FK varchar(60)

Resolution

The defect is logged under Bug ID: IOJ-2115054 and currently is on the defect queue.