SQL Server Some Columns are missing in data model

Get Help
1

I can not find some columns in datamodel. but if i type select * from mytable , i can see all columns.
When i using Oracle Db there is no problem.
I already Re sync the data .

{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:83.0) Gecko/20100101 Firefox/83.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.7+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.7",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.7+10",
    "os.name": "Linux",
    "os.version": "4.15.0-112-generic",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "10.11 (Debian 10.11-1.pgdg90+1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-11-16",
      "tag": "v0.37.2",
      "branch": "release-x.37.x",
      "hash": "25e5f70"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @omerfaruk
Check the logs for errors during sync - Admin > Troubleshooting > Logs.

3

I found errors like these

[d1b19014-7ff9-4ddc-baa1-e0e49d5f464b] 2020-12-01T21:47:36+03:00 ERROR metabase.sync.util Error fingerprinting Table 1,991 ‘dbo.SatinAlmaFaturalariListesi2019’
clojure.lang.ExceptionInfo: Timed out after 20.0 mins. {:status :timed-out, :type :timed-out}
at metabase.query_processor.context.default$default_timeoutf.invokeStatic(default.clj:91)
at metabase.query_processor.context.default$default_timeoutf.invoke(default.clj:87)
at metabase.query_processor.context$timeoutf.invokeStatic(context.clj:98)
at metabase.query_processor.context$timeoutf.invoke(context.clj:93)
at metabase.query_processor.reducible$wire_up_context_channels_BANG_$fn__38257$state_machine__15984__auto____38266$fn__38268.invoke(reducible.clj:24)
at metabase.query_processor.reducible$wire_up_context_channels_BANG_$fn__38257$state_machine__15984__auto____38266.invoke(reducible.clj:18)
at clojure.core.async.impl.ioc_macros$run_state_machine.invokeStatic(ioc_macros.clj:973)
at clojure.core.async.impl.ioc_macros$run_state_machine.invoke(ioc_macros.clj:972)
at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invokeStatic(ioc_macros.clj:977)
at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invoke(ioc_macros.clj:975)
at clojure.core.async$ioc_alts_BANG_$fn__16199.invoke(async.clj:385)
at clojure.core.async$do_alts$fn__16139$fn__16142.invoke(async.clj:254)
at clojure.core.async.impl.channels.ManyToManyChannel$fn__12268.invoke(channels.clj:265)
at clojure.lang.AFn.run(AFn.java:22)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
[d1b19014-7ff9-4ddc-baa1-e0e49d5f464b] 2020-12-01T21:47:36+03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*****·············································] :cry: 10% Table 2,011 ‘dbo.Erp_InventoryCampaignItem’
[d1b19014-7ff9-4ddc-baa1-e0e49d5f464b] 2020-12-01T21:48:43+03:00 ERROR metabase.sync.util Error fingerprinting Table 2,014 ‘dbo.SatinAlmaFaturalariListesi2018’

4

@omerfaruk Check your SQL Server log for any details that could explain why it didn’t succeed after 20 minutes.
And try starting Metabase with debug logging, so it gets more details during the sync process - example:

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