Java Engine not connecting to Database

[Former Member]

Dears,

I am facing this issue from a long time,My java engine is not working in ECC5.

Reason is that Java engine is not able to connect to database.There is no issue on ABAP side,Its working fine.

Checked user SAPSIDDB its not locked and working fine.

Configtool log says:

#1.5#C000ACA8010400010000002801CF243B00045697383075A8#1221107389593#/System/Configuration/Logging##com.sap.tc.logging.APILogger.FileLog[setFormatter()]#######Thread[AWT-EventQueue-0,6,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The for the has been changed from to )!#5#formatter#FileLog#.
system.log#com.sap.tc.logging.ListFormatter#com.sap.tc.logging.ListFormatter# #1.5#C000ACA8010400010000002901CF243B00045697383075A8#1221107389593#/System/Server##com.sap.engine.core.configuration#######Thread[AWT-EventQueue-0,6,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###Properties for connect through secure store not set. Please check your connect properties. Trying to connect via plain user/password.# Server0 default trace HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F75900630000004C0000172000045142445FBF8F#1215244963612#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0##server2.prospecta_PRO_5851450#Guest#bf352bd04a6811ddc25800145e41f759#SAPEngine_Application_Thread[impl:3]_37##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F759006A000000490000172000045142445FE546#1215244963612#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0####bf3775c04a6811dd999100145e41f759#SAPEngine_Application_Thread[impl:3]_32##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# Dispatcher Default trace #1.5#00145E41F7590016000000B400001710000451401221E8F9#1215235531374#com.sapmarkets.bam.jmxadapter.util.LogDirectory##com.sapmarkets.bam.jmxadapter.util.LogDirectory#######SAPEngine_System_Thread[impl:6]_26##0#0#Error#1#/System/Server#Plain###Error writing log directory entryD:
tmp
server2_PRO_00_5851400_lv_.xml (The system cannot find the path specified)# #1.5#00145E41F7590016000000B500001710000451401221EAE3#1215235531374#com.sapmarkets.bam.jmxadapter.sapjlog.LogTypeConfiguratorImpl##com.sapmarkets.bam.jmxadapter.sapjlog.LogTypeConfiguratorImpl#######SAPEngine_System_Thread[impl:6]_26##0#0#Error##Java###ASCII path registration error: log .
.hotspot_compiler [EXCEPTION] #1#com.sapmarkets.bam.util.BAMRuntimeException: <Localization failed: ResourceBundle='com.sapmarkets.bam.util.LogViewerMessages', ID='Error while writing to directory.', Arguments: []> : Can't find resource for bundle java.util.PropertyResourceBundle, key Error while writing to directory.

dev_jcmon

[Thr 5296] Wed Nov 15 17:44:42 2006

[Thr 5296] *** ERROR => Can't open property file [D:\usr\sap\PRO\SCS01\j2ee\cluster\instance.properties] [jstartxx.c 698]

[Thr 5296] Wed Nov 15 17:44:54 2006

[Thr 5296] *** ERROR => Can't attach to administration shared memory (rc=3) [jcmonxx.c 219]

Please suggest.

Shivam

Edited by: Shivam Mittal on Sep 11, 2008 7:55 AM

[Former Member]

HI,

please verify that the settings you have entered are correct.

I think the user name does not exist in the database which is there in Java.

I guess that is the reason it is unable to connect to the database.

Kinldy check and let me know if creating the user with the same credentials of the source system, could resolve the issue.

If that is the case create the a user with the correct credentials in the correct DB and use these credentials in the config tool to log into the DB.

can you please backup all the files in the workdirectory by moving them to anohter folder then restart the engine.

Thanks & Regards,

Pradeep Srigiri

[Former Member]

Hi Pradeep

I think the user name does not exist in the database which is there in Java

.

Please tell me the user name a i think definately both have different users like in java J2ee_* and in database SAPSIDDB.

Shivam

[Former Member]

Finally issue resolved with the help of SAP.

They provided one note SP_Check_login that reset all schema properties as per SAP standred and issue resolved.

Thanks all for your support.

Shivam

[Former Member]

To add ... ( i can't see the "edit" as the thread is lengthy ..)

The web service can't authenticate the user. Check the rights ..

Regards,

Srihari

[Former Member]

Hi Srihari,

As I am new to Java Stack not having much idea of which rights required for web service to connect.

Please suggest.

Shivam

[Former Member]

Hi Shivam,

>Server0 default trace

>HTTP request processing failed. HTTP error 401 will be returned. The error is http://Cannot authenticate >the user.No details available.#

>#1.5#00145E41F75900630000004C0000172000045142445FBF8F#1215244963612#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0##server2.prospecta_PRO_5851450#Guest#bf352bd04a6811ddc25800145e41f759#SAPEngine_Application_Threadimpl:3_37##0#0#Error#1#/System /Server#Plain###User J2EE_GUEST, IP address

the user name (J2EE_GUEST) signifies that it is a guest user from which you're trying to connect to the database. And i hope this user is not having admin rights. If so, please choose a user who has admin rights (may be <sid>adm???) ...

Regards,

Srihari

[Former Member]

Hi,

The Java instance bootstrap process creates a file called

instance.properties, containing the instance description, at

operating system level.

JControl imports the instance description from the file system

( Instance.properties )

But as per your log above it shows that

" ERROR => Can't open property file D:\usr\sap\PRO\SCS01\j2ee\cluster\instance.properties "

System is unable to fetch the instance properties from instance.properties file.

Just check out whether you are able to locate the instance.properties in the folder j2ee/cluster folder,

Rgds

Radhakrishna D S

[Former Member]

Hi Radhakrishna,

In D:\usr\sap\PRO\SCS01 we don't have j2ee folder there.Its availble in DVEBMGS00 folder and instance.properties file is also available at D:\usr\sap\PRO\DVEBMGS00\j2ee\cluster.

File contents are:

ID5851400.ClassPath=./bin/boot/boot.jar:./bin/system/bytecode.jar:.

ID5851400.Debuggable=no

ID5851400.JLaunchParameters=

ID5851400.JavaParameters=-Djava.security.policy=./java.policy -Djava.security.egd=file:/dev/urandom -Djco.jarm=1

-XX:NewSize=28m -XX:MaxNewSize=28m -Xms170m -XX:+DisableExplicitGC -Drdbms.driverLocation=D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/base.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/util.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/sqlserver.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/spy.jar -Dsys.global.dir=D:/usr/sap/PRO/SYS/global/

ID5851400.LogName=dispatcher

ID5851400.MainClass=com.sap.engine.boot.Start

ID5851400.MaxHeapSize=170

ID5851400.Name=dispatcher

ID5851400.Parameters=

ID5851400.RootPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/cluster/dispatcher

ID5851400.Type=dispatcher

ID5851450.ClassPath=./bin/boot/boot.jar:./bin/boot/jaas.jar:./bin/system/bytecode.jar:.

ID5851450.DebugMode=yes

ID5851450.DebugPort=50021

ID5851450.Debuggable=yes

ID5851450.JLaunchParameters=

ID5851450.JavaParameters=-Djavax.security.auth.useSubjectCredsOnly=false -Djava.security.krb5.conf=D:\usr\sap\PRO\krb5.conf -Dsun.security.krb5.debug=true -Djava.security.policy=./java.policy -Djava.security.egd=file:/dev/urandom -Dorg.omg.CORBA.ORBClass=com.sap.engine.system.ORBProxy -Dorg.omg.CORBA.ORBSingletonClass=com.sap.engine.system.ORBSingletonProxy -Djavax.rmi.CORBA.PortableRemoteObjectClass=com.sap.engine.system.PortableRemoteObjectProxy -Djco.jarm=1 -Dsun.io.useCanonCaches=false -Djava.awt.headless=true -XX:SoftRefLRUPolicyMSPerMB=1 -verbose:gc -XX:PrintGCDetails -XX:PrintGCTimeStamps -XX:UseParNewGC -Xms512M -Xmx512M -XX:MaxNewSize=85M -XX:NewSize=85M -XX:DisableExplicitGC -XX:MaxPermSize=192M -XX:PermSize=192M -XX:SurvivorRatio=2 -XX:TargetSurvivorRatio=90 -Drdbms.driverLocation=D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/base.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/util.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/sqlserver.jar:D:/usr/sap/PRO/DVEBMGS00/j2ee/jdbc/spy.jar -Dsys.global.dir=D:/usr/sap/PRO/SYS/global/

ID5851450.LogName=server0

ID5851450.MainClass=com.sap.engine.boot.Start

ID5851450.MaxHeapSize=512

ID5851450.Name=server0

ID5851450.Parameters=

ID5851450.RootPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/cluster/server0

ID5851450.Type=server

bootstrap.ClassPath=./bootstrap/launcher.jar

bootstrap.JavaParameters=-Djco.jarm=1 -Djco.jarm=1

bootstrap.MainClass=com.sap.engine.offline.OfflineToolStart

bootstrap.MaxHeapSize=128

bootstrap.Name=bootstrap

bootstrap.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0058514

bootstrap.RootPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/cluster

bootstrap.Type=bootstrap

bootstrap_ID5851400.ClassPath=./bootstrap/launcher.jar

bootstrap_ID5851400.JLaunchParameters=

bootstrap_ID5851400.JavaParameters=-Djco.jarm=1 -Djco.jarm=1

bootstrap_ID5851400.MainClass=com.sap.engine.offline.OfflineToolStart

bootstrap_ID5851400.MaxHeapSize=170

bootstrap_ID5851400.Name=dispatcher bootstrap

bootstrap_ID5851400.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID005851400

bootstrap_ID5851400.RootPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/cluster

bootstrap_ID5851400.Type=bootstrap

bootstrap_ID5851450.ClassPath=./bootstrap/launcher.jar

bootstrap_ID5851450.JLaunchParameters=

bootstrap_ID5851450.JavaParameters=-Djco.jarm=1 -Djco.jarm=1

bootstrap_ID5851450.MainClass=com.sap.engine.offline.OfflineToolStart

bootstrap_ID5851450.MaxHeapSize=600

bootstrap_ID5851450.Name=server0 bootstrap

bootstrap_ID5851450.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID005851450

bootstrap_ID5851450.RootPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/cluster

bootstrap_ID5851450.Type=bootstrap

instance.box.number=PRODVEBMGS00server2

instance.en.host=server2

instance.en.port=3201

instance.enabled=yes

instance.install.dir=D:\usr\sap\PRO\DVEBMGS00\j2ee

instance.ms.host=server2

instance.ms.port=3601

instance.osLibsPath=D:/usr/sap/PRO/DVEBMGS00/j2ee/os_libs

instance.runAction=NONE

instance.runMode=NORMAL

instance.system.id=0

Is there any Parameter that tell Java where instance.properties file is located.

Please suggest.

Shivam

[Former Member]

Hi,

The file instance.properties is stored under

\usr\sap\<SID>\<instance>\j2ee\cluster. The storage location

is specified in the instance profile (\usr\sap\<SID>\SYS\profile)

Rgds

Radhakrishna D S

[Former Member]

Hi,

Actually u can share the /j2ee/ folder within \usr\sap\PRO\SCS01\ so that you can resolve the issue.

Rgds

Radhakrishna D S

[Former Member]

Hi,

Parameter is set as

INSTANCE_PROPERTIES = $(DIR_INSTANCE)/j2ee/cluster/instance.properties

As i have ABAP+Jave stack so i think it is ok.I don't know in logs it is searching file in usr\sap\PRO\SCS01.

Should i change it usr/sap/PRO/DVEBMGS00/j2ee/cluster/instance.properties.

Please suggest.

Shivam

[Former Member]

Hi,

You can try the same as you have specified in your earlier update.

Just check out the value of the DIR_INSTANCE parameter. You can check the value by running rsparam report using se38.

Acutally it should point to /usr/sap/<SID>/<Instance>/

Rgds

Radhakrishna D S

[Former Member]

Set

DIR_INSTANCE D:\usr\sap\PRO\DVEBMGS00

restarted system but same same error.

Also copied j2ee to SCS01 but same issue.

Shivam