Loading model data to a cycle might fail if you specify a multiplier with more than two decimal places in SAS^® Financial Management Studio's Load Model Data wizard.

If the load is not successful, you will likely see the message:

Nothing was loaded.  See the log for more information.

and an error similar to the following will be written to the client log:

[main][ERRORSeedCycleWizard] -
java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sas.solutions.webservice.WebServiceServlet.doPost(WebServiceServlet.java:218)
at com.sas.solutions.webservice.AppStateAwareWebServiceServlet.doPost(AppStateAwareWebServiceServlet.java:33)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(Unknown Source)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.rmi.RemoteException: EJB Exception: ; nested exception is:
javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: org.hibernate.exception.DataException: Could not execute JDBC batch update
at weblogic.ejb.container.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeUtils.java:103)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:860)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:809)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:514)
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:60)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvokeTxRetry(BaseRemoteObject.java:441)
at com.sas.solutions.finance.models.cycle.ejb.CycleSeedingBean_8uf27q_EOImpl.seedCycle(CycleSeedingBean_8uf27q_EOImpl.java:75)
... 20 more
Caused by: javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: org.hibernate.exception.DataException: Could not execute JDBC batch update
at weblogic.ejb.container.internal.EJBRuntimeUtils.throwTransactionRolledbackLocal(EJBRuntimeUtils.java:238)
at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:864)
at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:791)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:486)
at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:424)
at com.sas.solutions.finance.models.data.ejb.DataLoadManager_79smk0_ELOImpl.update(DataLoadManager_79smk0_ELOImpl.java:1184)
at com.sas.solutions.finance.models.cycle.ejb.CycleSeedingBean.seedCycle(CycleSeedingBean.java:396)
at com.sas.solutions.finance.models.cycle.ejb.CycleSeedingBean_8uf27q_EOImpl.seedCycle(CycleSeedingBean_8uf27q_EOImpl.java:61)
... 20 more
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
at com.sas.solutions.finance.models.data.persistence.DataLoadHome.findByPrimaryKey(DataLoadHome.java:130)
at com.sas.solutions.finance.models.data.ejb.DataLoadManagerBean.update(DataLoadManagerBean.java:167)
at com.sas.solutions.finance.models.data.ejb.DataLoadManager_79smk0_ELOImpl.update(DataLoadManager_79smk0_ELOImpl.java:1169)
... 22 more
Caused by: java.sql.BatchUpdateException: Data truncation: Data truncated for column 'MULTIPLICATION_FACTOR' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1093)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:843)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:191)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 33 more

at com.sas.solutions.j2ee.client.ExceptionWrapper.readExternal(ExceptionWrapper.java:88)
at java.io.ObjectInputStream.readExternalData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readObject(Unknown Source)
at com.sas.solutions.j2ee.client.WebServiceBaseDelegate.executeMethod(WebServiceBaseDelegate.java:245)
at com.sas.solutions.finance.models.cycle.ejb.services.http.CycleSeedingBeanHttpService.seedCycle(CycleSeedingBeanHttpService.java:23)
at com.sas.solutions.finance.models.cycle.client.CycleSeedingBeanDelegate.seedCycle(CycleSeedingBeanDelegate.java:78)
at com.sas.solutions.finance.rcp.models.internal.ui.wizards.seedcycle.SeedCycleWizard.seedCycle(SeedCycleWizard.java:337)
at com.sas.solutions.finance.rcp.models.internal.ui.wizards.seedcycle.SeedCycleWizard.run(SeedCycleWizard.java:274)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
 

The SAS Financial Management client log is typically found in the

<installdrive>:\Program Files\SAS\SASFinancialManagementStudio\5.1

directory.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Financial Management	Microsoft® Windows® for x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2003 Datacenter Edition	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2003 Enterprise Edition	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2003 Standard Edition	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2003 for x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2008	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows Server 2008 for x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Microsoft Windows XP Professional	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Enterprise 32 bit	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Enterprise x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Professional 32 bit	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Professional x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Ultimate 32 bit	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows 7 Ultimate x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows Vista	5.1	5.2	9.2 TS2M2	9.2 TS2M2
		Windows Vista for x64	5.1	5.2	9.2 TS2M2	9.2 TS2M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Problem Note
Priority:	medium

Date Modified:	2010-09-21 16:43:28
Date Created:	2010-09-09 14:08:38