From: Hansville, WA, USA
How do I know which scenario needs to be updated to which database?
In general whenever you update a scenario it will be to the latest database in the DB folder. Trying to choose a different one may not fix a particular issue.
A problem can arise when some non-trivial thing changes such as fixing something that does not work correctly – as in this SOSUS case. The Northern Inferno Campaign was one of the original DLC releases from a couple of years ago. The SOSUS operation was subsequently determined to be incorrect and coding/database changes were made to correct the problem.
In a perfect world all the effected Campaign scenarios would be updated and provided in a new CMO update which is also a non-trivial process. In the real world the campaign authors, who are not necessarily part of the development staff, may not readily available to do the rebuilding. The result unfortunately means the player must update the scenario until a new “officially fixed” one is realized.
I completely understand the frustration of spending hours getting into a scenario and discovering that a feature is not working as it should, through no fault of your own. Hundreds of hours go into the testing of a DLC before release but actual changes to a system’s capabilities cannot always be foreseen. Often information becomes unclassified or otherwise available since the campaign’s creation. Then the decision is whether to leave things as they are if it does not degrade game play or update the code/database to conform to reality and risk the type of problem you are observing.
I apologize for the problems this has caused you and want you to know that this type of issue is taken vary seriously by the CMO development staff.
“There is no limit to what a man can do so long as he does not care a straw who gets the credit for it.”
Charles Edward Montague, English novelist and essayist
~Disenchantment, ch. 15 (1922)