faconvrt Execute select_CALocationsIdByCodeBypassDataAccess failed

Description of Issue

An error is being received when attempting to import Capital Assets into Munis.

<Exception Type="SQL" Message="Execute select_CALocationsIdByCodeBypassDataAccess failed - status: " Timestamp="XXXX">

Context
  • faconvrt
  • Capital Assets
Cause

This is error is being received due to missing location codes in the import file or in Munis.

Resolution

Review the import file for and location codes within Munis and verify that the same code exists in both the import file and Munis.

Additional Information

If you need to run the faconvrt process you can review the article Running the faconvrt Capital Asset import utility