Skip to end of metadata
Go to start of metadata

In a normal environment, nothing on this page will be required. However, if you have an unusual situation and need to recover drive space, these actions can be taken.

These steps are for the Jitterbit Harmony Windows Private Agents.

  • Set the temp path in C:\Program Files (x86)\Jitterbit Agent\Jitterbit.conf  (usually to c:\windows\temp)
  • To disable the creation of success and failure results files (only for Salesforce; to preserve disk space if they are not of interest), add this to bottom of the Jitterbit.conf file:
    [ResultFiles]
    DisableSuccess=true
    DisableFailure=true
  • Set the tmp and temp path in the Windows System Properties->Advanced->Environment Variables for both System and User. (Usually set to c:\windows\temp)
  • Make sure nothing has been deployed as debug.
  • This PostgreSQL script will find the operations that need to be fixed; use pgadmin to run it:

    Select operationstab.operation_name,operationpropertiestab.* from operationpropertiestab left join operationstab on operationstab.operation_id = operationpropertiestab.operation_id where keyname = 'write_log' and keyvalue = '1'

  • Make sure the log files are getting cleaned up in the C:\Program Files (x86)\Jitterbit Agent\CleanupRules.xml
  • Reduce the number of days to keep files and records in the CleanupRules.xml
  • Depending on your install (and OS), you may have to change some of the directories listed below, especially if a different version of PostgreSQL is installed.
    Run from a command prompt (Start->Run and type in CMD (in Windows the R key will bring up the run box if using Windows 8)
    • del /q /s "c:\windows\temp\*.*" > nul
    • del /q /s  "C:\Program Files\PostgreSQL\9.0\data\pg_log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\PostgreSQL\9.0\data\pg_log\*.*" > nul
    • del /q /s  "C:\Program Files\PostgreSQL\9.2\data\pg_log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\PostgreSQL\9.2\data\pg_log\*.*" > nul
    • del /q /s  "C:\Program Files\PostgreSQL\9.3\data\pg_log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\PostgreSQL\9.3\data\pg_log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Agent\log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Agent\apache\logs\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Agent\tomcat\logs\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Agent\DataInterchange\Temp\LOG\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Agent\DataInterchange\Temp\debug\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Integration Server\log\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Integration Server\apache\logs\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Integration Server\tomcat\logs\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Integration Server\DataInterchange\Temp\LOG\*.*" > nul
    • del /q /s "C:\Program Files (x86)\Jitterbit Integration Server\DataInterchange\Temp\debug\*.*" > nul
    • del /q /s "C:\Windows\Temp\jitterbit" > nul
  • If the PostgreSQL database is huge, it is possible to purge the archive tables in TranDb; use pgadmin to run it
    • For Version 7 and higher
      1. truncate table archivedataelementtab;
      2. truncate table archivemsgtab;
      3. truncate table archiveoperationlogtab;
      4. truncate table archiveoperationmessagetab;
      5. truncate table archiveoperationsummarytab;
      6. truncate table archivexferhist;
      7. in MsgDb
    • For Version 5
      1. truncate table archiveoperationsummarytab;
      2. truncate table archiveoperationmessagetab;
      3. truncate table archiveoperationlogtab;
    • Only for Version 5 and no tables for Version 7
      1. truncate table archiveoutgoingjmsmsgtab;
      2. truncate table archivemsgtab;
      3. truncate table archivejmssendingpropertiestab;
      4. truncate table archivejmspropertiestab;
      5. truncate table archivedataelementtab;
  • Reindex and reclaim disk space.
    • For Version 7 and higher
      1. "C:\Program Files (x86)\Jitterbit Agent\bin\JitterbitUtils.exe" --reindex-db
      2. "C:\Program Files (x86)\Jitterbit Agent\bin\JitterbitUtils.exe" --vacuum-db
      3. "C:\Program Files (x86)\Jitterbit Agent\bin\JitterbitUtils.exe" --reclaim-disk-space
    • For Version 5
      1. "C:\Program Files (x86)\Jitterbit Integration Server\bin\JitterbitUtils.exe" --reindex-db
      2. "C:\Program Files (x86)\Jitterbit Integration Server\bin\JitterbitUtils.exe" --vacuum-db
      3. "C:\Program Files (x86)\Jitterbit Integration Server\bin\JitterbitUtils.exe" --reclaim-disk-space


Related Topics

Last updated:  Jun 15, 2019