Stage propagation fails with an invalid cursor
state
|
Technote
(troubleshooting)
Problem(Abstract)
|
You receive error "CLI0115E Invalid cursor state" (similar
to the following one) when stage propagating.
<error> The command failed to propagate the change related to the
STAGLOG record 9906730.
fail to propagate this change (consolidated to STAGLOG record 9906730):
UPDATE table catentrel the record with the following key:
catentry_id_parent=192746, catentry_id_child=192749,
catreltype_id='PRODUCT_ITEM '
<SQLException> [IBM][CLI Driver] CLI0115E Invalid cursor state.
SQLSTATE=24000
|
Cause
|
An invalid cursor state indicates that the record in
question cannot be found. This can occur when one of the unique keys that
is used to index the records has been changed. Although the staging
framework is in place to support changes of this type, it has not been
implemented, and changes involving the unique keys are not supported.
|
Diagnosing the
problem
|
To check if you have run into this situation, run a query
against the staglog table to see if a key change has been made. Below is
an example SQL query with stgrfnbr as referenced in the error above.
Change the stgrfnbr to the one referenced in the error you are
experiencing.
SQL:
select stgokey1, stgokey2, stgokey3, stgokey4, stgokey5, stgnkey1,
stgnkey2, stgnkey3, stgnkey4, stgnkey5 from STAGLOG where
stgrfnbr=9906730
Check the output of this query to ensure that stgokey1=stgnkey1;
stgokey2=stgnkey2; stgokey3=stgnkey3; stgokey4=stgnkey4;
stgokey5=stgnkey5.
If any one of theses values do not match, this indicates that a unique key
change has been made.
|
Resolving the
problem
|
To recover from this error, you can run the following SQL
statement to manually set the staglog to indicate that this record has
been propagated:
SQL:
update staglog set stgprocessed=1 where stgrfnbr=9906730
Then manually make the change in your production database to update the
record. The record exists on staging using the stgnkey indexes and on
production using stgokey.
|
|
|
Cross Reference information
|
Segment
| Product
| Component
| Platform
| Version
| Edition
|
Commerce
| WebSphere Commerce Enterprise
| General
| AIX, Linux, Solaris, Windows
| 6.0, 6.0.0.1
|
|
Commerce
| WebSphere Commerce Business Edition
| General
| AIX, Linux, Solaris, Windows
| 5.6, 5.6.0.1, 5.6.0.2, 5.6.0.3, 5.6.0.4, 5.6.0.5, 5.6.0.6, 5.6.1,
5.6.1.1, 5.6.1.2
|
|
Commerce
| WebSphere Commerce Professional Edition
| General
| AIX, Linux, Solaris, Windows
| 5.6, 5.6.0.1, 5.6.0.2, 5.6.0.3, 5.6.0.4, 5.6.0.5, 5.6.0.6, 5.6.1,
5.6.1.1, 5.6.1.2, 6.0, 6.0.0.1
| |
|
Current web document: http://www.ibm.com/support/docview.wss?uid=swg21255844
|