Problem Note 40537: 'Nothing was loaded' message displayed when loading driver rates
 |  |  |  |  |
When loading driver rates in SAS® Financial Management Studio, you might receive the message
Nothing was loaded
If the <misc_rate> table in the CrossIndustryDDS library includes a key value for a dimension member that is either not valid or is not included in the SAS Financial Management cycle, then no records are loaded when you load driver rates in SAS Financial Management Studio.
The SASFinancialManagement5.1.log will contain errors that indicate that a duplicate entry is found.
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '7-3019-0,0,0,765,0' for key 2
The SAS Financial Management client log will contain a java error similar to the following:
Excerpt from the client log:
08-06 11:34:42,109 [main][ERRORLoadDriverRatesWizard] -
com.sas.solutions.finance.models.FinanceClientException: java.rmi.RemoteException: javax.ejb.EJBException; nested exception is:
java.lang.ClassNotFoundException: javax.ejb.EJBException
at com.sas.solutions.finance.models.data.client.JMSDelegate.sendToServer(JMSDelegate.java:194)
at com.sas.solutions.finance.models.data.client.JMSDelegate.load(JMSDelegate.java:286)
at com.sas.solutions.finance.models.data.client.PRateImportManagerDelegate.load(PRateImportManagerDelegate.java:63)
at com.sas.solutions.finance.models.data.client.PRateImportManagerDelegate.load(PRateImportManagerDelegate.java:84)
at com.sas.solutions.finance.rcp.rates.internal.ui.wizards.LoadDriverRatesWizard.loadRates(LoadDriverRatesWizard.java:203)
at com.sas.solutions.finance.rcp.rates.internal.ui.wizards.LoadDriverRatesWizard.run(LoadDriverRatesWizard.java:147)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.rmi.RemoteException: javax.ejb.EJBException; nested exception is:
java.lang.ClassNotFoundException: javax.ejb.EJBException
at com.sas.solutions.j2ee.client.WebServiceBaseDelegate.executeMethod(WebServiceBaseDelegate.java:312)
at com.sas.solutions.j2ee.client.WebServiceBaseDelegate.executeMethod(WebServiceBaseDelegate.java:171)
at com.sas.solutions.j2ee.client.WebServiceBaseDelegate.executeMethod(WebServiceBaseDelegate.java:166)
at com.sas.solutions.j2ee.client.WebServiceBaseDelegate.executeMethod(WebServiceBaseDelegate.java:91)
at com.sas.solutions.finance.models.data.client.JMSDelegate.getInvocationResponse(JMSDelegate.java:130)
at com.sas.solutions.finance.models.data.client.JMSDelegate.sendToServer(JMSDelegate.java:183)
... 6 more
Caused by: java.lang.ClassNotFoundException: javax.ejb.EJBException
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:481)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:397)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:385)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at java.io.ObjectInputStream.resolveClass(Unknown Source)
at java.io.ObjectInputStream.readNonProxyDesc(Unknown Source)
at java.io.ObjectInputStream.readClassDesc(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.readSerialData(Unknown Source)
at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
at java.io.ObjectInputStream.readSerialData(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)
... 11 more
For information on how to locate logs for SAS Financial Management, please refer to SAS Note 20058.
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_M2 | 5.2 | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 for x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 for x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Microsoft Windows XP Professional | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Enterprise 32 bit | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Enterprise x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Home Premium 32 bit | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Home Premium x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Professional 32 bit | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Professional x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Ultimate 32 bit | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
| Windows 7 Ultimate x64 | 5.1_M2 | 5.2 | 9.2 TS2M3 | |||
A fix for this issue for SAS Financial Management 5.1_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C50.html#40537| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-08-13 10:05:40 |
| Date Created: | 2010-08-06 11:49:31 |