HELP:Upload impossible. Internal error returned from server

ilmaurizio · Post by **ilmaurizio** » 25 Mar 2011 8:46

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
-----

rockym · Post by **rockym** » 28 Mar 2011 11:23

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 · Post by **ilmaurizio** » 29 Mar 2011 10:31

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 · Post by **ilmaurizio** » 04 Apr 2011 11:29

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?

ilmaurizio · Post by **ilmaurizio** » 04 Apr 2011 11:53

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" ?

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?

Walty · Post by **Walty** » 04 Apr 2011 6:07

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)

ilmaurizio · Post by **ilmaurizio** » 05 Apr 2011 1:55

Thank You !

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)

futre25 · Post by **futre25** » 05 Apr 2011 3:08

Hi,

excuse me, but I had the same problem and did not find the error you indicate.

Where you found the log file with the error. What can I say?, Where is the file and it's called.

Thanks to all.

Walty · Post by **Walty** » 08 Apr 2011 1:29

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.