AnsweredAssumed Answered

error XOG-3350 - ORA-01400: cannot insert NULL into ("***"."ODF_VIEWS".

Question asked by DaniPerez on Feb 28, 2014
Latest reply on Mar 11, 2014 by DaniPerez

I xogged OUT views in "Project Properties-Edit" from an environment and I am trying  to Xog IN previous XML to a different environment. But I am receiveing error 3350 (see at the bottom)

After many test cleaning XML file, I could XOG IN with success a very basic xml containing only section <property>

>>>example of  part of xml xogged IN

<contentPack update="true">
        <views update="true">
            <property code="project.mysubpage" complete="false" componentId="projmgr" isCustomized="true" isSecure="false" isSystem="false" linkCode="project.mysubpage" objectCode="project" partitionCode="NIKU.ROOT" sequence="22" type="update">
                <section currentState="collapsed" sequence="2">
                    <column sequence="1">
                    <viewFieldDescriptor aggregate="false" attributeCode="attribute1"....

<<<

However if I go to "Project Properties - [Layout Edit]" I cannot see these xogged in subpages, I suppose it is due "property set" missing:(

Furthermore always I try to XOG-In section "propertySet" I have the error XOG-3350

>>>>>example of code failing when xog IN

<Header action="write" externalSource="NIKU" objectType="contentPack" version="13.2.0.472"/>
    <contentPack update="true">
        <views update="true">
            <propertySet objectCode="project" partitionCode="NIKU.ROOT">
                <create code="projectCreate"/>
                <update>
                    <view code="project.mysubpage">
                        <nls languageCode="cs" name="attribute1".....

<<<

 

>>>>>Detail of error XOG -3350

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="contentPack"/>
  <Status elapsedTime="1.0 minute 18.923000000000002 seconds" state="FAILURE"/>
  <Statistics failureRecords="1" insertedRecords="6" totalNumberOfRecords="10" updatedRecords="5"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="externalSource">NIKU</column>
        <column name="source"/>
        <column name="code"/>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>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 ("MYCLARITY"."ODF_VIEWS"."CODE")

Executed:
 INSERT INTO ODF_VIEWS
.....

<<<<<<

It is v13.2 and xog v13.2.0.472

What do you think?

Have you deal with same error?

Thanks

Outcomes