2012.05.29


   Write welcome text
   
   Schema browser
   ++ add views
   ++ add functions
   ++ add indices
	  
++	  implement export
++	  implement myDB table rename
++	  implement myDB table drop
	  
	  metadata
   ++ invisible objects
	  
   Query
      write test queries
	  autogen output table name
++        autogen task name
++        implement quick
++        query task name
	  
   Job history
++    implement cancel
++    display error
   
++ Implement import
   
   Write generic help
   
   Always generate ID for myDB tables
   
   email template url double //   
   
   schema name in mysql tables
   
   
ADMIN:
   
   checktimeout
   entity dropdowns
   listview column width
   form control lower case names
   transaction required
   multiname list / \ . consistently
++ move instance file under LOG file group
   redirects use function to get url
   create nodes wizard
++ federation create form databaseversion target server version
   go to the appropriate tab
   review all redirects
   catch and log exceptions from web sites
   highlight fields acception expressionproperties
   convert numbers to some kind of byteproperty
   add system flag to autogenerated entities
   fix and upgrade slicing wizard
   nice entity cacheing
   refresh properties after button click
   add node wizard that creates TEMP and mirrors DBs
   special button: change deployment and running state
   reset lock from admin
   override delete when candelete is false
   database definition running/stoped button isn't working correctly
   do deep copy of entity references when cloning
   
Validation checks
   check for autogrow files
   check for default tempdb
   
Activities

-- Assembly loader: implement correct dll version checking
-- Solve problem of dll locking
   temp database clean-up job
+  job cancel logic to clean up temp tables
++ initialize job objects on deserialization
   
LIB

   buffered logging
   
   try dropping temp table before creating otherwise retry doesn't work
++ replace database server type to .net provider name
   
PARSER
	add resolved, normalized etc flags to selectstatement, queryspecification etc.
   
TESTS

   Test all exception classes for serialization/deserialization (as req'd by the scheduler!)
	
SKYQUERY
	
   number of partitions multiplier is a job setting
++ unit test for query factories
   command line installer to create jobs etc.


SCHEDULER

++ locking collision on job submit when scheduler is active - use lower isolation on web
++ cannot cancel executing jobs when locked by scheduler
++ write test to serialize workflows, there's a bug somewhere


REFACTOR

-- factor out plug-in support from jobs and make it more generic (PlugIns namespace?) - serializers & inherited types
-- Context -> RegistryContext
-- Create SMO context and close SMO connection, start by renaming GetSmoServer



BUGS:

++ sometimes schemamanager doesn't find table while it's certainly there
++ table peek
++ schema  manager breaks if table in session deleted
++ job list brakes if job classes change - go back to xmlserializer


REMOTE SERVICE:
   make app domain management common
   solve assembly loading and versioning problems
   try to time-out hosts and add versions to services
   does it use .net serializer?
   make authorization global for all function


WEB:
++ text from html files
++	copyright
++	contact
++	personnel
++	help
   schema browser: move columns to the details page
   email sender form
   highligh active module in menu
   table schema editor
++ button event fired twice?
   save query before navigating from page
   merge jobdescriptionfactory w/ webjobinstancefactory
++ user activation form and confirmation form are not centered
++ sign-out broken
++ account settings broken
++ register button on login screen causes validation and breaks
++ sign in with email address
++ sign in link points to wrong address (auth instead of gwauth)
   
REGISTRY:
   


SKYQUERY:
   validation
       only tables in xmatch (views cannot have zoneindex)
       check if target table is empty
       error expression requires min and max!



   write help
++ check non-button links
++ download list under mydb
++ footer links
++ user links
++ user icon top right corner
   list select by default on click back
   list full line click
++ user feedback form
++ exception form
   table editor (primary key, at least)
++ tab view active tab white instead of blue
++ schema browser buttons below instead of toolbar
   output table: into overwrites form field + add schema + check existing
++ job status control on details forms
++ main page in nice form
++ schema browser main page in nice form
++ download list use multilistview
++ mydb request more space link instead of button
   job error send inuiry link (need to pass jobid)
++ download links
   single/multi selection modes don't work on client side
   pager controls
++ download links use same function everywhere
++ query in job view displayed with incorrect encoding (<br>)


++ discover code
   collect databases and copy them


++ other browsers
mac




2013.01.09.

   File upload breaks if extension is unknown
   
   
2013.06.18.

   Check log file generation in mapper (must go to separate disk volumes)
   Scheduler breaks if no clr enabled in admin db
   SchemaSource server?



Unhandled Exception: System.Data.SqlClient.SqlException: The app domain with specified version id (525) was unloaded due
 to memory pressure and could not be found.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInA
ction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectio
nLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, B
ulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOption
sString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
 returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean re
turnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boo
lean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Jhu.Graywulf.Registry.QueueInstance.GetNextJobInstance() in C:\Data0\dobos\project\graywulf\dll\Jhu.Graywulf.Regis
try\Registry\QueueInstance.io.cs:line 31
   at Jhu.Graywulf.Scheduler.QueueManager.PollNewJobs() in C:\Data0\dobos\project\graywulf\exe\Jhu.Graywulf.Scheduler\Qu
eueManager.cs:line 475
   at Jhu.Graywulf.Scheduler.QueueManager.Poll() in C:\Data0\dobos\project\graywulf\exe\Jhu.Graywulf.Scheduler\QueueMana
ger.cs:line 358
   at Jhu.Graywulf.Scheduler.QueueManager.Poller() in C:\Data0\dobos\project\graywulf\exe\Jhu.Graywulf.Scheduler\QueueMa
nager.cs:line 343
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object
state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, B
oolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
PS Microsoft.PowerShell.Core\FileSystem::\\blackhole\data\Raid6_2\Graywulf\GWCode\RemoteService> .\gwscheduler.exe
Graywulf scheduler is starting...
2014.07.09. 16:16:31 : Jhu.Graywulf.Scheduler.Start : Closed
2014.07.09. 16:16:31 : Jhu.Graywulf.Scheduler.LoadRegistry : Closed
2014.07.09. 16:16:32 : Jhu.Graywulf.Scheduler.QueueManager.ProcessInterruptedJobs[Executing] : Closed
2014.07.09. 16:16:32 : Jhu.Graywulf.Scheduler.StartPoller : Closed
                                  done.