Pervasive.SQL v9.6 (PCC Cannot Open) 1

[SeisaT]

Hello Mirtheil,

"You really should start a new thread.
This sounds like an install issue where one (or more) of the PSQL components did not register correctly. You should uninstall, reboot, reinstall. You should also make sure you have the latest Java Runtime installed."

First of all, I thought the thread was not that old and was about PVSW v9.6. I'm sorry.

If this is really about some component not registering correctly, I would like to know how to re-register the component. I did the "URR" thing about three times and still runs into the same problem. The Java version turns out to be 1.6.0_03 and this was pushed to my PC just before I did the second reinstall. What is supposed to be the latest version of Java?

Any more thoughts?

Rgds,
SeisaT

 

[mirtheil]

The thread may have been about 9.6 but wasn't about the issue you are having.
Java 1.6 should be fine.
An uninstall/reinstall should have fixed any problems with a component registering unless there's something else wrong with your system.

A few questions:
- What OS are you using?
- Are you installing in a Terminal Server / Remote Desktop session?
- Are you running the install as an Administrator?

As far as registering components, you might try to register PSSAX.DLL to see if it helps. THat's the Pervasive XML parser.



Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SeisaT]

I am running Windows XP PRO 2002 SP2 and this is standalone on my laptop. Of course I am an Administrator.

What beats me is that the PVSW passed all tests and didn't run into any install complications.

How do I register this PSSAX.DLL component?

Rgds,
SeisaT

 

[mirtheil]

To register it, run the following command line: REGSVR32 <path >\PSSAX.DLL
where <path> is the path to the DLL (by default, it's C:\PVSW\BIN).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SeisaT]

I just registered the DLL file but it still didn't help. Any more thoughts?

Rgds,
SeisaT

 

[mirtheil]

Can you post more of the log file where the error occurs?
Is it just the PCC that's failing? Is everything else working correctly?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SeisaT]

Certainly. Yes it's the PCC that fails to load and hence I cannot create new database for Accpac 5.4 which requires the databases to be first created in PCC.

Here is the logfile contents (and I'm sorry it's this big):

!SESSION Jan 23, 2008 17:09:44.678 ---------------------------------------------
eclipse.buildId=I200406251208
java.version=1.3.1_01
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

!ENTRY org.eclipse.osgi Jan 23, 2008 17:09:44.678
!MESSAGE Error registering XML parser services.
!STACK 0
java.lang.ClassNotFoundException: javax.xml.parsers.SAXParserFactory
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
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 org.eclipse.core.runtime.adaptor.EclipseAdaptor.registerEndorsedXMLParser(EclipseAdaptor.java:272)
at org.eclipse.core.runtime.adaptor.EclipseAdaptor.frameworkStart(EclipseAdaptor.java:253)
at org.eclipse.osgi.framework.internal.core.SystemBundleActivator.start(SystemBundleActivator.java:61)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:958)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:954)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:937)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:553)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:477)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:273)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.launch(StartLevelManager.java:243)
at org.eclipse.osgi.framework.internal.core.SystemBundle.resume(SystemBundle.java:166)
at org.eclipse.osgi.framework.internal.core.Framework.launch(Framework.java:425)
at org.eclipse.osgi.framework.internal.core.OSGi.launch(OSGi.java:51)
at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:216)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:127)
at java.lang.reflect.Method.invoke(Native Method)
at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)

!ENTRY org.eclipse.osgi Jan 23, 2008 17:09:44.709
!MESSAGE Startup error
!STACK 1
java.lang.NoClassDefFoundError: org/xml/sax/helpers/DefaultHandler
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at org.eclipse.core.runtime.adaptor.PluginConverterImpl.parsePluginInfo(PluginConverterImpl.java:557)
at org.eclipse.core.runtime.adaptor.PluginConverterImpl.fillPluginInfo(PluginConverterImpl.java:111)
at org.eclipse.core.runtime.adaptor.PluginConverterImpl.convertManifest(PluginConverterImpl.java:660)
at org.eclipse.core.runtime.adaptor.EclipseBundleData.generateManifest(EclipseBundleData.java:233)
at org.eclipse.core.runtime.adaptor.EclipseBundleData.loadManifest(EclipseBundleData.java:191)
at org.eclipse.core.runtime.adaptor.EclipseBundleData.getManifest(EclipseBundleData.java:159)
at org.eclipse.core.runtime.adaptor.EclipseBundleData.loadFromManifest(EclipseBundleData.java:280)
at org.eclipse.osgi.framework.internal.defaultadaptor.DefaultBundleData.initializeNewBundle(DefaultBundleData.java:77)
at org.eclipse.osgi.framework.internal.defaultadaptor.DefaultAdaptor$1.begin(DefaultAdaptor.java:451)
at org.eclipse.osgi.framework.internal.core.Framework.installWorkerPrivileged(Framework.java:746)
at org.eclipse.osgi.framework.internal.core.Framework$2.run(Framework.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.Framework.installWorker(Framework.java:715)
at org.eclipse.osgi.framework.internal.core.Framework.installBundle(Framework.java:659)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.installBundle(BundleContextImpl.java:219)
at org.eclipse.core.runtime.adaptor.EclipseStarter.installBundles(EclipseStarter.java:800)
at org.eclipse.core.runtime.adaptor.EclipseStarter.loadBasicBundles(EclipseStarter.java:429)
at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:222)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:127)
at java.lang.reflect.Method.invoke(Native Method)
at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
at org.eclipse.core.launcher.Main.run(Main.java:704)
at org.eclipse.core.launcher.Main.main(Main.java:688)

!ENTRY org.eclipse.osgi Jan 23, 2008 17:09:44.725
!MESSAGE Bundle initial@reference:file:c:/PVSW/bin/plugins/org.eclipse.core.runtime_3.0.1/ [1] was not resolved.


I hope it makes sense. When I view the loaded pervasive modules using PSA, it shows quite a number of dll files, including the pssax, "not loaded" (not that I know if it means anything)

I hope this helps. I am really desperate as I cannot work on my clients' data problems from my office.

Rgds,
SeisaT

 

[mirtheil]

Your problem is the JRE:
java.version=1.3.1_01
You need the JRE 1.5 or later installed. Update your JRE and it should work.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SeisaT]

I am quite confused with conflicting reports coming from the logfile reporting JRE v1.3.1_01 whereas the Java Control panel as well as the Support Info dialog box reporting the version of JRE as 1.6.0_03. Which one is telling the truth about the current JRE version? Can there be conflicting versions and if so how do I get rid of the other?

My PC gets the latest Java updates automatically from the Windows Update.

I am really lost.

Rgds,
SeisaT

 

[mirtheil]

The PCC is finding an old JRE. It's probably in your system
path somewhere before the current JRE.
You can also check out the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment
It'll have the "CurrentVersion" setting and then it'll look for a subkey based on that.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SeisaT]

Hi Mirtheil,

I happened to be running an Oracle-based programme and it turned out that it was running an old version of JRE, 1.3.1_01. This I found out in the PATH, Environment Variables.

Thanks, I admire your patience. You have been of great help.

Rgds,
SeisaT

 

[mirtheil]

Thanks for the star. Glad it's all working now.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com