Syntax error / SSAS

Syntax error / SSAS

Postby jounikn » Wed 30 Oct 2013 11:14

Hi,
I'm trying to create a Cube in SQL Server using devArt connector for PostgreSQL.
Im using SQL Server 2008 R2 x64 and Visual Studio 2008 Business Intelligence Studio and Analysis Service project.

Creating Data Source is ok and connection test is ok. Retrieveing tables works too. But when Analysis Service tries to refresh data by querying it devArt connector fails with error "syntax error at or near "["." This is becasue SSAS is adding brackets to query automatically. I can't modify query as it is dynamically generated by runtime.

This is very likely same problems that has been here on these forums a couple of times before with MySQL:
http://forums.devart.com/viewtopic.php?t=10211
http://forums.devart.com/viewtopic.php?t=18233

I have downloaded both free and trial versions but both have same error. I'm trying to evaluate this connector for our company needs. :?:
jounikn
 
Posts: 2
Joined: Wed 30 Oct 2013 11:07

Re: Syntax error / SSAS

Postby Pinturiccio » Thu 31 Oct 2013 15:36

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

Re: Syntax error / SSAS

Postby jounikn » Mon 04 Nov 2013 05:34

Great, thanx, i'll be waiting :)
jounikn
 
Posts: 2
Joined: Wed 30 Oct 2013 11:07

Re: Syntax error / SSAS

Postby Pinturiccio » Fri 08 Nov 2013 13:51

This is designed behaviour. After installation dotConnect for PostgreSQL you will receive the exception "syntax error at or near "[".". To fix the issue you need to restart the "SQL Server Analysis Services" service. If you have restarted your computer after installing dotConnect for PostgreSQL everything should work.

If the "syntax error at or near "["." exception still occurs after restarting, please make sure that the Devart.Data.PostgreSql.xsl file is present in the following locations:
Program Files\Microsoft SQL Server\%Your SQL Server Instance%\OLAP\bin\Cartridges\
Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge\
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL