VERIFIED SOLUTION i
X

ERROR: ORA-12899: value too large for column in sagent while creating repository.

Issue

Error message returned while importing Sagent repository

[SERVERERROR] Error from Server: ORA-12899: value too large for column "SAGENT"."SARP_STEPPROP_STR"."FRAGMENT" (actual: 256, maximum: 255)

Information from server:
12899
0
orcl11
SA -- 0x1, RW -- 0x5
{sarpcmd.exe - 00000001 - 9/20/2012 18:45:31.457}



Sarputil image whie importing

Cause

Oracle character set for  "Source" and "Destination" database were different.

Example

Oracle character set for export repository server was: WE8MSWIN1252
Oracle character set on import repository server was: AL32UTF8

Resolution

UPDATED: March 27, 2017


From Sagent perspective, there is no fix as this issue is with Oracle server.

Note: Set same oracle character set for oracle server on Development and Production environment.
 

Possible workaround in Sagent

Modifying the repository column definitions.
Follow below steps.
  1. Take backup of  "columns.csv" file from repository location (C:\Program Files\Sagent\Data\rp\core\).
  2. Replace "columns.csv" with attached file.
  3. Recreate repository using sainrp.
  4. Run import using sarputil on new repository.

Environment Details

Sagent (Any version) when repository is on Oracle server.
 

Downloads

  • No Downloads