JDBC connectivity error

[Former Member]

I have done a refresh after installing the ABAP+JAVA then i copied all the filesystems from the source systems to the target system.

Now i checked that my ABAP system is working fine and all work process are showing there

but in Java side I see no work processes and when i try to connect from configtool then i get the following JDBC connectivity error.

#1.5 # #1262869129845#/System/Configuration/Logging##com.sap.tc.logging.APILogger.LogController[setResourceBundleName(String resourceBundleName)]#######Thread[main,5,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The for the has been changed from to )!#5#resource bundle name#LogController#/System/Database/sql/jdbc#<null>#com.sap.sql.log.OpenSQLResourceBundle# #1.5 # #1262869129845#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied

#jdbc:oracle:thin:@stelsap:1527:QAS#<null>#

Please suggest if any one has faced similar kind of problem

Thanks

[stefan_koehler]

Hello Himanshu,

have you changed the database connection string and the secure store?

If not check the hostname and the corresponding user.

Connecting to a Database: http://help.sap.com/saphelp_nw04/helpdata/en/ec/9432d189c445cdacdc7e520981b4b6/content.htm

Managing Secure Store Data: http://help.sap.com/saphelp_nw04/helpdata/en/c4/c13230eea54e7996b89fecef904a1c/content.htm

Regards

Stefan

[markus_doehr2]

> I have done a refresh after installing the ABAP+JAVA then i copied all the filesystems from the source systems to the target system.

That procedure doesn't work, you need to use sapinst to copy the Java part.

The reason is, that the old hostname, SID and database name is stored in the database itself, in various .properties files on the filesystem and, depending on the applications, in other places.

The only supported way of doing system copies of systems that contain Java, is using sapinst export/import.

Markus