Mayankkumar

small XOG write but Big UPDATE found in SQL Trace

Discussion created by Mayankkumar on Aug 21, 2012
Latest reply on Aug 22, 2012 by Dave
Dear all,
I am bit scared when I read the SQLTrace having an update statement resulted from the small XOG write statement:

XOG Write:
--------------

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="8.1.2.4524"/>
<Projects>
<Project financialLocation="australia" financialStatus="O"
name="Managing Creeks and Cattle for Biodiversity at Overton Northern NSW" projectID="GMX-CAG09-00679">
<CustomInformation>
<ColumnValue name="partition_code">grants_partition</ColumnValue>
<ColumnValue name="gm_sect_team">grant_svcs</ColumnValue>
</CustomInformation>
</Project>
</Projects>
</NikuDataBus>

====================================================================================================


The SQL trace is attached. There are multiple UPDATE statements in there and are updating attributes, which were not expected to be updated.

1> Is there any way how can I make XOG write update only those attributes specified in it?
2> Is it ok to run the same XOG in production environment? just to make sure there is no adverse effect.

Please advise.
Thanks
M

Outcomes