Log and Report Locations

Logs and reports are placed in the file hierarchy for each project.

Month Format

NN-MMM is a month format that combines the number of the month (NN) with the abbreviated name of the month (MMM). Example: 11-Nov refers to November, not November 11.

DaticalDB
   daticaldb.log - for GUI
datical
   <project>
      daticaldb.log - for CLI
      Logs/
         <YYYY>/
            <NN-MMM>/
               <dbdef>/
                  changelogSync/
                     sync.log
                  Checksum/
                     clearCheckSum.log
      Reports/
         <YYYY>/
            <NN-MMM>/
               <dbdef>/
                  clearCheckSums_<dbdef>_yyyyMMdd_hhmmss
                     clearChuckSums.log
                  deploy_<dbdef>_<date>/
                     parser_output/
                        <filename_<timestamp>.xml
                  forecast_<dbdef>_<date>/
                     parser_output/
                        <filename>_<timestamp>.xml
		  packager_<dbdef>_<date>/
			  packager.log
			  packagerReport.html
                  rollback_<dbdef>_<date>
                  Diff/
                  DiffChangelog/
      Snapshots/
         ChangeLog/
         DBObjects/

Daticaldb.log

The daticaldb.log file gets written to the current working directory when you run the Datical CLI or the Datical GUI. You typically find them in the following locations:

Datical DB CLI - <UserDirectory>/datical/<project>/ - directory for each project
Datical DB GUI - <datical-install> - Datical DB install directory

The log is a valuable trouble shooting resource when errors or bugs are encountered. When using the Datical DB GUI, this log file replaces the .metadata/.log file available in previous releases

Changelog Sync Log

datical/<project>/Logs/<YYYY>/<NN-MMM>/<dbDef>/changelogSync/sync.log

The changelogSync logs are located under specific projects in the datical workspace folder. They can be found under datical/<project>/Logs/<YYYY>/<NN-MMM>/<dbDef> folder. There are subfolders here for each changelog sync that is run. Under the sync folder is a file called sync.log. The sync.log file contains useful information related to running the ChangeLog Sync command, the various queries run and connections related to it.

Checksum Clear Log

datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef>/clearCheckSums_<dbdef>_yyyyMMdd_hhmmss/clearCheckSums.log

There is a timestamped subfolder for each checksum that is run. The log is in file clearCheckSums.log.

Forecast/Deploy Logs

datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef>/deploy_<dbdef>_<datetime>datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef>/forecast_<dbdef>_<datetime>

The forecast and deploy reports are located under specific projects in the datical workspace in datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef> folders. There are subfolders for each forecast/deploy report that is launched which contain the HTML report generated by the UI. Under the deploy folder is also a DaticalLiquibase.log file which contains useful troubleshooting information.

Rollback Log

datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef>/rollback_<dbdef>_<datetime>

The forecast and deploy reports are located under specific projects in the datical workspace in datical/<project>/Reports/<YYYY>/<NN-MMM>/<dbDef> folders.

Diff/DiffChangeLog Log

datical/<project>/Reports/Diff datical/<project>/Reports/DiffChangeLog

The Diff and DiffChangelog logs are located under specific projects in the datical workspace in datical/<project>/Reports. There are subfolders for Diff or DiffChangeLog that contain the corresponding logs for the particular compare. Under the Diff and DiffChangeLog folder is the actual report that was generated in the UI, plus log files that contain connection and query information.

Snapshot Log

datical/<project>/Snapshots/ChangeLog datical/<project>/Snapshots/DBObjects

The snapshot logs are located under specific projects in the datical workspace in datical/<project>/Snapshots. There are subfolders for ChangeLog and DBObjects that contain files related to the snapshot taken. Underneath these folders will be a log called snapshot.log which contains useful information about the connections as well as queries run.

Available Log Files and Reports