Short dump in generated programs

[Former Member]

Hi All,

We have generated the report RMCA1375 using tcode MCS/ to copy the info structure S137 to S138. When the report RMCA1375 is executed its dumping with "DBIF_RSQL_INVALID_CURSOR".

As this is a generated report its not allowing me to modify it and I searched for OSS notes but not able to find any.....

Is there any solution for this?

[former_member182354]

Hey please check your SQL query part as there seems to be something wrong with that..

Raghav

[Former Member]

Hi,

Please paste the part of the code from the short dump, this will help us analyze the problem in more detail. Also try not to put a break point while executing it.

Best regards,

Kazmi

[Former Member]

Hi,

Can you try this report "RMCSISGN",and also this error has based on sql query,once you need to activate all the tables are TMC4, TMC4T, TMCB, TMC2K, TMC1K, TMC1D, TMC1KS, TMC1DS, TMC73.Try this.I hope ,it will help you

<=<< Sharing knowledge is a way to Innovative >=>>

By,

Yoga

[Former Member]

Hi All,

I have fixed the issue thanks for all ur replies....

Solution :

If the Generated reports has SQL commands then if any Z report has been created which has "COMMIT WORK " in it then this short dump will come when the second time the fetch command is executed. CALL FUNCTION "DB_COMMIT" has to be used where ever COMMIT WORK is used.

Siva