Technote (FAQ)
Question
The "Clarity_Ent - Open Data Load" job keeps failing on client Clarity environment.
What could be causing this fail, with the following error message?
-----------------------------------------------------------------------------------------------------------------------
Executed as user: xxxx\claritysvc.
..
..
Description: Executing the query "Truncate Table dbo.tbl_ClarityData_OpenBatchControl " failed with the following error: "Cannot find the object "tbl_ClarityData_OpenBatchControl" because it does not exist or you do not have permissions."
-----------------------------------------------------------------------------------------------------------------------
Cause
It was found that the user account being used to run this job (*in this case, "claritysvc"), did not have the proper back end permissions (SQL) to edit the table mentioned.
Answer
Since the job is being executed as the "claritysvc" user, it needs to be able to edit/write to the "tbl_ClarityData_OpenBatchControl" table.
This error indicates the user account only has read access.
-Test by logging into the database/SQL Server Management Studio with the "claritysvc" account and try to edit this table.
-Ensure that data in the table can be changed and saved.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.