Products
Webtrends Visitor Data Mart
Issue
The wtEtlCredential account is missing or incorrectly configured, causing problems with the lookup table/translation file import process and configured extended attributes databases.
Resolution
If the “wtEtlCredential” SQL Server credential is missing on the EDB (shown below), or the password for the account that is used in the credential has changed. The user will have to update it per the instructions below.
wtEtlCredential shown in SQL Server Management Studio
If the credential is missing, you could add it back via SQL Server Management Studio (shown below):
Or, you could add the credential back via the following SQL Script:
CREATE CREDENTIAL [wtEtlCredential] WITH IDENTITY = N’TheLoaderServiceAccount’, SECRET = N’PasswordForAccount’
GO
If the credential exists, but you are still getting the error you may need to update the password. You can update the password via SQL Server Management Studio.
A couple of other things you may want to validate:
SQL Server Agent must be running on that EDB server.
The following SQL Server Proxy account must exist on that server: ?wtEtl application proxy?
If the proxy account is missing, you?ll have to add it back.
o Using SQL Server Management Studio:
o Via Script:
USE [msdb]
GO
EXEC msdb.dbo.sp_add_proxy @proxy_name=N’wtEtl application proxy’,@credential_name=N’wtEtlCredential’,
@enabled=1,
@description=N’WebTrends ETL execute SSIS package proxy.’
GO
EXEC msdb.dbo.sp_grant_proxy_to_subsystem @proxy_name=N’wtEtl application proxy’, @subsystem_id=11
GO