Error when run TestBusinessService.callBSSVWithXMLFile()

Andrew2009

Well Known Member
I got the below errors when I tried to run this method in Jdeveloper 10g. I'm able to create business services fine and I can do everything else in EOne fine. I got the below error only when I run this method. I'm using EOne 9.0, weblogic, 8.98.3.4 tool release.

TestBusinessService.callBSSVWithXMLFile("oracle.e1.sbf.JC57M001.IBS_OpportunityProcessor",
"updateVendor",
file,
IConnection.AUTO);

-------------------ERROR-------------
com.jdedwards.system.connector.dynamic.ServerFailureException: Exception occurred while validating role and/or environment in Java Connector Login method:[DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
Authentication Failure for BSSV request. Could not get Principal.
-------------------------------------

Below is from the bssv log file

--------------------------------------------

06 Jul 2011 20:51:30,255 [Line ?] [main] [DEBUG ] - [BSSVFRAMEWORK] [Context ID: TokenReauthenticateDelay] Token re-authentication delay set to 3600000.0
06 Jul 2011 20:51:30,817 [Line ?] [main] [DEBUG ] - [INTEROP] Session clearning thread started
06 Jul 2011 20:51:33,032 [Line ?] [main] [SEVERE] - [INTEROP] Unable to get initialize UserSession com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.lookupUser(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntriesWithVersion(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntries(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntry(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getExclusiveRowSecurityEntry(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.<init>(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBSystem.connect(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.lookupUser(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntriesWithVersion(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntries(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntry(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getExclusiveRowSecurityEntry(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.<init>(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBSystem.connect(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
... 35 more
com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.lookupUser(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntriesWithVersion(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntries(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntry(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getExclusiveRowSecurityEntry(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.<init>(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBSystem.connect(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
Caused by: com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
... 21 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
... 35 more
com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.lookupUser(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntriesWithVersion(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntries(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getSecurityEntry(Unknown Source)
at com.jdedwards.database.services.security.SecurityTableManager.getExclusiveRowSecurityEntry(Unknown Source)
at com.jdedwards.database.impl.security.JDBSecurityAccess.<init>(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBSystem.connect(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
Caused by: com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
... 20 more
Caused by: com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
... 21 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
... 35 more
06 Jul 2011 20:51:33,032 [Line ?] [main] [SEVERE] - [INTEROP] [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.) com.jdedwards.system.connector.dynamic.ServerFailureException: [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
com.jdedwards.system.connector.dynamic.ServerFailureException: [DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.system.connector.dynamic.UserSession.initialize(Unknown Source)
at com.jdedwards.system.connector.dynamic.UserSession.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
06 Jul 2011 20:51:33,032 [Line ?] [main] [SEVERE] - [INTEROP] Exception occurred while validating role and/or environment in Java Connector Login method:[DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.) com.jdedwards.system.connector.dynamic.ServerFailureException: Exception occurred while validating role and/or environment in Java Connector Login method:[DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
com.jdedwards.system.connector.dynamic.ServerFailureException: Exception occurred while validating role and/or environment in Java Connector Login method:[DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.E1Principal.login(Unknown Source)
at oracle.e1.bssvfoundation.impl.security.PrincipalCache.getIniPrincipal(Unknown Source)
at oracle.e1.bssvfoundation.impl.jdenet.CallSBFHandler.callSBF(Unknown Source)
at oracle.e1.bssvfoundation.base.TestBusinessService.callBSSVWithXMLFile(Unknown Source)
at oracle.e1.bssv.JC57M001.IBS_OpportunityProcessor.main(IBS_OpportunityProcessor.java:46)
06 Jul 2011 20:51:33,032 [Line ?] [main] [DEBUG ] - [BSSVFRAMEWORK] [Context ID: ] Login failed
Exception occurred while validating role and/or environment in Java Connector Login method:[DATA_SOURCE_NOT_FOUND] Data source for F00950, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.)


---------------------------------------------------
 
Under pathcode directory for example c:\e900\DV900\ini\sbf there are some files to configure:
-jdbj.ini and jdeinterop.ini
-tnsnames.ora (if you use Oracle db)

and under C:\e900\MISC you have to put jdbc driver (for example for Oracle db ojdbc5.jar)
gg
 
As said in previous post seems you are missing connection to Database. check if you have downloaded and using the correct jdbc file.
Also check the security setting in the setup table for business services

chan
 
This answer fixed my problem.

Thank you all for your replies.
 
Back
Top