Common DB connectivity issue in E1root log

21 Jan 2015 22:41:06,082 [SEVERE] APPYLIEW - [RUNTIME] An exception has been caught by the Web client. Please contact your system administrator. See log for details. Exception id =Exception_2015-01-21 22:41:06.082_APPYLIEW There was a problem with the server while running the business function GetPostedCodefromF03B14.\nPlease exit the application and restart it.\nButton clicked Line number 8\nP03B102_W03B102A com.jdedwards.runtime.base.SystemException: There was a problem with the server while running the business function GetPostedCodefromF03B14.\nPlease exit the application and restart it.\nButton clicked Line number 8\nP03B102_W03B102A 
22 Jan 2015 02:12:01,336 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910. java.sql.SQLRecoverableException: IO Error: Socket read timed out 
22 Jan 2015 02:12:01,336 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910. 
22 Jan 2015 02:12:01,336 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.) com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.) 
22 Jan 2015 02:12:01,336 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.) com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.) 
22 Jan 2015 02:12:01,336 [SEVERE] - [JAS] Exception occured in the JDESignon.jdeSignon() :BuildUserSession Failed. com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.) 
22 Jan 2015 02:13:37,698 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910. java.sql.SQLRecoverableException: IO Error: Socket read timed out 



Ensure to have the following settings:

1. For Windows servers, the Windows HOSTS file (under C:\windows\system32\drivers\etc folder) has IP address(es) setup for other JDE servers. This should be done for all Windows servers, such as HTML Server, Enterprise Server, Batch Server etc. If the IP addresses have previously been set, ensure the IP address is correct as the IP address of a host may change. Apply this to other platforms hosts file.
2. Increase the JDENET time out value.  In the Enterprise Server JDE.INI file, change the timeout to a higher value (see Additional Notes *):
   [NETWORK QUEUE SETTINGS]
   JDENETTimeout=120
   
   Increase this value up to 300 if necessary.
3. Specific to FIREWALL setup, ensure that Enterprise Server JDE.INI file, in the [JDENET] section, this parameter is added or changed to: enablePredefinedPorts=1 and this is used to activate the allocation of a predefined port range (see Additional Notes **).
   
   

Additional Notes:

* JDENETTimeout = The amount of time, in seconds, that a requesting process should wait after sending a JDENET request to wait for the response before considering the message to have timed out.  The default value for this parameter is 60. Do not set over value of 360.

** This needs to be set to '1' for predefined ports to work otherwise the port is completely arbitrary. Predefined ports must be opened to allow communication between servers. The predefined port range is determined by these two INI parameters located in:

[JDENET]
serviceNameListen=6019
maxNetProcesses=4

The range starts at the port number specified by serviceNameListen, and ends at port resulting from the calculation of (serviceNameListen + maxNetProcesses -1).  For example, 6019 (serviceNameListen) + 4 (maxNetProcesses) - 1 => the range of ports used is 6019 to 6022. Therefore these range must be opened in firewall.

If an EnterpriseOne Server is deployed inside a firewall-protected network, the enablePredefinedPorts can be set to 1 so that all NET server ports are allocated within the predefined port range.

As a basic network test, PING and TELNET tests should be performed from the client/E1 HTML Server machine.To perform PING test:
>ping SERVERNAME
To perform TELNET test:
>telnet SERVERNAME PORT
For example:
>telnet ENTSVR 6015
Note: Modern versions of Windows may not have the 'telnet' command. Perform the steps in the following Microsoft document to install 'telnet'.
http://technet.microsoft.com/en-us/library/cc771275(v=ws.10).aspx
If either of these tests fail, report the issue to the IT/network administrator to check and perform the necessary actions to resolve the network issue.