User b505cabb69
10-08-2009 18:59:04
We get the anerror when we click Add/Edit button on the JChem tab of JCHEM for Excel.
chemaxon/struc/PeriodicSystem Stack Trace dialog box
See document attached.
Once the problem starts, then reinstallation does not fix the problem.
System environment path:
C:\Program Files\ChemAxon\JChem\.\.install4j;c:\program files\java\jre6\bin;C:\Program Files\ChemAxon\JChem\bin;C:\oracle\product\11.1.0\db_1\bin;C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IronPython\;C:\Program Files\python24\;C:\Program Files\OpenBabel-2.2.0
IJCHEM version:2.5.2
Jchem4 excel 1.1.0
Windows XP sp3, Excel 2007, Marvin sketch 5.2.3_1
We can reproduce it on a second machine.Just delete C:\Program Files\ChemAxon\JChem\bin; from the windows system path and restart Excel.
If you add it back to the system path, then the problem does not go away-- even if you reboot.
ChemAxon 0e37943a96
11-08-2009 06:30:17
Hi,
in JChem for Excel we use an integrated Marvin Applet distributed with the installer. So it works without any other ChemAxon applications present. It is deployed under the JChem for Excel installation folder, in your case it is probably C\Program
Files\ChemAxon\JChemFor Excel\Applet. It normally resolves the classes needed from the sjars folder, where actually periodicsystem.jar containing the missing class from your error message should be present. The applet editor should not be influenced by any path settings.
We normally test on completely clean virtual machines, and virtual machines having Marvin Beans present.
We will check how the presence of JChem Instant JChem, or the deletion of C:\Program Files\ChemAxon\JChem\bin from the system path affects this. Does the problem come on machines having Marvin Sketch, JChem and even Instant JChem present?
As an alternative you could try the Marvin Ole editor, which uses Marvin Beans (I see it is present on your system). You could change this, under Options\Structure Editor.
I also recommend to use JChem for Excel 1.1.1 which contains numerous fixes fro the structre drawing.
With the 1.1.4 version in November, we will switch to the Marvin.NET editor, so hopefully these problems will go away. :).
Regards,
Tamas Pelcz.
User b505cabb69
12-08-2009 14:15:36
We are using 1.1.1.
In the meantime, we can't use jchem4excel anymore. Is there a way we can get it to start working again?
ChemAxon 0e37943a96
12-08-2009 15:15:31
Hi,
please follow these steps to re-enable the add-in:
Source: http://msdn.microsoft.com/en-us/library/ms268871(VS.80).aspx
To re-enable an add-in that has been soft disabled
by Excel 2007, PowerPoint 2007, or Word 2007
In the application, click the Microsoft Office Button.
Click the <ApplicationName> Options button.
In the categories pane, click Add-ins.
In the details pane, locate the add-in in the Inactive Application
Add-ins list.
The Name column specifies the name of the assembly, and the
Location column specifies the full path of the application manifest.
In the Manage box, click COM Add-ins, and then click
Go.
In the COM Add-Ins dialog box, select the check box next to the
disabled add-in.
Click OK.
Best regards,
Tamas.
User b505cabb69
13-08-2009 11:22:58
We are using 1.1.1 version.
Both machines were working normally and then we got the described problem on one machine.
The way I was able to duplicate the problem on the 2nd machine was by changing the windows path and then putting it back to the way it was.
Now we cannot get either machine to work even if we do an uninstall and reinstall and re-enabling the Excel add-ins as you described.
It almost seems like it is a dll/ registratrion problem, but I am not familiar.
Granted, we have more than just Excel and JChem4excel loaded on these computers; but because they were working and then stopped, then this is the problem we are hoping to figure out.
ChemAxon 0e37943a96
13-08-2009 15:06:59
Hi,
the installer should remove all JChem for Excel related registry settings. We cannot really influence that, it is how Windows Installer works.
After you uninstall there should be no JChem for Excel related add-in listed in Excel 2007.
After Install you should see the following among Active Application Add-Ins:
JChemExcel Functions - COM Add-In
JChemExcel JChemExcelAddin - Excel Add-In
These should all point to JChemExcel.COMShim.dll.
You could also check the following registry keys:
HKLM\SOFTWARE\Office\Excel\AddIns\JChemExcel.JChemExcelAddin\LoadBehavior
should be 3.
There should not be a key like:
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Resiliency\DisabledItems]
Have you performed the installation with Administrator, or an user with restricted rights?
Do you have other Excel Add-Ins?
If you would require a hands on assistance, we could schedule a date for next week (Monday, Tuesday or Wednesday). We use GoToMeeting, which allows screen sharing, and remote control of mouse and keyboard.
Regards,
Tamas.
PS: If you prefer you could reply by mail (if you do not want to share some data on the forum). I wrote an e-mail messge to you yesterday.
ChemAxon 6e93227fcc
20-08-2009 15:06:06
Hi,
I had the same error on my development machine. Can you try out if you get the same error for the applet also for one of our online examples?
If you also get the error please uninstall your JRE 1.6U16 and install a previous version. It might be a bug for our java applet related JRE 1.6U16 combined with IE.
Please let us know the results.
Calin.
P.S. For older JRE versions check http://java.sun.com/products/archive/.