[Solved] - There was a problem displaying this chart in PHP

edimar · January 12, 2021, 9:33pm

Hy guys,
My dashboard embedding it is show the issue:

Below the file log, anybody can help me plase?

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.8+10-post-Ubuntu-0ubuntu118.04.1",
    "java.vendor": "Ubuntu",
    "java.vendor.url": "https://ubuntu.com/",
    "java.version": "11.0.8",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.8+10-post-Ubuntu-0ubuntu118.04.1",
    "os.name": "Linux",
    "os.version": "4.15.0-121-generic",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-01-05",
      "tag": "v1.37.5",
      "branch": "release-x.37.x",
      "hash": "be537ee"
    },
    "settings": {
      "report-timezone": "Brazil/East"
    }
  }
}

Thank you

Luiggi · January 12, 2021, 11:49pm

Hi @edimar, are you passing the parameters correctly? It seems that there is an issue with the queries not being able to execute well. Can you see what does Metabase says on the logs?

edimar · January 14, 2021, 11:27am

Hi @Luiggi, don’t have parameter, see my code below:
#Write in PHP

class VwDashMeta extends TPage
{
public function __construct()
{
parent::__construct();

    $metabaseSiteUrl = 'http://localhost:3000';
    $metabaseSecretKey = '5543edi45mnfnnsmmnss5677wnndnnd44455';
                         
    $signer = new \Lcobucci\JWT\Signer\Hmac\Sha256();
    $token = (new \Lcobucci\JWT\Builder())
        ->set('resource', ['dashboard' => 100])
        ->set('params', ['your_custom_param' => 0])
        ->sign($signer, $metabaseSecretKey)
        ->getToken();

     

    $iframeUrl = "$metabaseSiteUrl/embed/dashboard/$token#bordered=true&titled=true";



    $iframe = new TElement('iframe');
    $iframe->id = "iframe_external";
    $iframe->src = $iframeUrl;
    $iframe->frameborder = "0";
    $iframe->scrolling = "yes";
    $iframe->width = "100%";
    $iframe->height = "800px";
    
    parent::add($iframe);
}

}

Luiggi · January 14, 2021, 12:11pm

Thanks @edimar, can you please send the browser console logs and Metabase logs to try to debug what is going on? Do you see the dashboard being rendered correctly in the embedding preview?

edimar · January 14, 2021, 1:19pm

Hello @Luiggi, thanks for help me!
Yes, I can see the preview normally.
See the browser console:
{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10-post-Ubuntu-0ubuntu118.04.1”,
“java.vendor”: “Ubuntu”,
“java.vendor.url”: “https://ubuntu.com/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10-post-Ubuntu-0ubuntu118.04.1”,
“os.name”: “Linux”,
“os.version”: “4.15.0-121-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
},
“metabase-info”: {
“databases”: [
“h2”,
“mysql”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2021-01-05”,
“tag”: “v1.37.5”,
“branch”: “release-x.37.x”,
“hash”: “be537ee”
},
“settings”: {
“report-timezone”: null
}
}
}

Below the metabase log:

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:32-03:00 INFO metabase.core
Metabase v1.37.5 (be537ee release-x.37.x)

Metabase Enterprise Edition extensions are PRESENT.

Usage of Metabase Enterprise Edition features are subject to the Metabase Commercial License.See https://www.metabase.com/license/commercial/ for details.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:32-03:00 WARN metabase.core WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:32-03:00 INFO metabase.core Starting Metabase in STANDALONE mode
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:32-03:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:32-03:00 INFO metabase.core Starting Metabase version v1.37.5 (be537ee release-x.37.x) …
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:33-03:00 INFO metabase.core System info:
{“file.encoding” “UTF-8”,
“java.runtime.name” “OpenJDK Runtime Environment”,
“java.runtime.version” “11.0.8+10-post-Ubuntu-0ubuntu118.04.1”,
“java.vendor” “Ubuntu”,
“java.vendor.url” “https://ubuntu.com/”,
“java.version” “11.0.8”,
“java.vm.name” “OpenJDK 64-Bit Server VM”,
“java.vm.version” “11.0.8+10-post-Ubuntu-0ubuntu118.04.1”,
“os.name” “Linux”,
“os.version” “4.15.0-121-generic”,
“user.language” “en”,
“user.timezone” “Etc/UTC”}

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:33-03:00 INFO metabase.plugins Loading plugins in /opt/metabase/plugins…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered abstract driver :sql
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered abstract driver :sql-jdbc (parents: [:sql])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :postgres (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Plugin ‘Metabase BigQuery Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase BigQuery Driver”]
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered abstract driver :google
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: [“Metabase BigQuery Driver”]
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 WARN metabase.plugins.lazy-loaded-driver Warning: plugin manifest for :bigquery does not include connection properties
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can’t ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase Vertica Driver”]
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :druid
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can’t ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase Oracle Driver” “Metabase Vertica Driver”]
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :presto (parents: [:sql])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Plugin ‘Metabase Google Analytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :googleanalytics (parents: [:google])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 INFO metabase.driver.impl Registered driver :mongo
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:34-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Registered driver :h2 (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Registered driver :mysql (parents: [:sql-jdbc])
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 WARN metabase.db WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.html
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.db Verifying h2 Database Connection …
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Initializing driver :sql…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Initializing driver :sql-jdbc…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:35-03:00 INFO metabase.driver.impl Initializing driver :h2…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:38-03:00 INFO metabase.db Successfully verified H2 1.4.197 (2018-03-18) application database connection.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:38-03:00 INFO metabase.db Running Database Migrations…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:38-03:00 INFO metabase.db Setting up Liquibase…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:39-03:00 INFO metabase.db Liquibase is ready.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:39-03:00 INFO metabase.db.liquibase Checking if Database has unrun migrations…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:42-03:00 INFO metabase.db Database Migrations Current …
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:42-03:00 INFO metabase.db.migrations Running all necessary data migrations, this may take a minute.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:42-03:00 INFO metabase.db.migrations Finished running data migrations.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.dependencies/Dependencies
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.activity-feed/ActivityFeed
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.metabot-lifecycle/MetaBotLifecycle
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.last-login/LastLogin
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.notifications/Notifications
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.sync-database/Sync
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.driver-notifications/DriverNotifications
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.revision/Revisions
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.events Starting events listener: :metabase.events.view-log/ViewLog
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task SyncDatabases
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task.sync-databases Starting sync task for Database 3.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.sync.util STARTING: Sync metadata for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.driver.impl Initializing driver :mysql…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.sync.util STARTING: step ‘sync-timezone’ for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task CheckForNewVersions
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task SendAnonymousUsageStats
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task SendAbandomentEmails
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task SendPulses
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task SendFollowUpEmails
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.task Initializing task TaskHistoryCleanup
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:43-03:00 INFO metabase.core Metabase Initialization COMPLETE
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:45-03:00 INFO metabase.sync.util FINISHED: step ‘sync-timezone’ for mysql Database 3 ‘PPinheiro’ (2.2 s)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:08:45-03:00 INFO metabase.sync.util STARTING: step ‘sync-tables’ for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:31-03:00 INFO metabase.util.i18n.impl Reading available locales from locales.clj…
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:31-03:00 INFO metabase.sync.util FINISHED: step ‘sync-tables’ for mysql Database 3 ‘PPinheiro’ (45.9 s)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:31-03:00 INFO metabase.sync.util STARTING: step ‘sync-fields’ for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:32-03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 53.6 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (46 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:33-03:00 DEBUG metabase.middleware.log GET /api/user/current 200 760.5 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (47 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:33-03:00 DEBUG metabase.middleware.log GET /api/database 200 48.4 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (47 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:33-03:00 DEBUG metabase.middleware.log GET /api/collection/root/items 200 355.3 ms (7 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (3 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:34-03:00 DEBUG metabase.middleware.log GET /api/collection/root 200 14.5 ms (2 DB calls) App DB connections: 2/4 Jetty threads: 4/50 (3 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:42-03:00 DEBUG metabase.middleware.log GET /api/user/current 200 24.5 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:42-03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 38.3 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:42-03:00 DEBUG metabase.middleware.log GET /api/database 200 8.3 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:09:42-03:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 6.9 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (48 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:10:06-03:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don’t know how to map column type ‘BIGINT UNSIGNED ZEROFILL’ to a Field base_type, falling back to :type/.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:32-03:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don’t know how to map column type ‘BIGINT UNSIGNED ZEROFILL’ to a Field base_type, falling back to :type/.
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:39-03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 1.7 ms (0 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (47 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:39-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc 200 201.3 ms (21 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/dashboard/132 401 494.1 µs (0 DB calls)
“Unauthenticated”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/313/card/17 400 8.3 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/314/card/18 400 4.9 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/320/card/24 400 3.7 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/319/card/23 400 5.4 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/321/card/25 400 5.5 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/340/card/309 400 3.7 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/315/card/20 400 4.0 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/307/card/1 400 4.5 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/317/card/21 400 3.4 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/341/card/310 400 4.5 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/311/card/14 400 3.0 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/318/card/22 400 4.4 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/312/card/15 400 3.3 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/339/card/308 400 3.2 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:40-03:00 DEBUG metabase.middleware.log GET /api/embed/dashboard/eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJyZXNvdXJjZSI6eyJkYXNoYm9hcmQiOjEwMH0sInBhcmFtcyI6eyJ5b3VyX2N1c3RvbV9wYXJhbSI6MH19.TBPRR9ooAUZOU_Fc8gF5bWvcACcC9H3WbfcFZMzrfpc/dashcard/309/card/12 400 3.9 ms (2 DB calls)
“Unknown parameter :your_custom_param.”

[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:45-03:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 5.5 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:53-03:00 INFO metabase.sync.util FINISHED: step ‘sync-fields’ for mysql Database 3 ‘PPinheiro’ (2.4 mins)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:11:53-03:00 INFO metabase.sync.util STARTING: step ‘sync-fks’ for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:13:52-03:00 INFO metabase.sync.util FINISHED: step ‘sync-fks’ for mysql Database 3 ‘PPinheiro’ (2.0 mins)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:13:52-03:00 INFO metabase.sync.util STARTING: step ‘sync-metabase-metadata’ for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:14:48-03:00 INFO metabase.sync.util FINISHED: step ‘sync-metabase-metadata’ for mysql Database 3 ‘PPinheiro’ (55.7 s)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:14:48-03:00 INFO metabase.sync.util FINISHED: Sync metadata for mysql Database 3 ‘PPinheiro’ (6.1 mins)
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:14:48-03:00 INFO metabase.sync.util STARTING: Analyze data for mysql Database 3 ‘PPinheiro’
[4a031e2e-ab80-45fb-9d1c-35b36d35e8d2] 2021-01-14T10:14:48-03:00 INFO metabase.sync.util STARTING: step ‘fingerprint-fields’ for mysql Database 3 ‘PPinheiro’

Luiggi · January 14, 2021, 1:31pm

@edimar the logs are telling that the dashboard is expecting parameters which you are not passing in your code. Check the sections in the log that say: “Unknown parameter :your_custom_param.”

You have configured the dashboards to expect parameters but in your code you are not sending any, so, configure the dashboards to not expect any parameters when you configure the embedding or pass the parameters in the code.

best regards

edimar · January 14, 2021, 1:36pm

Yes @Luiggi, the log show that. But my dashboard not have parameter and if delete “your_custom_param” in my code PHP, show erro to put parameter.

Stranger because not have this one parameter in dashboard.

Thank more one time for help me!

Luiggi · January 14, 2021, 2:04pm

@edimar unfortunately this is all I can help you as I’m not a PHP guy, but I fear that the error is on the PHP script trying to inject parameters where they don’t belong to

best regards

edimar · January 14, 2021, 2:09pm

Ok @Luiggi, your help was very very important for me.

Thank you very much and have a nice day!

Best regards,

Luiggi · January 14, 2021, 2:27pm

Thank you @edimar! if you find the solution please post it here so all users are able to see it

have a great day

edimar · January 14, 2021, 2:30pm

Yes, for sure!

Thank you.

edimar · February 12, 2021, 5:21pm

Hello @Luiggi , I solved my issue change the code below:

Before:

set(‘params’, [‘your_custom_param’ => 0])

After I change to:

set(‘params’, [‘params’ => null])

Thank for help me!