"ORA-01400" "SBL-DAT-00235" errors while releasing products using Business Service (Doc ID 531959.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2 [19213] to 7.8.2.2 [19219] [Release V7]
Oracle Solaris on SPARC (64-bit)
Database: Oracle 9.2.0.7
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-2804154185. Previously Handled in SR 38-2327888101.

***Checked for relevance on 28-Jul-2014***

Symptoms

From Siebel Application version 7.8, EIM cannot be used to populate the tables S_VOD, S_VOD_VER, S_ISS_OBJ_ATTR as there are no EIM mappings for them.

Initially EIM is used to import simple products, then Business Service Simulator is used to execute the following BS to release products:

Name: ISS Authoring Import Export Service, Method: Post_EIM_Upgrade, Input:
Name: ReportOnly
Value: FALSE

Errors:


Some of the products are not being released. In order to debug, Enable thick client detail tracing when executing BS, there are 2 types of errors. Here are the errors:

1.Product, Name - iModem Craft Terminal, Identifier - 1-JM-3974; Product can not be upgraded; Business Component - Cfg VOD Header (Convert): Field [VOD Type] = Product Definition, Field [VOD Name] = iModem Craft Terminal (1-JM-3974), Field [VOD Key] = 1-JM-3974; [1] An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111); [2] ORA-01400: cannot insert NULL into ("SIEBEL"."S_VOD"."OBJECT_NUM") ; Data will be skipped; Post EAM Upgrade of Product Records:

 

2. Product, Name - BIG IP FRU SMALL FORM FACTOR PLUGABLE FIBER OPTICAL MODULE FOR 1500, 3400, 6400 PLATFORMS, Identifier - 1-JQ-1522; Product can not be upgraded; Business Component - Cfg VOD Header (Convert): Field [VOD Type] = Product Definition, Field [VOD Name] = BIG IP FRU SMALL FORM FACTOR PLUGABLE FIBER OPTICAL MODULE FOR 1500, 3400, 6400 PLATFORMS (1-JQ-1522), Field [VOD Key] = 1-JQ-1522; [1] Value too long for field 'VOD Name' (maximum size 100).(SBL-DAT-00235); Data will be skipped



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms