IBM Support

Running agentserver gives Could not use datasourcename YFS10448 Unable to get database connection

Troubleshooting


Problem

Running agentserver gives Could not use datasourcename YFS10448 Unable to get database connection

Symptom

PART: Agents-OM 5.0 SP2 Platform
COMPONENT: Allocate Order

The requirement is to run the agentserver without refering to the lib directory but refering to the yantra.ear deployed in websphere.

Logically all the lib jars are in the ear as classes
And so are the properties.

For some reason, when the yantra.jar, yfs_Main.jar are used in the CLASSPATH, the agentserver gives an error -
2003-09-08 17:26:13,657:DEBUG : Jdbc Url null
: YFSContext
2003-09-08 17:26:13,657:DEBUG : Jdbc UserId null
2003-09-08 17:26:13,658:DEBUG : Opening/getting a new database connection
: YFSContext
Could not use datasourcename. Trying alternate connection mechanism using JDBC U
RL
2003-09-08 17:26:15,254:TIMER : YFSContext - End - [1606]
: YFSContext
2003-09-08 17:26:15,254:ERROR : Failed to Load the locales
: YFSSystem
2003-09-08 17:26:15,255:ERROR : [1063059975254]com.yantra.yfc.util.YFCException
: YFSSystem
2003-09-08 17:26:15,294:ERRORDTL: [1063059975254]TF-8"?>
<Errors>
<Error ErrorCode="YFS10448" ErrorDescription="YFS10448" ErrorRelatedMoreInfo<br>="Unable to get database connection">
<Attribute Name="ErrorDescription" Value="YFS10448"/>
<Attribute Name="ErrorCode" Value="YFS10448"/>
<Attribute Name="ErrorRelatedMoreInfo" Value="Unable to get database con<br>nection"/>
<Stack>com.yantra.yfc.util.YFCException at
com.yantra.yfs.core.YFSContext.createConnection(YFSContext.java:605)
at
com.yantra.yfs.core.YFSContext.<init>(YFSContext.java:195)
at
com.yantra.yfs.core.YFSContext.<init>(YFSContext.java:161)
at
com.yantra.yfs.core.YFSSystem.loadLocales(YFSSystem.java:110)
at com.yantra.yfs.core.YFSSystem.init(YFSSystem.java:64) at
com.yantra.yfs.core.YFSSystem.<clinit>(YFSSystem.java:48)
at java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:115) at
com.yantra.integration.adapter.IntegrationAdapter.main(IntegrationAd
apter.ja va:392) </Stack>
</Error>
</Errors>



The yfs.properties in the ear uses the connection pooling and hence has no JDBC URL etc. But my classpath has the agent specefic properties file earlier in the classpath, why is the one in the yfs_main being picked up?

Cause

Resolving The Problem

Ensure that the oracle driver zip file is in the classpath when starting agentserver.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49234

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21547473