Advance Filter Issue

[sweta_patnaik]

Hi Team,

I am getting an error message while using the advance filter option for "All Users" tab. I have checked it in other tabs like All Assets.. it is working fine. 

All Users>Advance Filter>Termination date is less than>------ It shows a HTML error and then Red bar error.

I have attached the Error snaps. Please Suggest.

[ChrisG · Accepted solution]

The first place to look to get information about red error bar messages like this is the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on the FlexNet Manager Suite web application server. Logging in this file will normally contain specific details about what has gone wrong.

I assume the "Termination date" field is a custom property that is defined on user records in your FlexNet Manager Suite system, as this is not a built-in field. A guess at one possible reason that an error like this might occur when configuring an advanced filter on a custom property that has a date type is if non-date values have been imported into that property, or date values have been imported an incorrect form. It is critical to import custom property date values as strings in the following form: yyyy-mm-ddThh:mi:ss.mmm

For example Sep 25, 2024 would be represented as the following string: 2024-09-25T00:00:00.000

[ChrisG · Accepted solution]

The first place to look to get information about red error bar messages like this is the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on the FlexNet Manager Suite web application server. Logging in this file will normally contain specific details about what has gone wrong.

I assume the "Termination date" field is a custom property that is defined on user records in your FlexNet Manager Suite system, as this is not a built-in field. A guess at one possible reason that an error like this might occur when configuring an advanced filter on a custom property that has a date type is if non-date values have been imported into that property, or date values have been imported an incorrect form. It is critical to import custom property date values as strings in the following form: yyyy-mm-ddThh:mi:ss.mmm

For example Sep 25, 2024 would be represented as the following string: 2024-09-25T00:00:00.000

[sweta_patnaik]

Thank you,

That's correct, but can you please help me where to change the datatype of the custom field. I checked the WebUI error log and it shows "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.".  I am not sure which table i can change the datatype of the date.

[ChrisG · Accepted solution]

The data type of custom properties is identified by the UIItem.UIFieldTypeID column in the compliance database.

If you have indeed ended up with a custom property that is configured with a "date" type but non-date values are being imported into the property then one approach to remediate that might be to update the original script used to configure the custom property to use a UIFieldTypeID value of "4"  (which is the ID for a "text box" property type), and re-run that script to re-configure the property.

You could also try directly updating the property type in the UIItem view with a query like the following:

UPDATE UIItem
SET UIFieldTypeID = 4 /* text box */
WHERE ItemResourceName = 'NameOfYourCustomProperty'

 See this page for information about different UIFieldTypeID values: Controls You Can Add.

[sweta_patnaik]

Thank You