07-09-2010 1:59 PM
Hi All,
I need to update the TVARVC table with latest Run date in field LOW
When I tried to Update or modify TVARVC in program level it is taking very long time, in back ground it is taking 48 hours ,In foreground it is going to dump.
After that I tried to change the filed value in debug mode, but in this also it is taking too much time and giving dump.
Here what could be the reason to giving dump while in debug mode also.
How to over come this problem? Please help me this
Thanks and Regards,
Rambabu.A
07-09-2010 2:04 PM
Hi ,
Hope you are passing all key fields for the record i.e NAME, TYPE, NUMB . If you are storing only one value in LOW, pass P to 'TYPE'.
Regards,
Venkat.
07-09-2010 2:16 PM
Hi Venkat,
I am passing all key fields and low value while updating the table TVARVC, but it is taking long time
What could be the reason, while changing the value in debug mode?
Please help me in this
Thanks and Regards,
Rambabu.A
07-09-2010 3:14 PM
Why don't you post your code? A single record update to TVARVC is a simple (fast) process. You'll get a better answer if you ask a better question ;-). And, asking why a dump happens certainly isn't as good as giving the name of the dump exception...
07-09-2010 3:37 PM
Hi All,
My problem got solved, thanks for giving support to solve the problem
Actual problem is this TVARVC table contains client specific field that needs fill with 'X' then only it will consider to save the or modify the record other wise it will search for all client sin the server
My code is :
SELECT SINGLE INTO wa_tvarvc
FROM tvarvc
WHERE name = 'ZFI_LAST_RUN_DATE'
AND type = 'P'
AND numb = c_0001
*begin of change
AND CLIE_INDEP = 'X'.
*End of change
p_date = tvarvc-low .
p_date = wa_tvarvc-low .
*<<End of change @003
w_date = sy-datum + 1 .
*Begin of change
tvarvc-low = w_date .
wa_tvarvc-low = w_date .
wa_tvarvc-CLIE_INDEP = u2018Xu2019.
UPDATE tvarvc .
MODIFY tvarvc FROM wa_tvarvc.
Thanks and Regards,
Rambabu.A
07-09-2010 2:09 PM
Hi,
Try to pass all the key fields into that as given below.
NAME - 'XXXX' (Name of the parameter need to update)
TYPE - 'P' or 'S' ( P in case of parameter and S in case of range)
NUMB - '0000'
SIGN
OPTI
LOW - 'Value'
HIGH
CLIE_INDEP
Also try to use UPDATE command instead of MODIFY.
Thanks,
Navneet Chaubey