E1:BSSV Getting "login failed!!" Pop-up Error in JDev When Trying to Add a Database Value Object Class to a BSSV (Doc ID 1469745.1)

Last updated on OCTOBER 12, 2016

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 to 8.98 [Release 8.98]
Information in this document applies to any platform.

Symptoms

Issue1: Customer is trying to create a a value object class in JDeveloper 11g, but getting a “Login failed!!" pop up error message with the following errors in the logs.

JDERoot errors:

08 Jun 2012 11:32:32,383 [SEVERE]  - [KERNEL]          *ERROR* RemoteEnv: execute:COSE#1002 Connection failed: LOCALHOST:6015 host:LOCALHOST:6015 user:MRAMIREZ Env:DV900
08 Jun 2012 11:32:32,384 [WARN  ]  - [RUNTIME]         *ERROR* CallObject@625ba0d9: execute of [LeftJustifyUDCValue] failed! Unable to obtain an environment on LOCALHOST:6015 user:MRAMIREZ Env:DV900

GenFromJNIFlag: Setting value [false] in cache.
08 Jun 2012 11:32:31,372 [SEVERE]  - [KERNEL]          *ERROR* RemoteEnv: execute:COSE#1004 I/O Failed:  host LOCALHOST:6015(6015) SocID:63422: java.net.SocketException Software caused connection abort: recv failed host:LOCALHOST:6015 user:MRAMIREZ Env:DV900

Jasdebug log:

13 Jun 2012 14:46:51,583 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            No available connection in pool - Creating new connection for poolKey jdbc:sqlserver://UTILENT:1433_JDE900_true_JDE
13 Jun 2012 14:46:51,583 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            dataSource.isUnicode() = [true]
13 Jun 2012 14:46:51,584 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]             Connecting to UTILENT with URL : jdbc:sqlserver://UTILENT:1433 DBUser : JDE
13 Jun 2012 14:46:51,592 [Line -1] [AWT-EventQueue-0] [SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900. java.sql.SQLException: No suitable driver found for jdbc:sqlserver://UTILENT:1433
13 Jun 2012 14:46:51,593 [Line -1] [AWT-EventQueue-0] [SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900.
13 Jun 2012 14:46:51,597 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            Using the JDBj datasource named 'Local - DV900' as defined in the JDBJ.ini section [JDBj-SPEC DATA SOURCE].
13 Jun 2012 14:46:51,598 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            Using runtime property Transaction Timeout default value 120000.
13 Jun 2012 14:46:51,598 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            Transaction 3 state initialized to auto commit.
13 Jun 2012 14:46:51,598 [Line -1] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            JDBj spec connection initialized: com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander@119a664.

 

Issue 2: Customer reporting the same issue where login failed had the following error in the jasdebug.log

20 Jan 2015 13:07:57,107 [Line ?] [AWT-EventQueue-0] [DEBUG ]  - [JDBJ]            The jdbj.ini defines a specification datasource overwride, OCM will not be used to the obtain spec datasource Corrective Action :The section [JDBj-SPEC DATA SOURCE] exists in the jdbj.ini which overrides any OCM mappings.
20 Jan 2015 13:07:57,107 [Line ?] [AWT-EventQueue-0] [SEVERE]  - [JDBJ]            Unable to find JDE.INI . java.lang.IllegalStateException: Unable to locate jde.ini file.  Must be able to locate this file in an Mobile configuration.  The path to the jde.ini must in the "java.library.path" java.lang.System property.
java.lang.IllegalStateException: Unable to locate jde.ini file.  Must be able to locate this file in an Mobile configuration.  The path to the jde.ini must in the "java.library.path" java.lang.System property.
    at com.jdedwards.system.security.db.SecurityWIN32LocalDB.<clinit>(Unknown Source)
    at com.jdedwards.database.services.bootstrap.JDBBootstrap.<clinit>(Unknown Source)
    at com.jdedwards.database.jdb.JDBConnectorImpl.getPhysicalConnection(Unknown Source)
    at com.jdedwards.database.jdb.JDBSystem.getPhysicalConnection(Unknown Source)

 

Issue 3:  You are on TR 9.1.4.5 or 9.1.4.6

21 Apr 2015 19:18:55,179 [Line -1] [AWT-EventQueue-0] [SEVERE]  - [INTEROP]         Unable to get initialize UserSession java.lang.NullPointerException
21 Apr 2015 19:18:55,184 [Line -1] [AWT-EventQueue-0] [SEVERE]  - [INTEROP]         com.jdedwards.system.connector.dynamic.ServerFailureException
21 Apr 2015 19:18:55,185 [Line -1] [AWT-EventQueue-0] [SEVERE]  - [INTEROP]           Exception occurred while validating role and/or environment in Java Connector Login method:null com.jdedwards.system.connector.dynamic.ServerFailureException:   Exception occurred while validating role and/or environment in Java Connector Login method:null

  

Issue 4: You are on 9.2.0 tools release

 

LOG FILE
-----------------------
Filename =jderoot_20151119_0.log
See the following error:

19 Nov 2015 12:11:12,645 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920. java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = E1Local)))
19 Nov 2015 12:11:12,645 [SEVERE] - [BASE] com

LOG FILE
-----------------------
Filename =bssv_20151119_0.log
See the following error:
19 Nov 2015 12:11:12,647 [Line -1] [AWT-EventQueue-0] [SEVERE] - [INTEROP] Unable to get initialize UserSession com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920.
19 Nov 2015 12:11:12,649 [Line -1] [AWT-EventQueue-0] [SEVERE] - [INTEROP] [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920. com.jdedwards.system.connector.dynamic.ServerFailureException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920.
19 Nov 2015 12:11:12,650 [Line -1] [AWT-EventQueue-0] [SEVERE] - [INTEROP] Exception occurred while validating role and/or environment in Java Connector Login method:[DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920. com.jdedwards.system.connector.dynamic.ServerFailureException: Exception occurred while validating role and/or environment in Java Connector Login method:[DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV920.
19

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms