NACIS
National Aviation Company Information System(NACIS) is a Civil Aviation computer application containing all certification, inspection and audit information related to Transport Canada.
Contact:
Development team: Alain Asgill, Chris Collins
Development Tools and Configuration:
We need to install Visual Studio, Team Explorer, MSSCCI provider, PowerBuilder, Toad
For NACIS, please make sure to use 32 bit application because NACIS, PB 2017 is 32 bit IDE.
TFS server is running with access to the user. If you can not see the project on the TFS server, i.e you do not have the access to see that specific project, please see the part “issues and fixes”
Open this link first, to see if you can see NACIS
http://tfsprod:8080/tfs/civav/NACIS-SINCA/NACIS-SINCA
Team Explorer 2013: Team explorer connects Visual Studio to Git and GitHub repositories, Team Foundation version control (TFVC) repositories, manage source code, work items, and builds. Why we install this version. Because this version is 32 bit compatibly and NACIS is 32 bit compatibility project. You will need a Microsoft account to download Visual Studio explorer
Follow link https://my.visualstudio.com/Downloads?q=team%20explorer%202013
MSSCCI provider: PowerBuilder requires MSSCCI to connect with TFS. Use the below link to download and install it
Please make sure you install 32 bit version
Testing if the Powerbuilder can connect to TFS by configuring PowerBuilder 2017.
-Verify if you have a project, if not, then add project in Team Explorer: Open Team Explorer 2013 and add project (NACIS) from the TFS server
-Configure PowerBuilder 2017
Open the workspace in PowerBuilder.
Go to properties of workspace-> Source Control.
In the source control system use Microsoft team foundation server.
Provide your windows login credentials in User ID.
Click on the ellipse button beside Project:. It should automatically select the project you chose before. If not then do it manually by selecting the TFS server and then server path from the popup screen.
Now, back Power Builder project solution, if you right click any pbl files, if you can see “Check in” or “Check out”, that means the PowerBuilder could connect to TFS successfully
Visual Studio 2017: you need a MSDN account to download and install the Visual Studio 2017
PowerBuilder 2017:
Each developer needs a Powerbuilder license
Current version for development at this point of writing (2021-06-10): 2017 R3 1915
Install files are at the location
Map NACIS source code to the local folder:
Create a folder such as C:\tfs_applications\projectName\Dev\Source
Add a Team Foundation Server
Team Explorer ->Manage connection->Add/ Connect to Team project->will see the window to add then to connect to Team Foundation Server
Add new connection for the TFS, click server add URL http://tfsprodL8080/tfs
Add a project in Team Explorer, select NACIS
http://tfsprod:8080/tfs/civav/NACIS-SINCA/NACIS-SINCA Team
After connecting successful, go to the folder:
NACIS-SINCA\Dev\Source\
Right Click on the Source folder → Advanced and map the TFS source code to your local folder like this picture
The above mapping step is only needed to do once for each project. However, if you need to get all latest code even overwritten what you have download, you can check both of the options and choose all files when the list of files are shown up
Connect to TFS ( Team Foundation Service) in PowerBuilder:
Go to NACIS local folder and turn off READ-ONLY for all files
Open the NACIS.pbw (solution) using PowerBuilder . We are using PB Version 2017 R3 Build 1915 (currently on 2021-06-09)
Right Click on nacis target-> properties, choose Source Control, and set up like this with your User ID
Before compiling NACIS in dev, you must need the database connection in DEV for NACIS
On PB, click on the icon for the database connection
At the Preview Syntax: the info should be like below and you can test connection. If the connection is not successful, you might have the wrong password, You can check the password and you can run Toast (database Sql editor) to verify the connection
Now we can rebuild NACIS solution and run NACIS on Dev
IF there is any error showing when running NACIS or logging in, please see below at “Issues and Fixes”
Logging in:
A developer can log in NACIS with his use id and his password, choose Region as HeadQuarters, Database as Developer to test the logging in
Toad
Each user needs to have a Toad license.
Currently we use Toad version 12.9.0.7.1
Install Toad software from the network
Setting up Toad to work with TFS:
There are documents to look when setting up Toad
1)Toad Upgrade: RDIMS# 12092565
2)Setting up Team Foundation Server on TOAD for Oracle : RDIMS#12092441
3) Upgrading TOAD for Oracle from Visual Source Safe (VSS) to Team Foundation Server (TFS) Developer’s Installation User Guide: RDIMS:#12143140
4)Connecting to Visual SourceSafe from TOAD and VSS on Windows: RDIMS #11969228
Below is the picture to show that Toad connects to Dev database with Oracle 32 bit and schema NAPA_NACIS.
NACIS.EXE
\\NCRFS1111\PROJLIB\NACIS\Releases. Currently version 6.1.2 is the latest one in PROD (2021-06-08)
How to install: Extract the zip file to C: \. The NACIS.exe and related files will be installed in the C:\NACISII\prod\Object
You would need the account in Prod to run the NACIS
Issues and Fixes
Issue: NACIS hangs when logging in by a user. This issue can happen when a pop up window is hidden at the back of logging window and wait for the user’s action. This pop-up window looks like this
Fix: Run the cmd as the Administrator to install vspell32.ocx ( for ex, vspell32.ocx at this location )
regsvr32.exe /s c:\nacisii\prod\object\vspell32.ocx
2. Issue: When there is a complain about missing any pbl
Fix: Go to Visual Studio Source Control Explorer, getting latest from the source control which is mapped to your local work space , then check if the mentioned pbl existed . If there is, then that pbl has to be included in the project’s library list
Check out [project name] target (nacis.pbt) and right click on the target property to see that library list contain the missing pbl. If there is not, then go to the VS source control explorer to copy both of the pbl and pbg in your local workspace, go to PB, right click to go to the Properties of Workspace, turn off the Source Control System to None, click Apply, go back to Source Control System, connecting to Microsoft Team Foundation Sever.
Verify again the library list, rebuild the workspace and run NACIS application again to see if the issue has gone
3. Issue: application execution error such as an object is out of date when running the project or null object reference at line…
Fix: finding the location of that object in the source code, right click on the pbl which contains the object → get latest version, select all->Advanced-> click both of options (see screenshot) to get latest and overwrite the local files. You might have to do in many places where that object is created/called
4. Issue: Opening NACIS workspace, there is an error about the migrate application such as
Fix: Check your powerbuilder version to see if that is Appeon Powerbuilder 2017 R3 Build 1915
If not, then goto and run this Powerbuilder Upgrade : NCRFS11\PROJLIB\NACIS\PBUpgrades\PowerBuilder 2017\2017_R3_1915\PWRBLDR-2017R3LTS-MR07-1915-EN.zip\PWRBLDR-2017R3LTS-MR07-1915-EN
6.Issue: If there is any Null object reference when running the app.
For ex:
Fix: Check the location of the object, go to the your local application folder, turn off read-only of that pbl, go back to PB and get latest to overwrite the local workspace. If there is no successful, check if that object is locked, get that unlocked, turn of read-only and get the latest again
7.Issue: When checking in any code in TFS, there should be an email notification which will be sent to you about the code checking in (team members can receive the same email about your checked in code if they set up properly). If you do not receive an email notification
Fix: for example if you want to receive email notifications when check in the code into TFS
on VS, goto http://tfsprod:8080/tfs/civav/_admin/_security, choose Notifications
Choose Subscribers and add a new Subscriber for your project, for ex like Napa or NACIS we should choose a subscriber with Category: TFVC and Template: Code is checked in
Entering your email and choose a specific Team project such as NACIS-SINCA and click Finish
Issue: Logging in NACIS, if we do not find the Database Development show up at the Database, then we need to change the logon.ini to enable it
Fix:
Find the C:\NACISII. This folder is created when we have NACIS.exe package installed. If you do not see this folder, please go to the network to install it( please see at the part talking about NACIS.exe)
On C:\NACISII\logon.ini, change the support number from 0 to 9. This will enable the Development database on NACIS log in window
Issue:
Logging in NACIS, choose Development database with default user id = “Test”, password is “CANADA”
Then after successful logging in with TEST/CANADA, NACIS will ask you to change the user id and password
If you catch the error like this
Fix:
You already have the user id/pass for NACIS or NAPA. Then you can go into the C:\NACISII\logon.ini to check these info which was saved previously
Issue: The version of the application is out of date
Fix:
Make sure the application nacis.pbl is unlocked
Go to the local folder and turn off read-only all files again
Right click the nacis solution->get latest version, choose
At the bottom of the screen, you will see “Building list of source control item..”, please do not do anything, please be patient
You can see this below, click ok
It took very long to see this
Then you can select all and click Advanced to select both options…
Issue: You can not see NACIS-SINCA in TFS server at this location http://tfsprod:8080/tfs/civav/
Fix: you can add yourself if you are administrator, otherwise you can ask the team leader do that
You have to be a contributor of NACIS project like this screenshot, you can search TC\your credential to see what permission you have for the specific project
Database
on Dev:
Server NNDEV.World
Userid = NAPA_NACIS
Password: please ask the database team
Add Comment