Understand the Command (SP) Timeouts tab

On this tab, you can configure a longer command timeout value for specific methods in the MES database. This is necessary for procedures that runs longer than the default command time. If clients consistently get timeout errors from the database when calling a specific middleware method, they may have to increase the timeout for the specific method.

This tab shows the stored procedures or methods and the corresponding timeout values under the Method Name and Timeout value columns respectively.

A method name is a two-part object.command name that the middleware maps to a stored procedure name. The method name is derived from the Object/Cmd/MsgType elements in the XML message sent to the middleware. If the MsgType is exec or getspec, then the method name is created by combining the Object and Cmd with a period (for example, ent.add). If the MsgType is getall, getbykey, or some other value, then the method name is created by combining the Object and the MsgType with a period (for example, ent.getbykey).

This automatic mapping rule also applies to Custom DB and Custom Batch SP Mappings.

To configure the Command (SP) Timeouts

1. Double-click and type the method name you want to configure in the Method Name column.

2. Type the timeout value (in seconds) in the Timeout value column.

3. Click Save.