[JohnWright]

I've had some trouble today when I update the accessorial costs for the week. Under power data>rates and codes>accessorial costs, after changing the expiration date and clicking finish, I get the following error:

Generic_Remote_Exception



javax.transaction.TransactionRolledbackException: Exception in ejbStore:: glog.util.exception.RemoteExceptionWrapper [ERROR] RECharge.ctor(Owner = RateGeoCostBean.TMS.RF_20080115091805_FSC_BRIL_LTL _ST_20080114_1): Exception caught: java.lang.NullPointerException java.lang.NullPointerException at glog.business.rate.rateengine.ElementDef.equals(El ementDef.java:249) at glog.business.rate.rateengine.ElementDef.isCompati bleWith(ElementDef.java:22 at glog.business.rate.rateengine.MethodOperand.isComp atibleWith(MethodOperand.java:119) at glog.business.rate.rateengine.RECharge.isCompatibl eWith(RECharge.java:1233) at glog.business.rate.rateengine.RECharge.(RECharge.j ava:1085) at glog.ejb.rates.AccessorialCostBean.checkConstraint s(AccessorialCostBean.java:74) at glog.util.remote.BaseEntityBean.preStore(BaseEntit yBean.java:82) at glog.util.remote.BaseEntityBean$3.pre(BaseEntityBe an.java:475) at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:755) at glog.util.remote.BaseEntityBean.ejbStore(BaseEntit yBean.java:474) at glog.ejb.rates.AccessorialCostBean_6kwys8_Impl.ejb Store(AccessorialCostBean_6kwys8_Impl.java:147) at weblogic.ejb20.manager.ExclusiveEntityManager.post Invoke(ExclusiveEntityManager.java:495) at weblogic.ejb20.internal.BaseEJBObject.postInvoke(B aseEJBObject.java:210) at glog.ejb.rates.AccessorialCostBean_6kwys8_EOImpl.t xPostInvoke(AccessorialCostBean_6kwys8_EOImpl.java :34) at glog.ejb.rates.AccessorialCostBean_6kwys8_EOImpl.s etData(AccessorialCostBean_6kwys8_EOImpl.java:992) at java.lang.reflect.Method.invoke(Native Method) at glog.util.remote.BeanBaseInvoker.invoke(BeanBaseIn voker.java:24) at glog.util.remote.EntityBeanInvoker.setData(EntityB eanInvoker.java:50) at glog.util.persistence.EjbPersistenceExecutor.inser tUpdatePerformed(EjbPersistenceExecutor.java:123) at glog.util.persistence.PersistenceExecutor.persiste ncePerformed(PersistenceExecutor.java:93) at glog.util.persistence.InsertUpdate.doPersist(Inser tUpdate.java:82) at glog.util.persistence.InsertUpdate.persist(InsertU pdate.java:6 at glog.util.persistence.PersistenceManager.execute(P ersistenceManager.java:100) at glog.util.genericcontainer.GenericContainerUtilSes sionBean.store(GenericContainerUtilSessionBean.jav a:33) at glog.util.genericcontainer.GenericContainerUtilSes sionBean.compareAndStore(GenericContainerUtilSessi onBean.java:96) at glog.util.genericcontainer.GenericContainerUtilSes sionBean_pja7ux_EOImpl.compareAndStore(GenericCont ainerUtilSessionBean_pja7ux_EOImpl.java:175) at glog.webserver.update.GenericContainerXMLUpdate.ca llGenericContainer(GenericContainerXMLUpdate.java: 355) at glog.webserver.update.GenericContainerXMLUpdate.Page Ranking ocess(GenericContainerXMLUpdate.java:150) at glog.server.xmlupdate.XMLUpdateSessionBean.updateA ndTrack(XMLUpdateSessionBean.java:212) at glog.server.xmlupdate.XMLUpdateSessionBean_yl7npx_ EOImpl.updateAndTrack(XMLUpdateSessionBean_yl7npx_ EOImpl.java:175) at glog.server.xmlupdate.XMLUpdateSessionBean_yl7npx_ EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.activation.ActivatableServer Ref.invoke(ActivatableServerRef.java:87) at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:313) at weblogic.security.service.SecurityServiceManager.r unAs(SecurityServiceManager.java:821) at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:30 at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:213) at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:189) at glog.business.rate.rateengine.RECharge.(RECharge.j ava:1220) at glog.ejb.rates.AccessorialCostBean.checkConstraint s(AccessorialCostBean.java:74) at glog.util.remote.BaseEntityBean.preStore(BaseEntit yBean.java:82) at glog.util.remote.BaseEntityBean$3.pre(BaseEntityBe an.java:475) at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:755) at glog.util.remote.BaseEntityBean.ejbStore(BaseEntit yBean.java:474) at glog.ejb.rates.AccessorialCostBean_6kwys8_Impl.ejb Store(AccessorialCostBean_6kwys8_Impl.java:147) at weblogic.ejb20.manager.ExclusiveEntityManager.post Invoke(ExclusiveEntityManager.java:495) at weblogic.ejb20.internal.BaseEJBObject.postInvoke(B aseEJBObject.java:210) at glog.ejb.rates.AccessorialCostBean_6kwys8_EOImpl.t xPostInvoke(AccessorialCostBean_6kwys8_EOImpl.java :34) at glog.ejb.rates.AccessorialCostBean_6kwys8_EOImpl.s etData(AccessorialCostBean_6kwys8_EOImpl.java:992) at java.lang.reflect.Method.invoke(Native Method) at glog.util.remote.BeanBaseInvoker.invoke(BeanBaseIn voker.java:24) at glog.util.remote.EntityBeanInvoker.setData(EntityB eanInvoker.java:50) at glog.util.persistence.EjbPersistenceExecutor.inser tUpdatePerformed(EjbPersistenceExecutor.java:123) at glog.util.persistence.PersistenceExecutor.persiste ncePerformed(PersistenceExecutor.java:93) at glog.util.persistence.InsertUpdate.doPersist(Inser tUpdate.java:82) at glog.util.persistence.InsertUpdate.persist(InsertU pdate.java:6 at glog.util.persistence.PersistenceManager.execute(P ersistenceManager.java:100) at glog.util.genericcontainer.GenericContainerUtilSes sionBean.store(GenericContainerUtilSessionBean.jav a:33) at glog.util.genericcontainer.GenericContainerUtilSes sionBean.compareAndStore(GenericContainerUtilSessi onBean.java:96) at glog.util.genericcontainer.GenericContainerUtilSes sionBean_pja7ux_EOImpl.compareAndStore(GenericCont ainerUtilSessionBean_pja7ux_EOImpl.java:175) at glog.webserver.update.GenericContainerXMLUpdate.ca llGenericContainer(GenericContainerXMLUpdate.java: 355) at glog.webserver.update.GenericContainerXMLUpdate.Page Ranking ocess(GenericContainerXMLUpdate.java:150) at glog.server.xmlupdate.XMLUpdateSessionBean.updateA ndTrack(XMLUpdateSessionBean.java:212) at glog.server.xmlupdate.XMLUpdateSessionBean_yl7npx_ EOImpl.updateAndTrack(XMLUpdateSessionBean_yl7npx_ EOImpl.java:175) at glog.server.xmlupdate.XMLUpdateSessionBean_yl7npx_ EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.activation.ActivatableServer Ref.invoke(ActivatableServerRef.java:87) at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:313) at weblogic.security.service.SecurityServiceManager.r unAs(SecurityServiceManager.java:821) at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:30 at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30) at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:213) at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:189) ; nested exception is: glog.util.exception.RemoteExceptionWrapper

Any suggestions would be helpful.

Thanks,

John

[bmj_23]

John - if you get a chance, turn on the SQL logs and try the same action in the UI. Take a look at the SQL statement that is being issued when you try to make this change via the UI and then post that on here. Is this a process that you have run before without any issues ?

[JohnWright]

I'm sorry, but I'm very new to this, but how do I turn on the SQL logs and yes, I was able to run this process before with no problems. Errors started occuring the past few weeks.

[bmj_23]

Under Configuration and Administration > Power Data > General > Log Files, run a search. You should see a log file that corresponds to your user - if not, you can create a new one (log file type = user and
log id = your user name without the domain specified).

In the Log file Details component of the screen, you can choose those elements of the application you want your log file to include. For now, I would add SQL - if you then log out, log back in again and re-run the action from the UI, you should see more details in your log file.

Basically, your issue seems to be with updating the rate record TMS.RF_20080115091805_FSC_BRIL_LTL _ST_20080114_1 but until we dig in to more detail, its hard to nail down the exact error.