My Oracle Support Banner

Unexpected Error Messages SBL-ISS-00121 and SBL-EAI-04376 When Migrating Promotions With Import Export (Doc ID 1134086.1)

Last updated on AUGUST 02, 2018

Applies to:

Siebel eConfigurator - Version 8.0.0.9[20433] to 8.0.0.11[20440] [Release V8]
Siebel eConfigurator - Version 8.0.0.9 SIA[20433] to 8.0.0.11 SIA[20440] [Release V8]
Siebel eConfigurator - Version 8.1.1 [21112] to 8.1.1.4 [21225] [Release V8]
Information in this document applies to any platform.

Symptoms


The following error message is displayed when migrating promotions from source to target environment:

[1] Partial Import: ; [1] Method 'Execute' of business component
'Product Promotions Relationship VBC' (integration component 'Product
Promotions Relationship VBC') returned the following error: "An active
version can not be found; Type ISS_PROD_DEF; Name Price for Life
Unlimited MRC; Time stamp 04/06/2010
12:57:01(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ; [1]
Method 'Execute' of business component 'Product Promotions Relationship
VBC' (integration component 'Product Promotions Relationship VBC')
returned the following error: "An active version can not be found; Type
ISS_PROD_DEF; Name Price for Life Unlimited MRC; Time stamp 04/07/2010
09:01:15(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ; [1]
Method 'Execute' of business component 'Product Promotions Relationship
VBC' (integration component 'Product Promotions Relationship VBC')
returned the following error: "An active version can not be found; Type
ISS_PROD_DEF; Name Price for Life Unlimited MRC; Time stamp 04/07/2010
13:27:48(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped ;


Steps to reproduce it:

1-) Create a Customizable Product with 1 child Product in the source environment

Root Product SF
Child Product SF 1

No Min or Default cardinality defined in the product. Max was set to 999 by default.

2-) Create a Promotion with Root Product SF

Promotion
Root Product (Min =1, Default =1 , Max =1)
Child Product

No promotions constraints or cardinality were set to the child products

3-) Export the promotion export using Full Structure

4-) Import in the target environment and release all objects

5-) In the source environment, add a new child Product to the Root Product

Root Product SF
Child Product SF 1
Child Product SF 2

No Min or Default cardinality defined in the product. Max was set to 999 by default.

6-) Check the Promotion and you will see that the Child Product SF 2 is now part of it.

7-) Re-export the promotion using Objects Only

8-) Import the Promotion in the target

=> We get the following error message:

Import: Partial; ; [1] Method 'Execute' of business component 'Product Promotions Relationship VBC' (integration component 'Product Promotions Relationship VBC') returned the following error:
"An active version can not be found; Type ISS_PROD_DEF; Name Child Product SF 1; Time stamp 04/30/2010 11:47:11(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped

9-) Re-export the Promotion using Full Structure and import in the target environment

=> We get the same error message:

Import: Partial; ; [1] Method 'Execute' of business component 'Product Promotions Relationship VBC' (integration component 'Product Promotions Relationship VBC') returned the following error:
"An active version can not be found; Type ISS_PROD_DEF; Name Child Product SF 2; Time stamp 04/30/2010 11:47:11(SBL-ISS-00121)"(SBL-EAI-04376); Data will be skipped

In version 7.8, the object gets imported as expected with no error messages using the same scenario.

Note: the error message is displayed even after applying the workaround provided on
<Bug 10583814> "Getting the error SBL-EAI-04421, when importing a product promotion from one environment of 8.1.1 to other environment"

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.