error while doing connection test for a jdbc system

[Former Member]

Hi all,

i created a JDBC system. i gave all the required information for creating it like username, passowrd, connection URL, driver class name.

i even did the user mapping. But still when i try the connetion test it is giving me an error.

the error message that is visible in the front end is like follows

<i>Test Connection with Connector - Jan 1, 1970 2:29:41 PM

Test Details:

The test consists of the following steps:

1. Retrieve the default alias of the system

2. Check the connection to the backend application using the connector defined in this system object

Results

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.</i>

when i c the log files i noticed the following log messages

<b>

#1.5#00065BF80BD800660000000000000C6C000414205F93044C#1148029181853#/System/Server#sap.com/irj#com.sap.portal.ivs.semantic.systemLandscape#Administrator#435####cf4424d0e71511da940a00065bf80bd8#D:/Triniti_Deployment_Source/infrastructure/fdt/WEB-INF/classes
fdtout.log##0#0#Warning#1#com.sap.portal.ivs.semantic.systemLandscape#Java###Failed to retrieve Password##

#1.5#00065BF80BD800660000000100000C6C000414205F93059D#1148029181853#/System/Server#sap.com/irj#com.sap.portal.ivs.semantic.systemLandscape#Administrator#435####cf4424d0e71511da940a00065bf80bd8#D:/Triniti_Deployment_Source/infrastructure/fdt/WEB-INF/classes
fdtout.log##0#0#Warning#1#com.sap.portal.ivs.semantic.systemLandscape#Java###Failed to retrieve User##

#1.5#00065BF80BD800660000000200000C6C000414205F930770#1148029181853#/System/Server#sap.com/irj#com.sap.portal.ivs.connectorService#Administrator#435####cf4424d0e71511da940a00065bf80bd8#D:/Triniti_Deployment_Source/infrastructure/fdt/WEB-INF/classes
fdtout.log##0#0#Error#1#com.sap.portal.ivs.connectorService#Java###Failed to get connection for system #1#Dummy_JDBC_System#

</b>

can any one please tell me where i am going wrong.

thanks in advance

Pavan Kumar.

[Former Member]

Hi Pavan

look at sap note 754281 might help u.

regards,

kaushal

[Former Member]

Hi kaushal,

Thanks for ur reply.

i have gone through the SAP note that u mentioned in ur reply.

But i already chose the "Validate Connection" to true.

There are some JDBC systems which are pointing to the same DB as the one that my jdbc system is pointing to.

Those systems were created long ago.They r working fine.

Y is my jdbc system not passing the "Connection Test"

Is there any thing else that i need to check

thanks

pavan kumar

[Former Member]

Hi Pavan

i see the log file that u provide

check ur connection properties.

further also check following might help u

http://help.sap.com/saphelp_nw2004s/helpdata/en/29/acd8403e37762ae10000000a155106/frameset.htm

also look at sap note 773401

regards,

kaushal

Message was edited by: kaushal malavia