My Oracle Support Banner

ODI Git Versioning Also Stores Scenario Execution Details - Resulting in Too Large Files for Git (Doc ID 2452549.1)

Last updated on FEBRUARY 28, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.3.221018 [Release 12c]
Information in this document applies to any platform.

Symptoms

When using Oracle Data Integrator (ODI) Studio with Git Version Control System (VCS), the resulting XML file for Git versioning of a scenario is very large (over 100 MB) and it includes all the executions for it. In some cases, the file exceeds the file-size limit allowed by Git, therefore, the scenario can no longer be versioned.

NOTE: In the example below any details, ie the port configured, represent a fictitious sample. Any similarity to actual configurations, persons, living or dead, is purely coincidental and not intended in any manner.



Example of an xml from a scenario (encrypted data masked out with italicized xxxxxx's):

<?xml version="1.0" encoding="UTF-8"?>
<SunopsisExport>
<Admin RepositoryVersion="05.02.02.05" IsLegacyIdCompatible="false" />
<Encryption algorithm="AES" keyLength="128" exportKeyHash="" keyVect="xxxxxxxxxxxxxx" exportKeySalt="xxxxxxxxxxxxxxxxxxxxxxxx" containsCipherText="false"/>
<Object class="com.sunopsis.dwg.dbobj.SnpScen">
<Field name="CecSessBehavior" type="java.lang.String"><![CDATA[E]]></Field>
<Field name="CecSessPollIntv" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ExtVersion" type="java.lang.String">null</Field>
<Field name="FirstDate" type="java.sql.Timestamp"><![CDATA[2018-06-05 14:40:26.0]]></Field>
<Field name="FirstUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="GlobalId" type="java.lang.String"><![CDATA[xxxxxxxxxxxxxxxxxxxxxx]]></Field>
<Field name="IndChange" type="java.lang.String"><![CDATA[U]]></Field>
<Field name="IndPromptParam" type="java.lang.String">null</Field>
<Field name="IntVersion" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="IsMaterialized" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="IDeploySpec" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="IMapping" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="IPackage" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IPop" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IScenFolder" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ITrt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ITxtScen" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IVar" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="LastDate" type="java.sql.Timestamp"><![CDATA[2018-06-05 14:41:27.0]]></Field>
<Field name="LastUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="MaxCecSess" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="RepGuid" type="java.lang.String">null</Field>
<Field name="RepVersion" type="java.lang.String">null</Field>
<Field name="RestartType" type="java.lang.String">null</Field>
<Field name="ScenName" type="java.lang.String"><![CDATA[MAP1]]></Field>
<Field name="ScenNo" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="ScenSnapshotNo" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="ScenVersion" type="java.lang.String"><![CDATA[001]]></Field>
<Field name="VLastDate" type="java.sql.Timestamp">null</Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpScenReport">
<Field name="AgentName" type="java.lang.String"><![CDATA[Internal]]></Field>
<Field name="ContextCode" type="java.lang.String"><![CDATA[GLOBAL]]></Field>
<Field name="ErrorMessage" type="java.lang.String">null</Field>
<Field name="GlobalId" type="java.lang.String"><![CDATA[xxxxxxxxxxxxxxxxxxxxxxx]]></Field>
<Field name="ITxtSessMess" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="NbDel" type="com.sunopsis.sql.DbInt"><![CDATA[7]]></Field>
<Field name="NbErr" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="NbIns" type="com.sunopsis.sql.DbInt"><![CDATA[7]]></Field>
<Field name="NbMrg" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="NbRow" type="com.sunopsis.sql.DbInt"><![CDATA[21]]></Field>
<Field name="NbUpd" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="ScenNo" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="ScenRunNo" type="com.sunopsis.sql.DbInt"><![CDATA[4]]></Field>
<Field name="SessBeg" type="java.sql.Timestamp"><![CDATA[2018-06-05 14:41:08.0]]></Field>
<Field name="SessDur" type="com.sunopsis.sql.DbFloat"><![CDATA[0]]></Field>
<Field name="SessEnd" type="java.sql.Timestamp"><![CDATA[2018-06-05 14:41:08.0]]></Field>
<Field name="SessRc" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="SessStatus" type="java.lang.String"><![CDATA[D]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpStepReport">
<Field name="ContextCode" type="java.lang.String">null</Field>
<Field name="ErrorMessage" type="java.lang.String">null</Field>
<Field name="ExecutionOrder" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="FContextCode" type="java.lang.String"><![CDATA[GLOBAL]]></Field>
<Field name="GlobalId" type="java.lang.String"><![CDATA[xxxxxxxxxxxxxxxxxxxxxxxxxxxxx]]></Field>
<Field name="IStep" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ITxtStepMess" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>

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!

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