Galaxy Error	Problem	Resolution Action Required
Scheme is not available in the master	The scheme specified in this file is not set up in the scheme master. Pathway: Business Admin > Organisational Setup > Schemes	Check that the fund code is correctly populatedd in the file; potential data quality issues arising. If it is a genuine, new scheme - Set up the new scheme in the scheme master. There is a separate setup documentation around new scheme setup.
Counterparty is not available in the master	The counterparty specified in this file is not captured in the company master	Check that the counterparty is setup in the Company master. If not, please setup. (Ensuring "Entity Type" is selected to be "Both") If counterparty is present in the Company Master - Check that the short name is correct, and that "Entity Type" of "Both" has been selected. (To allow the company to be recognised as an acceptable counterparty)
Failed (Incorrect syntax near (.at Line No. 10)	Formatting Issue: the date is not in the UK format which Galaxy has been set to recognise	Check date format should be dd/mm/yyyy not using the American format. If formatting is not resolving this issue, it may need to be escalated to level 1&2 support
Failed (The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. At Line No. 231)	Formatting Issue: the date is not in the UK format which Galaxy has been set to recognise	Check date format should be dd/mm/yyyy not using the American format
Failed (Error converting data type varchar to float. At Line No. 1)	Content on the lower part of the file not in a format which is compatible with Galaxy / data mapping setup	Delete any information after the last row of data within the Excel to remove any additional unrequired content. Ensure no merged cells are present in the Excel.
No cashflow is defined or matching with the transaction	Cashflow activity/ transaction not populated in the cashflow grouping in Galaxy. Can be blank, or populated in the Excel - but not setup in Galaxy.	If the Excel has a blank field (i.e. not categorised), then manually populate or change cash flow type in the Excel. (Must be populated with a cashflow grouping which is already in Galaxy). If populated in the Excel; the cashflow activity/ transaction needs to be added to the cashflow grouping in Galaxy.
Failed (String or binary data would be truncated. At Line No.1)	Data character length issue: Text has too many characters in 1 cell - unable to upload in Galaxy.	Reduce amount of characters in a column. No more than 100 characters, go to use FX LEN - formula to check character length. (This process is detailed in the file upload procedure.)
Transaction Type is not available in the file	No transaction type is populated in the file	If the Excel has a blank field (i.e. not categorised) then manually populate the transaction type in the Excel. (Must be populated with a cashflow grouping which is already in Galaxy).
Transaction ID is not available in the file	Every cashflow requires an ID but this is not available for certain rows.	Identify which field in the cahflow Excel maps into the transaction ID field in Galaxy. (This can be viewed via the file specific data-mapping) Locate blank fields in upload Excel Consider if they should be populated  Expected Exceptions: - If open and close balances are the same (no movement; cash flow amount = zero) Not: if there is movement; this should be uploaded into Galaxy; a dummy transaction ID can be used.