Esb Administration Console example - problem

[rukus]

I've trying to complete this demo
http://labs.jboss.com/jbossesb/resources/tutorials/xformation-demos/console-demo-01.html
but when i finish setup trnsformation and trying to test it there is exception:

Transformation Exception...

org.milyn.SmooksException: Unable to filter InputStream for target profile [org.milyn.profile.Profile#OPEN_PROFILE_NAME].

Check Java console.

NOTE: This particular error was caused by a org.xml.sax.SAXParseException exception which can result from attempting to parse the incomming message with the wrong SAX Parser. If the message is not an XML message, you must specify an appropriate parser.

where i've got mistake?

[rukus]

P.S. i've used: jboss-4.2.1.ga & jboss-esb-4.2.GA

[tfennelly]

And you've configured the CSV parser for the message transform? You can see whether or not the parser is configured by visiting the "Manage Configurations" screen.

[rukus]

"tfennelly" wrote:
And you've configured the CSV parser for the message transform? You can see whether or not the parser is configured by visiting the "Manage Configurations" screen.

yes
http://img409.imageshack.us/my.php?image=esbadminfw6.jpg

[rukus]

i've used such params:
hsqldb
jbossfaces

There is exceptions:
web error page:

java.lang.NullPointerException
at com.sun.facelets.util.DevTools.writeVariables(DevTools.java:168)
at com.sun.facelets.util.DevTools.writeVariables(DevTools.java:144)
at com.sun.facelets.util.DevTools.debugHtml(DevTools.java:135)
at com.sun.facelets.tag.ui.UIDebug.writeDebugOutput(UIDebug.java:92)
at com.sun.facelets.tag.ui.UIDebug.encodeBegin(UIDebug.java:81)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:571)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:74)
at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

Server log:
http://www.mediafire.com/?dm14ii2smd0

[tfennelly]

It appears as though things started going wrong long before that stack trace. You're getting the following hibernate/hsqldb error on startup:

17:14:54,812 INFO [SchemaExport] Running hbm2ddl schema export
17:14:54,859 INFO [SchemaExport] exporting generated schema to database
17:14:55,078 INFO [SchemaExport] Executing import script: /import.sql
17:14:55,078 ERROR [SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution
 at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:258)
 at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192)
 at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
 at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:311)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
 at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
 at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
 at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
 at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:354)
 at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
 at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
 at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
Caused by: java.sql.SQLException: Table not found in statement [delete from participant]
 at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:84)
 at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)
 ... 11 more

Sorry about this. I'll need to take a look at this locally. There's a JIRA issue logged against this for some time now. There was little or no interest in this for a long time, but it appears to have increased of late.

[tfennelly]

Sorry, after post that last trace I see it's nothing to do with the console :-) The one that follows it in the log does though....

17:15:37,312 ERROR [SeamPhaseListener] uncaught exception
java.lang.RuntimeException: org.dom4j.DocumentException: Connection timed out: connect Nested exception: Connection timed out: connect
 at org.jboss.seam.core.Pages.getDocumentRoot(Pages.java:795)
 at org.jboss.seam.core.Pages.parse(Pages.java:760)
 at org.jboss.seam.core.Pages.initialize(Pages.java:99)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

Not sure if this is causing any issues, but things are obviously not happy there.