Error Message
The materials service currently is not available. Is External Service Available failed with error 'Could not load file or assembly 'Oracle.DataAccess, Version=<Version number>, Culture=neutral, PublicKeyToken=<Token number>' or one of its dependencies. The system cannot find the file specified.'
Solution
-
Verify that the assembly with the same version as the one displayed in the error message is in the Global Assembly Cache (GAC). The Smart Construction server is 64-bit, so the assembly must be 64-bit.
-
If the assembly is not in the GAC, reinstall Oracle or install the assembly delivered by Oracle into the GAC.
-
Verify that the corresponding TNS_ADMIN key value exists in the system environment variables. The default value is <Oracle Installation Location>\Network\ADMIN\tnsnames.ora.