topic RE: SQL Syntax Issue in Product Forum

SQL Syntax Issue

ManasJena — Thu, 27 Feb 2020 22:31:00 GMT

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

RE: SQL Syntax Issue

vivek.kumar.goel — Fri, 28 Feb 2020 05:37:00 GMT

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

RE: SQL Syntax Issue

jorge.barajas — Fri, 28 Feb 2020 15:42:00 GMT

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

RE: SQL Syntax Issue

ManasJena — Fri, 28 Feb 2020 16:13:00 GMT

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#bm278ce7a9-0945-44e1-847f-cdc046806a83

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