My Oracle Support Banner

IP2017: Unable to create Siebel Migration plan due to ORA-12899: value too large for column "SIEBEL"."S_DP_MP_RSRC"."WS_LANG_CD" (actual: 179, maximum:100) (Doc ID 2708770.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

While creating a migration plan for Full Runtime Repository export of Development repository that have 45 languages, it's shown error "Unable to create migration. Please contact System administrator".

The evidence of the issue captured in migration log:

[ERROR] [https-openssl-nio-9100-exec-9] Migration - com.siebel.migration.server.MigrationDataComp:insertMigrationPlan Exception while inserting MigrationPlan java.sql.SQLException: ORA-12899: value too large for column "SIEBEL"."S_DP_MP_RSRC"."WS_LANG_CD" (actual: 179, maximum: 100)

 

Changes

 Install Development environment with 45 languages. In migration.log is shown the deployed languages. For example:

Migration - com.siebel.migration.server.MigrationExecution:GetVersionDetail Plan Id [xxxx] Source WSInfo: {"status":"success","msg":"","data":{"trackingid":"xxx","workspace":{"MAIN":"<version>"},"languages":"GCS,ESS,TWN,ESO,DAN,ESN,HUN,ESM,ESL,PLK,CAN,ESC,CSY,GCA,FIN,IBE,FRN,NOK,GER,HEB,ITA,NLD,FRA,JPN,PTG,SVE,PTB,APC,ENU,ACY,TRK,KRN,DES,AFS,ENG,ETI,ENB,MEA,RUS,ROM,CHN,MNC,DEA,SKY,HRV","defaultworkspacename":{"defaultworkspacename":"MAIN"}}}, Target watermark: SrcWorkspaceName=MAIN;SrcStartVer=100000;SrcTableSchemaVer=1;TgtTableSchemaVer=0;SeedVersion=0;SrcDRStartDate=<date>;TgtWorkspaceId=id;TgtLatestVer=0;Lang=ACY,AFS,APC,CAN,CHN,CSY,DAN,DEA,DES,ENU,ESC,ESL,ESM,ESN,ESO,ENB,ENG,ESS,ETI,FIN,FRA,FRN,GCA,GCS,GER,HEB,HRV,HUN,IBE,ITA,JPN,KRN,MEA,MNC,NLD,NOK,PLK,PTB,PTG,ROM,RUS,SKY,SVE,TRK,TWN;Mode=Migration,Integration Branch name: MAIN

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.