VDM SSIS Error – Lookup tables don’t import

Products

Webtrends Visitor Data Mart

Cause

You will see one or more of the following error messages in a VDM profile’s status message during DBSync:

DBSync: WARNING: LaunchSSISPackageAgent Failure: Spawned Process LaunchSSISPackageAgent Exited with a Return Code of 1

DBSync: LaunchSSISPackageAgent: Visitor Data Mart Import failed to execute with a proxy account. Verify the following SQL proxy (SSIS Package Execution): ‘wtEtl application on the Event database server has not been removed’.

This will cause lookup table uploads to not work properly.

Resolution

This is caused by issues with the wtEtl proxy permissions. To fix this, run the following query:
USE[msdb]
GO
EXECmsdb.dbo.sp_add_proxy@proxy_name=N’wtEtl application proxy’,@credential_name=N’wtEtlCredential’,
@enabled=1,
@description=N’WebTrendsETL execute SSIS package proxy.’
GO
EXECmsdb.dbo.sp_grant_proxy_to_subsystem@proxy_name=N’wtEtl application proxy’,@subsystem_id=11
GO