SQL Syntax Issue

[ManasJena]

Hi All,

I am trying to use OLE DB and execute below Query. It fails with error  saying " SQL Syntac Error:Error Occurred while executing a MDX statement"

"SELECT * FROM _SYS_BIC.ZB.CROSS- APPLICATION.GLOBAL.DIM/DIM_GB_SOURCE_SYSTEM"

Any suggestion ?


------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------

[VivekGoel]

At the first look, the SQL Syntax doesn't seem to be right. "/" ?
Can you post the exact error ?

------------------------------
Vivek Goel
"If you like this post, please press the "Recommend" Button.
------------------------------

[jorge.barajas]

Hi Manas, 

If you can execute the same select statement directly on a SQL Server query window successfully. It may be that OLE DB doesn't like the way some of those special characters (hyphen, periods, slashes, underscore) are being passed in. Try making a copy of the table for testing purposes and rename it taking out all those characters, then execute your statement from BP adding them back in to the name, one at the time, to see where you get an error. At that point you'll just focus on how to format that character so that OLE DB and Blue Prism can execute it correctly. 

That is an interesting table name though!

Regards,

------------------------------
Jorge Barajas
Blue Prism
Senior Product Consultant
Austin, Texas
------------------------------

[ManasJena]

Hi Jorge,

I can't change the table name the way you suggested. It's a SAP HANA database I am trying to interact and facing this issue.

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=278ce7a9-0945-44e1-847f-cdc046806a83&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer#bm...


------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------