XML to SQL

[Former Community Member]

I am attempting to use the Avoka XMLtoSQL QPac in order to insert multiple rows of data into a MS SQL server db. I am not sure what is meant by the use of the # to indicate the index of the repeating element.



Has anyone an idea? (Howard?)



I have specified the repeating element xpath. I understand that the parameters that are specified are appended onto the repeating element path. When I run the process nothing appears either in the stalled branch or in the database.



Any tips would be appreciated.



Thanks,



NKP

[HowardTreisman]

Hi NKP

Please turn on debugging.

If you're using Jboss, that means finding the file: C:\Adobe\LiveCycle\jboss\server\all\conf\log4j.xml, and modifying the threshold value shown below in bold

<appender name="FILE" class="org.jboss.logging.appender.DailyRollingFileAppender">

<errorHandler class="org.jboss.logging.util.OnlyOnceErrorHandler"/>

<param name="File" value="${jboss.server.home.dir}/log/server.log"/>

<param name="Threshold" value="
DEBUG"/>



Then please invoke the process, and post the relevant part of the log file. This should give us some clues. If the file is large, you can send it to support-at-avoka.com



My apologies for your difficulties, this QPAC isn't properly documented. We'll try to address that as soon as possible.



Howard

http://www.avoka.com

[Former Community Member]

Well at least I managed to get it to stall. Here is the log where it errors on the XMLtoSQL QPac. I am sure it has to do with how I configured the Input settings. <br /><br />Thx<br />NKP<br /><br />2007-03-07 11:00:02,189 DEBUG [com.adobe.workflow.AWS] com.adobe.workflow.engine.PEUtil.executeAction completed invocation of QPAC: XML2SQL<br />2007-03-07 11:00:02,189 DEBUG [com.avoka.workflow.qpac.xml2sql.XML2SQLService] com.avoka.workflow.qpac.xml2sql.XML2SQLService.execute [PID:3715] Entering<br />2007-03-07 11:00:02,189 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,189 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@e8a14{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,189 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,189 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@1890fdd{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,205 INFO [STDOUT] Evaluation license for product: [XML2SQL]. Organization: [null]. Invocations remaining: [100], minutes remaining: [360]<br />2007-03-07 11:00:02,205 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,205 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@4d8ef7{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,205 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,205 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@17c306a{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,220 DEBUG [com.avoka.workflow.qpac.xml2sql.XML2SQLService] com.avoka.workflow.qpac.xml2sql.XML2SQLService.execute [PID:3715] Error occurred, attempting to roll back transaction for direct JDBC connection <br />2007-03-07 11:00:02,220 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,220 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@1a7705f{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,236 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null<br />2007-03-07 11:00:02,236 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] setRepository, r=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1a40fff, ucl=org.jboss.mx.loading.UnifiedClassLoader3@1fa486{ url=null ,addedOrder=0}<br />2007-03-07 11:00:02,236 ERROR [com.avoka.workflow.qpac.xml2sql.XML2SQLService] QPAC.XML2SQL.1: [PID:3715] Unexpected exception.<br />org.jaxen.XPathSyntaxException: Expected one of '.', '..', '@', '*', <QName><br /> at org.jaxen.BaseXPath.<init>(BaseXPath.java:136)<br /> at org.jaxen.BaseXPath.<init>(BaseXPath.java:159)<br /> at org.jaxen.dom.DOMXPath.<init>(DOMXPath.java:99)<br /> at com.adobe.workflow.jaxen.dom.DefaultDOMXPath.<init>(DefaultDOMXPath.java:43)<br /> at com.adobe.workflow.pat.service.PATExecutionContextImpl.getProcessDataValue(PATExecutionContextImpl.java:269)<br /> at com.avoka.workflow.qpac.xml2sql.XML2SQLService.execute(Unknown Source)<br /> at com.adobe.workflow.engine.PEUtil.executeAction(PEUtil.java:184)<br /> at com.adobe.workflow.engine.ProcessEngineBMTBean.continueBranchAtAction(ProcessEngineBMTBean.java:2371)<br /> at com.adobe.workflow.engine.ProcessEngineBMTBean.asyncContinueBranchCommand(ProcessEngineBMTBean.java:1836)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:324)<br /> at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)<br /> at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)<br /> at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)<br /> at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)<br /> at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)<br /> at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)<br /> at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)<br /> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)<br /> at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)<br /> at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)<br /> at org.jboss.ejb.Container.invoke(Container.java:723)<br /> at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:359)<br /> at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)<br /> at $Proxy252.asyncContinueBranchCommand(Unknown Source)<br /> at com.adobe.workflow.engine.ProcessCommandControllerBean.onMessage(ProcessCommandControllerBean.java:115)<br /> at sun.reflect.GeneratedMethodAccessor266.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:324)<br /> at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:458)<br /> at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)<br /> at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:62)<br /> at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)<br /> at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)<br /> at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)<br /> at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:90)<br /> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)<br /> at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:372)<br /> at org.jboss.ejb.Container.invoke(Container.java:723)<br /> at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:914)<br /> at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1208)<br /> at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:276)<br /> at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:871)<br /> at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:159)<br /> at org.jboss.mq.SpySession.run(SpySession.java:347)<br /> at org.jboss.jms.asf.StdServerSession.run0(StdServerSession.java:200)<br /> at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)<br /> at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)<br /> at java.lang.Thread.run(Thread.java:534)

[HowardTreisman]

All

This has been fixed by direct communication.

If anyone watching this thread needs more info, please contact support-at-avoka.com

Howard

http://www.avoka.com