Skip to Content
0

JRC error calling procedure

Oct 25, 2016 at 04:25 PM

29

avatar image
Former Member

I have a report that uses the sap procedure TMSP_DOCLINETYPELAYOUT. In the report I defined two numeric parameters: DocKey and ObjectId. If I open the preview with Crystal Report, it works fine, but if I load the .rpt with JRC and than export it in PDF, it gives me this error:

INFO [com.crystaldecisions.reports.queryengine] - <QueryInfo openRowset:> 
INFO [com.crystaldecisions.reports.queryengine] - <Rowset restart: moveToStart true>
INFO [com.crystaldecisions.reports.queryengine] - <Rowset execute>
INFO [com.crystaldecisions.reports.queryengine] - <Executing query using a Query Definition. > 
INFO [com.crystaldecisions.reports.queryengine.querybuilder] - <Query: 
 SELECT "OINV"."VatSum", "OINV"."TaxDate", "OINV"."ObjType", "OINV"."Address", "INV1"."Price", "OPYM"."Descript", "OCRD"."AddID", "OCRD"."LicTradNum", "OINV"."DocNum", "OINV"."DiscPrcnt", "OINV"."CardName", "INV1"."VatPrcnt", "INV1"."LineTotal", "OINV"."TotalExpns", "OINV"."DocEntry", "INV1"."Quantity", "INV1"."VatGroup", "OCTG"."PymntGroup", "INV1"."FreeTxt", "OINV"."DocTotal", "TMSP_DOCLINETYPELAYOUT"."LineText"
 FROM   "FCG_TEST3"."OINV" "OINV", "FCG_TEST3"."INV1" "INV1", "FCG_TEST3"."OPYM" "OPYM", "FCG_TEST3"."OCRD" "OCRD", "FCG_TEST3"."OCTG" "OCTG", "FCG_TEST3"."TMSP_DOCLINETYPELAYOUT" "TMSP_DOCLINETYPELAYOUT">
DEBUG [com.crystaldecisions.reports.exporters.page.pdf.AdobePDFExporter] - <PDFExporter: PDFFormatter.finalizeFormatJob> 
ERROR [com.businessobjects.reports.sdk.JRCCommunicationAdapter] - < detected an exception: Unexpected database connector error 
at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:632)
at com.crystaldecisions.reports.datalayer.a.do(SourceFile:1621) 
at com.crystaldecisions.reports.datalayer.a.a(SourceFile:1404) 
... 

Removing the procedure TMSP_DOCLINETYPELAYOUT form the report, the report is exported without problems.

Can anyone help me with this error?

Thanks

Giu

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers