java.net.SocketTimeoutException: Read timed out while doing check out of DC

[Former Member]

Hi,

I have an unique error.

In our project, we have installed NetWeaver 7.0 EHP1 SP4 as the Portal Devlopment Server.

I have done all the steps for Post Installation Steps of NWDI.

Now, there is an SAP SRS Compnent being deployed in Portal and functional consultant are

also using it.

Component Name : ISRSRS05_0-20002510.SCA

Version: SP05 for IS-R-SRS 602.

Now, this component is already being deployed in our Portal Server SAP NetWeaver 7.0 EHP1 SP4.

I was able to import this component in our NWDI track.

The dependent components of this .SCA are EP-BUILDT 7.0, SAP-JEE 7.0, SAP-BUILDT 7.0 and SAP_JTECHS 7.0

All the mandatory steps in Landscape Configurator and Transport Studio in CMS were done without error.

Then, I imported the NWDI track Configuration in NWDS 7.01 SP4.

I am able to import the inactive dcs of IS-R-SRS but when checking out, I am getting

Checkout failed: Checkout file failed (server response: Communication error [cause: Read timed out]):/TST/sap.com_IS-R-SRS/dev/inactive/DCs/sap.com/is/isr/srs/men/app/_comp/src/packages/com/sap/is/isr/srs/men/app/MainAppComp.wdcomponent /DJ1_TST_D~is~isr~srs~men~app~sap.com/src/packages/com/sap/is/isr/srs/men/app/MainAppComp.wdcomponent

The error in NWDS .metadata log is

!MESSAGE Feb 2, 2010 5:48:46 PM       com.sap.dtr.client.lib.protocol.requests.RequestBase     [Thread[main,5,main]] Error: 
java.net.SocketTimeoutException: Read timed out
	at java.net.SocketInputStream.socketRead0(Native Method)
	at java.net.SocketInputStream.read(SocketInputStream.java:129)
	at java.net.SocketInputStream.read(SocketInputStream.java:182)
	at com.sap.dtr.client.lib.protocol.streams.ChunkedInputStream.readLine(ChunkedInputStream.java:327)

But I can create activities successfully in NWDS (DTR).

I am able to write code in Compnent Controller of my custom SC VIN_PRD.

Now, my question is whether this is java.net.SocketException or incompatibility of software.

My delivery manager told me to get the older version of NWDS ie., NWDS 6.40 but I am sure

that will not work with SAP NetWeaver 7.0 EHP1 SP4.

There is an error in DTR log server but on earlier date:

com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task {0} failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTas

Regards

Kaushik Banerjee

[former_member214355 · Accepted solution]

Hi

Can you change 'fullyMaterialzeLobData=false' to

'fullyMaterialzeLobData=true' in the jdbc/pool/DJ1/Url.

Please also refer to note 784568 on this problem

Thanks

Kenny

[Former Member]

Kaushik,

I am able to import the inactive dcs of IS-R-SRS but when checking out...

Are you saying that your NWDS is able to get the source of these DCs into your local environment?

What database/OS is used for the DI system? Have you attempted to use the console clients included with NWDS? I also agree that the logs are going to be your best friend to solve this problem. Please read through both the server and client's log and post anything relevant back to the thread.

Did you adjust the socket timeout per Neha's suggestion? If so, did the errors change?

Kindest Regards,

Zach

Edited by: Zachary Shay on Feb 3, 2010 4:00 PM

[Former Member]

Hi Zach,

NWDS is able to import the inactive dcs of IS-R-SRS but when checking out,

I am getting the

Read Timed Out error.

We have DB2 database installed/ OS is Microsoft Windows 2003 Server R2

Standard x64 Edition Service Pack2.

I can adjust the server settings in NWDS Client on the location

C:\Documents and Settings\Administrator\.dtr -> servers.xml

But it is extending the time of Read Time Out error.

I don't how and where to extend the timeout in DTR or SAP NetWeaver.

There is nothing in the server log for this error.

The client log is: java.net.SocketException Read Timed Out

Regards

Kaushik

[former_member214355]

Hi

DTR communication timeouts error are very likely due to bad DTR responsiveness.

The poor DTR responsiveness is possibly caused by poor DB

performance.

Do the database data spaces and log spaces look

healthy?

Can you try Update statistics of all DTR tables (PVC_, DAV_)

You can also try the following;

Please start the Visual Admin of the Engine and check that the following

values are set:

Dispatcher-> Services->HTTP Provider -> Properties TAB

KeepAliveTimeout = 300 (seconds)

MaxRequestContentLength = 1048576 (kB)

Server->Services-> HTTP Provider -> Properties TAB

ServletsLongDataTransferTimeout = 600000 (milli seconds)

Then restart the whole Engine and retry

[Former Member]

Hi Kelly,

I am specyfing the DB2 Configuration by executing the command

GET DATABASE CONFIGURATION

Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2560

Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC

Max number of active applications (MAXAPPLS) = AUTOMATIC

I think this should match with the one given in the link

http://help.sap.com/saphelp_nw04s/helpdata/en/36/a9de3f68d48f15e10000000a155106/content.htm

Other Settings below are set as told by you:

Dispatcher-> Services->HTTP Provider -> Properties TAB

KeepAliveTimeout = 300 (seconds)

MaxRequestContentLength = 1048576 (kB)

Server->Services-> HTTP Provider -> Properties TAB

ServletsLongDataTransferTimeout = 600000 (milli seconds)

How to update the DTR tables PVC_, DAV_ ?

Regards

Kaushik

[Former Member]

Kaushik,

Are these server distributed over a global network? If so, this could really just be a network performance issue.

This solution assumes that there are no other issues besides some sort of timeout exception. Please look at the following [wiki page.|http://wiki.sdn.sap.com/wiki/display/JSTSG/(WSR)Problems-P01] This page will explain the process of increasing the SocketTimeOut indefinitely. This isn't a client change, it is a server change. That being said, you will need to have access to the Web AS through Visual Administrator.

Kindest Regards,

Zach

[Former Member]

Hi Zach,

I have got some updated DTR Log.

Regards

Kaushik Banerjee

-

---

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7185 - 630]/>

<!NAME[logFile]/>

<!PATTERN[dtr.log]/>

<!FORMATTER[com.sap.tc.logging.ListFormatter]/>

<!ENCODING[UTF8]/>

<!FILESET[3, 20, 2000000]/>

<!PREVIOUSFILE[dtr.2.log]/>

<!NEXTFILE[dtr.4.log]/>

<!LOGHEADER[END]/>

#1.5 #0050568941311FAD0000000600000A3C000478FB3DAC2C8F#1258920373644#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##7c361904d7a211de984a005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33450_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33450]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask# #1.5 #0050568941311FAE0000000600000A3C000478FB3F786F71#1258920403800#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##8e260afcd7a211dec7b6005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33451_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33451]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask#

#1.5 #0050568941311FAF0000000600000A3C000478FB4140468D#1258920433675#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##a0007bc0d7a211de8ff6005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33452_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33452]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask# #1.5 #0050568941311FB00000000600000A3C000478FB430BEBA2#1258920463800#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##b1f2f51cd7a211deaaab005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33453_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33453]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask#

#1.5 #0050568941311FB10000000600000A3C000478FB44D3D00A#1258920493675#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##c3bf0c4dd7a211de9e61005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33454_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#33454]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask# #com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask#

#1.5 #005056894131229F0000000600000A3C000478FF9EEF477D#1258939185233#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##48cd3d11d7ce11de8fda005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#34077_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#34077]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask# .resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask#

#1.5 #00505689413124160000000600000A3C00047901CEAD3702#1258948576120#/Applications/DTR/BackgroundTasks#sap.com/tc_dtrenterpriseapp#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Guest#0##n/a##26329b80d7e411de881f005056894131#Thread[Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#34390_workerThread\#0,1,Scheduler_com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask\#34390]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.AbstractSessionBoundTask#Java#background.outOfDBConnections#com.tssap.dtr.server.deltav.resources.log_messages#Service unavailable, running background task failed. Database connection pool is out of connections. Check connection pool and database settings.#1#com.tssap.dtr.server.deltav.runtimeconfig.impl.ConfigParamsCheckerTask#

Unregistration of DTR monitoring MBean failed. Check monitoring service of J2EE engine.#

[Former Member]

Service unavailable, running background task {0} failed. Database connection pool is out of connections.
Check connection pool and database settings.

Try checking out this [link|http://help.sap.com/saphelp_nw70/helpdata/de/2d/732441509fa831e10000000a1550b0/content.htm]. Section 2 looks promising.

Kindest Regards,

Zach

[Former Member]

Hi,

I am getting an error in my database logs under:

E:\usr\sap\DJ1\JC61\j2ee\cluster\server0\log\system

Regards

Kaushik Banerjee

-

---

1. 1.5 # 005056894131001A000000260000191400047D7FA459225F # 1263887080222 # / System / Database / sql / jdbc / directrices com.sap.sql.jdbc.direct.DirectPreparedStatement # # # # # # n / a # # # 396c2f1f04c711df8b36005056894131 Thread [CBS BSA Orc, 10, SAPEngine_System_Thread [ impl: 5] Group] # # 0 # 0 # Error # 1 # # com.sap.sql.jdbc.direct.DirectPreparedStatement Java com.sap.sql0003 # # # com.sap.sql.log.OpenSQLResourceBundle SQL error occurred on connection 10.xxx.xx.xx: DJ1: SAPDJ1DB: code =- 4228, state = "null", message = "[JCC] [t4] [102] [10040] [x.50.xxx] Error in non-atomic bundle. bundle shipped , but we encounter any minimum u00C3 u00A9 n deviation of an element in the bundle.

Use getNextException () to retrieve variations of specific bundle of features. ErrorCode =- 4228, SQLSTATE = null

=> (-803.23505, Error for batch element \ # 1: DB2 SQL Error: SQLCODE =- 803, SQLSTATE = 23505, SQLERRMC = 1; SAPDJ1DB.CBS_LOCK, DRIVER = x.50.xxx) ";

SQL statement is "INSERT INTO" CBS_LOCK "(" LOCKID "," LOCK GROUP "," LOCKIT ") VALUES (?,?,?)".# 5 # -4228 # # <null> [JCC] [t4] [102 ] [10040] [x.50.xxx] Error in non-atomic bundle. Bundle is shipped, but we encounter a minimum of u00A5 u00C3 u00A9 n deviation of an element in the bundle.

This looks the solution of the DTR issue.

http://help.sap.com/saphelp_nw70/helpdata/de/2d/732441509fa831e10000000a1550b0/content.htm

But I am still getting the error after increasing the parameter to 900

from 100.

Now the questions is: " If the number of used connections (number

in red) is the less than the number of free connections (number in

green), then check the log file for the following error messages.

○ Service unavailable, cannot serve request. Database connection

pool is out of connections. Check connection pool and database settings.

○ Service unavailable, running background task failed. Database

connection pool is out of connections. Check connection pool and

database settings."

My case red value is: 3 and green value is: 4.

Now, the SAP help states that "You must change the parameter

sysDS.maximumConnections to an appropriate value. Ensure that the value

is less than the number of database sessions as defined by the database

(refer to the next session to find the number of database sessions

which are active)."

How to find the number of database sessions which are active?

Regards

Kaushik Banerjee

Edited by: Kaushik Banerjee on Feb 15, 2010 2:57 PM

[Former Member]

I've never used DB2 before, but a google search of "db2 find active sessions" produced [this|http://stackoverflow.com/questions/261512/how-to-find-all-open-active-connections-in-db2-8-x].

Another link from that google serach suggested:

db2 attach to <instance name>

then

db2 list applications show details
OR
db2 list applications # show detail

-zach

[Former Member]

Hi,

Note 826419 helps with your issue.

But you don't have the right version do the necessary steps.

It looks you don't have the right version of IS-R-SRS.sca deployed in portal.

Please try to import some other file and check whether you can check out DC

from that those SC.

If you face the same error, then it is some thing to do with SocketException.

Also, contact SAP for help.

May other experts can help you.

Regards

Neha Singh

[Former Member]

Hi,

This looks a network issue.

I need more replies.

Please help me.

Regards

Kaushik Banerjee

[former_member214355]

Hello

Could you please check whether the DTR is up and running?

Can you access it by invoking its webui (http://<host>:<port>/dtr) ?

You can try to restart it from the visual administrator's deploy

service. The application name you need to look for this case is:

sap.com\tc_dtrenterpriseapp

What is the version of the NWDS on the client side? Please ask the

involved developers about it, and let me know. You find this information

in NWDS help about. .

If the NWDS on client side is very old, then you can face communication

problems (since the NWDS has also DTR client). Do you face the same

problem by all developers, or only by some of them?

Thanks

Kenny

[Former Member]

Hi Kenny,

I can access DTR webui (http://<host>:<port>/dtr .

On restart of sap.com\tc_dtrenterapp, I will try it now.

Version of NWDS is:

SAP NetWeaver Developer Studio

Version: 7.01.04

Build id: 200904170509

Vesrion of SAP NetWeaver Server is:

Software Components all components...

Name Version Applied

sap.com/SAP-JEECOR 7.01 SP4 (1000.7.01.4.0.20090417015900) 20090702221933

sap.com/SAP-JEE 7.01 SP4 (1000.7.01.4.1.20090612152648) 20090702221803

We are facing this in all NWDS clients.

Regards

Kaushik

[former_member214355]

please look at the latest server default trace for error messages.

It may be an authentication issue?

[Former Member]

Hi Kenny,

I have given all these roles to my Portal User:

NWDI.Operator

NWDI.Administrator

NWDI.Configurator

NWDI.Developer

I think, I should all the roles and keep the NWDI.Developer role with me.

Regards

Kaushik