DTA Purge and Archive Job Failed

Yes! It does not work "by default" when you install fresh BizTalk Server
How to fix it ?!

Open properties of the job and select Steps

Select Archive and Purge the only step and click Edit
change the parameters of the procedure
@nLiveHours tinyint to 1
@nLiveDays tinyint to 0
@nHardDeleteDays tinyint to 0
@nvcFolder nvarchar(1024) to '\\MyServer\backup'
@nvcValidatingServer sysname to null
@fForceBackup int to 0

the edited command should look like
exec dtasp_BackupAndPurgeTrackingDatabase 1, 0, 1, 'c:\backup', null, 0

save it and try to run job one more time

Comments

Post a Comment

Popular posts from this blog

Testing Azure Functions locally with automated integration test

Image
I am investing more and more time and efforts into building Azure Functions and using serverless instead of WebApps. Greater stability and balancing makes it my first choice when need high quality API. Being big fun of automated testing, faced some issues when coding tests and could not find any useful/working examples. Sources can be found here Some steps here Create function with HTTP trigger using template, dont need anything fancy there. Base it on .Net Core 3.1, you can change it, but then check the path in Test project Create MS Test project Folder structure Project structure Important step, install Azure Function tools from command line, just run npm i -g azure-functions-core-tools after that you can test if it is available from command line The idea is to start functions engine from test project. In local environment you can start it from your command line using Func utility, same can be done from Test project. From command line it will look like this F
Read more

Running Stockfish hosted in Azure function

Image
While working on small chess application had an idea to integrate Stockfish engine, so it will be possible to play with engine. More about Stockfish here : https://stockfishchess.org/ and here https://github.com/mcostalba/Stockfish The idea is to pass FEN and Depth for calculation to some API which will suggest the best move. My main problem is that the goal is to host engine in Azure, as function written in C# while Stockfish is in C++. There are of course some .net ports but really outdated and did not want to experiment with them. First step is just to clone git repo of Stockfish and build exe file, put it into separate folder in my solution. Stockfish is a command line tool. I will send the commands to console and read the output. This is what I will send and get: And in the solution it will look like this: With "No build" and "Copy to output" options The function by itself to get the request is pretty simple: [FunctionName("stockfish")
Read more

Consuming Web API using JavaScript and XMLHttpRequest method

Image
Using JavaScript with remote services by calling REST, JSON, WCF or other web service will decrease data round trips and will allow to create reach web interfaces. For demo I will use Visual Studio 2012 and MVC4. Client call will be hosted in MVC4 page and service will be provided by WebAPI which is also based on MVC4. Lets first see how it works in one server environment, more complex scenario will be in next posts.  Start Visual Studio 2012 and create a web site using  ASP.NET MVC4 Web Application  template.   Then choose  Basic  template without creating test project. Create HomeController and corresponding View which will response to root address I want to skip details about creating controllers and views, you can find a lot of samples and blog posts about it. On next step I will create another controller which will response to JavaScript calls. To create WebAPI page right click on  Controllers  folder and click on  Add / Web API Controller class .
Read more