openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prabhat Sharma2 <prabhatsha...@in.ibm.com>
Subject Re: Critical issue (Blocker): missing fields in update statement
Date Thu, 08 Mar 2012 12:13:29 GMT

Many Thanks for helping me.

But when I remove or make  "unsupported", i get the below error:

====================================================
62  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting OpenJPA
1.2.2
187  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
Mar 8, 2012 6:58:49 AM com.ibm.ws.util.ImplFactory
WARNING: WSVR0073W
9484  RDCBusinessComponent  WARN   [P=928671:O=0:CT] openjpa.Enhance - This
configuration disallows runtime optimization, but the following listed
types were not enhanced at build time or at class load time with a
javaagent: "[........class com.ibm.rdc.business.sapr3.TpakdPK,class
com.ibm.rdc.business.sapr3.Knvv,class
com.ibm.rdc.business.sapr3.KnvvPK,........... ]".
<openjpa-1.2.2-r422266:898935 fatal user error>
org.apache.openjpa.persistence.ArgumentException: The type "class
com.ibm.rdc.business.sapr3.KnvvPK" has not been enhanced.
====================================================

And when I Enhance at compile using "Add/Remove Bytecode Enhancer" (on
RSA8.0.3 (using OpenJPA plugin)  then all "@Transient" variables comes in
entity SQLs. Below is the error:
====================================================

62  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting OpenJPA
1.2.2
156  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
Mar 8, 2012 7:10:23 AM com.ibm.ws.util.ImplFactory
WARNING: WSVR0073W
8828  RDCBusinessComponent  TRACE  [P=622625:O=0:CT] openjpa.jdbc.SQL - <t
1181369962, conn 1349406830> executing prepstmnt 1665033022 SELECT
t0.allowDelete, t0.allowInsert, t0.allowUpdate, t0.antlf, t0.aufsd,
t0.autlf, t0.awahr, t0.begru, t0.boidt, t0.bokre, t0.bzirk, t0.chspl,
t0.eikto, t0.erdat, t0.ernam, t0.faksd, t0.fpart, t0.kunnr, t0.mandt,
t0.spart, t0.vkorg, t0.vtweg, t0.inco1, t0.inco2, t0.kalks, t0.kdgrp,
t0.klabc, t0.konda, t0.kotkd, t0.ktgrd, t0.ktokd, t0.kurst, t0.kvakz,
t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3, t0.kvgr4, t0.kvgr5, t0.kzazu,
t0.kztlf, t0.lifsd, t0.loevm, t0.lprio, t0.mrnkz, t0.OLDKNVV_KUNNR,
t0.OLDKNVV_MANDT, t0.OLDKNVV_SPART, t0.OLDKNVV_VKORG, t0.OLDKNVV_VTWEG,
t0.perfk, t0.perrl, t0.pltyp, t0.prat1, t0.prat2, t0.prat3, t0.prat4,
t0.prat5, t0.prat6, t0.prat7, t0.prat8, t0.prat9, t0.prata, t0.prfre,
t0.SAP_TS, t0.SHAD_UPDATE_IND, t0.SHAD_UPDATE_TS, t0.waers, t0.vkbur,
t0.vwerk, t0.versg, t0.vkgrp, t0.vsbed, t0.vsort, t0.zterm FROM SAPR3.KNVV
t0 WHERE t0.kunnr = ? AND t0.mandt = ? AND t0.spart = ? AND t0.vkorg = ?
AND t0.vtweg = ?  optimize for 1 row [params=(String) 0060718462, (String)
030, (String) 00, (String) 0147, (String) C]
10687  RDCBusinessComponent  TRACE  [P=622625:O=0:CT] openjpa.jdbc.SQL - <t
1181369962, conn 1349406830> [1859 ms] spent
<openjpa-1.2.2-r422266:898935 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: T0.ALLOWDELETE IS NOT
VALID IN THE CONTEXT WHERE IT IS USED. SQLCODE=-206, SQLSTATE=42703,
DRIVER=3.58.81 {prepstmnt 1665033022 SELECT t0.allowDelete, t0.allowInsert,
t0.allowUpdate, t0.antlf, t0.aufsd, t0.autlf, t0.awahr, t0.begru, t0.boidt,
t0.bokre, t0.bzirk, t0.chspl, t0.eikto, t0.erdat, t0.ernam, t0.faksd,
t0.fpart, t0.kunnr, t0.mandt, t0.spart, t0.vkorg, t0.vtweg, t0.inco1,
t0.inco2, t0.kalks, t0.kdgrp, t0.klabc, t0.konda, t0.kotkd, t0.ktgrd,
t0.ktokd, t0.kurst, t0.kvakz, t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3,
t0.kvgr4, t0.kvgr5, t0.kzazu, t0.kztlf, t0.lifsd, t0.loevm, t0.lprio,
t0.mrnkz, t0.OLDKNVV_KUNNR, t0.OLDKNVV_MANDT, t0.OLDKNVV_SPART,
t0.OLDKNVV_VKORG, t0.OLDKNVV_VTWEG, t0.perfk, t0.perrl, t0.pltyp, t0.prat1,
t0.prat2, t0.prat3, t0.prat4, t0.prat5, t0.prat6, t0.prat7, t0.prat8,
t0.prat9, t0.prata, t0.prfre, t0.SAP_TS, t0.SHAD_UPDATE_IND,
t0.SHAD_UPDATE_TS, t0.waers, t0.vkbur, t0.vwerk, t0.versg, t0.vkgrp,
t0.vsbed, t0.vsort, t0.zterm FROM SAPR3.KNVV t0 WHERE t0.kunnr = ? AND
t0.mandt = ? AND t0.spart = ? AND t0.vkorg = ? AND t0.vtweg = ?  optimize
for 1 row [params=(String) 0060718462, (String) 030, (String) 00, (String)
0147, (String) C]} [code=-206, state=42703]SQLCA OUTPUT[Errp=DSNXORSO,
Errd=-600, 0, 0, -1, 0, 0]

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



Thanks & Regards,
Prabhat Sharma




From:	Kevin Sutter <kwsutter@gmail.com>
To:	dev@openjpa.apache.org
Date:	03/07/2012 06:21 PM
Subject:	Re: Critical issue (Blocker): missing fields in update
            statement



Who told you to use this property?

<property name="openjpa.RuntimeUnenhancedClasses" value="supported"/>

This is bad, very bad...  Subclassing support is not ready for primetime.
There is a reason why this is deliberately turned off both...

Kevin

On Wed, Mar 7, 2012 at 4:50 PM, Prabhat Sharma2
<prabhatsharma@in.ibm.com>wrote:

> Hi Kevin,
>
> Yes, we have so many fields in the table and relationships. This is on an
> old legacy SAP model. Our system was build on Versata and now migrating
on
> OpenJPA and Struts. We can not modify the schema/table.
>
>
> I am getting the same error even after removing  EM.merge() from
> entiryManager method updateKnvv:
> ===============================================================
> @Action(Action.ACTION_TYPE.UPDATE)
>        public String updateKnvv(Knvv knvv) throws Exception,RDCException
{
>                 EntityManager em = getEntityManager();
>                try {
>                        em.getTransaction().begin();
>                         Knvv o = em.find(Knvv.class, knvv.getId());
>
>                        o.setLoevm(knvv.getLoevm());
>                        em.getTransaction().commit();
>                        //em.flush();
>                        //em.getTransaction().commit();
>                } catch(RDCException rde){
>                        throw new RDCException(rde.getMessage());
>                 }
>                catch (Exception ex) {
>                        try {
>                                if (em.getTransaction().isActive()) {
>                                        em.getTransaction().rollback();
>                                }
>                        } catch (Exception e) {
>                                ex.printStackTrace();
>                                throw e;
>                        }
>                        throw ex;
>                } finally {
>                         //em.close();
>                }
>                return "";
>        }
> ===============================================================
>
> My persistence.xml has all the entites. here is the sample:
> ===============================================================
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=
> "http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>
>
>        <persistence-unit name="RDCBusinessComponent">
>
>                <jta-data-source>jdbc/EUSHDB2C</jta-data-source>
>                <class>com.ibm.rdc.business.sapr3.Knvv</class>
>                <class>com.ibm.rdc.business.sapr3.KnvpPK</class>
>                <class>com.ibm.rdc.business.sapr3.Kna1PK</class>
>                <class>com.ibm.rdc.business.sapr3.Kna1</class>
> ..
> ..
> ..
> ..
>                <jta-data-source>jdbc/RDCDB2</jta-data-source>
>                <properties>
>
>                        <!-- property name="openjpa.jdbc.EagerFetchMode"
>
value="none"/-->
>                        <property name="openjpa.jdbc.Schema"
value="SAPR3"/>
>                        <property name="openjpa.jdbc.TransactionIsolation"
> value=
> "read-uncommitted"/>
>                        <property name="openjpa.ManagedRuntime"
value="jndi
> (TransactionManagerName=java:appserver/TransactionManager)"/>
>                        <property name="openjpa.ConnectionFactoryMode"
> value=
> "managed"/>
>                        <property name="openjpa.ConnectionRetainMode"
value=
> "always"/>
>                        <property name="openjpa.RuntimeUnenhancedClasses"
> value=
> "supported"/>
>                        <property name="openjpa.jdbc.EagerFetchMode"
> value="join"
> />
>
>                        <!--  When needs to run on local -->
>                        <property name="openjpa.Log" value="SQL=TRACE"/>
>                        <property name="openjpa.ConnectionDriverName"
value=
> "com.ibm.db2.jcc.DB2Driver"/>
>                        <property name="openjpa.ConnectionURL" value=XXXXX
>                        <property name="openjpa.ConnectionUserName"
> value="XXXX"
> />
>                        <property name="openjpa.ConnectionPassword"
> value="XXXX"
> />
>                        <!--   END  -->
>
>                </properties>
>        </persistence-unit>
>
> </persistence>
>
>
> ===============================================================
>
> I enabled the trace, here is the output of the trace:
>
> ====================================================================
> 47  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting
OpenJPA
> 1.2.2
> 141  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
> dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
> Mar 7, 2012 2:13:41 PM com.ibm.ws.util.ImplFactory
> WARNING: WSVR0073W
>
> 3454  RDCBusinessComponent  INFO   [P=621171:O=0:CT] openjpa.Enhance -
> Creating subclass for "[class com.ibm.rdc.business.sapr3.TpakdPK, class
> com.ibm.rdc.business.sapr3.IknviPK, class
> com.ibm.rdc.business.sapr3.Tvv4PK, class
> com.ibm.rdc.business.sapr3.CountyRegion, class
> com.ibm.rdc.business.sapr3.Rkna1PK, class
> com.ibm.rdc.business.sapr3.TvsbPK, class
> com.ibm.rdc.business.sapr3.TvkbtPK, class
> com.ibm.rdc.business.sapr3.Tvk0tPK, class
> com.ibm.rdc.business.sapr3.GcsFinoblInput, class
> com.ibm.rdc.business.sapr3.LegxrefPK, class
> com.ibm.rdc.business.sapr3.TerritoryPK, class
> com.ibm.rdc.business.sapr3.TzontPK, class
com.ibm.rdc.business.sapr3.Rknbk,
> class com.ibm.rdc.business.sapr3.ShipMethPK, class
> com.ibm.rdc.business.sapr3.DstXrefPK, class
> com.ibm.rdc.business.sapr3.TtxitPK, class
> com.ibm.rdc.business.sapr3.ZkvindtPK, class
> com.ibm.rdc.business.sapr3.JobMsgPK, class
> com.ibm.rdc.business.sapr3.Tvk8tPK, class
> com.ibm.rdc.business.sapr3.SdOrgtempPK, class
> com.ibm.rdc.business.sapr3.Tprit, class
> com.ibm.rdc.business.sapr3.InacxrefPK, class
> com.ibm.rdc.business.sapr3.SdValidTaxcd, class
> com.ibm.rdc.business.sapr3.AvoidtagPK, class
> com.ibm.rdc.business.sapr3.ImetatablePK, class
> com.ibm.rdc.business.sapr3.RknvlPK, class
com.ibm.rdc.business.sapr3.Tprio,
> class com.ibm.rdc.business.sapr3.DpartnerPK, class
> com.ibm.rdc.business.sapr3.ConditionPK, class
> com.ibm.rdc.business.sapr3.TerritoryLog, class
> com.ibm.rdc.business.sapr3.Guictinpctl, class
> com.ibm.rdc.business.sapr3.Tvkwz, class com.ibm.rdc.business.sapr3.Tvk9t,
> class com.ibm.rdc.business.sapr3.CtReqStatus, class
> com.ibm.rdc.business.sapr3.CountyRegionPK, class
> com.ibm.rdc.business.sapr3.Istxhl, class com.ibm.rdc.business.sapr3.Tspa,
> class com.ibm.rdc.business.sapr3.RknvvPK, class
> com.ibm.rdc.business.sapr3.Bisadr, class
> com.ibm.rdc.business.sapr3.TkuktAwfFilterPK, class
> com.ibm.rdc.business.sapr3.T009tPK, class
> com.ibm.rdc.business.sapr3.T042zPK, class
> com.ibm.rdc.business.sapr3.ExtractmsgPK, class
> com.ibm.rdc.business.sapr3.CtEmeaIsuconv, class
> com.ibm.rdc.business.sapr3.T188PK, class
> com.ibm.rdc.business.sapr3.Zkvindt, class
> com.ibm.rdc.business.sapr3.Tvk8PK, class
com.ibm.rdc.business.sapr3.TparPK,
> class com.ibm.rdc.business.sapr3.T151PK, class
> com.ibm.rdc.business.sapr3.T014PK, class
> com.ibm.rdc.business.sapr3.JobControl, class
> com.ibm.rdc.business.sapr3.ClusterLog, class
> com.ibm.rdc.business.sapr3.Tskdt, class
com.ibm.rdc.business.sapr3.KnvkPK,
> class com.ibm.rdc.business.sapr3.Tvf, class
> com.ibm.rdc.business.sapr3.RknvpPK, class
> com.ibm.rdc.business.sapr3.Tvk3tPK, class
> com.ibm.rdc.business.sapr3.NutmegCollt, class
> com.ibm.rdc.business.sapr3.Tvast, class
> com.ibm.rdc.business.sapr3.ClientDun, class
> com.ibm.rdc.business.sapr3.TtxidPK, class
> com.ibm.rdc.business.sapr3.Condition, class
> com.ibm.rdc.business.sapr3.KnviPK, class
> com.ibm.rdc.business.sapr3.Tvk4tPK, class
com.ibm.rdc.business.sapr3.Rsadr,
> class com.ibm.rdc.business.sapr3.TkuktAwfFilter, class
> com.ibm.rdc.business.sapr3.T685, class com.ibm.rdc.business.sapr3.Tpart,
> class com.ibm.rdc.business.sapr3.T683, class
> com.ibm.rdc.business.sapr3.Tvl, class com.ibm.rdc.business.sapr3.Tvv5PK,
> class com.ibm.rdc.business.sapr3.PoolLogPK, class
> com.ibm.rdc.business.sapr3.Tvv3PK, class
> com.ibm.rdc.business.sapr3.IknexPK, class
com.ibm.rdc.business.sapr3.T009t,
> class com.ibm.rdc.business.sapr3.DpredPK, class
> com.ibm.rdc.business.sapr3.Tvmst, class
com.ibm.rdc.business.sapr3.BnkaPK,
> class com.ibm.rdc.business.sapr3.T005PK, class
> com.ibm.rdc.business.sapr3.CoverageId, class
> com.ibm.rdc.business.sapr3.TvkwzPK, class
> com.ibm.rdc.business.sapr3.RknviPK, class
> com.ibm.rdc.business.sapr3.Kna1PK, class
> com.ibm.rdc.business.rdaccess.UserHasRolePK, class
> com.ibm.rdc.business.sapr3.RegionPK, class
> com.ibm.rdc.business.sapr3.Sizeinfo, class
> com.ibm.rdc.business.sapr3.LogChgCode, class
> com.ibm.rdc.business.sapr3.Tvk7t, class
> com.ibm.rdc.business.sapr3.ZkvinactPK, class
> com.ibm.rdc.business.sapr3.Tpfkt, class com.ibm.rdc.business.sapr3.Tsad3,
> class com.ibm.rdc.business.sapr3.Iknvi, class
> com.ibm.rdc.business.sapr3.Tsabt, class
com.ibm.rdc.business.sapr3.Tvk6tPK,
> class com.ibm.rdc.business.sapr3.PendAaRuleset, class
> com.ibm.rdc.business.sapr3.Iknvl, class
com.ibm.rdc.business.sapr3.TincPK,
> class com.ibm.rdc.business.sapr3.T005tPK, class
> com.ibm.rdc.business.sapr3.Iknvk, class com.ibm.rdc.business.sapr3.Iknva,
> class com.ibm.rdc.business.sapr3.KnexPK, class
> com.ibm.rdc.business.sapr3.KnvaPK, class com.ibm.rdc.business.sapr3.Pool,
> class com.ibm.rdc.business.sapr3.Loadfilestatus, class
> com.ibm.rdc.business.sapr3.Cmrstatus, class
> com.ibm.rdc.business.sapr3.Iknvd, class
com.ibm.rdc.business.sapr3.BknvpPK,
> class com.ibm.rdc.business.sapr3.RsegPK, class
> com.ibm.rdc.business.sapr3.Tvbur, class
> com.ibm.rdc.business.sapr3.CdGcsFinoblHier, class
> com.ibm.rdc.business.sapr3.Avoidtag, class
> com.ibm.rdc.business.sapr3.Tvv5tPK, class
com.ibm.rdc.business.sapr3.Tvk8t,
> class com.ibm.rdc.business.sapr3.SadrPK, class
> com.ibm.rdc.business.sapr3.Iknvp, class com.ibm.rdc.business.sapr3.Iknvv,
> class com.ibm.rdc.business.sapr3.Kna1, class
> com.ibm.rdc.business.sapr3.Tbrc, class
com.ibm.rdc.business.sapr3.Pkna1PK,
> class com.ibm.rdc.business.sapr3.Bknva, class
> com.ibm.rdc.business.sapr3.Upload, class
com.ibm.rdc.business.sapr3.Bknvd,
> class com.ibm.rdc.business.sapr3.Tstl, class
> com.ibm.rdc.business.sapr3.T685aPK, class
> com.ibm.rdc.business.sapr3.FsExtractReqPK, class
> com.ibm.rdc.business.sapr3.Rknb1, class
> com.ibm.rdc.business.sapr3.Icommidoc, class
> com.ibm.rdc.business.sapr3.T685a, class
com.ibm.rdc.business.sapr3.T001PK,
> class com.ibm.rdc.business.sapr3.Iseg, class
> com.ibm.rdc.business.sapr3.Tvk5t, class
com.ibm.rdc.business.sapr3.TcurfPK,
> class com.ibm.rdc.business.sapr3.SectorIsuPK, class
> com.ibm.rdc.business.sapr3.EmeaLo, class
com.ibm.rdc.business.sapr3.Isadr,
> class com.ibm.rdc.business.sapr3.Chghistory, class
> com.ibm.rdc.business.sapr3.KnbkPK, class
> com.ibm.rdc.business.sapr3.Tvk2tPK, class
> com.ibm.rdc.business.sapr3.TviptPK, class
> com.ibm.rdc.business.rdaccess.User, class
> com.ibm.rdc.business.sapr3.Tvk1PK, class
com.ibm.rdc.business.sapr3.Tvk0PK,
> class com.ibm.rdc.business.sapr3.Loadstatus, class
> com.ibm.rdc.business.sapr3.Kna1extLog, class
> com.ibm.rdc.business.sapr3.Dfilter, class
com.ibm.rdc.business.sapr3.Rkna1,
> class com.ibm.rdc.business.sapr3.BknvkPK, class
> com.ibm.rdc.business.sapr3.Kna1ext, class
> com.ibm.rdc.business.sapr3.AutodelExPK, class
> com.ibm.rdc.business.sapr3.BknvlPK, class
com.ibm.rdc.business.sapr3.Tvk6t,
> class com.ibm.rdc.business.rdaccess.UserHasRole, class
> com.ibm.rdc.business.sapr3.FsCriteria, class
> com.ibm.rdc.business.sapr3.Region, class
> com.ibm.rdc.business.sapr3.Coverage, class
> com.ibm.rdc.business.sapr3.Tvp6PK, class
com.ibm.rdc.business.sapr3.Tvv2PK,
> class com.ibm.rdc.business.sapr3.BisadrPK, class
> com.ibm.rdc.business.sapr3.Tvkbz, class
> com.ibm.rdc.business.sapr3.CviCovAssign, class
> com.ibm.rdc.business.sapr3.BknexPK, class
com.ibm.rdc.business.sapr3.T005p,
> class com.ibm.rdc.business.sapr3.CtBatchStatus, class
> com.ibm.rdc.business.sapr3.TprioPK, class
> com.ibm.rdc.business.sapr3.TpaumPK, class
com.ibm.rdc.business.sapr3.Tpakd,
> class com.ibm.rdc.business.sapr3.Kna1extPK, class
> com.ibm.rdc.business.sapr3.TtxerPK, class
com.ibm.rdc.business.sapr3.T005t,
> class com.ibm.rdc.business.sapr3.CopycfgPK, class
> com.ibm.rdc.business.sapr3.T005u, class com.ibm.rdc.business.sapr3.T005f,
> class com.ibm.rdc.business.sapr3.EmeaLoPK, class
> com.ibm.rdc.business.sapr3.Tvkbt, class
com.ibm.rdc.business.sapr3.TvkotPK,
> class com.ibm.rdc.business.sapr3.Distnr, class
> com.ibm.rdc.business.sapr3.Knvv, class
com.ibm.rdc.business.sapr3.BknvaPK,
> class com.ibm.rdc.business.sapr3.Zkvinacn, class
> com.ibm.rdc.business.sapr3.Bknex, class com.ibm.rdc.business.sapr3.Knvp,
> class com.ibm.rdc.business.sapr3.Zkvinact, class
> com.ibm.rdc.business.sapr3.CtPriority, class
> com.ibm.rdc.business.sapr3.Pkna1, class com.ibm.rdc.business.sapr3.Knvh,
> class com.ibm.rdc.business.sapr3.Tvsdt, class
> com.ibm.rdc.business.sapr3.Knvi, class
> com.ibm.rdc.business.sapr3.Changelog, class
> com.ibm.rdc.business.sapr3.Knvk, class com.ibm.rdc.business.sapr3.Knvl,
> class com.ibm.rdc.business.sapr3.DispatchTime, class
> com.ibm.rdc.business.sapr3.IntAccountPK, class
> com.ibm.rdc.business.sapr3.VSiteKnvv, class
> com.ibm.rdc.business.sapr3.Knva, class
> com.ibm.rdc.business.sapr3.FsExtractReq, class
> com.ibm.rdc.business.sapr3.Knvd, class
com.ibm.rdc.business.sapr3.BknbkPK,
> class com.ibm.rdc.business.sapr3.GmeDunPK, class
> com.ibm.rdc.business.sapr3.Skb1PK, class
> com.ibm.rdc.business.sapr3.Checkbox, class
> com.ibm.rdc.business.sapr3.CustreqPK, class
> com.ibm.rdc.business.sapr3.CtBatchStatusPK, class
> com.ibm.rdc.business.sapr3.Bkna1PK, class
> com.ibm.rdc.business.sapr3.TryForFitRslt, class
> com.ibm.rdc.business.sapr3.CoveragePK, class
> com.ibm.rdc.business.sapr3.Tsad3tSadr, class
> com.ibm.rdc.business.sapr3.IsadrPK, class
> com.ibm.rdc.business.sapr3.Territory, class
> com.ibm.rdc.business.sapr3.KsskPK, class
> com.ibm.rdc.business.rdaccess.UserPropertyVal, class
> com.ibm.rdc.business.sapr3.Tvkdt, class
> com.ibm.rdc.business.sapr3.Tsad3tPK, class
> com.ibm.rdc.business.sapr3.ZzkvSic, class
> com.ibm.rdc.business.sapr3.TvsdtPK, class
> com.ibm.rdc.business.sapr3.Tvk6PK, class
com.ibm.rdc.business.sapr3.T683PK,
> class com.ibm.rdc.business.sapr3.T052uAwfFilter, class
> com.ibm.rdc.business.sapr3.Tvsbt, class com.ibm.rdc.business.sapr3.Geo,
> class com.ibm.rdc.business.sapr3.SubBranchPK, class
> com.ibm.rdc.business.sapr3.TzonePK, class
> com.ibm.rdc.business.sapr3.Land1MappingPK, class
> com.ibm.rdc.business.sapr3.Tvfst, class
com.ibm.rdc.business.sapr3.T685PK,
> class com.ibm.rdc.business.sapr3.Ilrruleset, class
> com.ibm.rdc.business.sapr3.BknviPK, class
> com.ibm.rdc.business.sapr3.CtT005extPK, class
> com.ibm.rdc.business.sapr3.CoverageLstRunTimestampTmpPK, class
> com.ibm.rdc.business.sapr3.TvfPK, class
> com.ibm.rdc.business.sapr3.FsCriteriaPK, class
> com.ibm.rdc.business.sapr3.RknvkPK, class
com.ibm.rdc.business.sapr3.Rseg,
> class com.ibm.rdc.business.sapr3.StxhPK, class
> com.ibm.rdc.business.sapr3.JobMsg, class
com.ibm.rdc.business.sapr3.RulePK,
> class com.ibm.rdc.business.sapr3.IntAccount, class
> com.ibm.rdc.business.sapr3.Sadr, class
com.ibm.rdc.business.sapr3.TvkbzPK,
> class com.ibm.rdc.business.sapr3.Tbrct, class
> com.ibm.rdc.business.sapr3.Ttxid, class
> com.ibm.rdc.business.sapr3.TaguserPK, class
> com.ibm.rdc.business.sapr3.Tinct, class
com.ibm.rdc.business.sapr3.TvgfPK,
> class com.ibm.rdc.business.sapr3.Tvk7tPK, class
> com.ibm.rdc.business.sapr3.T052uAwfFilterPK, class
> com.ibm.rdc.business.sapr3.Host, class
> com.ibm.rdc.business.sapr3.BknvkSadr, class
> com.ibm.rdc.business.sapr3.Cluster, class
> com.ibm.rdc.business.sapr3.CtLaRegion, class
> com.ibm.rdc.business.sapr3.T001wPK, class
> com.ibm.rdc.business.sapr3.HierarchyLinksExPK, class
> com.ibm.rdc.business.sapr3.Ixftest, class
> com.ibm.rdc.business.sapr3.Knb1PK, class com.ibm.rdc.business.sapr3.Tinc,
> class com.ibm.rdc.business.sapr3.Ttxit, class
> com.ibm.rdc.business.sapr3.T001w, class
com.ibm.rdc.business.sapr3.GmeDun,
> class com.ibm.rdc.business.sapr3.NutmegColltPK, class
> com.ibm.rdc.business.sapr3.T016t, class
> com.ibm.rdc.business.sapr3.CountryRegion, class
> com.ibm.rdc.business.sapr3.TransMedium, class
> com.ibm.rdc.business.sapr3.Ttxer, class com.ibm.rdc.business.sapr3.JobPK,
> class com.ibm.rdc.business.sapr3.IcommaudPK, class
> com.ibm.rdc.business.sapr3.Rknvv, class
com.ibm.rdc.business.sapr3.TvsbtPK,
> class com.ibm.rdc.business.sapr3.T002t, class
> com.ibm.rdc.business.sapr3.ChangelogPK, class
> com.ibm.rdc.business.sapr3.ZkvinacnPK, class
> com.ibm.rdc.business.sapr3.Account, class
> com.ibm.rdc.business.sapr3.ThitPK, class
> com.ibm.rdc.business.sapr3.CrmRestart, class
> com.ibm.rdc.business.sapr3.Tpaer, class
com.ibm.rdc.business.sapr3.TspaPK,
> class com.ibm.rdc.business.sapr3.Ikna1PK, class
> com.ibm.rdc.business.sapr3.LoadjobPK, class
> com.ibm.rdc.business.sapr3.Tsad3PK, class
com.ibm.rdc.business.sapr3.Tzone,
> class com.ibm.rdc.business.sapr3.Tsad3tSadrPK, class
> com.ibm.rdc.business.sapr3.TsadvtPK, class
com.ibm.rdc.business.sapr3.Bnka,
> class com.ibm.rdc.business.sapr3.CtLaRegionPK, class
> com.ibm.rdc.business.sapr3.CtActInactStat, class
> com.ibm.rdc.business.sapr3.CtEmeaIsuconvPK, class
> com.ibm.rdc.business.sapr3.Rknva, class com.ibm.rdc.business.sapr3.Tcurc,
> class com.ibm.rdc.business.sapr3.Tcurf, class
> com.ibm.rdc.business.sapr3.Tcure, class
com.ibm.rdc.business.sapr3.Bstxhl,
> class com.ibm.rdc.business.sapr3.AutodelEx, class
> com.ibm.rdc.business.sapr3.Dpartner, class
> com.ibm.rdc.business.sapr3.Rknvd, class com.ibm.rdc.business.sapr3.Tcury,
> class com.ibm.rdc.business.sapr3.Tzont, class
> com.ibm.rdc.business.sapr3.Extractmsg, class
> com.ibm.rdc.business.sapr3.Rknvi, class
> com.ibm.rdc.business.sapr3.SalesVertical, class
> com.ibm.rdc.business.sapr3.CtYesno, class
com.ibm.rdc.business.sapr3.Rknvk,
> class com.ibm.rdc.business.sapr3.Rknvl, class
> com.ibm.rdc.business.sapr3.T016tPK, class
com.ibm.rdc.business.sapr3.Tcurr,
> class com.ibm.rdc.business.sapr3.Rknvp, class
> com.ibm.rdc.business.sapr3.Tcurt, class com.ibm.rdc.business.sapr3.Tcurv,
> class com.ibm.rdc.business.sapr3.TbrctPK, class
> com.ibm.rdc.business.sapr3.Bknb1, class
> com.ibm.rdc.business.sapr3.DstNonclonedPK, class
> com.ibm.rdc.business.sapr3.OrgMemoryTable, class
> com.ibm.rdc.business.sapr3.Skb1, class com.ibm.rdc.business.sapr3.TclaPK,
> class com.ibm.rdc.business.sapr3.T005fPK, class
> com.ibm.rdc.business.sapr3.Tsadvt, class
> com.ibm.rdc.business.sapr3.T056xPK, class
> com.ibm.rdc.business.sapr3.T077dPK, class
> com.ibm.rdc.business.sapr3.InobPK, class
> com.ibm.rdc.business.sapr3.TkupaPK, class
> com.ibm.rdc.business.sapr3.SubBranch, class
> com.ibm.rdc.business.sapr3.Thit, class com.ibm.rdc.business.sapr3.Bkna1,
> class com.ibm.rdc.business.sapr3.TvgftPK, class
> com.ibm.rdc.business.sapr3.Iknbk, class
> com.ibm.rdc.business.sapr3.TryForFitRsltPK, class
> com.ibm.rdc.business.sapr3.SdOrgtemp, class
> com.ibm.rdc.business.sapr3.TpfktPK, class
> com.ibm.rdc.business.sapr3.IaleaudPK, class
> com.ibm.rdc.business.sapr3.OrgMemoryTablePK, class
> com.ibm.rdc.business.sapr3.Tvkt, class
com.ibm.rdc.business.sapr3.TsabtPK,
> class com.ibm.rdc.business.sapr3.Branch, class
> com.ibm.rdc.business.sapr3.TpartPK, class
> com.ibm.rdc.business.sapr3.ZzkvSicPK, class
> com.ibm.rdc.business.sapr3.Land1Mapping, class
> com.ibm.rdc.business.sapr3.Ikna1, class
> com.ibm.rdc.business.sapr3.Acctxref, class
> com.ibm.rdc.business.sapr3.CceKnvvPK, class
> com.ibm.rdc.business.sapr3.Copycfg, class
> com.ibm.rdc.business.sapr3.TvlstPK, class
> com.ibm.rdc.business.sapr3.IknvvPK, class
> com.ibm.rdc.business.sapr3.PartDelivery, class
> com.ibm.rdc.business.sapr3.UploadPK, class
> com.ibm.rdc.business.sapr3.LegDiscLog, class
> com.ibm.rdc.business.sapr3.Tvko, class
> com.ibm.rdc.business.sapr3.LedgerKatr6MapPK, class
> com.ibm.rdc.business.sapr3.Kna1extLogPK, class
> com.ibm.rdc.business.sapr3.Kna1Dun, class
> com.ibm.rdc.business.sapr3.Kna1DunPK, class
> com.ibm.rdc.business.sapr3.Tpar, class
> com.ibm.rdc.business.sapr3.CoverageLstRunTimestampTmp, class
> com.ibm.rdc.business.sapr3.Tvv4tPK, class
> com.ibm.rdc.business.sapr3.CoverageLstRunTimestamp, class
> com.ibm.rdc.business.sapr3.Iknb1, class
> com.ibm.rdc.business.sapr3.CoverageLstRunTimestampPK, class
> com.ibm.rdc.business.sapr3.TcurtPK, class
> com.ibm.rdc.business.sapr3.BknvvPK, class
com.ibm.rdc.business.sapr3.Inob,
> class com.ibm.rdc.business.sapr3.Sector, class
> com.ibm.rdc.business.sapr3.TsavtPK, class
> com.ibm.rdc.business.sapr3.Tvk5tPK, class
> com.ibm.rdc.business.sapr3.IknvkSadrPK, class
> com.ibm.rdc.business.sapr3.IknvpPK, class
com.ibm.rdc.business.sapr3.Tvk8,
> class com.ibm.rdc.business.sapr3.TvkttPK, class
> com.ibm.rdc.business.sapr3.CceKnvpPK, class
> com.ibm.rdc.business.sapr3.ClusterLogPK, class
> com.ibm.rdc.business.sapr3.Tvk6, class com.ibm.rdc.business.sapr3.TvlPK,
> class com.ibm.rdc.business.sapr3.Iknex, class
> com.ibm.rdc.business.sapr3.Tvk2, class
> com.ibm.rdc.business.sapr3.IntAccountLogPK, class
> com.ibm.rdc.business.sapr3.Tvk1, class com.ibm.rdc.business.sapr3.Tvk0,
> class com.ibm.rdc.business.sapr3.T002, class
> com.ibm.rdc.business.sapr3.T001, class com.ibm.rdc.business.sapr3.Tvk2PK,
> class com.ibm.rdc.business.sapr3.T005, class
> com.ibm.rdc.business.sapr3.T052uPK, class
> com.ibm.rdc.business.sapr3.TcurePK, class
> com.ibm.rdc.business.sapr3.TbrcPK, class
> com.ibm.rdc.business.sapr3.ImasteridocPK, class
> com.ibm.rdc.business.sapr3.CradDecisionTbl, class
> com.ibm.rdc.business.sapr3.Tier, class
> com.ibm.rdc.business.sapr3.AccountPK, class
> com.ibm.rdc.business.sapr3.ClusterPK, class
> com.ibm.rdc.business.sapr3.DdestPK, class
> com.ibm.rdc.business.sapr3.LedgerKatr6Map, class
> com.ibm.rdc.business.sapr3.Imasteridoc, class
> com.ibm.rdc.business.sapr3.T014, class
com.ibm.rdc.business.sapr3.IknbkPK,
> class com.ibm.rdc.business.sapr3.T151, class
> com.ibm.rdc.business.sapr3.Tsad3t, class
> com.ibm.rdc.business.sapr3.T005pPK, class
> com.ibm.rdc.business.sapr3.PrefMethContact, class
> com.ibm.rdc.business.sapr3.T002tPK, class
> com.ibm.rdc.business.sapr3.Loadjob, class com.ibm.rdc.business.sapr3.Job,
> class com.ibm.rdc.business.sapr3.Icommaud, class
> com.ibm.rdc.business.sapr3.IstxhlPK, class
> com.ibm.rdc.business.sapr3.TvmstPK, class
com.ibm.rdc.business.sapr3.Tvgf,
> class com.ibm.rdc.business.sapr3.Legxref, class
> com.ibm.rdc.business.sapr3.Bknbk, class
> com.ibm.rdc.business.sapr3.Custlist, class
> com.ibm.rdc.business.sapr3.Remoteaction, class
> com.ibm.rdc.business.sapr3.TvtwPK, class
> com.ibm.rdc.business.sapr3.TvfstPK, class
> com.ibm.rdc.business.sapr3.T151tPK, class
> com.ibm.rdc.business.sapr3.KlahPK, class
> com.ibm.rdc.business.sapr3.SdValidTaxcdPK, class
> com.ibm.rdc.business.sapr3.Tvv1tPK, class
> com.ibm.rdc.business.sapr3.CmrstatusPK, class
> com.ibm.rdc.business.sapr3.Langid, class
com.ibm.rdc.business.sapr3.TskdPK,
> class com.ibm.rdc.business.sapr3.IsuSubind, class
> com.ibm.rdc.business.sapr3.T151t, class
com.ibm.rdc.business.sapr3.Tvv1PK,
> class com.ibm.rdc.business.sapr3.Imetatable, class
> com.ibm.rdc.business.sapr3.LoadmsgPK, class
> com.ibm.rdc.business.sapr3.Tvv1t, class
com.ibm.rdc.business.sapr3.TinctPK,
> class com.ibm.rdc.business.sapr3.TfactPK, class
> com.ibm.rdc.business.sapr3.LoadstatusPK, class
> com.ibm.rdc.business.sapr3.GcsFinoblHierPK, class
> com.ibm.rdc.business.sapr3.GcsFinoblHier, class
> com.ibm.rdc.business.sapr3.Tvv2tPK, class
> com.ibm.rdc.business.sapr3.RknbkPK, class
com.ibm.rdc.business.sapr3.Tvk4t,
> class com.ibm.rdc.business.sapr3.Bknvi, class
> com.ibm.rdc.business.sapr3.Custreq, class
com.ibm.rdc.business.sapr3.Bknvk,
> class com.ibm.rdc.business.sapr3.TvkdtPK, class
> com.ibm.rdc.business.sapr3.Bknvl, class
com.ibm.rdc.business.sapr3.TskdtPK,
> class com.ibm.rdc.business.sapr3.Rknkk, class
> com.ibm.rdc.business.sapr3.Tsavt, class
com.ibm.rdc.business.sapr3.TvktPK,
> class com.ibm.rdc.business.sapr3.Bknvp, class
> com.ibm.rdc.business.sapr3.IsuSubindPK, class
> com.ibm.rdc.business.sapr3.Ialeaud, class
com.ibm.rdc.business.sapr3.Tvv2t,
> class com.ibm.rdc.business.sapr3.TkuklPK, class
> com.ibm.rdc.business.sapr3.Atab, class com.ibm.rdc.business.sapr3.Bknvv,
> class com.ibm.rdc.business.sapr3.RknkkPK, class
> com.ibm.rdc.business.sapr3.PendRulesetKatr6PK, class
> com.ibm.rdc.business.sapr3.Knex, class
> com.ibm.rdc.business.sapr3.IcommidocPK, class
> com.ibm.rdc.business.sapr3.T188, class
com.ibm.rdc.business.sapr3.Loadmsg,
> class com.ibm.rdc.business.sapr3.Tvk3t, class
> com.ibm.rdc.business.sapr3.Tvk9tPK, class
> com.ibm.rdc.business.sapr3.ShipMeth, class
> com.ibm.rdc.business.sapr3.Tvv3t, class
com.ibm.rdc.business.sapr3.TpaerPK,
> class com.ibm.rdc.business.sapr3.FloorLevelChk, class
> com.ibm.rdc.business.sapr3.IntAccountLog, class
> com.ibm.rdc.business.sapr3.IknvkPK, class
com.ibm.rdc.business.sapr3.Tvv1,
> class com.ibm.rdc.business.sapr3.Tvv2, class
> com.ibm.rdc.business.sapr3.Tvv4t, class com.ibm.rdc.business.sapr3.Tvv5,
> class com.ibm.rdc.business.sapr3.T188t, class
> com.ibm.rdc.business.sapr3.ClientTable, class
> com.ibm.rdc.business.sapr3.Tvv3, class
com.ibm.rdc.business.sapr3.RknexPK,
> class com.ibm.rdc.business.sapr3.Tvv4, class
> com.ibm.rdc.business.sapr3.CustdestPK, class
> com.ibm.rdc.business.sapr3.AtabPK, class com.ibm.rdc.business.sapr3.Tvtw,
> class com.ibm.rdc.business.sapr3.TvstPK, class
> com.ibm.rdc.business.sapr3.Tvsb, class
com.ibm.rdc.business.sapr3.Taguser,
> class com.ibm.rdc.business.sapr3.Tvk2t, class
> com.ibm.rdc.business.sapr3.Tvipt, class
com.ibm.rdc.business.sapr3.Rknb1PK,
> class com.ibm.rdc.business.sapr3.Tkupa, class
> com.ibm.rdc.business.sapr3.T005uPK, class
com.ibm.rdc.business.sapr3.Tvsd,
> class com.ibm.rdc.business.sapr3.TvburPK, class
> com.ibm.rdc.business.sapr3.T056x, class com.ibm.rdc.business.sapr3.Tvv5t,
> class com.ibm.rdc.business.sapr3.TcurrPK, class
> com.ibm.rdc.business.sapr3.Tvst, class
com.ibm.rdc.business.sapr3.Tvk1tPK,
> class com.ibm.rdc.business.sapr3.Tskd, class
> com.ibm.rdc.business.sapr3.T077d, class com.ibm.rdc.business.sapr3.Tvk1t,
> class com.ibm.rdc.business.sapr3.BstxhlPK, class
> com.ibm.rdc.business.sapr3.Bknb1PK, class
com.ibm.rdc.business.sapr3.T077x,
> class com.ibm.rdc.business.sapr3.PoolLog, class
> com.ibm.rdc.business.sapr3.Extractstatus, class
> com.ibm.rdc.business.sapr3.BknvkSadrPK, class
> com.ibm.rdc.business.sapr3.TstlPK, class
com.ibm.rdc.business.sapr3.Tvkot,
> class com.ibm.rdc.business.sapr3.DstNoncloned, class
> com.ibm.rdc.business.sapr3.TcuryPK, class
> com.ibm.rdc.business.sapr3.JobControlPK, class
> com.ibm.rdc.business.sapr3.Tvro, class
com.ibm.rdc.business.sapr3.TvastPK,
> class com.ibm.rdc.business.sapr3.Tvlst, class
> com.ibm.rdc.business.sapr3.TcurvPK, class
> com.ibm.rdc.business.sapr3.LogChgCodePK, class
> com.ibm.rdc.business.sapr3.RsadrPK, class
> com.ibm.rdc.business.sapr3.VKnvpUnion1, class
> com.ibm.rdc.business.sapr3.Tclu, class com.ibm.rdc.business.sapr3.PoolPK,
> class com.ibm.rdc.business.sapr3.Inacxref, class
> com.ibm.rdc.business.sapr3.Tcla, class com.ibm.rdc.business.sapr3.Tvk0t,
> class com.ibm.rdc.business.sapr3.BranchPK, class
> com.ibm.rdc.business.sapr3.ExtractstatusPK, class
> com.ibm.rdc.business.sapr3.TcluPK, class
> com.ibm.rdc.business.sapr3.CustlistPK, class
> com.ibm.rdc.business.sapr3.RknvaPK, class
> com.ibm.rdc.business.sapr3.Pmasteridoc, class
> com.ibm.rdc.business.sapr3.TcurcPK, class
> com.ibm.rdc.business.sapr3.KnvlPK, class
> com.ibm.rdc.business.sapr3.PmasteridocPK, class
> com.ibm.rdc.business.sapr3.GeoPK, class
> com.ibm.rdc.business.sapr3.PendRulesetKatr6, class
> com.ibm.rdc.business.sapr3.DfilterPK, class
> com.ibm.rdc.business.sapr3.HierarchyLinksEx, class
> com.ibm.rdc.business.sapr3.IknvkSadr, class
> com.ibm.rdc.business.sapr3.IknvaPK, class
> com.ibm.rdc.business.sapr3.IknvlPK, class
> com.ibm.rdc.business.sapr3.TvkoPK, class
com.ibm.rdc.business.sapr3.Tvgft,
> class com.ibm.rdc.business.sapr3.KnvpPK, class
> com.ibm.rdc.business.sapr3.Ddest, class
> com.ibm.rdc.business.sapr3.SectorPK, class
com.ibm.rdc.business.sapr3.Rule,
> class com.ibm.rdc.business.sapr3.Knb1, class
> com.ibm.rdc.business.sapr3.Iknb1PK, class
> com.ibm.rdc.business.sapr3.ChghistoryPK, class
> com.ibm.rdc.business.sapr3.SectorIsu, class
> com.ibm.rdc.business.sapr3.TkuktPK, class
> com.ibm.rdc.business.sapr3.SalesVerticalPK, class
> com.ibm.rdc.business.sapr3.Klah, class
com.ibm.rdc.business.sapr3.RknvdPK,
> class com.ibm.rdc.business.sapr3.KnvvPK, class
> com.ibm.rdc.business.sapr3.AcctxrefPK, class
> com.ibm.rdc.business.sapr3.Knb5, class
> com.ibm.rdc.business.sapr3.SizeinfoPK, class
> com.ibm.rdc.business.sapr3.KnvhPK, class com.ibm.rdc.business.sapr3.Stxl,
> class com.ibm.rdc.business.sapr3.Tkukt, class
> com.ibm.rdc.business.sapr3.T189tPK, class
> com.ibm.rdc.business.sapr3.IknvdPK, class
> com.ibm.rdc.business.sapr3.CceKnvp, class
> com.ibm.rdc.business.sapr3.TpritPK, class
com.ibm.rdc.business.sapr3.Tfact,
> class com.ibm.rdc.business.sapr3.CdGcsFinoblHierPK, class
> com.ibm.rdc.business.sapr3.Stxh, class
> com.ibm.rdc.business.sapr3.CoverageIdPK, class
> com.ibm.rdc.business.sapr3.TvroPK, class
com.ibm.rdc.business.sapr3.Tkukl,
> class com.ibm.rdc.business.sapr3.CceKnvv, class
> com.ibm.rdc.business.sapr3.BknvdPK, class
> com.ibm.rdc.business.sapr3.Tvv3tPK, class
com.ibm.rdc.business.sapr3.Tvktt,
> class com.ibm.rdc.business.sapr3.StxlPK, class
> com.ibm.rdc.business.sapr3.Rknex, class
> com.ibm.rdc.business.sapr3.Custdest, class
> com.ibm.rdc.business.sapr3.T189t, class com.ibm.rdc.business.sapr3.T052u,
> class com.ibm.rdc.business.sapr3.T042z, class
> com.ibm.rdc.business.sapr3.Kssk, class
com.ibm.rdc.business.sapr3.VCceOrg,
> class com.ibm.rdc.business.sapr3.CviCovAssignPK, class
> com.ibm.rdc.business.sapr3.CtT005ext, class
> com.ibm.rdc.business.sapr3.CountryRegionPK, class
> com.ibm.rdc.business.sapr3.T188tPK, class
> com.ibm.rdc.business.sapr3.TvsdPK, class
> com.ibm.rdc.business.sapr3.TerritoryLogPK, class
> com.ibm.rdc.business.sapr3.Dpred, class com.ibm.rdc.business.sapr3.Tvp6,
> class com.ibm.rdc.business.sapr3.Knbk, class

> t10.prst2, t10.pruin, t10.spras, t10.uinln, t10.umrwrt, t10.waers,
> t10.wechf, t10.xaddr, t10.xanzum, t10.xdezp, t10.xegld, t10.xland,
> t10.xmwsn, t10.xplpf, t10.xplst, t10.xprbk, t10.xprso, t10.xregs,
> t10.xskfn, t11.counc, t11.LAND1, t11.mandt, t11.regio, t11.spras,
> t11.bezei, t12.LAND1, t12.mandt, t12.spras, t12.landx, t12.natio,
> t13.bland, t13.LAND1, t13.mandt, t13.spras, t13.bezei, t14.mandt,
> t14.periv, t14.spras, t14.ltext, t15.BRSCH, t15.mandt, t15.spras,
> t15.brtxt, t16.KTOKD, t16.mandt, t16.spras, t16.txt30, t17.braco,
> t17.mandt, t17.vtext, t17.spras, t18.braco, t18.mandt, t18.vtext,
> t18.spras, t19.braco, t19.mandt, t19.vtext, t19.spras, t20.braco,
> t20.mandt, t20.vtext, t20.spras, t21.braco, t21.mandt, t21.vtext,
> t21.spras, t22.mandt, t22.waers, t22.altwr, t22.gdatu, t22.isocd,
t6.TELBX,
> t6.TELF1, t6.TELF2, t6.TELFX, t6.TELTX, t6.TELX1, t23.ident, t23.abbr,
> t23.aktbjahr, t23.aktvjahr, t23.basis, t23.bjahr, t23.crdat, t23.crtime,
> t23.crusr, t23.ditag, t23.dotag, t23.fetag, t23.frtag, t23.hocid,
> t23.interv, t23.miwch, t23.motag, t23.satag, t23.sotag, t23.vjahr,
> t24.ident, t24.spras, t24.ltext, t25.kukla, t25.mandt, t25.spras,
> t25.vtext, t26.client, t26.langu, t26.title, t26.TITLE_MEDI, t27.aufsp,
> t27.mandt, t27.spras, t27.vtext, t28.faksp, t28.mandt, t28.spras,
> t28.vtext, t29.gform, t29.mandt, t30.katr10, t30.mandt, t31.katr10,
> t31.mandt, t31.spras, t31.vtext, t32.katr1, t32.mandt, t32.spras,
> t32.vtext, t33.katr2, t33.mandt, t33.spras, t33.vtext, t34.katr3,
> t34.mandt, t34.spras, t34.vtext, t35.katr4, t35.mandt, t35.spras,
> t35.vtext, t36.katr5, t36.mandt, t36.spras, t36.vtext, t37.katr6,
> t37.mandt, t37.spras, t37.vtext, t38.katr7, t38.mandt, t38.spras,
> t38.vtext, t39.katr8, t39.mandt, t39.spras, t39.vtext, t40.katr9,
> t40.mandt, t40.spras, t40.vtext, t41.lifsp, t41.mandt, t41.spras,
> t41.vtext, t6.TXJCD, t42.LAND1, t42.mandt, t42.spras, t42.zone1,
t42.vtext,
> t6.UMJAH, t6.UMSA1, t6.UMSAT, t6.UWAER, t6.VBUND, t6.WERKS, t6.XCPDK,
> t6.XZEMP, t43.mandt, t43.ZZKV_INAC, t43.ZZKV_INACT, t43.ZZKV_ACD,
> t43.ZZKV_ACT, t43.ZZKV_ASSIST_IND, t43.ZZKV_CTRYNX, t43.ZZKV_DESC,
> t43.ZZKV_GCM, t43.ZZKV_HQ_LOCATION, t43.ZZKV_HQCC, t43.ZZKV_INAC_NAMEAB,
> t43.ZZKV_INAC_SUPER, t43.ZZKV_TOP_CUST, t44.mandt, t44.spras,
> t44.ZZKV_INACT, t44.ZZKV_DESC, t6.ZZKV_CUSNO, t6.ZZKV_DEPT, t6.ZZKV_DUNS,
> t6.ZZKV_ESTAB, t6.ZZKV_INAC, t6.ZZKV_INACT, t6.ZZKV_INTFUNC,
> t6.ZZKV_INTLOC, t6.ZZKV_INTUSER, t6.ZZKV_LIC, t6.ZZKV_LOTID,
t6.ZZKV_NODE1,
> t6.ZZKV_NODE2, t6.ZZKV_ORG_FLG, t6.ZZKV_PARTYID, t6.ZZKV_SEQNO,
> t6.ZZKV_SIC, t45.bran1, t45.brsch, t45.mandt, t45.ZZKV_GEO, t45.ZZKV_SIC,
> t45.BRAN1_DESC, t45.BRSCH_DESC, t45.CREATE_TMSTMP, t45.CREATE_USERID,
> t45.UPD_TMSTMP, t45.UPD_USERID, t45.ZZKV_SIC_DESC, t6.ZZKV_SNDX_NAME1,
> t6.ZZKV_SNDX_NAME2, t6.ZZKV_TIER, t6.ZZKV_UC_STRT_ADDR, t0.konda,
t0.ktgrd,
> t0.kurst, t0.kvakz, t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3, t0.kvgr4,
> t0.kvgr5, t0.kzazu, t0.kztlf, t0.lifsd, t0.loevm, t0.lprio, t0.mrnkz,
> t46.kztlf, t46.text, t0.perfk, t0.perrl, t0.pltyp, t0.prat1, t0.prat2,
> t0.prat3, t0.prat4, t0.prat5, t0.prat6, t0.prat7, t0.prat8, t0.prat9,
> t0.prata, t0.prfre, t0.SAP_TS, t0.SHAD_UPDATE_IND, t0.SHAD_UPDATE_TS,
> t47.mandt, t47.spras, t47.ztagg, t47.zterm, t47.text1, t48.kdgrp,
> t48.mandt, t48.spras, t48.ktext, t49.konda, t49.mandt, t49.spras,
> t49.vtext, t50.mandt, t50.pltyp, t50.spras, t50.ptext, t51.CURC_OLD,
> t51.mandt, t51.cause, t51.CURC_NEW, t52.mandt, t52.spras, t52.waers,
> t52.ktext, t52.ltext, t53.ident, t53.spras, t53.ltext, t54.ident,
> t54.spras, t54.ltext, t55.inco1, t55.mandt, t55.ortob, t56.inco1,
> t56.mandt, t56.spras, t56.bezei, t57.lprio, t57.mandt, t57.spras,
> t57.bezei, t58.aufsp, t58.mandt, t58.spras, t58.vtext, t59.faksp,
> t59.mandt, t59.spras, t59.vtext, t60.mandt, t60.spras, t60.vkbur,
> t60.bezei, t61.mandt, t61.spart, t61.vkbur, t61.vkorg, t61.vtweg,
> t62.kalks, t62.mandt, t62.spras, t62.vtext, t63.mandt, t63.spras,
> t63.vkorg, t63.vtext, t64.ktgrd, t64.mandt, t64.spras, t64.vtext,
> t65.mandt, t65.vkorg, t65.vtweg, t65.werks, t66.lifsp, t66.mandt,
> t66.spras, t66.vtext, t67.mandt, t67.spras, t67.vsbed, t67.vtext,
> t68.mandt, t68.spras, t68.stgku, t68.bezei20, t69.kvgr1, t69.mandt,
> t69.spras, t69.bezei, t70.kvgr2, t70.mandt, t70.spras, t70.bezei,
> t71.kvgr3, t71.mandt, t71.spras, t71.bezei, t72.kvgr4, t72.mandt,
> t72.spras, t72.bezei, t73.kvgr5, t73.mandt, t73.spras, t73.bezei,
t0.versg,
> t0.vkbur, t0.vkgrp, t0.vsbed, t0.vsort, t0.vwerk, t0.waers, t0.zterm FROM
> SAPR3.KNVV t0 LEFT OUTER JOIN SAPR3.Checkbox t1 ON t0.loevm = t1.flag
LEFT
> OUTER JOIN SAPR3.Checkbox t2 ON t0.kzazu = t2.flag LEFT OUTER JOIN
> SAPR3.Checkbox t3 ON t0.loevm = t3.flag LEFT OUTER JOIN SAPR3.Checkbox t4
> ON t0.mrnkz = t4.flag LEFT OUTER JOIN SAPR3.CLIENT_TABLE t5 ON t0.mandt =
> t5.client LEFT OUTER JOIN SAPR3.KNA1 t6 ON t0.kunnr = t6.KUNNR AND
t0.mandt
> = t6.MANDT LEFT OUTER JOIN SAPR3.PART_DELIVERY t46 ON t0.kztlf =
t46.kztlf
> LEFT OUTER JOIN SAPR3.T052u t47 ON t0.mandt = t47.mandt AND t0.zterm =
> t47.zterm LEFT OUTER JOIN SAPR3.T151t t48 ON t0.mandt = t48.mandt AND
> t0.kdgrp = t48.kdgrp LEFT OUTER JOIN SAPR3.T188t t49 ON t0.mandt =
> t49.mandt AND t0.konda = t49.konda LEFT OUTER JOIN SAPR3.T189t t50 ON
> t0.mandt = t50.mandt AND t0.pltyp = t50.pltyp LEFT OUTER JOIN SAPR3.Tcure
> t51 ON t0.mandt = t51.mandt AND t0.waers = t51.CURC_OLD LEFT OUTER JOIN
> SAPR3.Tcurt t52 ON t0.mandt = t52.mandt AND t0.waers = t52.waers LEFT
OUTER
> JOIN SAPR3.Tfact t53 ON t0.perfk = t53.ident LEFT OUTER JOIN SAPR3.Tfact
> t54 ON t0.perrl = t54.ident LEFT OUTER JOIN SAPR3.Tinc t55 ON t0.mandt =
> t55.mandt AND t0.inco1 = t55.inco1 LEFT OUTER JOIN SAPR3.Tinct t56 ON
> t0.mandt = t56.mandt AND t0.inco1 = t56.inco1 LEFT OUTER JOIN SAPR3.Tprit
> t57 ON t0.mandt = t57.mandt AND t0.lprio = t57.lprio LEFT OUTER JOIN
> SAPR3.Tvast t58 ON t0.mandt = t58.mandt AND t0.aufsd = t58.aufsp LEFT
OUTER
> JOIN SAPR3.TVFST t59 ON t0.mandt = t59.mandt AND t0.faksd = t59.faksp
LEFT
> OUTER JOIN SAPR3.Tvkbt t60 ON t0.mandt = t60.mandt AND t0.vkbur =
t60.vkbur
> LEFT OUTER JOIN SAPR3.Tvkbz t61 ON t0.mandt = t61.mandt AND t0.vkorg =
> t61.vkorg AND t0.vtweg = t61.vtweg AND t0.spart = t61.spart AND t0.vkbur
=
> t61.vkbur LEFT OUTER JOIN SAPR3.Tvkdt t62 ON t0.mandt = t62.mandt AND
> t0.kalks = t62.kalks LEFT OUTER JOIN SAPR3.Tvkot t63 ON t0.mandt =
> t63.mandt AND t0.vkorg = t63.vkorg LEFT OUTER JOIN SAPR3.Tvktt t64 ON
> t0.mandt = t64.mandt AND t0.ktgrd = t64.ktgrd LEFT OUTER JOIN SAPR3.Tvkwz
> t65 ON t0.mandt = t65.mandt AND t0.vkorg = t65.vkorg AND t0.vtweg =
> t65.vtweg AND t0.vwerk = t65.werks LEFT OUTER JOIN SAPR3.TVLST t66 ON
> t0.mandt = t66.mandt AND t0.lifsd = t66.lifsp LEFT OUTER JOIN SAPR3.Tvsbt
> t67 ON t0.mandt = t67.mandt AND t0.vsbed = t67.vsbed LEFT OUTER JOIN
> SAPR3.Tvsdt t68 ON t0.mandt = t68.mandt AND t0.versg = t68.stgku LEFT
OUTER
> JOIN SAPR3.Tvv1t t69 ON t0.mandt = t69.mandt AND t0.kvgr1 = t69.kvgr1
LEFT
> OUTER JOIN SAPR3.Tvv2t t70 ON t0.mandt = t70.mandt AND t0.kvgr2 =
t70.kvgr2
> LEFT OUTER JOIN SAPR3.Tvv3t t71 ON t0.mandt = t71.mandt AND t0.kvgr3 =
> t71.kvgr3 LEFT OUTER JOIN SAPR3.Tvv4t t72 ON t0.mandt = t72.mandt AND
> t0.kvgr4 = t72.kvgr4 LEFT OUTER JOIN SAPR3.Tvv5t t73 ON t0.mandt =
> t73.mandt AND t0.kvgr5 = t73.kvgr5 LEFT OUTER JOIN SAPR3.CLIENT_TABLE t7
ON
> t6.MANDT = t7.client LEFT OUTER JOIN SAPR3.T001w t8 ON t6.MANDT =
t8.MANDT
> AND t6.WERKS = t8.werks LEFT OUTER JOIN SAPR3.T002T t9 ON t6.SPRAS =
> t9.SPRSL LEFT OUTER JOIN SAPR3.T005 t10 ON t6.MANDT = t10.MANDT AND
> t6.LAND1 = t10.LAND1 LEFT OUTER JOIN SAPR3.T005f t11 ON t6.MANDT =
> t11.mandt AND t6.LAND1 = t11.LAND1 AND t6.REGIO = t11.regio AND t6.COUNC
=
> t11.counc LEFT OUTER JOIN SAPR3.T005T t12 ON t6.MANDT = t12.mandt AND
> t6.LAND1 = t12.LAND1 LEFT OUTER JOIN SAPR3.T005U t13 ON t6.MANDT =
> t13.mandt AND t6.LAND1 = t13.LAND1 AND t6.REGIO = t13.bland LEFT OUTER
JOIN
> SAPR3.T009t t14 ON t6.MANDT = t14.mandt AND t6.PERIV = t14.periv LEFT
OUTER
> JOIN SAPR3.T016T t15 ON t6.MANDT = t15.mandt AND t6.BRSCH = t15.BRSCH
LEFT
> OUTER JOIN SAPR3.T077X t16 ON t6.MANDT = t16.mandt AND t6.KTOKD =
t16.KTOKD
> LEFT OUTER JOIN SAPR3.TBRCT t17 ON t6.MANDT = t17.mandt AND t6.BRAN1 =
> t17.braco LEFT OUTER JOIN SAPR3.TBRCT t18 ON t6.MANDT = t18.mandt AND
> t6.BRAN2 = t18.braco LEFT OUTER JOIN SAPR3.TBRCT t19 ON t6.MANDT =
> t19.mandt AND t6.BRAN3 = t19.braco LEFT OUTER JOIN SAPR3.TBRCT t20 ON
> t6.MANDT = t20.mandt AND t6.BRAN4 = t20.braco LEFT OUTER JOIN SAPR3.TBRCT
> t21 ON t6.MANDT = t21.mandt AND t6.BRAN5 = t21.braco LEFT OUTER JOIN
> SAPR3.Tcurc t22 ON t6.MANDT = t22.mandt AND t6.UWAER = t22.waers LEFT
OUTER
> JOIN SAPR3.Tfacd t23 ON t6.KNAZK = t23.ident LEFT OUTER JOIN SAPR3.Tfact
> t24 ON t6.KNAZK = t24.ident AND t6.SPRAS = t24.spras LEFT OUTER JOIN
> SAPR3.TKUKT t25 ON t6.MANDT = t25.mandt AND t6.KUKLA = t25.kukla LEFT
OUTER
> JOIN SAPR3.Tsad3t t26 ON t6.MANDT = t26.client AND t6.ANRED =
> t26.TITLE_MEDI LEFT OUTER JOIN SAPR3.Tvast t27 ON t6.MANDT = t27.mandt
AND
> t6.AUFSD = t27.aufsp LEFT OUTER JOIN SAPR3.TVFST t28 ON t6.MANDT =
> t28.mandt AND t6.FAKSD = t28.faksp LEFT OUTER JOIN SAPR3.Tvgf t29 ON
> t6.MANDT = t29.mandt AND t6.GFORM = t29.gform LEFT OUTER JOIN SAPR3.Tvk0
> t30 ON t6.MANDT = t30.mandt AND t6.KATR10 = t30.katr10 LEFT OUTER JOIN
> SAPR3.TVK0T t31 ON t6.MANDT = t31.mandt AND t6.KATR10 = t31.katr10 LEFT
> OUTER JOIN SAPR3.TVK1T t32 ON t6.MANDT = t32.mandt AND t6.KATR1 =
t32.katr1
> LEFT OUTER JOIN SAPR3.Tvk2t t33 ON t6.MANDT = t33.mandt AND t6.KATR2 =
> t33.katr2 LEFT OUTER JOIN SAPR3.TVK3T t34 ON t6.MANDT = t34.mandt AND
> t6.KATR3 = t34.katr3 LEFT OUTER JOIN SAPR3.TVK4T t35 ON t6.MANDT =
> t35.mandt AND t6.KATR4 = t35.katr4 LEFT OUTER JOIN SAPR3.Tvk5t t36 ON
> t6.MANDT = t36.mandt AND t6.KATR5 = t36.katr5 LEFT OUTER JOIN SAPR3.TVK6T
> t37 ON t6.MANDT = t37.mandt AND t6.KATR6 = t37.katr6 LEFT OUTER JOIN
> SAPR3.TVK7T t38 ON t6.MANDT = t38.mandt AND t6.KATR7 = t38.katr7 LEFT
OUTER
> JOIN SAPR3.Tvk8t t39 ON t6.MANDT = t39.mandt AND t6.KATR8 = t39.katr8
LEFT
> OUTER JOIN SAPR3.TVK9T t40 ON t6.MANDT = t40.mandt AND t6.KATR9 =
t40.katr9
> LEFT OUTER JOIN SAPR3.TVLST t41 ON t6.MANDT = t41.mandt AND t6.LIFSD =
> t41.lifsp LEFT OUTER JOIN SAPR3.TZONT t42 ON t6.MANDT = t42.mandt AND
> t6.LAND1 = t42.LAND1 AND t6.LZONE = t42.zone1 LEFT OUTER JOIN
> SAPR3.ZKVINACN t43 ON t6.MANDT = t43.mandt AND t6.ZZKV_INACT =
> t43.ZZKV_INACT AND t6.ZZKV_INAC = t43.ZZKV_INAC LEFT OUTER JOIN
> SAPR3.Zkvinact t44 ON t6.MANDT = t44.mandt AND t6.ZZKV_INACT =
> t44.ZZKV_INACT LEFT OUTER JOIN SAPR3.ZZKV_SIC t45 ON t6.MANDT = t45.mandt
> AND t6.ZZKV_SIC = t45.ZZKV_SIC WHERE t0.kunnr = ? AND t0.mandt = ? AND
> t0.spart = ? AND t0.vkorg = ? AND t0.vtweg = ?  optimize for 1 row
[params=
> (String) 0060718462, (String) 030, (String) 00, (String) 0147, (String)
C]
> 43344  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL -
<t
> 1181369962, conn 1860595430> [640 ms] spent
> log4j:WARN No appenders could be found for logger
> (com.ibm.rdc.business.sapr3.entitylisteners.KNA1_Listener).
> KNA1_Listener.preUpdate()
> log4j:WARN Please initialize the log4j system properly.
> KNVV_Listener.preUpdate
> 44594  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL -
<t
> 1181369962, conn 1860595430> executing prepstmnt 1319259810 UPDATE
> SAPR3.PART_DELIVERY SET text = ? WHERE kztlf = ? [params=(String) Partial
> delivery allowed, (String)  ]
> 44704  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL -
<t
> 1181369962, conn 1860595430> [110 ms] spent
> 44704  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL -
<t
> 1181369962, conn 1860595430> executing prepstmnt 1761372412 UPDATE
> SAPR3.KNA1 SET MANDT = ?, ABRVW = ?, ADRNR = ?, ANRED = ?, AUFSD = ?,
BAHNE
> = ?, BAHNS = ?, BBBNR = ?, BBSNR = ?, BEGRU = ?, BRAN1 = ?, BRAN2 = ?,
> BRAN3 = ?, BRAN4 = ?, BRAN5 = ?, BRSCH = ?, BUBKZ = ?, CITYC = ?, CIVVE
> = ?, COUNC = ?, CREATE_OPT_NUM = ?, DATLT = ?, DEAR1 = ?, DEAR2 = ?,
DEAR3
> = ?, DEAR4 = ?, DEAR5 = ?, DTAMS = ?, DTAWS = ?, DUEFL = ?, EKONT = ?,
> ERDAT = ?, ERNAM = ?, ETIKG = ?, EXABL = ?, FAKSD = ?, FISKN = ?, GFORM
> = ?, HZUOR = ?, INSPATDEBI = ?, INSPBYDEBI = ?, JMJAH = ?, JMZAH = ?,
KATR1
> = ?, KATR10 = ?, KATR2 = ?, KATR3 = ?, KATR4 = ?, KATR5 = ?, KATR6 = ?,
> KATR7 = ?, KATR8 = ?, KATR9 = ?, KDKG1 = ?, KDKG2 = ?, KDKG3 = ?, KDKG4
> = ?, KDKG5 = ?, KNAZK = ?, KNRZA = ?, KONZS = ?, KTOCD = ?, KTOKD = ?,
> KUKLA = ?, LAND1 = ?, LIFNR = ?, LIFSD = ?, LOCCO = ?, LOEVM = ?, LZONE
> = ?, MCOD1 = ?, MCOD2 = ?, MCOD3 = ?, MILVE = ?, NAME1 = ?, NAME2 = ?,
> NAME3 = ?, NAME4 = ?, NIELS = ?, ORT01 = ?, ORT02 = ?, PERIV = ?, PFACH
> = ?, PFORT = ?, PSTL2 = ?, PSTLZ = ?, REGIO = ?, RESTRICT_CD = ?, RPMKR
> = ?, SAP_TS = ?, SHAD_UPDATE_IND = ?, SHAD_UPDATE_TS = ?, SORTL = ?,
SPERR
> = ?, SPERZ = ?, SPRAS = ?, STCD1 = ?, STCD2 = ?, STCEG = ?, STKZA = ?,
> STKZN = ?, STKZU = ?, STRAS = ?, WERKS = ? [params=(String) 030,
(String) ,
> (String) , (String) , (String) IN, (String) , (String) , (String)
0000000,
> (String) 00000, (String) US, (String) FA, (String) , (String) ,
(String) ,
> (String) , (String) 04, (String) 0, (String) , (String)  , (String) ,
> (String) 1, (String) , (String)  , (String)  , (String)  , (String)  ,
> (String)  , (String)  , (String) , (String)  , (String) , (String)
> 20070920, (String) CCE_BP_USER, (String) , (String)  , (String) ,
> (String) , (String) , (String) 00, (String)  , (String)  , (String) 0000,
> (String) 000000, (String) , (String) , (String) , (String) 9, (String) ,
> (String) , (String) 897, (String) , (String) , (String) , (String) ,
> (String) , (String) , (String) , (String) , (String) , (String) ,
> (String) , (String) , (String) ZS01, (String) 11, (String) US, (String) ,
> (String) CE, (String) , (String)  , (String) Z000000001, (String)
> ORG20070803, (String) , (String) CITYYY, (String)  , (String)
org20070803,
> (String) , (String) sitename3, (String) , (String) , (String) cityyy,
> (String) , (String) , (String) , (String) , (String) , (String) 33487,
> (String) FL, (String)    , (String) , (Timestamp) 2007-12-13 14:16:15.0,
> (String) U, (Timestamp) 2007-12-13 14:16:15.0, (String) org2007080,
> (String)  , (String)  , (String) E, (String) , (String) A000, (String) ,
> (String)  , (String)  , (String)  , (String) streete, (null) null]
> 44969  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL -
<t
> 1181369962, conn 1860595430> [265 ms] spent
> KNA1_Listener.postUpdate()
> KNVV_Listener.postUpdate()
> <openjpa-1.2.2-r422266:898935 fatal store error>
> org.apache.openjpa.persistence.RollbackException: AN UPDATE, INSERT, OR
SET
> VALUE IS NULL, BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES.
> SQLCODE=-407, SQLSTATE=23502, DRIVER=3.58.81
>        at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> EntityManagerImpl.java:523)
>        at com.ibm.rdc.business.sapr3.manager.KnvvManager.updateKnvv(
> KnvvManager.java:133)
>        at com.ibm.rdc.business.rdaccess.impl.UserRoles.updateRole(
> UserRoles.java:417)
>        at com.ibm.rdc.business.rdaccess.impl.UserRoles.main(
> UserRoles.java:296)
> Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: AN UPDATE, INSERT,
OR
> SET VALUE IS NULL, BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES.
> SQLCODE=-407, SQLSTATE=23502, DRIVER=3.58.81
> FailedObject: prepstmnt 1761372412 UPDATE SAPR3.KNA1 SET MANDT = ?, ABRVW
> = ?, ADRNR = ?, ANRED = ?, AUFSD = ?, BAHNE = ?, BAHNS = ?, BBBNR = ?,
> BBSNR = ?, BEGRU = ?, BRAN1 = ?, BRAN2 = ?, BRAN3 = ?, BRAN4 = ?, BRAN5
> = ?, BRSCH = ?, BUBKZ = ?, CITYC = ?, CIVVE = ?, COUNC = ?,
CREATE_OPT_NUM
> = ?, DATLT = ?, DEAR1 = ?, DEAR2 = ?, DEAR3 = ?, DEAR4 = ?, DEAR5 = ?,
> DTAMS = ?, DTAWS = ?, DUEFL = ?, EKONT = ?, ERDAT = ?, ERNAM = ?, ETIKG
> = ?, EXABL = ?, FAKSD = ?, FISKN = ?, GFORM = ?, HZUOR = ?, INSPATDEBI
= ?,
> INSPBYDEBI = ?, JMJAH = ?, JMZAH = ?, KATR1 = ?, KATR10 = ?, KATR2 = ?,
> KATR3 = ?, KATR4 = ?, KATR5 = ?, KATR6 = ?, KATR7 = ?, KATR8 = ?, KATR9
> = ?, KDKG1 = ?, KDKG2 = ?, KDKG3 = ?, KDKG4 = ?, KDKG5 = ?, KNAZK = ?,
> KNRZA = ?, KONZS = ?, KTOCD = ?, KTOKD = ?, KUKLA = ?, LAND1 = ?, LIFNR
> = ?, LIFSD = ?, LOCCO = ?, LOEVM = ?, LZONE = ?, MCOD1 = ?, MCOD2 = ?,
> MCOD3 = ?, MILVE = ?, NAME1 = ?, NAME2 = ?, NAME3 = ?, NAME4 = ?, NIELS
> = ?, ORT01 = ?, ORT02 = ?, PERIV = ?, PFACH = ?, PFORT = ?, PSTL2 = ?,
> PSTLZ = ?, REGIO = ?, RESTRICT_CD = ?, RPMKR = ?, SAP_TS = ?,
> SHAD_UPDATE_IND = ?, SHAD_UPDATE_TS = ?, SORTL = ?, SPERR = ?, SPERZ = ?,
> SPRAS = ?, STCD1 = ?, STCD2 = ?, STCEG = ?, STKZA = ?, STKZN = ?, STKZU
> = ?, STRAS = ?, WERKS = ?
[org.apache.openjpa.jdbc.kernel.JDBCStoreManager
> $CancelPreparedStatement]
>        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(
> DBDictionary.java:4246)
>        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(
> DBDictionary.java:4211)
>        at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(
> DB2Dictionary.java:504)
>        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:102)
>        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> SQLExceptions.java:72)
>        at
> com.ibm.ws.persistence.jdbc.kernel.PreparedStatementManagerImpl.flush(
> PreparedStatementManagerImpl.java:170)
>        at
org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(
> OperationOrderUpdateManager.java:105)
>        at
> com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.flush(
> OperationOrderUpdateManager.java:93)
>        at
> com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.flush(
> OperationOrderUpdateManager.java:75)
>        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(
> JDBCStoreManager.java:721)
>        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(
> DelegatingStoreManager.java:130)
>        at org.apache.openjpa.kernel.BrokerImpl.flush
(BrokerImpl.java:2029)
>        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(
> BrokerImpl.java:1927)
>        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(
> BrokerImpl.java:1845)
>        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(
> LocalManagedRuntime.java:81)
>        at org.apache.openjpa.kernel.BrokerImpl.commit
(BrokerImpl.java:1369)
>        at org.apache.openjpa.kernel.DelegatingBroker.commit(
> DelegatingBroker.java:877)
>        at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> EntityManagerImpl.java:512)
>        ... 3 more
> Caused by: com.ibm.db2.jcc.am.oo: AN UPDATE, INSERT, OR SET VALUE IS
NULL,
> BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES. SQLCODE=-407,
> SQLSTATE=23502, DRIVER=3.58.81
>        at com.ibm.db2.jcc.am.ed.a(ed.java:672)
>        at com.ibm.db2.jcc.am.ed.a(ed.java:60)
>        at com.ibm.db2.jcc.am.ed.a(ed.java:127)
>        at com.ibm.db2.jcc.am.tm.b(tm.java:2192)
>        at com.ibm.db2.jcc.am.tm.c(tm.java:2175)
>        at com.ibm.db2.jcc.t4.fb.k(fb.java:355)
>        at com.ibm.db2.jcc.t4.fb.a(fb.java:61)
>        at com.ibm.db2.jcc.t4.t.a(t.java:50)
>        at com.ibm.db2.jcc.t4.vb.b(vb.java:218)
>        at com.ibm.db2.jcc.am.um.jc(um.java:2860)
>        at com.ibm.db2.jcc.am.um.b(um.java:3795)
>        at com.ibm.db2.jcc.am.um.ac(um.java:709)
>        at com.ibm.db2.jcc.am.um.executeUpdate(um.java:692)
>        at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(
> DelegatingPreparedStatement.java:269)
>        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
> $LoggingConnection$LoggingPreparedStatement.executeUpdate(
> LoggingConnectionDecorator.java:864)
>        at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(
> DelegatingPreparedStatement.java:269)
>        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager
> $CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1590)
>        at
> com.ibm.ws.persistence.jdbc.kernel.PreparedStatementManagerImpl.flush(
> PreparedStatementManagerImpl.java:112)
>        ... 15 more
>
>
======================================================================================

>
>
> Thanks & Regards,
> Prabhat Sharma
>
>
>
>
> From:   Kevin Sutter <kwsutter@gmail.com>
> To:     dev@openjpa.apache.org
> Date:   03/07/2012 11:44 AM
> Subject:        Re: Critical issue (Blocker): missing fields in update
>             statement
>
>
>
> Hi,
> None of your attachments came through, so I can't comment directly.  But,
I
> have a couple of observations...
>
> You mention one Entity with 66 fields and 46 relationships.  And, another
> Entity definition has 141 fields.  Really?  Are you trying to map to an
> existing database schema?  If not, I would reconsider your object model
> since these numbers sound a bit excessive.  Even if you are working with
an
> existing schema, is there any possibility of modifying the schema?  I'm
not
> saying that the number of attributes/relationships per Entity is the
cause
> of your issue.  But, I would say that complicated Entities like this will
> also complicate your application development and test cycle.
>
> I also have to ask whether you are using the EM.merge() method correctly?
> Are the entities (Knw) detached from the persistence context?  And,
that's
> why you are merging them in?  FYI, normal updating of Entities while
being
> managed by an EntityManager (ie. persistence context) do not have to be
> merged.  The changes just need to be committed to the database.  I just
> wanted to clarify the proper, expected usage of the JPA programming
model.
>
> As far as why not all of the attributes are being processed, I have no
> idea.  I would suggest turning on Trace and seeing if there any clues as
to
> why the processing is not completing as expected.
>
> Good luck,
> Kevin
>
> On Mon, Mar 5, 2012 at 7:09 PM, Prabhat Sharma2
> <prabhatsharma@in.ibm.com>wrote:
>
> >
> > Environment:
> >
> > OS: Windows XP
> > IDE:  IBM Rational® Software Architect for WebSphere Software (Version:
> > 8.0.3)
> > WAS: 6.1
> > OpenJPA:  1.2.2
> >
> >
> > Thanks & Regards,
> > Prabhat Sharma
> >
> >
> >
> >
> > From:   Prabhat Sharma2/India/IBM
> > To:     dev@openjpa.apache.org, dev-help@openjpa.apache.org
> > Cc:     Umamaheswari Subramanian/India/IBM, Vasudevan
> >            Mogan/India/IBM@IBMIN, Ashish Nema1/India/IBM@IBMIN, Peri
> >            Sujata/India/IBM@IBMIN, Hariom Soni1/India/IBM@IBMIN
> > Date:   03/05/2012 08:07 PM
> > Subject:        Critical issue (Blocker): missing fields in update
> > statement
> >
> >
> > Hello Team,
> >
> > We have some problem while updating an entity via entityManager's
update
> > method (generated by RSA8.0.3).
> >
> > Environment:
> > OS: Windows XP
> > IDE:  IBM Rational® Software Architect for WebSphere Software (Version:
> > 8.0.3)
> > WAS: 6.1
> >
> >
> > This entity has around 66 fields and  42  ManyToOne  & 4 OneToMany.
> > relationships. While update, it is calling update for all relational
> > entities.
> >
> > For one of the oneToMany relationship table KNA1  (attaching the
entity),
> > the update is not appending all fields of the entity and last field
field
> > value is appearing like  " (null) null]". This entity has around 141
> > fields.
> > Attaching the main entity (Knvv) which I am updating.
> >
> > [attachment "Knvv.java" deleted by Prabhat Sharma2/India/IBM]
> > [attachment "KnvvPK.java" deleted by Prabhat Sharma2/India/IBM]
> >
> > Here is the entity which has OneToMany relationship.
> >
> >
> >
> > [attachment "Kna1.java" deleted by Prabhat Sharma2/India/IBM]
> > [attachment "Kna1PK.java" deleted by Prabhat Sharma2/India/IBM]
> >
> >
> > Attaching the error log.
> >
> > [attachment "ErrorLog.txt" deleted by Prabhat Sharma2/India/IBM]
> >
> > Attaching persistence.xml also.
> >
> > [attachment "persistence.xml" deleted by Prabhat Sharma2/India/IBM]
> >
> > Please help me resolving the issue.
> >
> >
> > I am updating an entity by using the below entityManager:
> >
> > @Action(Action.ACTION_TYPE.UPDATE)
> >        public String updateKnvv(Knvv knvv) throws Exception {
> >                EntityManager em = getEntityManager();
> >                try {
> >                        em.getTransaction().begin();
> >                        knvv = em.merge(knvv);
> >                        em.getTransaction().commit();
> >                } catch (Exception ex) {
> >                        try {
> >                                if (em.getTransaction().isActive()) {
> >                                        em.getTransaction().rollback();
> >                                }
> >                        } catch (Exception e) {
> >                                ex.printStackTrace();
> >                                throw e;
> >                        }
> >                        throw ex;
> >                } finally {
> >                        em.close();
> >                }
> >                return "";
> >        }
> >
> >
> > Thanks & Regards,
> > Prabhat Sharma
> >
> >
> >
>
>
>




Mime
View raw message