search cancel

catalog uploading Attachment is not working

book

Article ID: 186975

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

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"

Environment

Release : 17.2

Component : CA SERVICE CATALOG
Patch level: 17.2.0.6

Cause

Missing Seed data

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.