#1 2018-02-12 13:27:38

rferro
Member
Registered: 2018-02-12

starting crystal reports

Hello
I am evaluating this reports server to migrate crystal reports V9. I have a java application calling reports.

If i started it i received

exception :
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Impossible de se connecter au serveur : OraTest.---- Error code:-2147217387 Error code name:connectServer


Do you have an idea ?

Offline

#2 2018-02-12 13:47:40

eduardo
Administrator
Registered: 2016-11-01
Website

Re: starting crystal reports

Hi rferro,

1. what reportserver have you installed?
2. Are you using the enterprise version or the community version?
3. have you checked this: https://reportserver.net/en/guides/admi … l-Reports/
4. could you please the complete error stack? you can find this in your tomcat logs

Regards,
Eduardo

Offline

#3 2018-02-12 16:12:46

rferro
Member
Registered: 2018-02-12

Re: starting crystal reports

Hello
I now evaluate the entreprise version to know if it is the right tool I need.

Of course I reed the doc but I do not find how to to make it work. I think I cannot reach the reports server, so the logfile will be empty.

To configure the reports to run with "crystal reports serveur 9" we configure the file "clientSDKOptions.xml"
This file contain something like

<CrystalReports.ClientSDKOptions xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance" version="2" xsi:type="CrystalReports.ClientSDKOptions">
    <ServerInfos version="2" xsi:type="CrystalReports.ServerInfos" id="1">
        <ServerInfo version="2" xsi:type="CrystalReports.ServerInfo" id="2">
            <Server>OraTest:8210</Server>
            <Adapter>TCPIP</Adapter>
        </ServerInfo>
    </ServerInfos>
</CrystalReports.ClientSDKOptions>

hope you can help me

Offline

#4 2018-02-13 07:52:24

eduardo
Administrator
Registered: 2016-11-01
Website

Re: starting crystal reports

Hello rferro,

clientSDKOptions.xml is not a reportserver configuration file.

First, you need reportserver installed and working. For this, you can install one of the bitnami installer packages for your operating system: https://reportserver.net/de/download/
If you see the reportserver app from your browser, you can start adding new reports. Start with a dynamic list for testing. When this works, you can install Crystal as explained here: https://reportserver.net/en/guides/admi … l-Reports/

You don't need crystal reports server for this. You only need reportserver and your .rpt files. You may also check this: https://reportserver.net/en/guides/admi … anagement/ for more information and the getting started tutorial: https://reportserver.net/en/tutorials/t … t-started/

Regards,
Eduardo

Offline

#5 2018-02-13 14:04:14

rferro
Member
Registered: 2018-02-12

Re: starting crystal reports

thanks
The dynamic reports work correctely
I configure Crystal Reports load one of mine simple reports in the server and i got the error

Error: An error occurred during report execution.
The report could not be executed: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:535) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:416) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:346) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:339) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:168) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741.CGLIB$doGet$1() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741$$FastClassByGuice$$701f450e.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741.doGet() at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741.CGLIB$service$14() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741$$FastClassByGuice$$701f450e.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$3e7df741.service() at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorRuntimeException: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:104) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:63) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:150) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) ... 57 more Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.crystal.service.crystal.reportengine.output.generator.CrystalPDFOutputGenerator.exportReport(CrystalPDFOutputGenerator.java:58) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:93) ... 60 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at net.datenwerke.rs.crystal.service.crystal.reportengine.output.generator.CrystalPDFOutputGenerator.exportReport(CrystalPDFOutputGenerator.java:52) ... 61 more Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: InternalFormatterException---- Error code:-2147467259 Error code name:failed at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:237) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111) ... 66 more Caused by: com.crystaldecisions.reports.exportinterface2.exceptions.InternalFormatterException: InternalFormatterException at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:258) at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(SourceFile:642) at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(SourceFile:586) at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:637) at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:673) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1943) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:660) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:166) at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:528) at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:526) at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:524) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:423) at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:351) at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54) at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67) at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716) at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125) at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537) at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186) at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558) at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:223) ... 69 more Caused by: com.crystaldecisions.reports.dataengine.DataEngineException: Exception in formula '{@Record_Selection}' at '{A_ECO_STA_LST.NUM_SOC}': This field name is not known. at com.crystaldecisions.reports.dataengine.DataSourceManager.do(SourceFile:692) at com.crystaldecisions.reports.dataengine.DataSourceManager.new(SourceFile:607) at com.crystaldecisions.reports.dataengine.DataSourceManagerCoordinator.a(SourceFile:505) at com.crystaldecisions.reports.dataengine.DataSourceManager.a(SourceFile:1060) at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:729) at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.(SourceFile:179) at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.if(SourceFile:135) at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatterBase.(SourceFile:75) at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.(SourceFile:183) at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(SourceFile:162) at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:202) ... 91 more Caused by: com.crystaldecisions.reports.formulas.FormulaException: Exception in formula '{@Record_Selection}' at '{A_ECO_STA_LST.NUM_SOC}': This field name is not known. at com.crystaldecisions.reports.formulas.o.a(SourceFile:1041) at com.crystaldecisions.reports.formulas.o.do(SourceFile:1013) at com.crystaldecisions.reports.formulas.o.new(SourceFile:688) at com.crystaldecisions.reports.formulas.o.else(SourceFile:459) at com.crystaldecisions.reports.formulas.f.void(SourceFile:65) at com.crystaldecisions.reports.formulas.FormulaParser.a(SourceFile:345) at com.crystaldecisions.reports.formulas.r.a(SourceFile:89) at com.crystaldecisions.reports.formulas.FormulaInfo.a(SourceFile:570) at com.crystaldecisions.reports.formulas.FormulaService.compile(SourceFile:347) at com.crystaldecisions.reports.reportdefinition.FormulaCompiler.a(SourceFile:139) at com.crystaldecisions.reports.reportdefinition.FormulaFieldDefinitionBase.compile(SourceFile:928) at com.crystaldecisions.reports.reportdefinition.o.a(SourceFile:1360) at com.crystaldecisions.reports.reportdefinition.o.a(SourceFile:1348) at

Offline

#6 2018-02-14 09:05:50

eduardo
Administrator
Registered: 2016-11-01
Website

Re: starting crystal reports

Hi rferro,

what is "'{@Record_Selection}' at '{A_ECO_STA_LST.NUM_SOC}': This field name is not known ?" Are you sure this field exists? Is this a parameter? If yes, have you added the parameter to the report (in reportserver)?
You should start with a simple report, for example one without parameters and with a simple query. This allows you to check connectivity from crystal. Then you can add parameters, etc.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB