cancel
Showing results for 
Search instead for 
Did you mean: 

CRYSTAL/OSQL_EXECUTE_QUERY returned: subrc: 4( Crystal Reports 2008 against ECC FMs)

Former Member
0 Kudos

Dear Community,

We are on BOBJ 3.1  SP3. Build Number:   812     Product Version:   12.3.3.812 

Out of curiosity, Is there a limit in Crystal Reports in handling ABAP function based long text fields. We have close to 10 long text fields required for reporting.

I was able to extract 9 long text fields to the report. The 10th long text gave the error:

Error: "Database Connector Error: '/CRYSTAL/OSQL_EXECUTE_QUERY returned: subrc:4.  Message: The size of structure(540016 bytes) exceed the maximum length of 52487 bytes..Line 48. Word:0.'        

Here the specifics of the Function Module if this helps.

Input parameters - Project ID

10 Export parameters of datatype Char with length-30000

I found certain posts in the community on error message above, but didnt find a specific post or SAP note regarding the structure size.

Thanks

V

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

Have you tried running the function module in SE37 in ECC and does it return the desired data before trying it in Crystal?

Former Member
0 Kudos

Yes, the FM returns data for all the required long text fields..

Former Member
0 Kudos

Any updates on this post?

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

SAP IK Transport had regressions between SP03 and FP3.1

I  believe this issue was fixed in FP3.2

However, You need to reproduce on FP3.7 before contacting support. (FP3.8 is due soon, and final package on that codeline)

To qualify for fix support, you need to be on SP04 FP4.1 or SP05

Regards,

H