[Anthill-pro] Remote scripting VS SOAP Api.

Steve Boone sbb at urbancode.com
Tue Mar 18 07:48:23 CST 2008 

Frederic,

This looks like IE put some crazy characters into the script that went into
the DB.

You will have to delete the entry from the database.

The SQL that you would want to run would be:

SELECT MAX(ID) FROM REPORT

DELETE FROM REPORT WHERE ID = ?

On 3/18/08, Frederic Jean <frederic.jean at ubisoft.com> wrote:
>
> I just tried to add the report you linked me as an example for testing and
> I got the following error while trying to save :
>
> I can't access the panel anymore and here is the error I get :
>
>
> PersistenceException: Error restoring object from database
>
> com.urbancode.anthill3.domain.persistent.PersistenceException: Error
> restoring object from database
>         at com.urbancode.anthill3.domain.persistent.DaoSql.restoreAll(
> DaoSql.java:386)
>         at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.restoreAll0(
> UnitOfWorkDefault.java:291)
>         at com.urbancode.anthill3.persistence.UnitOfWork.restoreAll(
> UnitOfWork.java:553)
>         at
> com.urbancode.anthill3.domain.reporting.ReportFactory.restoreAll(
> ReportFactory.java:50)
>         at
> com.urbancode.anthill3.web.admin.reporting.ReportingTasks.viewReportList(
> ReportingTasks.java:138)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at com.urbancode.anthill3.web.controller.ControllerServlet.doPost(
> ControllerServlet.java:313)
>         at com.urbancode.anthill3.web.controller.ControllerServlet.doGet(
> ControllerServlet.java:160)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:269)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at com.urbancode.anthill3.web.util.LicenseFilter.doFilter(
> LicenseFilter.java:78)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:215)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at com.urbancode.anthill3.web.util.SecurityFilter.doFilter(
> SecurityFilter.java:132)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:215)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(
> AuthorityFilter.java:67)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:215)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(
> DisableSessionUrlFilter.java:114)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:215)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(
> SecureSessionFilter.java:114)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:215)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:174)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:127)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:117)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:108)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:151)
>         at org.apache.coyote.http11.Http11Processor.process(
> Http11Processor.java:874)
>         at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:665)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:528)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:81)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:689)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: com.urbancode.anthill3.domain.persistent.PersistenceException:
> Error restoring object from database
>         at com.urbancode.anthill3.domain.reporting.ReportDaoSql.restore(
> ReportDaoSql.java:150)
>         at com.urbancode.anthill3.domain.persistent.DaoSql.restoreAll(
> DaoSql.java:381)
>         ... 41 more
> Caused by: com.urbancode.anthill3.domain.persistent.MarshallingException:
> org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8 sequence.
>         at
> com.urbancode.anthill3.domain.persistent.XMLMarshaller.readStream(
> XMLMarshaller.java:140)
>         at com.urbancode.anthill3.domain.reporting.ReportDaoSql.restore(
> ReportDaoSql.java:132)
>         ... 42 more
> Caused by: org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8
> sequence.
>         at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
>         at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown
> Source)
>         at com.urbancode.commons.xml.DOMUtils.loadDocument(DOMUtils.java
> :160)
>         at
> com.urbancode.anthill3.domain.persistent.XMLMarshaller.readStream(
> XMLMarshaller.java:135)
>         ... 43 more
>
>
>
>
> -----Message d'origine-----
> De : anthill-pro-bounces at lists.urbancode.com [mailto:
> anthill-pro-bounces at lists.urbancode.com] De la part de Frederic Jean
> Envoyé : 18 mars 2008 08:46
>
> À : AnthillPro user and support list.
>
> Objet : RE: [Anthill-pro] Remote scripting VS SOAP Api.
>
>
> Thank you for the reply !
>
> Do you have more example of reports (code or look) that show the
> possibility of what can be done ?
>
> Thank you
>
> Frederic Jean
> -----Message d'origine-----
> De : anthill-pro-bounces at lists.urbancode.com [mailto:
> anthill-pro-bounces at lists.urbancode.com] De la part de Eric Minick
> Envoyé : 17 mars 2008 17:22
> À : AnthillPro user and support list.
> Objet : Re: [Anthill-pro] Remote scripting VS SOAP Api.
>
> I'd like to float a third option as well. This would be to use the API
> from within Anthill to generate a report that is made accessible to
> everyone. Any example of simple light dashboad is available out here:
> http://bugs.urbancode.com/browse/AHPSCRIPTS-13
>
> In general, both the SOAP and java client libraries are going to filter
> projects for a particular user. Since you have to log in through the
> libraries, any "get all" type methods will automatically filter out any
> project/workflow that the user does not have permission to see - much of
> the security is implemented at the database and data access tiers.
>
> The SOAP interface is designed to be a stable interface providing some
> tools supporting common access patterns. The java library is essentially
> the AnthillPro domain with the persistence system modified to go back to
> the central server instead of directly to the database. Since it is
> almost the entire domain, it is naturally going to be more complete and
> more powerful at the cost of ease of use. That said, we are definitely
> open to expanding the features exposed by the SOAP interface if there
> are some calls you think would be helpful for us to implement.
>
> Warm Regards,
>
> Eric
>
> Frederic Jean wrote:
> > I'm presently exploring the possibility to use the SOAP Api of anthill
> > and create for the user a "light dashboard", where they can see results
> > of projects/workflow.
> >
> > As it seem the API is very limited to Projects/Workflow and latest
> > activities and there is no way to dig in those workflows or project ,
> > except for their properties..
> >
> > Why the SOAP api isn't as complete as the remote scripting api ?
> > So what is the plan of Anthill with the SOAP api ?
> > Any development plan to enhance it in the future ?
> >
> >
> > Also , with the remote scripting could i fetch the same data (all
> > available projects for a user, current workflow activities, ...  and I
> > suppose i could dig in my workflow to see job iteration , and what
> > actually failed ???)
> >
> > (I'm not a java guru) So I suppose I could work on a jsp web site ,
> > displaying this data using the remote scripting api ? Problem is all
> > technology used here is everything except java , is there a solution
> > where my asp.net application could hook to anthill using the remote
> > scripting Api instead of web services as the soap api doesn't contain
> > all the information I would like to get ??
> >
> > Thank you
> > Frederic Jean
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > Anthill-pro mailing list
> > Anthill-pro at lists.urbancode.com
> > http://lists.urbancode.com/mailman/listinfo/anthill-pro
> >
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080318/cc7e29e2/attachment-0001.htm

More information about the Anthill-pro mailing list