on 05-03-2011 2:51 PM
Hi,
I am trying to execute a test run of client copy using Transaction "SCCL" which fails, and gives shortdump in Thx. ST22 as follow:
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLSCCR" had to be terminated because it has come across a statement that unfortunately cannot be executed.
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_CONVERSION_OVERFLOW', was not caught in
procedure "COPY_CLIDEP_TABLES" "(FORM)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated.
The reason for the exception is:
When attempting to convert the value "2.23093e+09", an overflow occurred.
How to correct the error |
If the error occurred in your own ABAP program or in an SAP |
program you modified, try to remove the error. |
If the error occures in a non-modified SAP program, you may be able to |
find an interim solution in an SAP Note. |
If you have access to SAP Notes, carry out a search with the following |
keywords: |
"CONVT_OVERFLOW" "CX_SY_CONVERSION_OVERFLOW" |
"SAPLSCCR" or "LSCCRF1W" |
| "COPY_CLIDEP_TABLES"
We ar using :
Kernel release: 701
OS: Linux GNU SLES-9 x86_64 cc4.1.2 Feb 6 2011 2
The largest Tablespace "PSAPSR3" is "921.000,00 MB"
Unfortunately I was not able to find the solution, is there someone who can help me to figure out this issue.
Thanks for your help in advance
sahmad
Hi,
Please contact you functional Team before excluding the table & check this site
http://itsiti.com/rsccexpt-client-copy-expert-settings or you can execute these reports RSSPACECHECK or RSTABLESIZE in SE38 to determine the size of the client.
Thanks
Kiran.GVL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just type in the name of the table you want to exclude there and then save it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FOr excluding a table in the local client copy, please go to the Tcode SCCL and then go to edit-->expert setting. Once you are in that screen there will be many tabs like options, copy individually,tables, main process etc. Go to tables tab and include the table you want to exclude and save it . Now if you run the client copy this table will be excluded. Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
The client copy is dumping at the processing of the table which will be in your ST22 dump you will find table name ,which is an application table having a lot of entries and also it's table length also seems to be quite large.
you can exclude this table from client copy using the report RSCCEXPT please refer the note 70290 for more details,
after this, client copy should run fine.
Let us know of the result.
Thanks and regards,
Atil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I DO NOT see table name in shortdump, it terminates when calculating the size, but in SCC3 I can see that it terminates when reading Table (VBFCL).
I have been reading SAP Note 70290 about (RSCCEXPT) don't understand how to exclude the table, could you please explain, list the steps.
Thank you in advance for your help.
sahmad
Hi Atil,
Here the section what I believe it terminates:
ENDIF.
LEAVE PROGRAM.
ENDIF.
IF USED_ERR > 10.
PERFORM LOG_MSG USING 2 '165'
PROCESS SPACE SPACE SPACE.
Prozess & abgebrochen wegen fehlender Berechtigung
EXIT.
ENDIF.
ENDLOOP.
REQ_SPACE = DB_REQSPACE / 1024.
ENDFORM. " COPY_CLIDEP_TABLES
Thanks for your reply in advance.
sahmad
Hi Subhash,
Unfortunately in SCC3 I do not see any error log, except it's telling me job was canceleld at the point when reading Table (VBFCL), please see below database, and Tablespace size:
Db size = 1023.41 Gb
PSAPSR3 921,000.00
PSAPSR3701 50,320.00
PSAPSR3FACT 100.00
PSAPSR3ODS 100.00
PSAPSR3USR 3,580.00
PSAPTEMP 62,140.00
PSAPUNDO 9,480.00
SYSAUX 300.00
SYSTEM 950.00
VBFCl table size is = 4,288.000
As already mentioned above in St22 shortdump I can see where it was terminated as follow:
ENDIF.
LEAVE PROGRAM.
ENDIF.
IF USED_ERR > 10.
PERFORM LOG_MSG USING 2 '165'
PROCESS SPACE SPACE SPACE.
Prozess & abgebrochen wegen fehlender Berechtigung
EXIT.
ENDIF.
ENDLOOP.
REQ_SPACE = DB_REQSPACE / 1024.
ENDFORM. " COPY_CLIDEP_TABLES
I am posting content of shortdump, maybe somone else can see the problem:
-
-
Content of shortdump in ST22
Runtime Errors CONVT_OVERFLOW
Exception CX_SY_CONVERSION_OVERFLOW
Date and Time 27.04.2011 20:49:04
-
-
-
-
Short text |
Overflow when converting from "2.22273e+09" |
-
-
-
-
What happened? |
Error in the ABAP Application Program |
The current ABAP program "SAPLSCCR" had to be terminated because it has |
come across a statement that unfortunately cannot be executed. |
-
-
-
-
Error analysis |
An exception occurred that is explained in detail below. |
The exception, which is assigned to class 'CX_SY_CONVERSION_OVERFLOW', was not |
caught in |
procedure "COPY_CLIDEP_TABLES" "(FORM)", nor was it propagated by a RAISING |
clause. |
Since the caller of the procedure could not have anticipated that the |
exception would occur, the current program is terminated. |
The reason for the exception is: |
When attempting to convert the value "2.22273e+09", an overflow occurred. |
-
-
|
-
-
Information on where terminated |
Termination occurred in the ABAP program "SAPLSCCR" - in "COPY_CLIDEP_TABLES". |
The main program was "RSCLXCOP ". |
In the source code you have the termination point in line 301 |
of the (Include) program "LSCCRF1W". |
The program "SAPLSCCR" was started as a background job. |
Job Name....... "CLIENTCOPY 007 -> 100 (SAP_ALL )" |
Job Initiator.. "SAP*" |
Job Number..... 18115700 |
The termination is caused because exception "CX_SY_CONVERSION_OVERFLOW" |
occurred in |
procedure "COPY_CLIDEP_TABLES" "(FORM)", but it was neither handled locally nor |
declared |
in the RAISING clause of its signature. |
The procedure is in program "SAPLSCCR "; its source code begins in line |
7 of the (Include program "LSCCRF1W ". |
-
-
-
-
Source Code Extract |
-
-
Line | SourceCde |
-
-
271 | ENDIF. |
272 | IF SELTAB-MESSNR = '360'. |
273 |
|
274 | SELTAB-MESSID = 'TA'. |
275 | MODIFY SELTAB. |
276 | ENDIF. |
277 | ENDIF. |
278 | SELECT SINGLE STATUS FROM CCCFLOW INTO STATUS |
279 | WHERE TSTAMP = CCCFLOW_CURR-TSTAMP |
280 | AND MANDT = CCCFLOW_CURR-MANDT. "#EC CI_SEL_NESTED |
281 | IF STATUS = 'A'. |
282 | PERFORM LOG_MSG USING 3 '267' |
283 | PROCESS SPACE SPACE SPACE. |
284 |
|
285 | IF CCCFLOW_CURR-NOPROCS > 1. |
286 | UPDATE CCPROCTAB SET TABNAME = SPACE |
287 | WHERE PROCESS = PROCESS. |
288 | EXEC SQL. |
289 | COMMIT WORK |
290 | ENDEXEC. |
291 | ENDIF. |
292 | LEAVE PROGRAM. |
293 | ENDIF. |
294 | IF USED_ERR > 10. |
295 | PERFORM LOG_MSG USING 2 '165' |
296 | PROCESS SPACE SPACE SPACE. |
297 |
|
298 | EXIT. |
299 | ENDIF. |
300 | ENDLOOP. |
>>>>> | REQ_SPACE = DB_REQSPACE / 1024. |
302 | ENDFORM. " COPY_CLIDEP_TABLES |
-
-
|
Val. |
-
-
No. 5 Ty. FORM |
Name COPY_CLIDEP_TABLES |
-
-
PROCESS |
00001 |
33333 |
00001 |
SY-MSGNO |
000 |
333 |
000 |
USED_ERR |
0 |
0000 |
0000 |
SY |
/###############################################f###A###!###d###############µ################# |
2000000000000000000000000000000000000000000000006000400020006000000000000000B00000000000000000 |
F000100010001000000000001000000000000000100000006000100010004000000000000000500000000000000000 |
RSJOBINFO |
00000000000000 #### |
222222222222222222222222222222223333333333333322222222222222222222222222222222220000 |
000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
INCL_TASKS |
2 |
0 |
DB_REQSPACE |
2276074590752 |
009F8884 |
00104F02 |
REQ_SPACE |
185262052 |
ED00 |
4FAB |
-
-
No. 4 Ty. FUNCTION |
Name SCCR_COPY_SELTAB_FROM_SOURCE |
-
-
Unfortunately I am not able to paste complete content of shortdump
-
-
Additionally can you tell me what are the steps when I am doing client export in Thx. SCC8
Thanks for yoyr help in advance
sahmad
Hi ,
can you please update what is the profile you were choosing while doing client copy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you try re-executing that and also can you paste the line where id dumped by clicking on source code extract?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please find below required information:
ENDIF.
LEAVE PROGRAM.
ENDIF.
IF USED_ERR > 10.
PERFORM LOG_MSG USING 2 '165'
PROCESS SPACE SPACE SPACE.
Prozess & abgebrochen wegen fehlender Berechtigung
EXIT.
ENDIF.
ENDLOOP.
REQ_SPACE = DB_REQSPACE / 1024.
ENDFORM. " COPY_CLIDEP_TABLES
Thanks for your reply in advance.
sahmad
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.