Have you ever had to alter foreign keys in a way not supported by mere alteration? Dropping and re-creating all of them can be quite a chore, but a little SQL can make it easier. In this post, I’m sharing…
This post is specific to WebSphere Commerce. One of the most frequent things I do is to look up whether a table is a part of stagingprop. When to Check The most obvious time to check is when someone asks…
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…
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…
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…
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…
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…
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.… Read…
So I plan to go through some of the stagingprop problems I've seen - especially the more common ones. This is probably the most common of all, especially if the java developers you're working with have not used Commerce and particularly stagingprop before.
So every client I support has issues with stagingprop at some point. The vast majority of them are due to mistakes made in the development process. Many developers do not fully understand what stagingprop does, so here's a general description that might help.