I’m experiencing the following issue with with the database activities, specifically Execute Non Query.
A colleague created this code and it uses the database activities to setup a connection to an excel file and query the excel file as if it were a database. This has worked correctly for a long period of time however it has started throwing errors.
I have the following query in the activity "Update [ALL_GENDER$] set [Disability?] = 'N/A' Where [Disability?] IS NULL"
where All_GENDER is the excel sheet and Disability? is a column heading.
As I said, this has worked without any issues for a long period of time however I’m now getting the following error Query '' is corrupt.
I haven’t used these activities before so any suggestions or help would be greatly appreciated.
kindly run the same code in your database server and check manually once whether this statement is working or not
based on that we can validate where is the issue
we would have connected to a server…na
i hope we can run this sql statement over there
Update [ALL_GENDER$] set [Disability?] = ‘N/A’ Where [Disability?] IS NULL @ConorSmalley
A fix is known and available for MSI office installations however a fix isn’t yet available for C2R installations, the solution for this at the minute is to rollback the patch