I have a situation where my DB contains more than 2100 tables. I import a few of them an when I try to import a couple more Radzen does not "remember" the previously selected although they exist in datasource.json file.
I reduced the number of unused tables to 1330, yet the issue persists.
I include my datasource.json:
{
"info": {
"title": "DB2000TR",
"x-type": "odata",
"x-connector": "mssql",
"x-connector-version": 13
},
"definitions": {
"Symbolaium": {
"x-table": "dbo.symbolaia",
"resource": "Symbolaia",
"required": [
"ArSymb",
"ArAnan",
"Ekdos",
"Enar",
"Eponymo",
"KodPel",
"KodSynerg",
"HmLhx",
"HmIsot",
"Odos",
"Onoma",
"Paketo",
"Parat1",
"Parat2",
"Parat3",
"Parat4",
"Polis",
"Odos1",
"Tk1",
"Polis1",
"Telef1",
"ArAithshs",
"Phmeres",
"Status2",
"Status1",
"Anafora",
"Ypenth",
"AccExecutive",
"KodDiefTrap",
"Eispraktoras",
"Polhths",
"AfmAsf",
"DoyAsf",
"ArDan",
"LogarDan",
"Koxrh",
"EnarSymb",
"Wzonh",
"ArDanAlt",
"WzonhOld",
"Perioysia",
"LipTop",
"DikDan",
"Pagiano",
"Creditcard",
"Fil1",
"KodAkin"
],
"properties": {
"ArSymb": {
"x-nullable": false,
"type": "string",
"length": 8,
"x-key": true,
"x-virtual": true
},
"ArAnan": {
"x-nullable": false,
"type": "string",
"length": 8
},
"AaAnan": {
"type": "number",
"format": "decimal"
},
"Anapr": {
"type": "number",
"format": "decimal"
},
"Dik": {
"type": "number",
"format": "decimal"
},
"Eidan": {
"type": "number",
"format": "decimal"
},
"Ekdos": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Enar": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Epet": {
"type": "number",
"format": "decimal"
},
"Eponymo": {
"x-nullable": false,
"type": "string",
"length": 30
},
"Fke": {
"type": "number",
"format": "decimal"
},
"Fkp": {
"type": "number",
"format": "decimal"
},
"Kefal": {
"type": "number",
"format": "decimal"
},
"Klad": {
"type": "number",
"format": "decimal"
},
"KodPel": {
"x-nullable": false,
"type": "string",
"length": 6
},
"KodSynerg": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Epasfal": {
"type": "number",
"format": "decimal"
},
"HmLhx": {
"x-nullable": false,
"type": "string",
"length": 8
},
"HmIsot": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Nomisma": {
"type": "number",
"format": "decimal"
},
"Odos": {
"x-nullable": false,
"type": "string",
"length": 25
},
"Onoma": {
"x-nullable": false,
"type": "string",
"length": 15
},
"Paketo": {
"x-nullable": false,
"type": "string",
"length": 1
},
"Parat1": {
"x-nullable": false,
"type": "string",
"length": 45
},
"Parat2": {
"x-nullable": false,
"type": "string",
"length": 45
},
"Parat3": {
"x-nullable": false,
"type": "string",
"length": 45
},
"Parat4": {
"x-nullable": false,
"type": "string",
"length": 45
},
"Polis": {
"x-nullable": false,
"type": "string",
"length": 30
},
"Poso": {
"type": "number",
"format": "decimal"
},
"Prokat": {
"type": "number",
"format": "decimal"
},
"Prom": {
"type": "number",
"format": "decimal"
},
"Telef": {
"type": "string",
"length": 21
},
"TrPlhr": {
"type": "number",
"format": "decimal"
},
"TrEisp": {
"type": "number",
"format": "decimal"
},
"TrAnan": {
"type": "number",
"format": "decimal"
},
"Uy": {
"type": "number",
"format": "decimal"
},
"Kath": {
"type": "number",
"format": "decimal"
},
"Mikta": {
"type": "number",
"format": "decimal"
},
"Xmo": {
"type": "number",
"format": "decimal"
},
"Zhmies": {
"type": "number",
"format": "decimal"
},
"Odos1": {
"x-nullable": false,
"type": "string",
"length": 25
},
"Tk1": {
"x-nullable": false,
"type": "string",
"length": 5
},
"Polis1": {
"x-nullable": false,
"type": "string",
"length": 25
},
"Telef1": {
"x-nullable": false,
"type": "string",
"length": 21
},
"TeoAy": {
"type": "number",
"format": "decimal"
},
"KodPak": {
"type": "number",
"format": "decimal"
},
"Katanomh": {
"type": "number",
"format": "decimal"
},
"Cid": {
"type": "integer"
},
"ArAithshs": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Phmeres": {
"x-nullable": false,
"type": "integer",
"format": "int16"
},
"Status2": {
"x-nullable": false,
"type": "string",
"length": 10
},
"Status1": {
"x-nullable": false,
"type": "string",
"length": 1
},
"Anafora": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Ypenth": {
"x-nullable": false,
"type": "string",
"length": 3
},
"KodTrap": {
"type": "number",
"format": "decimal"
},
"KodYpok": {
"type": "number",
"format": "decimal"
},
"AccExecutive": {
"x-nullable": false,
"type": "string",
"length": 6
},
"KodDiefTrap": {
"x-nullable": false,
"type": "string",
"length": 6
},
"Eispraktoras": {
"x-nullable": false,
"type": "string",
"length": 6
},
"Polhths": {
"x-nullable": false,
"type": "string",
"length": 6
},
"TyposSymbol": {
"type": "number",
"format": "decimal"
},
"ProgAsfal": {
"type": "number",
"format": "decimal"
},
"BankSector": {
"type": "number",
"format": "decimal"
},
"AfmAsf": {
"x-nullable": false,
"type": "string",
"length": 10
},
"DoyAsf": {
"x-nullable": false,
"type": "string",
"length": 15
},
"ArDan": {
"x-nullable": false,
"type": "string",
"length": 15
},
"LogarDan": {
"x-nullable": false,
"type": "string",
"length": 25
},
"Koxrh": {
"x-nullable": false,
"type": "string",
"length": 4
},
"EnarSymb": {
"x-nullable": false,
"type": "string",
"length": 8
},
"Tea": {
"type": "number",
"format": "decimal"
},
"PrcTea": {
"type": "number",
"format": "decimal"
},
"ZonhSismu": {
"type": "number",
"format": "decimal"
},
"Wzonh": {
"x-nullable": false,
"type": "string",
"length": 20
},
"MhnasAnapr": {
"type": "number",
"format": "decimal"
},
"EtosAnapr": {
"type": "number",
"format": "decimal"
},
"DeiktMin": {
"type": "string",
"length": 1
},
"ArDanAlt": {
"x-nullable": false,
"type": "string",
"length": 15
},
"DiktXart": {
"type": "number",
"format": "decimal"
},
"KodProduct": {
"type": "number",
"format": "decimal"
},
"ZonhSismuOld": {
"type": "number",
"format": "decimal"
},
"Kindyn": {
"type": "number",
"format": "decimal"
},
"PrOik": {
"type": "number",
"format": "decimal"
},
"Taji": {
"type": "number",
"format": "decimal"
},
"Timol": {
"type": "number",
"format": "decimal"
},
"Xrhsh": {
"type": "number",
"format": "decimal"
},
"KefIdKr": {
"type": "string",
"length": 20
},
"WzonhOld": {
"x-nullable": false,
"type": "string",
"length": 20
},
"Stegi": {
"type": "number",
"format": "decimal"
},
"Perioysia": {
"x-nullable": false,
"type": "string",
"length": 50
},
"Orofi": {
"type": "number",
"format": "decimal"
},
"Ktirio": {
"type": "number",
"format": "decimal"
},
"Periex": {
"type": "number",
"format": "decimal"
},
"Synora": {
"type": "number",
"format": "decimal"
},
"LipTop": {
"x-nullable": false,
"type": "string",
"length": 50
},
"DikDan": {
"x-nullable": false,
"type": "string",
"length": 25
},
"Pagiano": {
"x-nullable": false,
"type": "string",
"length": 14
},
"Creditcard": {
"x-nullable": false,
"type": "string",
"length": 16
},
"Lhxhcard": {
"type": "number",
"format": "decimal"
},
"Tetragonika": {
"type": "number",
"format": "decimal"
},
"Orofos": {
"type": "number",
"format": "decimal"
},
"Etoskatask": {
"type": "number",
"format": "decimal"
},
"Adeiaoik": {
"type": "number",
"format": "decimal"
},
"Eidosoikod": {
"type": "number",
"format": "decimal"
},
"Prostasia": {
"type": "number",
"format": "decimal"
},
"Oikodkal": {
"type": "number",
"format": "decimal"
},
"KefIdKrPr": {
"type": "number",
"format": "decimal"
},
"PrcApokl": {
"type": "number",
"format": "decimal"
},
"Fil1": {
"x-nullable": false,
"type": "string",
"length": 27
},
"Eidoskat": {
"type": "number",
"format": "decimal"
},
"AstEyth": {
"type": "number",
"format": "decimal"
},
"SeismCont": {
"type": "number",
"format": "decimal"
},
"Cvv": {
"type": "string",
"length": 4
},
"KodAkin": {
"x-nullable": false,
"type": "string",
"length": 10
},
"Seismosyn": {
"type": "number",
"format": "decimal"
},
"Klophyn": {
"type": "number",
"format": "decimal"
},
"Oikodkef": {
"type": "number",
"format": "decimal"
},
"Periexkef": {
"type": "number",
"format": "decimal"
},
"Seismoskef": {
"type": "number",
"format": "decimal"
},
"Klophkef": {
"type": "number",
"format": "decimal"
},
"Diktpolisis": {
"type": "integer",
"format": "int16"
},
"HmerEispr": {
"type": "string",
"length": 8
},
"Hmerstatus": {
"type": "string",
"length": 8
},
"ArAithsprpr": {
"type": "string",
"length": 8
},
"DiktAkyrSymb": {
"type": "string",
"length": 1
},
"ArDan2": {
"type": "string",
"length": 15
},
"ArDanAlt2": {
"type": "string",
"length": 15
},
"ArDan3": {
"type": "string",
"length": 15
},
"ArDanAlt3": {
"type": "string",
"length": 15
},
"Diktthesnikh": {
"type": "integer",
"format": "int16"
},
"KodTrap2": {
"type": "number",
"format": "decimal"
},
"KodTrap3": {
"type": "number",
"format": "decimal"
},
"codekaek": {
"type": "string",
"length": 25
},
"PosostSynasfal": {
"type": "number",
"format": "decimal"
},
"Cmpgncd": {
"type": "integer"
},
"PROEL": {
"x-default-sql": "((0))",
"x-nullable": false,
"type": "string",
"length": 1
}
},
"x-view": true
}
},
"paths": {
"/Symbolaia": {
"get": {
"operationId": "getSymbolaia",
"parameters": [
{
"in": "query",
"name": "$filter",
"type": "string"
},
{
"in": "query",
"name": "$top",
"type": "integer"
},
{
"in": "query",
"name": "$skip",
"type": "integer"
},
{
"in": "query",
"name": "$orderby",
"type": "string"
},
{
"in": "query",
"name": "$count",
"type": "boolean"
},
{
"in": "query",
"name": "$expand",
"type": "string"
},
{
"in": "query",
"name": "$format",
"type": "string"
},
{
"in": "query",
"name": "$select",
"type": "string"
}
],
"responses": {
"200": {
"schema": {
"properties": {
"value": {
"items": {
"$ref": "#/definitions/Symbolaium"
},
"type": "array"
}
},
"type": "object"
}
},
"default": {
"schema": {
"$ref": "#/definitions/Error"
}
}
}
}
}
},
"basePath": "/odata/DB2000TR",
"host": "localhost:5000",
"schemes": [
"http"
]
}