Load Real Time Data - Clarity_Ent - Open Data Load job

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:

(0 users)Average rating

Document information


More support for:

Clarity 7
Clarity Server

Software version:

7.2

Operating system(s):

Windows

Software edition:

Standard

Reference #:

1622586

Modified date:

2013-01-16

Translate my page

Machine Translation

Content navigation