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.
Historical Number
PRI49234
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21547473