Fw: SQL Server as Datasource doesnt show tables on click of load tables

[Gladson Vas <gl...@yahoo.com>]

 Hi,
    I followed all the steps in this url http://kylin.apache.org/docs/tutorial/setup_jdbc_datasource.html , but when i click on Load table button or Load table from tree i don't seem to have any tables loaded from the SQL Server data source.There are no errors/exceptions in the logs too.
kylin.properties:
kylin.source.default=8kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=samplekylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverkylin.source.jdbc.dialect=mssqlkylin.source.jdbc.user=userkylin.source.jdbc.pass=passkylin.source.jdbc.sqoop-home=sqoophomekylin.source.jdbc.filed-delimiter=|kylin.source.jdbc.sqoop-mapper-num=4
kylin.log
2019-01-28 22:52:27,948 DEBUG [http-bio-7070-exec-1] common.KylinConfig:328 : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable2019-01-28 22:52:28,017 INFO  [FetcherRunner 992042775-44] threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0 others2019-01-28 22:52:28,123 INFO  [http-bio-7070-exec-4] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.metadata.project.ProjectManager2019-01-28 22:52:28,125 INFO  [http-bio-7070-exec-4] project.ProjectManager:81 : Initializing ProjectManager with metadata url kylin_metadata@hbase2019-01-28 22:52:28,129 DEBUG [http-bio-7070-exec-4] cachesync.CachedCrudAssist:118 : Reloading ProjectInstance from kylin_metadata(key='/project')@kylin_metadata@hbase2019-01-28 22:52:28,188 DEBUG [http-bio-7070-exec-4] cachesync.CachedCrudAssist:127 : Loaded 1 ProjectInstance(s) out of 1 resource2019-01-28 22:52:28,304 DEBUG [http-bio-7070-exec-5] project.ProjectL2Cache:198 : Loading L2 project cache for Testing2019-01-28 22:52:28,325 INFO  [http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.metadata.TableMetadataManager2019-01-28 22:52:28,326 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableDesc from kylin_metadata(key='/table')@kylin_metadata@hbase2019-01-28 22:52:28,333 INFO  [http-bio-7070-exec-1] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.metadata.model.DataModelManager2019-01-28 22:52:28,360 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 TableDesc(s) out of 0 resource2019-01-28 22:52:28,361 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableExtDesc from kylin_metadata(key='/table_exd')@kylin_metadata@hbase2019-01-28 22:52:28,391 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 TableExtDesc(s) out of 0 resource2019-01-28 22:52:28,392 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading ExternalFilterDesc from kylin_metadata(key='/ext_filter')@kylin_metadata@hbase2019-01-28 22:52:28,421 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 ExternalFilterDesc(s) out of 0 resource2019-01-28 22:52:28,423 DEBUG [http-bio-7070-exec-1] cachesync.CachedCrudAssist:118 : Reloading DataModelDesc from kylin_metadata(key='/model_desc')@kylin_metadata@hbase2019-01-28 22:52:28,428 DEBUG [http-bio-7070-exec-1] cachesync.CachedCrudAssist:127 : Loaded 0 DataModelDesc(s) out of 0 resource2019-01-28 22:52:28,434 INFO  [http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.metadata.realization.RealizationRegistry2019-01-28 22:52:28,435 INFO  [http-bio-7070-exec-5] realization.RealizationRegistry:54 : Initializing RealizationRegistry with metadata url kylin_metadata@hbase2019-01-28 22:52:28,455 INFO  [http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.cube.CubeManager2019-01-28 22:52:28,468 INFO  [http-bio-7070-exec-5] cube.CubeManager:133 : Initializing CubeManager with config kylin_metadata@hbase2019-01-28 22:52:28,469 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading CubeInstance from kylin_metadata(key='/cube')@kylin_metadata@hbase2019-01-28 22:52:28,475 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 CubeInstance(s) out of 0 resource2019-01-28 22:52:28,479 INFO  [http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.storage.hybrid.HybridManager2019-01-28 22:52:28,480 INFO  [http-bio-7070-exec-5] hybrid.HybridManager:71 : Initializing HybridManager with config kylin_metadata@hbase2019-01-28 22:52:28,480 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading HybridInstance from kylin_metadata(key='/hybrid')@kylin_metadata@hbase2019-01-28 22:52:28,483 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 HybridInstance(s) out of 0 resource2019-01-28 22:52:28,484 INFO  [http-bio-7070-exec-5] realization.RealizationRegistry:81 : RealizationRegistry is {HYBRID=org.apache.kylin.storage.hybrid.HybridManager@39367d9d, CUBE=org.apache.kylin.cube.CubeManager@1db7a56b}2019-01-28 22:52:47,405 INFO  [http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance of class org.apache.kylin.source.SourceManager2019-01-28 22:52:58,013 INFO  [FetcherRunner 992042775-44] threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0 others2019-01-28 22:53:25,050 INFO  [BadQueryDetector] service.BadQueryDetector:147 : Detect bad query.2019-01-28 22:53:28,013 INFO  [FetcherRunner 992042775-44] threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0 others
Please help,Gladson