05-01-2018 05:30 AM
I am trying to create a view in data preparation but I am unfortunately greeted by the error in the title. Is there any I can get this to work?
SAS VA is version 7.4, the target database is SQL Server.
The reason I am trying to create a view is because creating a table just leads to VA showing "running" for hours without any results. The source table is 5gb big and consists of 23mio rows, maybe that is too much?
05-01-2018 09:41 AM
It really depends on your hardware, but 23 millions rows (5gb) is not that much. I once loaded a table that was around 115gb (oracle) and it took about 15 minutes (we had decent hardware). Have you tried to load a small table just to check that your server and library definitions is working? I would also take a look at the options in the library statement to see if you can optimize the query a bit. Take a look at the SAS Acess documentation (and google to find more specifc papers).
05-01-2018 09:45 AM
thank you for your reply. I found the problem: I was downloading and uploading to and from the same database server. So even if it had worked I wouldn't have had the data where I wanted it (in the LASR server). I chose the correct library and now everything is working as expected.