Thanks ! Jorge,
Below is how I have tried .It seems issue is with Provider it shows that MDX in error message.
Thanks!
Regards,
Manas Jena
Robotic Process Automation COE
Warsaw, Indiana
574-372-4013(Office)
574-306-8685 (Mobile)
---CONFIDENTIALITY NOTICE---
This communication and any attachements hereto may contain confidential information. Unauthorized use or disclosure to additional parties is prohibited. If you are not an intended recipient, kindly notify the sender and destroy all copies in your possession.
------Original Message------
Try using a calculation stage to set the command text into a data input. Then use the data input as your SQL statement.
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
------------------------------
