Hello All.
I have a problem during Upload from Control-M Desktop.
Problem description
-----------------------
I have a "big" table with about 1400 jobs
When i change some jobs i do Write and Upload, as usual.
But while the first action (Write) takes few seconds, the second action (Upload) takes up to more or less 2 minutes.
Often the second action (Upload) fails after 2 minutes or so with the following message:
Upload table myBigTable_tbl impossible.
Internal error returned from server
Our Control-M version is 6.2.01.400
Database : SQL SERVER on Windows 2003
Does anyone ever met the same error ?
How to solve it ?
Plz help! Thanx
Regards,
Mau
-----
HELP:Upload impossible. Internal error returned from server
- ilmaurizio
- Nouveau
- Posts: 5
- Joined: 18 Oct 2007 12:00
- ilmaurizio
- Nouveau
- Posts: 5
- Joined: 18 Oct 2007 12:00
I am going to try FORCE UPLOAD the next time the error is popping up.
The WARNING you described is NOT the error i get.
I am thinking that's something about a sort of timeout maybe determined by net congestion or so.
The WARNING you described is NOT the error i get.
I am thinking that's something about a sort of timeout maybe determined by net congestion or so.
rockym wrote:Did you try FORCE UPLOAD?
Sometimes, when nothing is changed in the table (modified status NO) and still we try to upload the table, i get below error:
CTM5723 WARNING: SCHEDULING TABLE CLAMIC UP TO DATE. REQUEST REJECTED
Is this the case with you?
- ilmaurizio
- Nouveau
- Posts: 5
- Joined: 18 Oct 2007 12:00
WEll, i tried to UPLOAD the big table .. and had the same error aftrer 30 seconds, then i tried FORCE UPLOAD and i had this error (after few seconds) :
Force Upload Table MyBigTable impossible.
No communication with Gateway <MyProductionName>
There is also a bad side effect from this error : when i have the UPLOAD error i loose connection to server also from Enterprise Manager
Does anyone have any idea about where to search for the solution?
Many thanks in advance.
Force Upload Table MyBigTable impossible.
No communication with Gateway <MyProductionName>
There is also a bad side effect from this error : when i have the UPLOAD error i loose connection to server also from Enterprise Manager
Does anyone have any idea about where to search for the solution?
Many thanks in advance.
ilmaurizio wrote:I am going to try FORCE UPLOAD the next time the error is popping up.
The WARNING you described is NOT the error i get.
I am thinking that's something about a sort of timeout maybe determined by net congestion or so.
rockym wrote:Did you try FORCE UPLOAD?
Sometimes, when nothing is changed in the table (modified status NO) and still we try to upload the table, i get below error:
CTM5723 WARNING: SCHEDULING TABLE CLAMIC UP TO DATE. REQUEST REJECTED
Is this the case with you?
- ilmaurizio
- Nouveau
- Posts: 5
- Joined: 18 Oct 2007 12:00
I was searching in logs for any message that could help and i found this :
[04@11:04:25.949:] ===> ERROR: CTM message queue overflows. max_mf_queue_size = 500000 Actual = 502836
Does anyone knows this parameter "max_mf_queue_size" ?
[04@11:04:25.949:] ===> ERROR: CTM message queue overflows. max_mf_queue_size = 500000 Actual = 502836
Does anyone knows this parameter "max_mf_queue_size" ?
ilmaurizio wrote:WEll, i tried to UPLOAD the big table .. and had the same error aftrer 30 seconds, then i tried FORCE UPLOAD and i had this error (after few seconds) :
Force Upload Table MyBigTable impossible.
No communication with Gateway <MyProductionName>
There is also a bad side effect from this error : when i have the UPLOAD error i loose connection to server also from Enterprise Manager
Does anyone have any idea about where to search for the solution?
Many thanks in advance.
ilmaurizio wrote:I am going to try FORCE UPLOAD the next time the error is popping up.
The WARNING you described is NOT the error i get.
I am thinking that's something about a sort of timeout maybe determined by net congestion or so.
rockym wrote:Did you try FORCE UPLOAD?
Sometimes, when nothing is changed in the table (modified status NO) and still we try to upload the table, i get below error:
CTM5723 WARNING: SCHEDULING TABLE CLAMIC UP TO DATE. REQUEST REJECTED
Is this the case with you?
Hi,
This issue occurs when you have big Tables or many Tables to upload.
Try this:
1. Increase the value of parameter 'max_mf_queue_size' and 'max_ws_queue_size' from the default value (500'000) to 2'097'152 (2Mb) in the 'Defaults.rsc' file.
Normally you find it on your ECSHOME>\gtwgcs\appl\ecs\resource
2. Recycle the Gateway from the Administration Facility
3. Rerun the Upload of the Table (Force mode)
This issue occurs when you have big Tables or many Tables to upload.
Try this:
1. Increase the value of parameter 'max_mf_queue_size' and 'max_ws_queue_size' from the default value (500'000) to 2'097'152 (2Mb) in the 'Defaults.rsc' file.
Normally you find it on your ECSHOME>\gtwgcs\appl\ecs\resource
2. Recycle the Gateway from the Administration Facility
3. Rerun the Upload of the Table (Force mode)
Best regards
Walty
Walty
- ilmaurizio
- Nouveau
- Posts: 5
- Joined: 18 Oct 2007 12:00
Thank You !
That solved the problem.
Best Regards,
Mau
----------
That solved the problem.
Best Regards,
Mau
----------
Walty wrote:Hi,
This issue occurs when you have big Tables or many Tables to upload.
Try this:
1. Increase the value of parameter 'max_mf_queue_size' and 'max_ws_queue_size' from the default value (500'000) to 2'097'152 (2Mb) in the 'Defaults.rsc' file.
Normally you find it on your ECSHOME>\gtwgcs\appl\ecs\resource
2. Recycle the Gateway from the Administration Facility
3. Rerun the Upload of the Table (Force mode)
Hi futre25,
The location of the Gateway log file :
- Windows = home_directory\log
- UNIX = home_directory/log/
The full file name of this file is: gtw_log.data_center.date.seq_num
- data_center = Name of the data center.
- date = current date in yyyymmdd format.
- seq_num = Sequential number for the day. Default: 0.
The location of the Gateway log file :
- Windows = home_directory\log
- UNIX = home_directory/log/
The full file name of this file is: gtw_log.data_center.date.seq_num
- data_center = Name of the data center.
- date = current date in yyyymmdd format.
- seq_num = Sequential number for the day. Default: 0.
Best regards
Walty
Walty