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 my experience and SQL in hopes of helping others who have to do the same thing.… Read the rest
Continue reading »Tag: Staging Utilities
How to Tell if a Table is a Part of Stagingprop
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 “Is this table a part of stagingprop”.… Read the rest
Continue reading »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.… Read the rest
Continue reading »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 all the unprocessed STAGLOG as a whole.… Read the rest Continue reading »
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 questions of.… Read the rest
Continue reading »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.… Read the rest
Continue reading »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.… Read the rest
Continue reading »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.… Read the rest
Continue reading »Stagingprop – SQL0803 “oops, you inserted data directly on production”
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.
Continue reading »
Stagingprop – the high-level explanation
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.
Continue reading »