Category: Staging Utilities

0

STGMENBR and Stagingprop Failure

This post is specific to WebSphere Commerce. I ran into a new stagingprop failure today(which doesn’t happen all that often anymore), and it taught me something about custom staging triggers, too. What this Error Looks Like Stagingprop fails, and a message such as this this in the stagingprop log. (Tue Oct 02 09:51:44 EDT 2012) The sequence of the following...

0

Stagingprop – Invalid Sequence of Operations

This post is specific to WebSphere Commerce. Stagingprop can fail for a dizzying array of reasons. I’m attempting to document some of them, since there’s no real reference that digs into the details. What This Problem Looks Like The error you get for this one looks like this(table name and values may vary): (Wed Aug 08 14:44:20 CDT 2012) Consolidate...

5

Stagingprop – the basics

I realized today that I haven’t done a post on the basics of stagingprop. All the pieces are there somewhere in the info center, and I love the info center once you’ve got the basics down, but I remember how confusing stagingprop was when I first started out, even though I had a major expert on the topic to ask...

2

Data Movement Options for Commerce Databases – Synchronizing Data Between Commerce Environments

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR. So with 4 environments, they can get out of sync. For the most part, business users are making...

2

Data Movement Options for Commerce Databases – Creation of staging database during build

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR. So with 4 environments, they can get out of sync. For the most part, business users are making...

4

Stagingprop – SQL0803 – a rarer cause

I went through the most common cause of SQL0803 back in a previous post. There’s a rarer cause that can look very similar, and I thought I’d detail it. What this problem looks like: The following appears in the stagingprop log. The location and name of the stagingprop log can vary, but is most frequently on the application server where the stagingprop is run...