FOAEA Daily Notifications Stopped

Owned by Le, Michelle
Jun 22, 2021
1 min read

Bug: Josée Sabourin’s team has stopped receiving the daily notifications from FOAEA

 

Fix:

  1. Go to \\ncrws548\scripts\CivAv\FOAEA\FOAEA\FoaeaLog and examine the log files.

  2. [From Bug 108778] Found the following entry in some the latest log files.

    • 2147467259[Microsoft][ODBC Microsoft Access Driver] '\\Ncrws410\foaeadownload\Database\aces.mdb' is not a valid path.

    • Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

  3. Looked at \\ncrws548\scripts\CivAv\FOAEA\FOAEA\Database\foaea.mdb and found the 2 missing links to Access databases that link to the Oracle databases, one to DAPLS and the other to ACES. I could only do this after installing MS Access 2003 on my workstation because Access 2007 kept crashing when I tried to link the tables.

  4. Since the above database gets copied from \\NCRWS555\wwwdatabases\Foaea\ when the script is run, I opened this second database and update the linked tables as follows

    • Changed \\ncrws410\scripts\CivAv\FOAEA\FOAEADownload\Database\aces.mdb to \\ncrws548\scripts\CivAv\FOAEA\FOAEADownload\Database\aces.mdb

    • Changed \\ncrws410\scripts\CivAv\FOAEA\FOAEADownload\Database\dapls.mdb to \\ncrws548\scripts\CivAv\FOAEA\FOAEADownload\Database\ dapls.mdb

  5. Run the FOAEA script to make sure it is working properly.

 

Past Bugs in DevOps: https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_workitems/edit/108778