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

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


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:
SA -- 0x1, RW -- 0x5
{sarpcmd.exe - 00000001 - 9/20/2012 18:45:31.457}

Sarputil image whie importing


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


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


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.