SQL Power Software Forum

This message was edited 4 times. Last update was at 2011-10-31 18:07:27

So I'm sorry if this has been answered before I did a quick skim, but probably not the most thorough.
It should be noted that I am very new to SQL and Power Architect. I'm working on a simple project in which we are simply improving a classmates logical model. While completing this process I somehow messed things up huge. I get the following error code-

"Could Not Launch the SQL Power Architect

Exception type: ca.sqlpower.sqlobject.SQLObjectException

Detail string: There is an XML parsing error in project file at LIne:9 Column:41

Root Cause: Error at (9, 41:null

Followed by...

ca.sqlpower.sqlobject.SQLObjectException: There is an XML parsing error in project file at Line:9 Column:41
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:209)
at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:195)
at ca.sqlpower.architect.swingui.ArchitectSwingSessionContextImpl.createSession(ArchitectSwingSessionContextImpl.java:211)
at ca.sqlpower.architect.swingui.ArchitectFrame$11.run(ArchitectFrame.java:819)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException; lineNumber: 9; columnNumber: 41; Error at (9, 41: null
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
at org.apache.commons.digester.Digester.startElement(Digester.java:1276)
at ca.sqlpower.xml.UnescapingDefaultHandler.startElement(UnescapingDefaultHandler.java:235)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at ca.sqlpower.xml.UnescapingXMLReader.parse(UnescapingXMLReader.java:99)
at org.apache.commons.digester.Digester.parse(Digester.java:1567)
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:19

... 17 more
Caused by: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLDatabase.setDataSource(SQLDatabase.java:464)
at ca.sqlpower.architect.ProjectLoader$TargetDBFactory.createObject(ProjectLoader.java:472)
at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:429)
at org.apache.commons.digester.Digester.startElement(Digester.java:1273)
... 31 more

Anyone have any ideas on A. What I did wrong? B. How to fix it?

Thank you for help.

Edit: where the emoticon appears should read (ProjectLoader.java:198.) (without the period after the 8.)

Edit 2: Trying to attach files, but Attach Files Button is not responding, not sure if I lack sufficient clearance to post files, but if anyone is able to help I can send those to you.

After searching some more, it seems that this solution might be some help
http://www.sqlpower.ca/forum/posts/list/2136.page

However I am still struggling a bit in finding the empty table-ref

I am using:
SQL Power Architect 1.0.6
Operating System:
Windows 7 6.1 (x86)
Runtime Environment:
Java(TM) SE Runtime Environment
1.7.0_05-b05
VM info:
Java HotSpot(TM) Client VM
23.1-b03
Oracle Corporation
Memory:
41MiB allocated (580MiB max); 17MiB free

I get error:
Image attatched

Details:
ca.sqlpower.sqlobject.SQLObjectException: There is an XML parsing error in project file at Line:213 Column:187
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:23

at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:223)
at ca.sqlpower.architect.swingui.action.OpenProjectAction$LoadFileWorker.doStuff(OpenProjectAction.java:21

at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at ca.sqlpower.architect.swingui.action.OpenProjectAction$1.open(OpenProjectAction.java:87)
at ca.sqlpower.architect.swingui.ArchitectFrame$18.loadFile(ArchitectFrame.java:912)
at ca.sqlpower.swingui.RecentMenu.openFile(RecentMenu.java:129)
at ca.sqlpower.swingui.RecentMenu$1.actionPerformed(RecentMenu.java:14

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException; lineNumber: 213; columnNumber: 187; Error at (213, 187: Index: 4, Size: 3
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
at org.apache.commons.digester.Digester.endElement(Digester.java:1061)
at ca.sqlpower.xml.UnescapingDefaultHandler.endElement(UnescapingDefaultHandler.java:151)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at ca.sqlpower.xml.UnescapingXMLReader.parse(UnescapingXMLReader.java:99)
at org.apache.commons.digester.Digester.parse(Digester.java:1567)
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:222)
... 45 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 4, Size: 3
at java.util.ArrayList.rangeCheckForAdd(Unknown Source)
at java.util.ArrayList.add(Unknown Source)
at ca.sqlpower.sqlobject.SQLIndex.addIndexColumn(SQLIndex.java:1016)
at ca.sqlpower.sqlobject.SQLIndex.addChildImpl(SQLIndex.java:673)
at ca.sqlpower.object.AbstractSPObject.addChild(AbstractSPObject.java:105)
at ca.sqlpower.sqlobject.SQLObject.addChild(SQLObject.java:38

at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
at org.apache.commons.digester.Rule.end(Rule.java:276)
at org.apache.commons.digester.Digester.endElement(Digester.java:105

... 59 more

Hi Christiaan,

Did you did any changes to pl.ini? pl.ini file is created when you launch Architect 1st time and stored under user. If you have done any changes and not sure the just rename pl.ini to something else (e.g.pl_old.ini) or you can delete it. In both cases you have to recreate your database connections.
another option is you can try the latest version of Architect.

-Kirti