{"id":4800,"date":"2025-07-30T13:21:09","date_gmt":"2025-07-30T13:21:09","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4800"},"modified":"2025-07-30T13:21:09","modified_gmt":"2025-07-30T13:21:09","slug":"using-the-logs-in-board-to-troubleshoot-load-errors","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/","title":{"rendered":"Using the Logs in Board to Troubleshoot Load Errors"},"content":{"rendered":"

Using the Logs in Board to Troubleshoot Load Errors<\/strong><\/p>\n

\"\"<\/p>\n

When data loads fail in Board, whether it’s an entity hierarchy or cube population, the logs<\/strong> are your best friend. The logs pinpoint where and why the process failed.<\/p>\n

\ud83e\udded How to Access the logs<\/strong><\/p>\n

    \n
  1. The logs can be downloaded from the Cloud Administration Portal.<\/li>\n
  2. Open the log and scroll to view detailed system messages and error flags.<\/li>\n<\/ol>\n

    \u00a0<\/strong><\/p>\n

    \ud83d\udd0d What to Look For<\/strong><\/p>\n

      \n
    • Line Numbers<\/strong>
      \nIdentify which row in your CSV or data source caused the error.<\/li>\n
    • Error Types<\/strong>
      \nLook for:<\/p>\n
        \n
      • Orphan node: Indicates a missing parent in a hierarchy<\/li>\n
      • Duplicate code: Same code listed multiple times in an entity<\/li>\n
      • Invalid date format: Date does not match the expected format (e.g., DD\/MM\/YYYY)<\/li>\n<\/ul>\n<\/li>\n
      • Execution Summary<\/strong>
        \nAt the end of the log, you’ll see the number of errors encountered and whether the load was terminated.<\/li>\n<\/ul>\n

        \u2705 Pro Tips<\/strong><\/p>\n

          \n
        • Use the logs immediately<\/em> after any failed execution; don\u2019t rerun before reviewing the log.<\/li>\n
        • Copy and paste the specific error lines into a text editor for debugging or import them into Excel.<\/li>\n
        • Cross-reference the line number with your original file to correct issues directly.<\/li>\n
        • If you’re loading hierarchies, verify parent-child logic before re-importing.<\/li>\n<\/ul>\n

          \ud83e\udde9 Example Scenario<\/strong><\/p>\n

          You attempt to load a department hierarchy, and the Data Reader fails. In the logs, you see:<\/p>\n

          pgsql<\/p>\n

          CopyEdit<\/p>\n

          [ERROR] Line 24: Orphan node ‘Dept_501’ has no valid parent.<\/p>\n

          You open the file, find row 24, and notice the parent column is blank. Fix it, reload, and the error is resolved.<\/p>\n

          \ud83d\udd04 Related Articles<\/strong><\/p>\n

            \n
          • How to Use the Data Reader Preview Function in Board<\/li>\n
          • Error Handling \u2013 Common Hierarchy Loading Errors (coming soon)<\/em><\/li>\n<\/ul>\n

            \ud83d\udc49 Next Step:<\/strong><\/p>\n

            Need help diagnosing a persistent error?<\/strong> Contact QueBIT Support<\/p>\n","protected":false},"excerpt":{"rendered":"

            Using the Logs in Board to Troubleshoot Load Errors When data loads fail in Board, whether it’s an entity hierarchy or cube population, the logs are your best friend. The logs pinpoint where and why the process failed. \ud83e\udded How to Access the logs The logs can be downloaded from the Cloud Administration Portal. Open…<\/p>\n","protected":false},"author":5,"featured_media":4801,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[115],"tags":[114,113],"class_list":["post-4800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-board","tag-board","tag-tutorial"],"acf":[],"yoast_head":"\nUsing the Logs in Board to Troubleshoot Load Errors - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Logs in Board to Troubleshoot Load Errors - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Using the Logs in Board to Troubleshoot Load Errors When data loads fail in Board, whether it’s an entity hierarchy or cube population, the logs are your best friend. The logs pinpoint where and why the process failed. \ud83e\udded How to Access the logs The logs can be downloaded from the Cloud Administration Portal. Open…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-30T13:21:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"577\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"Using the Logs in Board to Troubleshoot Load Errors\",\"datePublished\":\"2025-07-30T13:21:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/\"},\"wordCount\":293,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Picture1-1.png\",\"keywords\":[\"Board\",\"Tutorial\"],\"articleSection\":[\"Board\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/\",\"name\":\"Using the Logs in Board to Troubleshoot Load Errors - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Picture1-1.png\",\"datePublished\":\"2025-07-30T13:21:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Picture1-1.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Picture1-1.png\",\"width\":780,\"height\":577},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-logs-in-board-to-troubleshoot-load-errors\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the Logs in Board to Troubleshoot Load Errors\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using the Logs in Board to Troubleshoot Load Errors - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/","og_locale":"en_US","og_type":"article","og_title":"Using the Logs in Board to Troubleshoot Load Errors - QueBIT","og_description":"Using the Logs in Board to Troubleshoot Load Errors When data loads fail in Board, whether it’s an entity hierarchy or cube population, the logs are your best friend. The logs pinpoint where and why the process failed. \ud83e\udded How to Access the logs The logs can be downloaded from the Cloud Administration Portal. Open…","og_url":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/","og_site_name":"QueBIT","article_published_time":"2025-07-30T13:21:09+00:00","og_image":[{"width":780,"height":577,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png","type":"image\/png"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"Using the Logs in Board to Troubleshoot Load Errors","datePublished":"2025-07-30T13:21:09+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/"},"wordCount":293,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png","keywords":["Board","Tutorial"],"articleSection":["Board"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/","url":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/","name":"Using the Logs in Board to Troubleshoot Load Errors - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png","datePublished":"2025-07-30T13:21:09+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/07\/Picture1-1.png","width":780,"height":577},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/using-the-logs-in-board-to-troubleshoot-load-errors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Using the Logs in Board to Troubleshoot Load Errors"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4800"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4800\/revisions"}],"predecessor-version":[{"id":4803,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4800\/revisions\/4803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media\/4801"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}