search

shivasakthi18 / alfresco-business-reporting

Automatically exported from code.google.com/p/alfresco-business-reporting
0 stars 0 forks source link

Unable to connect to database #18

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Installed AMP and Jars on Ubuntu 12.04 and restarted Alfresco
2. Navigated to Data Dictionary/Reporting and ran the "fill database script"
3. Received the following error:

org.alfresco.error.AlfrescoRuntimeException: 04140037 Error during command 
servlet processing: The transaction has already been marked for rollback
caused by:
javax.transaction.RollbackException: The transaction has already been marked 
for rollback

Hide Details

org.alfresco.error.AlfrescoRuntimeException: 04140037 Error during command 
servlet processing: The transaction has already been marked for rollback
at org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:194)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:305)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at 
org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(C
hainingSubsystemProxyFactory.java:116)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM
ethodInvocation.java:172)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.j
ava:202)
at $Proxy246.doFilter(Unknown Source)
at 
org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java
:82)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:243)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at 
org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizatio
nFilter.java:61)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:243)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
22)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
23)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.jav
a:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118
)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor
.java:1002)
at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractPro
tocol.java:585)
at 
org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoin
t.java:1771)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: javax.transaction.RollbackException: The transaction has already 
been marked for rollback
at 
org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserT
ransaction.java:456)
at org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:159)

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system?

Please provide any additional information below.

I also did not get an "alfresco.xml" file.  I did edit the context.xml to look 
like this:

<?xml version="1.0" encoding="UTF-8"?>
<Context>
  <!-- Uncomment in $CATALINA_BASE/conf/[enginename]/[hostname]/alfresco.xml to define your own datasource. Add value attributes to each of the environment ta$
  <!-- Resource defaultTransactionIsolation="-1" defaultAutoCommit="false" maxActive="100" initialSize="10" password="alfresco" username="alfresco" url="jdbc:$
  <Environment override="false" type="java.lang.Boolean" name="properties/startup.enable" description="A flag that globally enables or disables startup of the$
  <Environment override="false" type="java.lang.String" name="properties/dir.root" description="The filesystem directory below which content and index data is$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.dialect" description="The fully qualified name of a org.hibernate.dialect.D$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.query.substitutions" description="Mapping from tokens in Hibernate queries $
  <Environment override="false" type="java.lang.Boolean" name="properties/hibernate.jdbc.use_get_generated_keys" description="Enable use of JDBC3 PreparedStat$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.default_schema" description="Qualify unqualified table names with the given$

  <Resource defaultTransactionIsolation="-1" defaultAutoCommit="true"
                maxActive="10" maxIdle="3" initialSize="1"
                username="username" password="password"
                url="jdbc:mysql://servername:3306/alfrescosvn-reporting"
                driverClassName="org.gjt.mm.mysql.Driver"
                type="javax.sql.DataSource" auth="Container"
                name="jdbc/alfrescosvn-reporting"/>

</Context>

Where username/password and servername have the actual info.  I also tried 
changing the "name=" as shown above hoping it needed the database name but that 
didn't help...

Original issue reported on code.google.com by dhar...@legalonramp.com on 14 May 2013 at 9:45

GoogleCodeExporter commented 8 years ago 
Also am wondering if/when this will work with Postgres....

Original comment by dhar...@legalonramp.com on 14 May 2013 at 9:47

GoogleCodeExporter commented 8 years ago 
alfresco.xml might be created when you first start tomcat with Alfresco. If 
not, you have to create alfresco.xml manually then. 
It won't work if you add the jndi definition to the context.xml...

Please help yourself and keep the JNDI name jdbc/alfrescoReporting as in the 
wiki... The crux is that this name is identical in all your reports. If you 
want to use any of the existing reports, you have to update each and every 
report yourself...

Something like this should do as alfresco.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <Resource name="jdbc/alfrescoReporting" auth="Container"
            defaultTransactionIsolation="-1" defaultAutoCommit="false" 
            maxActive="15" maxIdle="3" initialSize="1" 
            username="username" password="password" 
            url="jdbc:mysql://localhost:3306/alfrescosvn-reporting" 
            driverClassName="org.gjt.mm.mysql.Driver" 
            type="javax.sql.DataSource"
            />
</Context>

Original comment by tjarda.p...@incentro.com on 14 May 2013 at 10:14

GoogleCodeExporter commented 8 years ago 
It definitely will *not* work against Postgres. It is high on my todo list, as 
you can see in the wiki. It also states it is not in as of today.

(The tool does to much fiddling with dynamically adding tables and columns, and 
that is  vendor specific. This is work in progress already, the concepts are 
'on the shelf' already. Fixing current broken features first...)

Original comment by tjarda.p...@incentro.com on 14 May 2013 at 10:18

GoogleCodeExporter commented 8 years ago 
Thanks for the quick response.  So I should remove the changes I made to
context.xml?  Do I need to do anything with that file?  Also, since I need
to create the alfresco.xml file, what all should it contain?

Thanks...

On Tue, May 14, 2013 at 3:15 PM, <alfresco-business-reporting@googlecode.com

Original comment by dhar...@legalonramp.com on 14 May 2013 at 10:19

GoogleCodeExporter commented 8 years ago 
See content of alfresco.xml in my previous answer. context.xml does not
need any modification, please remove your changes...

*Tjarda** Peelen*
Consultant *|* Incentro Utrecht

Rijnzathe 40, De Meern
Utrecht, The Netherlands, 3454 PV

*E:* tjarda.peelen@incentro.com
*T:* +31306665315
*M: *+31655190369
*W:* www.incentro.com
[image: Logo Incentro] <http://www.incentro.com/nl/>

Original comment by tjarda.p...@incentro.com on 14 May 2013 at 10:23

GoogleCodeExporter commented 8 years ago 
Got it.  Thanks again.

On Tue, May 14, 2013 at 3:23 PM, <alfresco-business-reporting@googlecode.com

Original comment by dhar...@legalonramp.com on 14 May 2013 at 10:24

GoogleCodeExporter commented 8 years ago 
Throw me a nice PDF if you created magic of your own!
(Excel output is known to be broken at this point in time)

Original comment by tjarda.p...@incentro.com on 14 May 2013 at 10:27

GoogleCodeExporter commented 8 years ago 
Well, I created the alfresco.xml file, added the recommended contents
(updating it with my server/login info), removed the changes to context.xml
and restarted Alfresco but still get the same errors when trying to run the
"fill database" script.  Any ideas?  Are them some other modules or setup
that this depends on that I might have missed?  I do have Reporting enabled
in global.properties...

On Tue, May 14, 2013 at 3:28 PM, <alfresco-business-reporting@googlecode.com

Original comment by dhar...@legalonramp.com on 14 May 2013 at 10:38

GoogleCodeExporter commented 8 years ago 
FYI, the MySQL server is not on the same server as is Alfresco, so I am 
substituting "localhost" for the actual server name, but it is running on port 
3306

Original comment by dhar...@legalonramp.com on 14 May 2013 at 10:47

GoogleCodeExporter commented 8 years ago 
I am also getting errors when trying to access the Reporting Console from 
within Share:

The Web Script /share/service/components/console/reporting-console has 
responded with a status of 500 - Internal Error.

500 Description:    An error inside the HTTP server which prevented it from 
fulfilling the request.

Message:    04140001 Failed to execute script 
'classpath*:alfresco/web-extension/site-webscripts/org/alfresco/reporting/report
ing-console.get.js': 04140000 TypeError: Cannot parse XML: Scanner State 24 not 
Recognized 
(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar
!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-consol
e.get.js#8(eval)#1)

Exception:  org.mozilla.javascript.EcmaError - TypeError: Cannot parse XML: 
Scanner State 24 not Recognized 
(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar
!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-consol
e.get.js#8(eval)#1)

    org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
    org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
    org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3356)
    org.mozilla.javascript.xmlimpl.XMLLibImpl.parse(XMLLibImpl.java:411)
    org.mozilla.javascript.xmlimpl.XMLLibImpl.ecmaToXml(XMLLibImpl.java:433)
    org.mozilla.javascript.xmlimpl.XMLObjectImpl.ecmaToXml(XMLObjectImpl.java:779)
    org.mozilla.javascript.xmlimpl.XML.jsConstructor(XML.java:250)
    org.mozilla.javascript.xmlimpl.XMLObjectImpl.execIdCall(XMLObjectImpl.java:570)
    org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:127)
    org.mozilla.javascript.BaseFunction.construct(BaseFunction.java:313)
    org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3281)
    org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
    org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
    org.mozilla.javascript.ScriptRuntime.evalSpecial(ScriptRuntime.java:2280)
    org.mozilla.javascript.ScriptRuntime.callSpecial(ScriptRuntime.java:2143)
    org.mozilla.javascript.optimizer.OptRuntime.callSpecial(OptRuntime.java:165)
    org.mozilla.javascript.gen.c38._c0(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-console.get.js:8)
    org.mozilla.javascript.gen.c38.call(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-console.get.js)
    org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
    org.mozilla.javascript.gen.c38.call(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-console.get.js)
    org.mozilla.javascript.gen.c38.exec(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-console.get.js)
    org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScriptImpl(JSScriptProcessor.java:318)
    org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScript(JSScriptProcessor.java:192)
    org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1305)
    org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
    org.springframework.extensions.webscripts.PresentationContainer.executeScript(PresentationContainer.java:70)
    org.springframework.extensions.webscripts.LocalWebScriptRuntimeContainer.executeScript(LocalWebScriptRuntimeContainer.java:240)
    org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
    org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
    org.springframework.extensions.webscripts.WebScriptProcessor.executeBody(WebScriptProcessor.java:310)
    org.springframework.extensions.surf.render.AbstractProcessor.execute(AbstractProcessor.java:57)
    org.springframework.extensions.surf.render.RenderService.process(RenderService.java:599)
    org.springframework.extensions.surf.render.RenderService.renderSubComponent(RenderService.java:505)
    org.springframework.extensions.surf.render.RenderService.renderChromeInclude(RenderService.java:1284)
    org.springframework.extensions.directives.ChromeIncludeFreeMarkerDirective.execute(ChromeIncludeFreeMarkerDirective.java:81)
    freemarker.core.Environment.visit(Environment.java:274)
    freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.IfBlock.accept(IfBlock.java:82)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Environment.process(Environment.java:199)
    org.springframework.extensions.webscripts.processor.FTLTemplateProcessor.process(FTLTemplateProcessor.java:171)
    org.springframework.extensions.webscripts.WebTemplateProcessor.executeBody(WebTemplateProcessor.java:438)
    org.springframework.extensions.surf.render.AbstractProcessor.execute(AbstractProcessor.java:57)
    org.springframework.extensions.surf.render.RenderService.processRenderable(RenderService.java:204)
    org.springframework.extensions.surf.render.bean.ChromeRenderer.body(ChromeRenderer.java:95)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.bean.ChromeRenderer.render(ChromeRenderer.java:86)
    org.springframework.extensions.surf.render.RenderService.processComponent(RenderService.java:432)
    org.springframework.extensions.surf.render.bean.ComponentRenderer.body(ComponentRenderer.java:94)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.RenderService.renderComponent(RenderService.java:961)
    org.springframework.extensions.surf.render.RenderService.renderRegionComponents(RenderService.java:900)
    org.springframework.extensions.surf.render.RenderService.renderChromeInclude(RenderService.java:1263)
    org.springframework.extensions.directives.ChromeIncludeFreeMarkerDirective.execute(ChromeIncludeFreeMarkerDirective.java:81)
    freemarker.core.Environment.visit(Environment.java:274)
    freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Environment.process(Environment.java:199)
    org.springframework.extensions.webscripts.processor.FTLTemplateProcessor.process(FTLTemplateProcessor.java:171)
    org.springframework.extensions.webscripts.WebTemplateProcessor.executeBody(WebTemplateProcessor.java:438)
    org.springframework.extensions.surf.render.AbstractProcessor.execute(AbstractProcessor.java:57)
    org.springframework.extensions.surf.render.RenderService.processRenderable(RenderService.java:204)
    org.springframework.extensions.surf.render.bean.ChromeRenderer.body(ChromeRenderer.java:95)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.bean.ChromeRenderer.render(ChromeRenderer.java:86)
    org.springframework.extensions.surf.render.bean.RegionRenderer.body(RegionRenderer.java:99)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.RenderService.renderRegion(RenderService.java:851)
    org.springframework.extensions.directives.RegionDirectiveData.render(RegionDirectiveData.java:91)
    org.springframework.extensions.surf.extensibility.impl.ExtensibilityModelImpl.merge(ExtensibilityModelImpl.java:408)
    org.springframework.extensions.surf.extensibility.impl.AbstractExtensibilityDirective.merge(AbstractExtensibilityDirective.java:169)
    org.springframework.extensions.surf.extensibility.impl.AbstractExtensibilityDirective.execute(AbstractExtensibilityDirective.java:137)
    freemarker.core.Environment.visit(Environment.java:274)
    freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Environment$3.render(Environment.java:246)
    org.springframework.extensions.surf.extensibility.impl.DefaultExtensibilityDirectiveData.render(DefaultExtensibilityDirectiveData.java:119)
    org.springframework.extensions.surf.extensibility.impl.ExtensibilityModelImpl.merge(ExtensibilityModelImpl.java:408)
    org.springframework.extensions.surf.extensibility.impl.AbstractExtensibilityDirective.merge(AbstractExtensibilityDirective.java:169)
    org.springframework.extensions.surf.extensibility.impl.AbstractExtensibilityDirective.execute(AbstractExtensibilityDirective.java:137)
    freemarker.core.Environment.visit(Environment.java:274)
    freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Environment.visit(Environment.java:406)
    freemarker.core.BodyInstruction.accept(BodyInstruction.java:93)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Macro$Context.runMacro(Macro.java:172)
    freemarker.core.Environment.visit(Environment.java:614)
    freemarker.core.UnifiedCall.accept(UnifiedCall.java:106)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.MixedContent.accept(MixedContent.java:92)
    freemarker.core.Environment.visit(Environment.java:221)
    freemarker.core.Environment.process(Environment.java:199)
    org.springframework.extensions.webscripts.processor.FTLTemplateProcessor.process(FTLTemplateProcessor.java:171)
    org.springframework.extensions.webscripts.WebTemplateProcessor.executeBody(WebTemplateProcessor.java:438)
    org.springframework.extensions.surf.render.AbstractProcessor.execute(AbstractProcessor.java:57)
    org.springframework.extensions.surf.render.RenderService.processTemplate(RenderService.java:721)
    org.springframework.extensions.surf.render.bean.TemplateInstanceRenderer.body(TemplateInstanceRenderer.java:140)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.bean.PageRenderer.body(PageRenderer.java:85)
    org.springframework.extensions.surf.render.AbstractRenderer.render(AbstractRenderer.java:77)
    org.springframework.extensions.surf.render.RenderService.renderPage(RenderService.java:762)
    org.springframework.extensions.surf.mvc.PageView.dispatchPage(PageView.java:411)
    org.springframework.extensions.surf.mvc.PageView.renderView(PageView.java:306)
    org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:316)
    org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
    org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047)
    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817)
    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    org.alfresco.web.site.servlet.MTAuthenticationFilter.doFilter(MTAuthenticationFilter.java:74)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    org.alfresco.web.site.servlet.SSOAuthenticationFilter.doFilter(SSOAuthenticationFilter.java:374)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
    org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
    org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    java.lang.Thread.run(Thread.java:722)

Exception:  org.springframework.extensions.webscripts.WebScriptException - 
04140000 TypeError: Cannot parse XML: Scanner State 24 not Recognized 
(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar
!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-consol
e.get.js#8(eval)#1)

    org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScriptImpl(JSScriptProcessor.java:328)

Exception:  org.springframework.extensions.webscripts.WebScriptException - 
04140001 Failed to execute script 
'classpath*:alfresco/web-extension/site-webscripts/org/alfresco/reporting/report
ing-console.get.js': 04140000 TypeError: Cannot parse XML: Scanner State 24 not 
Recognized 
(jar:file:/opt/alfresco/tomcat/lib/alfresco-business-reporting-share-0.8.0.1.jar
!/alfresco/web-extension/site-webscripts/org/alfresco/reporting/reporting-consol
e.get.js#8(eval)#1)

    org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScript(JSScriptProcessor.java:200)

Server: Spring WebScripts - v1.2.0 (Release 1207) schema 1,000
Time:   May 14, 2013 4:22:17 PM

Original comment by dhar...@legalonramp.com on 14 May 2013 at 11:24

GoogleCodeExporter commented 8 years ago 
One more note in case it helps.  I'm running:
4.2.c on 64 bit Ubuntu 
using lfresco-business-reporting-explorer-0.8.0.1.amp
and
alfresco-business-reporting-share-0.8.0.1.jar

Original comment by dhar...@legalonramp.com on 14 May 2013 at 11:31

GoogleCodeExporter commented 8 years ago 
It just occurred to me that even though I created a MySQL database for your 
tool, the Alfresco database is Postgres.  Could that be the problem?  Do both 
the reporting database AND the Alfresco databases need to be MySQL?

Original comment by dhar...@legalonramp.com on 14 May 2013 at 11:43

GoogleCodeExporter commented 8 years ago 
I am trying to run this in JBOSS. Added the <Resource> tag as explained to 
Context.xml. On startup of Alfresco, it created Reporting node etc. BUt I get 
error on log saying this:
15:15:17,960 INFO  [AlfrescoSchedulerFactory] Quartz scheduler version: 1.8.3
15:15:17,961 INFO  [QuartzScheduler] JobFactory set to: 
org.alfresco.repo.scheduler.AlfrescoJobFactory@7adc1ca7
15:15:23,997 ERROR [STDERR] javax.naming.NameNotFoundException: 
alfrescoReporting not bound
....
...
15:15:24,007 INFO  [STDOUT] 15:15:24,007  WARN  
[reporting.db.DatabaseHelperBean] Reporting table information could not be 
retrieved!!

Can you please let me know, what is causing this?
Thanks,
SR

Original comment by shylasem...@gmail.com on 7 Nov 2013 at 8:19

GoogleCodeExporter commented 8 years ago 
I am experiencing the same issues as dhar...@legalonramp.com reported in reply 
#10.  Have you any update on how to fix this yet?

Alfresco 4.0d
PostgreSQL 9.1.4
Windows 2008 R2 SP1
MySQL 5.6.15
alfresco-business-reporting-explorer-0.8.0.3.amp
alfresco-business-reporting-share-0.8.0.3.jar

Original comment by ewan.rit...@gmail.com on 19 Dec 2013 at 3:53

GoogleCodeExporter commented 8 years ago 
Hi,

I am experiencing the same issue which started this issue:

org.alfresco.error.AlfrescoRuntimeException: 02110371 Error during command 
servlet processing: The transaction has already been marked for rollback
caused by:
javax.transaction.RollbackException: The transaction has already been marked 
for rollback

and in my log-file

16:33:25,330 FATAL [org.alfresco.reporting.script.AlfrescoReporting] 
processGroups - terrible error:
16:33:25,361 FATAL [org.alfresco.reporting.script.AlfrescoReporting] 
processSitePerson - terrible error:

Made the necessary changes to alfresco.xml. Created the reporting-databse, but 
no tables. No tables get created automatically either when executing the "Fill 
Reporting database" action.

Am using MySQL for both alfresco and the reporting-db. Installed version 
0.8.0.1 of the add-on.

Is there any news on these issues?

On a side-note: when installing 0.8.0.3 of the add-on, alfresco won't start 
anymore :(

Original comment by hans.de...@gmail.com on 11 Mar 2014 at 3:41

GoogleCodeExporter commented 8 years ago 
Hans,

Can you attach/send the complete logfile, from starting until the failed 
harvesting-run?
Can you connect to your reporting database using the command-line given the URL 
and credentials as used in the alfresco.xml?
(Is your reporting db located at localhost, or otherwise, is your reporting 
mysql user allowed to connect from the outside??)

Cheers,

Tjarda

Original comment by tjarda.p...@incentro.com on 11 Mar 2014 at 7:28

GoogleCodeExporter commented 8 years ago 
Hi Tjarda,

Attached alfresco.log from startup untill failed harvesting. Als connected to 
reporting-db through command-line with this command: mysql --host=localhost 
--user=<user> --password=<password> alf_bus_reporting, with user, password and 
database as in alfresco.xml. This worked.
As you can see the reporting-db is on localhost (actually on the same 
mysql-instance as the alfresco-db).

Original comment by hans.de...@gmail.com on 12 Mar 2014 at 7:40

Attachments: