add lang repos fails with ORA-01400 and no _INTL table is updated on 8.1.1.8 (Doc ID 1516154.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.8 SIA [23012] and later
Information in this document applies to any platform.
***Checked for relevance on 25-Jul-2014***

Symptoms

On : 8.1.1.8 SIA [23012] version, Installation

When attempting to import lang repository, PTB,
the following error occurs.

ERROR
DBCLog DBCLogError 1 0000000250cc005e:0 2012-12-15 18:06:09 [DataDirect][ODBC 20101 driver][20101]ORA-01400: cannot insert NULL into ("SIEBEL"."S_INST_UPG_HIST"."PRI_LANG_INSTALED")
in the log file
imprep_lang/output//srvrupgwiz1.log 8.1.1.8 [23012] ENU

After this , if going to Tools > Symbolic Strings, there is no data for the new language added

STEPS
The issue can be reproduced at will with the following steps:
1. in a fresh installation, run database wizard configuration choosing add language, PTB
2. finished fine
3. run database configuration choosing importing lang repository, PTB
it fails

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