INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Pervasive.SQL v9.6 (PCC Cannot Open)

Pervasive.SQL v9.6 (PCC Cannot Open)

(OP)
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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

(OP)
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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

Rgds,
SeisaT

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

(OP)
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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

(OP)
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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

(OP)
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

RE: Pervasive.SQL v9.6 (PCC Cannot Open)

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

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close