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

A fix for this issue for SAS Financial Management 5.1_M2 is available at: