curved-magazine-23582
02/20/2021, 6:23 AMException while fetching data (/search) : java.lang.RuntimeException: Failed to execute search: entity type DATASET, query demand, filters: [], start: 0, count: 10
curved-magazine-23582
02/20/2021, 6:06 PMbig-carpet-38439
02/20/2021, 6:08 PMbig-carpet-38439
02/20/2021, 6:11 PMcurved-magazine-23582
02/20/2021, 6:17 PMbig-carpet-38439
02/20/2021, 6:43 PMquickstart-react
?big-carpet-38439
02/20/2021, 6:44 PMcurved-magazine-23582
02/21/2021, 4:29 PMcurved-magazine-23582
02/21/2021, 4:34 PM{
"snapshot": {
"urn": "urn:li:dataset:(urn:li:dataPlatform:hive,landing-db.data,DEV)",
"aspects": [
{
"com.linkedin.common.Ownership": {
"owners": [
{
"owner": "urn:li:corpuser:enterprisearchitect",
"type": "DATAOWNER"
}
],
"lastModified": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1608306715000
}
}
},
{
"com.linkedin.dataset.DatasetProperties": {
"description": "Data output from listening to Manufacturing Order events (completed only) and determining the full BOM tree for the material requirements that went into that order.",
"tags": [],
"customProperties": {
"CrawlerSchemaDeserializerVersion": "1.0",
"CrawlerSchemaSerializerVersion": "1.0",
"UPDATED_BY_CRAWLER": "requirements-firehose",
"averageRecordSize": "9",
"classification": "parquet",
"compressionType": "none",
"objectCount": "5532",
"recordCount": "26505986",
"sizeKey": "302519150",
"typeOfData": "file"
}
}
},
{
"com.linkedin.schema.SchemaMetadata": {
"schemaName": "landing-db.data-schema",
"platform": "urn:li:dataPlatform:hive",
"version": 0,
"created": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1608306715000
},
"lastModified": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613693715000
},
"hash": "",
"platformSchema": {
"com.linkedin.schema.KafkaSchema": {
"documentSchema": "{\"type\":\"record\",\"name\":\"landing-db.data-schema\",\"namespace\":\"com.linkedin.dataset\",\"doc\":\"Data output from listening to Manufacturing Order events (completed only) and determining the full BOM tree for the material requirements that went into that order.\",\"fields\":[{\"name\":\"manufacturingstartdate\",\"type\":[\"string\"]},{\"name\":\"component\",\"type\":[\"string\"]},{\"name\":\"componentquantity\",\"type\":[\"double\"]}]}"
}
},
"fields": [
{
"fieldPath": "manufacturingstartdate",
"description": "The date the manufacturing started. This is when the material would have needed to be available.",
"jsonPath": "",
"nullable": false,
"recursive": false,
"nativeDataType": "string",
"type": {
"type": {
"com.linkedin.schema.StringType": {}
}
}
},
{
"fieldPath": "component",
"description": "The part description (including any -.) of the required material.",
"jsonPath": "",
"nullable": false,
"recursive": false,
"nativeDataType": "string",
"type": {
"type": {
"com.linkedin.schema.StringType": {}
}
}
},
{
"fieldPath": "componentquantity",
"description": "How much of the required component was needed to manufacture the finished good (including scrap)",
"jsonPath": "",
"nullable": false,
"recursive": false,
"nativeDataType": "double",
"type": {
"type": {
"com.linkedin.schema.FixedType": {}
}
}
}
]
}
},
{
"com.linkedin.dataset.UpstreamLineage": {
"upstreams": [
{
"dataset": "urn:li:dataset:(urn:li:dataPlatform:mssql,Operations.BillOfMaterial_Base,PROD)",
"type": "TRANSFORMED",
"auditStamp": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613762687145
}
},
{
"dataset": "urn:li:dataset:(urn:li:dataPlatform:mssql,Operations.Components_Base,PROD)",
"type": "TRANSFORMED",
"auditStamp": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613762687145
}
},
{
"dataset": "urn:li:dataset:(urn:li:dataPlatform:mssql,dbo.INV_MATERIAL_BASE,PROD)",
"type": "TRANSFORMED",
"auditStamp": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613762687145
}
},
{
"dataset": "urn:li:dataset:(urn:li:dataPlatform:mssql,dbo.SAMTEC_PART_MASTER_BASE,PROD)",
"type": "TRANSFORMED",
"auditStamp": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613762687145
}
},
{
"dataset": "urn:li:dataset:(urn:li:dataPlatform:mssql,ShopFloorControl.MaterialRequirement_base,PROD)",
"type": "TRANSFORMED",
"auditStamp": {
"actor": "urn:li:corpuser:enterprisearchitect",
"time": 1613762687145
}
}
]
}
}
]
}
}
big-carpet-38439
02/22/2021, 2:33 PMcurved-magazine-23582
02/25/2021, 3:51 AMbig-carpet-38439
02/26/2021, 5:00 PM[{"dataset":"urn:li:dataset:(urn:li:dataPlatform:mssql,Operations.BillOfMaterial_Base,PROD)","type":"TRANSFORMED","auditStamp":{"actor":"urn:li:corpuser:enterprisearchitect","time":1613762687145}},{"dataset":"urn:li:dataset:(urn:li:dataPlatform:mssql,Operations.Components_Base,PROD)","type":"TRANSFORMED","auditStamp":{"actor":"urn:li:corpuser:enterprisearchitect","time":1613762687145}},{"dataset":"urn:li:dataset:(urn:li:dataPlatform:mssql,dbo.INV_MATERIAL_BASE,PROD)","type":"TRANSFORMED","auditStamp":{"actor":"urn:li:corpuser:enterprisearchitect","time":1613762687145}},{"dataset":"urn:li:dataset:(urn:li:dataPlatform:mssql,dbo.SAMTEC_PART_MASTER_BASE,PROD)","type":"TRANSFORMED","auditStamp":{"actor":"urn:li:corpuser:enterprisearchitect","time":1613762687145}},{"dataset":"urn:li:dataset:(urn:li:dataPlatform:mssql,ShopFloorControl.MaterialRequirement_base,PROD)","type":"TRANSFORMED","auditStamp":{"actor":"urn:li:corpuser:enterprisearchitect","time":1613762687145}}]}}]}}
Second, is the dataPlatform "mssql" present in your DataPlatformInfo.json file? https://github.com/linkedin/datahub/blob/master/gms/impl/src/main/resources/DataPlatformInfo.json
If not, please add an entry in your file and re-deploy. In the meantime, I'll create a PR to add it to the default list! We validate against this set of dataPlatforms on read... if it'sbig-carpet-38439
02/26/2021, 5:01 PMcurved-magazine-23582
02/26/2021, 5:57 PM1. Yes, all datasets in upstream lineage are present in DataHub.
2. mssql not in dataplatformInfo.json, although all mssql datasets are loading fine in both UI.
I will try to get latest codes/docker images early next week.big-carpet-38439
02/26/2021, 6:05 PM