Clearing 'stuck' data writes in DVUpload Status
Get a list of what is currently outstanding:
select *
from DVENTERPRISE.dbo.StagingRequests
where StatusId < 4
Fail those currently outstanding records
Update DVENTERPRISE.dbo.StagingRequests
Set StatusId = 5
where StatusId < 4
Related Articles
DV Addin - Calling Alt-F9/DVUpload from a macro
Dear Developer Divas, I have a macro. It is a fine and cunning macro. I want to Alt-F9 my Datavision formulas from my macro. I want to DVUpload from my macro. How can I do this? Signed Just Jamming with Jamacros Dear Jamanda, Excellent question! ...
Purging PCI data from Old SMSMkt database
Periodically, Pebble beach will find some PCI data in their Marketing Module. This is the old Marketing Module, so it isn't checking for CC# in all the fields like comment or phone #, etc. So Alan Fujii will send a list of tables with bad values ...
Interface Delphi2008 - How to stop data from being extracted for a property in a multi-properties scenario
Following are the instructions on how to de-activate data extraction for a property. Make a backup of the Access database CountryStateCodeLookUps.mdb and put it into the _Archive folder. Preferred naming convention of backup is ...
BrandKarma/TrustYou interface stuck with error about System.UnauthorizedAccessException
So, your BrandKarma/TrustYou interface is acting up. It's generating a line like the below in it's error log: 20190221 14:05:32 | ExtractDataFromFile: .sftp System.UnauthorizedAccessException: Access to the path ...
Steps to fix stuck writebacks on hosted properties (IHGMIA, IHGORD, AKA, Brasada, Balboa, Geneva)
Restart DVWriteBack Monitor Service - this will be located on each of the properties individual RDP sessions a.