we are seeing error message on accessing the Attachment feature "Choose File" button, presented with an error "Failed to fetch the maximum file size from the server"
Cause
Missing Seed data
Environment
Release : 17.2
Component : CA SERVICE CATALOG Patch level: 17.2.0.6
Resolution
The below query resulted zero result i.e "select *from usm_asset where asset_parent_id = asset_id and (object_type is null or object_type <= 0)" Its suspected the seeddata is not loaded into the catalog system as we get zero results for the query mentioned above. To correct this follow the below manual steps
Run the below seeddata command for both Catalog/scripts and view/scripts and recycle the services once complete. Test the behavior if you are able to fetch the information.
1. Open a command prompt 2. Change directory(CD) to %USM_Home%/scripts Note: %USM_HOME% is the location where you have installed the catalog application. 3. Run the below command one after the other. ----------------------------------------------------------------------------------------------------- seeddata.bat -n "C:\Program Files\CA\Service Catalog\config.properties" -o "C:\Program Files\CA\Service Catalog\config.properties" "C:\Program Files\CA\Service Catalog\catalog\scripts\MDB\SQL\" ----------------------------------------------------------------------------------------------------- seeddata.bat -n "C:\Program Files\CA\Service Catalog\config.properties" -o "C:\Program Files\CA\Service Catalog\config.properties" "C:\Program Files\CA\Service Catalog\view\scripts\MDB\SQL\" ----------------------------------------------------------------------------------------------------- 4. Restart the services 5. Verify the behavior if the issue is resolved.