Error when Changing data type to merge tables

Bug reports
1

Hello everyone,

Alex here, almost new to Metabase. I am working on a dashboard where I need to get the field from another table. And there's only one field that matches.

But, in one it's entity key & Type/text, the other one is category & Type/BigInteger. I have tried using SQL inquiry, yet couldn't do it, then I have contacted our admin, he has created a special field in one of the tables, all saved, yet the field wasn't available for edits in 'Fields in this table' tab. I thought it would need some time to sync, but after 6 hours we see that the field disappeared from the table.

The table comes from HubSpot via Segment integration.

Would appreciate any help.

Thank you

2

Hi @alexsit
Please post "Diagnostic Info" from Admin > Troubleshooting.
Do a manual sync via Admin > Databases, and then check the log for errors in Admin > Troubleshooting > Logs.

3

Hi @flamber and thank you for the quick reply.

Here goes the information you requested:

Here is diagnostic info

{
  "browser-info": {
    "language": "en",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "ANSI_X3.4-1968",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_275-8u275-b01-1~deb9u1-b01",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_275",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.275-b01",
    "os.name": "Linux",
    "os.version": "5.4.104+",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.6"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "tag": "v1.39.3",
      "date": "2021-05-27",
      "branch": "release-x.39.x",
      "hash": "598a112"
    },
    "settings": {
      "report-timezone": "Europe/Berlin"
    }
  }
}

I also did manual sync as recommended and it was completed with no errors.

4

@alexsit If you are an Enterprise customer/trial, then please use the support email. Otherwise you should use open source edition instead.

I don't think I understand what the problem is. Can you describe it differently and provide screenshots?
I don't understand what your admin did.

You can start with the log4j parameter to get more details during sync - example:

java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar