topic Re: Data Preparation: The CREATE VIEW statement cannot be processed directly by the database. in SAS Visual Analytics

Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

dakes — Tue, 01 May 2018 09:30:28 GMT

Hi,

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?

Thanks,

David

Re: Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

Erik_Zencos — Tue, 01 May 2018 13:41:03 GMT

Hi David,

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).

http://documentation.sas.com/?docsetId=acreldb&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=en

Regards,

Erik

Re: Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

dakes — Tue, 01 May 2018 13:45:49 GMT

Hi Erik,

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.

Regards,

David