Utopia Knowledge Base Definitions
  • Welcome to Utopia University
  • 🔦Overview
    • How to Navigate the University
    • How is Utopia different
    • Features
    • Utopia Sync Website Links
  • 😁Contact Us
    • Open Chat Room
    • Contact Us
  • ⬇️Installation guide
    • Docker Compose Installation
      • Prerequisites
      • The Installation Configurator
        • Databases
        • S3 (Optional)
        • SMTP Details (Compulsory)
        • Adobe API Credentials (Optional)
        • Final steps to get your compose fle
      • Compose Installation
    • Kubernetes Installation
      • Prerequisites
      • The Installation Configurator
        • Databases
        • S3 (Optional)
        • SMTP Details (Compulsory)
        • Adobe API Credentials (Optional)
        • Ingress Naming (Compulsory)
        • Final steps to get helm chart
      • Using Helm to Install and Edit
      • Final Stage DNS setup
        • Setting up TLS cert
        • Third Party Service DNS Manager (like Cloudflare)
        • DNS Work-around while you get your cert ready
    • Cluster Craft
      • Basic Kubernetes install with microk8s
      • Basic Kubernetes install with microk8s and NFS storage
      • Updating Loadbalancer IP with Microk8s and Metallb
      • Installing Utopia in Azure
      • Testing SMTP server from a Kubernetes Cluster or a Container using telnet and openssl
      • Kubernetes Visibility
        • Kube CLI visibility with Lens or OpenLens
        • Prometheus and Grafana Monitoring
      • Syntax Cheat Sheet
        • Kubectl
        • Microk8s
        • Microceph
        • Mongodb Compass
          • _MONGOSH Terminal Commands
          • Query Commands
        • Shell Commands
  • 🖥️Product Guide
    • Integration Hub
      • Selecting your Organization
      • Menu Navigation
      • Data In
        • Collection Parameters
        • Document Lifespan Strategy
        • Source Connectors
          • Connector Modules
            • Empact Email Orders
            • File Transfer Protocol (FTP)
            • Generate Random Documents (Test)
            • HTTP REST Collection Source
            • Lotus 1-2-3 prn file
            • Microsoft Navision Collection
            • MySQL Query
            • Pick n Pay Supplier Orders
            • Post Office Protocol (POP3)
            • Secure File Transfer Protocol (SFTP) (SSH)
            • Internet Message Access Protocol (IMAP)
            • Shoprite Collection
            • SQL Server Query
            • StrategixNav Collection
            • Transaction Query
          • Web Hook Triggers
        • API Listeners
          • Document Capture
          • Document Query (External)
          • Document Query (Integrated)
          • Listener Security
      • Transform
        • Search Documents
        • The Designer Panel
        • The Designer view
        • Transform Stage Types
          • Filter
          • Lookup
          • Add Field
          • Projection
          • Unwind
          • JS / JSON
      • Data Out
        • Publisher Collection Parameters
        • Data Out Connector
          • API Collection Publisher
          • Do Nothing
          • File Transfer Protocol (FTP)
          • HTTP REST Collection Publisher
          • Message Transport Post
          • Microsoft Navision Publisher
          • PDF Document Emailer
          • Pick n Pay Invoices
          • Post Syspro QueryQuery
          • Post Syspro Transaction
          • Post Vector Orders
          • Secure File Transform Protocol (SFTP) (SSH)
          • Shoprite Invoice Publisher
          • SMTP Collection Publisher
          • SQL Server OPENJSON Publisher
          • SQL Server Query Publisher
          • StrategixNav Publisher
      • Validation
    • Organizations
    • Transaction Page
    • User Profile
    • Logging
    • Process Que Dashboard
    • Process Error Dashboard
    • New Functions
      • XML to Json using the Transform Designer
      • XML to Json using ChatGPT
      • Rest Connector JS Prescript
    • Release Notes
      • Microservices
        • 0.12.1622
        • 0.12.1630
  • ☕Use Cases
    • Follow Along Examples
      • Look-ups! no-code Transform Stage
        • Multi Field Look-ups! low-code Transform Stage
      • Rest Connector JS Prescript Example
        • Rest Connector JS PreScript Fault Finding Techniques
      • XML to Json using the Transform Designer
      • XML to Json using ChatGPT
    • Solution Discussions
      • Moditar: Increasing Integration Adoption using UtopiaSync
      • UtopiaSync the scalable no-code Backend?
      • UtopiaSync Security - How does it work?
      • UtopiaSync Custom Configuration
      • UtopiaSync Maintenance
  • 😁Case Studies
    • How Moditar drove efficiency for Meridian Wine Merchants using Utopia iPaaS
    • The journey to Spier Wine Farm's perfect eCommerce Integration
    • Integration journey to 100% automated with La Concorde Bakery
Powered by GitBook
On this page
  1. Product Guide

Logging

PreviousUser ProfileNextProcess Que Dashboard

Last updated 9 months ago

One of the features Utopia has is the extensive logging it provides out the box. These can be extremely helpful when it come to fault finding or performance managing.

The logs can be seen via dashboard at the Utopia UI, and

Below are the basic guidelines of where to find the log files which feed the UI's as well as highlight extra log details.

MongoDB:

Connector Logging - Logging the behaviour on each connector run. you can view the raw content that was collected or received, the times collected and process, batch information etc. These can be found by CSC_{{ connectorId }} (CollectionSourceConnector) or CPC_{{ connectorId }} (CollectionPublisherConnector).

Transaction Logging - These are a summary of the documents movements and data, these are used to populate the transaction page data in the UI too. You can identify these by transactions_{{ organisationId }}

Document Data - The data saved by the documents flowing through the system. The snap shots of the data and each collection. (data-in, transform, etc). You can identify these as guids with no prefix which are simply {{ collectionId }}.

MySQL (SQL, which ever table based DB you have selected):

Processing stats - Utopia records all each time a connector runs, how many docs it finds, how long it processed for etc. you can use this table to identify which processes are using your resources and working the hardest. This table can be found at microservices.ProcessStatistics

Connector logging - Here you can view any logging activities created by the Listeners (API's), so every time someone hits the end point a log is created. This activity is saved here and if you have an S3 setup for the cluster, it will also save the request details into S3. This table can be found at microservices.ConnectorLogging

Persistent Grants table - system autorisation token generation and management is logged in this table. If a system or user logs in and creates a token, this will hold its validity and details. This table is found at identity.PersistedGrants

S3 database (optional)

If you have a S3 setup for maintenance the following logs will be pulled out of Utopia and stored in S3 for reference (If the maintenance toggle is selected in the Utopia UI):

Collection Connector Logs - CSC_{{ }} & CPC_{{ }} Transaction Logs - transactions_{{ }} Documents - {{ }} Listener Logs - as described above, S3 file location found in microservices.ConnectorLogging

You can find the maintenance schedules and configs for thse in the microservices deployment:

            - name: DocumentMaintenance__Enabled
              value: 'true'
            - name: DocumentMaintenance__Dispatcher__Cron
              value: 0 09 * * *
            - name: DocumentMaintenance__Backup__Months
              value: '2'
            - name: SystemMaintenance__Enabled
              value: 'true'
            - name: SystemMaintenance__BackupStatistics__Days
              value: '90'
            - name: SystemMaintenance__Dispatcher__Cron
              value: 15 7 * * *
            - name: SystemMaintenance__Backup__Hours
              value: '72'

If you are unsure how to understand the cron numbering please take a look

🖥️
Hangfire
Elmah
here