Error Creating Projects in NAPA/NDWL

Owned by Christopher Collins
Feb 08, 2023
3 min read

Sometimes the users will get an error when creating a project.

Main reasons this occurs is:

  1. The year end Roll over was not processed.

To fix See NAPA Year End Roll Over - BSD - Civil Aviation - Confluence (atlassian.net)

2. A change was made behind the scenes via system tables.

This could be that the project type was changed, an aproval number was changed, or a foreign design authority was changed. This is causing more than 1 Project (or 0 projects) to be returned when trying to create a revision.

3. A project was logically deleted that is causing more than 1 project to be returned when creating a revision.

 

Usually, the Error message will tell you where to look to find the SQL that is causing the error.

Example NAP-0216 create_based_on_mod_proj returened-6. Try again or contact System administrator.

Go into Toad and look for the area with the same error (example -6)

Look to see that there is not a duplicate data causing the error in that table.

NOTE: A MOD Project Chain is typically Repeating values of MOD_ID_NUM with the same MOD_PROJ.TYP_CD (Project Type) and the same approval numbers from MOD_APRV_RVS (APRV_NUM, APRV_NNN and a combination of FOREIGN_AUTHORITY_CD and FAA_STC_NUM)

Example 2 rows (same MOD_ID_NUM with more than 1 row with most recent revision number (MOD_APRV_RSN.RVS_NUM).

This sometimes occurs when a project is deleted. MOD_PROJ.MOD_PROJ_DELETED = 'Y'

So you need to look at the rows on MOD_PROJ and MOD_APRV_RSN

Renumber the deleted Project to not be equal to the most current RVS_NUM if possible.

______________________________________________________________________________________________________

Or it could be that more than 1 project “chain” has the same approval number combination

Example

 

If the Projects are correct then you will need to modify the MOD_ID_NUM on MOD_APRV_RVS, MOD_PROJ, MOD_APRV_MDL, MOD_APRV_CERT etc to the correct MOD_ID_NUM chain.

The example above the Project was being Cancelled (or Logically deleted) so you can modify the approval number so it won’t get found again.

________________________________________________________

The same type of thing can happen on TC Projects but you need to look on tables TA_PROJ, TA_APPL

And the column names are slightly different.