[ACP-1786]  Eliminate shared/cached database access object
Type Change Request
Priority High
Severity Show Stopper
Component Main Program, Server-Side Web ASP pages
Fixed In Version [9.0] 9.0
Versions Affected [8.3] 8.3
Severity Closed
Resolution Bad Idea
Reported By Bob Denny
Resources Bob Denny
Start Date 8/12/2020

Description 
Remove the Scheduler.Dataabase shared database handle. This will no longer be used as the Jet 2020 database cannot have shared/continuously open connections. See Scheduler-1785  for more.






For now don't change the API, just raise an error if anyone tries to use Scheduler.Database and mainlyu do not create a DC3.Scheduler.Database object and connect it inside ACP!!!.

Comments
1/12/2021 10:31:02 AM   Bob Denny 
Solved with a Microsoft Update Fix
1/8/2021 2:52:19 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/acp
 

 

  SVN Revision
  1293
 

 

  Affected files
  /trunk/WebDocs/ac/asastroimage.asp (Modified)
/trunk/WebDocs/ac/asgenprojlist.asp (Modified)
/trunk/WebDocs/ac/asphotosingle.asp (Modified)
/trunk/WebDocs/ac/asqueryccdnav.asp (Modified)
/trunk/WebDocs/ac/asuploadrtml.asp (Modified)
/trunk/WebDocs/ac/asuploadrtmlskytools.asp (Replaced)

 

 

  Check-in comment
  REVERT the changes to these ASPs for the ill-fated DB hack. 
GEM:1786
9/28/2020 2:10:32 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/acp
 

 

  SVN Revision
  1275
 

 

  Affected files
  /trunk/Scheduler.cls (Modified)

 

 

  Check-in comment
  Undo the change and restore the Scheduler.Database object. This was a bad idea.
GEM:1786
8/13/2020 1:31:39 PM   Bob Denny 
FAILED WORKAROUND - BAD IDEA






This looked so promising. However in final production configuration, it turns out that you cannot have any open connection to the database and to anything else on another connection, or the DB will inflate. So working with the schedule browser while observing is a fail. Plus the Scheduler itself has open connections. 







All changes pushed below have been reverted to the previous version(s). 
8/12/2020 4:20:28 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/acp
 

 

  SVN Revision
  1270
 

 

  Affected files
  /trunk/WebDocs/author.html (Modified)
/trunk/WebDocs/index.asp (Modified)

 

 

  Check-in comment
  This removes the schDB global copy of the now removed persistent connected Scheduler.Database object in ACP. 
GEM:1786
8/12/2020 4:16:35 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/acp
 

 

  SVN Revision
  1269
 

 

  Affected files
  /trunk/WebDocs/ac/asastroimage.asp (Modified)
/trunk/WebDocs/ac/asgenprojlist.asp (Modified)
/trunk/WebDocs/ac/asphotosingle.asp (Modified)
/trunk/WebDocs/ac/asqueryccdnav.asp (Modified)
/trunk/WebDocs/ac/asqueryskytools.asp (Modified)
/trunk/WebDocs/ac/asuploadrtml.asp (Modified)

 

 

  Check-in comment
  Changes for temporary database object instead of shared.
GEM:1786
8/12/2020 3:25:54 PM   Bob Denny 
Need to change multiple server side ASP pages that access the database.
8/12/2020 3:12:43 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/acp
 

 

  SVN Revision
  1268
 

 

  Affected files
  /trunk/ACP Help/relnotes.htm (Modified)
/trunk/Scheduler.cls (Modified)

 

 

  Check-in comment
  The Scheduler.Database object no longer makes connections to the Scheduler database and can thus no longer be used as a persistent shared connection to the database API.
GEM:1786