Can not create dataset

I have follow the instruction (“Microsoft SQL Server - MindsDB Documentation”) and try to use DB on my local MS SQL server, I can connect to database without any issue(Capture_Create_dataset_1.PNG), but when I try to create dataset, I keep getting error(Capture_Create_dataset_2_error.PNG). Please help me out, thanks first!

1 Like

BTW, when I try to install MS SQL dependency, I got this error, FYI, thanks!

And I copy the detail console error as below, hope it is helpful:

[2021-03-30 11:13:05,759] ERROR in app: Exception on /api/datasources/testsource [PUT]
Traceback (most recent call last):
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\app.py”, line 1950, in full_dispatch_request
rv = self.dispatch_request()
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\app.py”, line 1936, in dispatch_request
return self.view_functionsrule.endpoint
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\api.py”, line 375, in wrapper
resp = resource(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\views.py”, line 89, in view
return self.dispatch_request(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\resource.py”, line 44, in dispatch_request
resp = meth(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\marshalling.py”, line 248, in wrapper
resp = f(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\mindsdb\api\http\namespaces\datasource.py”, line 141, in put
ca.default_store.save_datasource(name, source_type, data)
File “C:\Program Files\MindsDB\python\lib\site-packages\mindsdb\interfaces\datastore\datastore.py”, line 151, in save_datasource
‘class’: dsClass.name,
AttributeError: ‘NoneType’ object has no attribute ‘name
ERROR:mindsdb.api.http.initialize:Exception on /api/datasources/testsource [PUT]
Traceback (most recent call last):
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\app.py”, line 1950, in full_dispatch_request
rv = self.dispatch_request()
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\app.py”, line 1936, in dispatch_request
return self.view_functionsrule.endpoint
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\api.py”, line 375, in wrapper
resp = resource(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask\views.py”, line 89, in view
return self.dispatch_request(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\resource.py”, line 44, in dispatch_request
resp = meth(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\flask_restx\marshalling.py”, line 248, in wrapper
resp = f(*args, **kwargs)
File “C:\Program Files\MindsDB\python\lib\site-packages\mindsdb\api\http\namespaces\datasource.py”, line 141, in put
ca.default_store.save_datasource(name, source_type, data)
File “C:\Program Files\MindsDB\python\lib\site-packages\mindsdb\interfaces\datastore\datastore.py”, line 151, in save_datasource

Thanks for reporting this @toronto899, we will check this and get back to you asap. This was reported few times but with your help, we got the stack trace now :raised_hands:

Hi, Zoran Thank you for looking into this issue and we are looking forward the solution coming soon. Please let us know if you need anything from us can speed up the process. Appreciated providing and sharing this great product!

1 Like

Thanks, @toronto899. So far, the log that you have provided is more then enough. I will ping you if we need more information.

Hi, @Zoran When we are waiting for the fix for MS SQL server, is there any other SQL server maybe we can try to create data set right now? Any suggestion? Thanks first!

1 Like

Hi @toronto899 maybe we can schedule a call where I can help you with the mssql issue first then we can talk about other integrations? Or, you can join our slack channel(mindsdbcommunity.slack.com
) and we can chat. Also, I can provide you some demo environments for different databases so you can test the product.