SQL Syntax Issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-02-20 10:31 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 05:36 AM
Can you post the exact error ?
------------------------------
Vivek Goel
"If you like this post, please press the "Recommend" Button.
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 01:26 PM
Attached is the exact error.
------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 01:28 PM
------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 01:38 PM
I still see same error after taking out that space you mentioned.
Internal : Could not execute code stage because exception thrown by code stage: sql syntax error: Error occurred while executing a MDX statement. The error message is: Syntax Error : SELECT * FROM _SYS_BIC.ZB.CROSS-<<<
attached is SQL Query image.
------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 01:40 PM
------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 02:00 PM
------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 02:03 PM
------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 02:18 PM
SELECT * FROM "_SYS_BIC"."ZB.CROSS-APPLICATION.GLOBAL.DIM/DIM_GB_SOURCE_SYSTEM"
------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-20 05:37 PM
Also try executing a SELECT statement with another table just so you can get it to work. Sometimes I find that simplifying the issue and approaching it in steps helps.
Example: 1. Get a simple SELECT statement to return data with a small test table with a 1 word name (select * from myTestTable) once you get that to work you have established that you have connectivity, that you are getting data back from the database.
2. Rename that test table using some of the characters of the real table name until you can identify the one that is causing your issue
3. Format your statement so the select statement can be addressed with the real name but is formatted in the way OLE DB and BP accept the statement.
I hope this troubleshooting helps. If you can't rename the original table, make a test table with simple test data that you can modify and test with.
Regards
------------------------------
Jorge Barajas
Blue Prism
Senior Product Consultant
Austin, Texas
------------------------------
