OpenDocument and parameters with parentheses

system · November 16, 2015, 10:56am

Hello everybody, I have trouble using OpenDocument with my application (SAP BusinessObjects 4.1 Support Pack 3 Version: 14.1.3.1257). I am passing the parameters using prompt0, prompt1, prompt2, etc … There seems to be a problem in prompt10 because the parentheses in the attribute: test1 (166 / PM03).

I’ve tried to use encryption functions in the application but not resolved. I’ve tried replacing Parentheses by 28% and 29% but failed.

I do not know the solution. Attributes can not have parentheses? Am I doing something wrong?

Below is the URL I’m using and the error screen:

http://server:port/BOE/OpenDocument/opendoc/openDocument.jsp?sDocName=lista_postagem_periodico_preco_des&prompt0=8437&prompt1=SPM&prompt2=00236544&prompt3=ALAMEDA GLETE, SANTA CECILIA-SAO PAULO&prompt4=9912269278 &prompt5=0061305790&prompt6=10418644 &prompt7=AGF CAMPOS ELISEOS&prompt8=22/09/2015&prompt9=ARAUTOS DO EVANGELHO&prompt10=TESTE1 (166 / PM03)

edison_filho (BOB member since 2015-11-16)

system · November 16, 2015, 11:44am

I believe you need to be looking at URL encode for this, have a search on here.

That having been said, using any special characters in any objects or variables is not a great idea.

Mak 1 (BOB member since 2005-01-06)

system · November 16, 2015, 11:55am

already tried:

TESTE1%20(166%20%2F%20PM03)%20

AND:

encodeURI(TESTE1 (166 / PM03))

AND:

encodeURIComponent(TESTE1 (166 / PM03))

AND:

TESTE1 %28166 / PM03%29

All forms of encryption or replacement of characters resulted in the same problem. How should I proceed?

edison_filho (BOB member since 2015-11-16)

system · November 16, 2015, 12:39pm

And i Tried with URLENCODE():

http://server:port/BOE/OpenDocument/opendoc/openDocument.jsp?sDocName=lista_postagem_periodico_preco_des&prompt0=8437&prompt1=SPM&prompt2=00236544&prompt3=ALAMEDA GLETE, SANTA CECILIA-SAO PAULO&prompt4=9912269278 &prompt5=0061305790&prompt6=10418644 &prompt7=AGF CAMPOS ELISEOS&prompt8=22/09/2015&prompt9=ARAUTOS DO EVANGELHO&prompt10=UrlEncode(“TESTE1 (166 / PM03)”)

I tried but failed.

edison_filho (BOB member since 2015-11-16)

system · November 16, 2015, 4:52pm

I don’t think the parenthesis is a problem and needs to be encoded to work. The following are considered safe characters $-_.+!*() and should work without encoding needed.
e.g On 4.1 Sp4, Win/Tomcat i tried &lsSDummyParam=Test2($-_.+!*/()) and was able to capture it back in the report.

Shobhit_Acharya (BOB member since 2005-08-11)

system · November 17, 2015, 12:43pm

I don’t think it’s the parenthesis either.

First thought – how long is the actual URL? IE has a limit, although it’s pretty high - over 2,000 characters. But if you’re hitting it, that would do it.

I assume &prompt0, &prompt, etc. in your URL are just placeholders, but are you actually using the correct syntax? Prompt names must be preceded by &lsS or &lsM.

joepeters (BOB member since 2002-08-29)

system · November 19, 2015, 12:58pm

I do not believe it are the parentheses.

I tried to join in other ways:
[b]
http://server:port/BOE/OpenDocument/opendoc/openDocument.jsp?sDocName=lista_postagem_periodico_preco_des&prompt0=8437&prompt1=SPM&prompt2=00236544&prompt3=ALAMEDA GLETE, SANTA CECILIA-SAO PAULO&prompt4=9912269278 &prompt5=0061305790&prompt6=10418644 &prompt7=AGF CAMPOS ELISEOS&prompt8=22/09/2015&prompt9=ARAUTOS DO EVANGELHO&prompt10=TESTE1 (166 / PM03)

http://server:port/BOE/OpenDocument/opendoc/openDocument.jsp?sDocName=lista_postagem_periodico_preco_des&lsSPARAM_LPO_NU=8437&lsSPARAM_DR=SPM&lsSPARAM_COD_STO=00236544&lsSPARAM_LOCALIDADE_POSTAGEM=ALAMEDA GLETE, SANTA CECILIA-SAO PAULO&lsSPARAM_NUMERO_CONTRATO=9912269278 &lsSPARAM_CARTAO_HABILITACAO=0061305790&lsSPARAM_COD_ADMINISTRATIVO=10418644 &lsSPARAM_UNI_POSTAGEM=AGF CAMPOS ELISEOS&lsSPARAM_PCA_DH_FINAL=22/09/2015&lsPARAM_EDI_NO=ARAUTOS DO EVANGELHO&lsSPARAM_OBJETOS_NO=TESTE1 (166 / PM03)

http://server:port/BOE/OpenDocument/opendoc/openDocument.jsp?sDocName=lista_postagem_periodico_preco_des&lsSPARAM_LPO_NU=8437&lsSPARAM_DR=SPM&lsSPARAM_COD_STO=00236544&lsSPARAM_LOCALIDADE_POSTAGEM=ALAMEDA%20GLETE,%20SANTA%20CECILIA-SAO%20PAULO&lsSPARAM_NUMERO_CONTRATO=9912269278%20&lsSPARAM_CARTAO_HABILITACAO=0061305790&lsSPARAM_COD_ADMINISTRATIVO=10418644%20&lsSPARAM_UNI_POSTAGEM=AGF%20CAMPOS%20ELISEOS&lsSPARAM_PCA_DH_FINAL=22/09/2015&lsPARAM_EDI_NO=ARAUTOS%20DO%20EVANGELHO&lsSPARAM_OBJETOS_NO=TESTE1%20(166%20/%20PM03)[/b]

…and the error changed:

2015-11-17 17:10:36
com.businessobjects.report.web.shared.WebReportingException: O visualizador não pôde processar um evento. Falha ao abrir a conexão.
lista_postagem_periodico_preco_Des
Detalhes: [Código do Fornecedor de Banco de Dados: 12154 ] [] ---- Error code:0 [CRWEB00000119]
at com.businessobjects.report.web.shared.WebReportingException.throwWebReportingException(WebReportingException.java:71)
at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1439)
at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:353)
at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:255)
at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:106)
at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)
at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)
at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)
at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)
at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)
at com.businessobjects.bip.core.web.filter.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.java:32)
at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
at com.businessobjects.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35)
at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
at com.businessobjects.bip.core.web.supportabilty.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)
at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)
at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
at com.businessobjects.bip.core.web.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)
at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)
at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)
at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)
at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java: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.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(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:761)
Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Falha ao abrir a conexão.
lista_postagem_periodico_preco_Des
Detalhes: [Código do Fornecedor de Banco de Dados: 12154 ]---- Error code:-2147215357 [] Error code name:internal
at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(ReportSDKException.java:120)
at com.crystaldecisions.sdk.occa.managedreports.ps.internal.SendRequestHelper.sendRequest(SendRequestHelper.java:141)
at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1796)
at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1283)
at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:377)
at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:178)
at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:120)
at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)
at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)
at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)
at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)
at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1426)
… 51 more

edison_filho (BOB member since 2015-11-16)