‎2009 Jul 29 11:58 AM
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?
‎2009 Jul 29 4:08 PM
Hey please check your SQL query part as there seems to be something wrong with that..
Raghav
‎2009 Jul 29 4:08 PM
Hey please check your SQL query part as there seems to be something wrong with that..
Raghav
‎2009 Jul 29 4:40 PM
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
‎2009 Jul 29 7:58 PM
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
‎2009 Jul 30 5:20 PM
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