SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Could not Launch the SQL Power Architect-XML parsing error in project file  XML
Forum Index » SQL Power Architect Technical Support
Author Message
Ineedsqlhelpplease


Joined: 2011-10-31 15:10:20
Messages: 1
Offline

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

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

Christiaan


Joined: 2016-01-07 03:38:15
Messages: 1
Offline

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


[Thumb - 1.PNG]
 Filename 1.PNG [Disk] Download
 Description
 Filesize 23 Kbytes
 Downloaded:  2208 time(s)

Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline

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




 
Forum Index » SQL Power Architect Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team