AnsweredAssumed Answered

Idea views XOG - Error

Question asked by nmanoha on Oct 3, 2013
Latest reply on Oct 3, 2013 by another_martink
Hi All,

I need to XOG in ‘Idea’ object views from testing environment to Development environment.

I used the ‘List_view_read.xml’ to read from the Test Environment, below is the file.

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="8.0" action="read" objectType="contentPack" externalSource="NIKU">
<!-- the contentType is used to determine which filter goes where -->
<args contentType="job_definition" name="order_by_1" value="code"/>
<args contentType="menu" name="order_by_1" value="code"/>
<args contentType="view" name="order_by_1" value="code"/>
<args contentType="process" name="order_by_1" value="code"/>
<args contentType="object" name="order_by_1" value="code"/>
</Header>
<ViewQuery>
<Filter name="code" criteria="EQUALS">property</Filter>
<Filter name="object_code" criteria="EQUALS">idea</Filter>
</ViewQuery>
</NikuDataBus>

But when I use the output from test environment to XOG in to Development, I got the below error .Idea Create layout is now same as Test, but the idea edit Layout did not come through. Let me know how to proceed.


XOG-3350: Custom view record has not been inserted java.lang.Exception: Invalid expression insertMasterView: com.niku.union.persistence.PersistenceException:
SQL error code: 1400
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

Executed:
INSERT INTO ODF_VIEWS
(id, code, view_type, view_subtype, principal_type, principal_id,
data_service, data_service_type, object_code, caption, sequence,
obs_table_name_key, is_system, partition_code, is_customized,
link_code,
is_secure,
created_date, created_by, last_updated_date, last_updated_by
)
VALUES
(?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?,
?, ?, ?, ?,
?,
?,
?, ?, ?, ?
)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="view/property.xml" id="odf.insertPropertyView" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<errorMapping applicationCode="odf.valueToLarge">
<dbError dbCode="1401" dbVendor="oracle"/>
<dbError dbCode="8152" dbVendor="mssql"/>
</errorMapping>
<sql dbVendor="all">
<text>
INSERT INTO ODF_VIEWS
(id, code, view_type, view_subtype, principal_type, principal_id,
data_service, data_service_type, object_code, caption, sequence,
obs_table_name_key, is_system, partition_code, is_customized,
link_code,
is_secure,
created_date, created_by, last_updated_date, last_updated_by
)
VALUES
(?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?,
?, ?, ?, ?,
?,
?,
?, ?, ?, ?
)
</text>
<param name="ID" direction="IN" expressionListDelimiter="," tableName="ODF_VIEWS" sequenceType="nextValue"/>
<param name="viewName" type="string" direction="IN" expressionListDelimiter=","/>
<param name="type" type="string" direction="IN" expressionListDelimiter=","/>
<param name="view_subtype" type="string" direction="IN" expressionListDelimiter=","/>
<param name="p_type" type="string" direction="IN" expressionListDelimiter=","/>
<param name="p_id" type="int" direction="IN" expressionListDelimiter=","/>
<param name="dataService" type="string" direction="IN" expressionListDelimiter=","/>
<param name="dataServiceType" type="int" direction="IN" expressionListDelimiter=","/>
<param name="objectName" type="string" direction="IN" expressionListDelimiter=","/>
<param name="caption" type="string" direction="IN" expressionListDelimiter=","/>
<param name="sequence" type="int" direction="IN" expressionListDelimiter=","/>
<param name="obsTableNameKey" type="string" direction="IN" expressionListDelimiter=","/>
<param name="is_system" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/>
<param name="partitionCode" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/>
<param name="is_customized" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/>
<param name="linkCode" type="string" direction="IN" expressionListDelimiter=","/>
<param name="is_secure" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
</sql>
<outputMapping rowElementName="view"/>

Outcomes