acollier
Member
Hello,
I'm installing JDE E1 9.0 Standalone on Windows XP Pro SP3. I've followed all of the instructions available, and tried many of the fixes others have tried, but still can't log into the system.
The following is the information on the error and my system setup. Any help is greatly appreciated.
When I try to log into JDE Edwards E9.0 Standalone, I receive the following message:
eSecSystemFailure - Security kernel encountered system problem.
The second log file has the following error messages in the first few lines:
5460/1672 MAIN_THREAD Fri Apr 24 13:00:49.437003 ipcmisc.c299
process 5460 <"D:\B9\system\bin32\jdenet_n.exe"> registered in entry 0
5460/1516 UNKNOWN Fri Apr 24 13:00:49.781005 jdeksec.c768
INITIALIZING SECURITY SERVER KERNEL
5460/1516 UNKNOWN Fri Apr 24 13:00:49.859003 Netpub.c975
JDENet already initialized
5460/1516 UNKNOWN Fri Apr 24 13:00:49.859006 Jdb_ctl.c2890
Net init failed or not initialized
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609100 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609102 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'SPEC_MASTER.DBO.F98740MASTER'.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609104 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609106 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98740MASTER, ODBC DSN EnterpriseOne SSELocal.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609108 Jdbodbc.c3285
SQL Server is setup as follows:
CAOFFICE\CASSDEV2005 (SERVER AND INSTANCE)
I can access the JDE Databases and view the files from SQL Studio Manager.
There are no JDE services running.
The ODBC is EnterpriseOne SSELocal using server CAOFFICE\CASSDEV2005 and defaults to JDEVL. If also tried JDEData. Test connections works for both.
Heres the JDE.ini file:
;OneWorld initialization file JDE.INI
;Client specific version - E900
[JDE_CG]
STDLIBDIR=$(COMP)\VC98\lib
TPLNAME=EXEFORM2
ERRNAME=CGERR
TARGET=Optimize
INCLUDES=$(COMP)\VC98\include;$(SYSTEM)\include;$(SYSTEM)\cg;$(APP)\include;$(SYSTEM)\includev
LIBS=$(COMP)\VC98\lib;$(SYSTEM)\lib32;$(APP)\lib32;$(SYSTEM)\libv32
MAKEDIR=$(COMP)\VC98\bin;$(COMP)\Common\MSDev98\Bin
USER=JDE
[DEBUG]
TAMMultiUserOn=0
Output=FILE
ServerLog=0
LEVEL=BSFN,EVENTS
;BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ
DebugFile=d:\jdedebug.log
JobFile=d:\jde.log
Frequency=10000
RepTrace=0
[Explorer]
ExplorerHomeURL=\B9\SolutionExplorer\data\index.html
ExplorerStart=INTERNET
[PORTALENVMAP]
PD9=JPD9
PY9=JPY9
DV9=JDV9
TS9=JTS9
PR9=JPR9
[EVEREST]
ColorScheme=1
ShowAlias=0
ServerHelpPath=\E900\helps
[SVR]
EnvType=1
EnvironmentName=DEMO
SpecPath=spec
SourcePath=source
ObjectPath=obj
HeaderPath=include
HeaderVPath=includev
BinPath=bin32
LibPath=lib32
LibVPath=libv32
MakePath=make
WorkPath=work
CodeGeneratorPath=cg
ResourcePath=res
IconPath=res\icons
HelpPath=helps
TreeBmpPath=res\treebmps
ModelPath=models
LocalePath=locale
IconvPath=locale\Iconv
LibraryListName=DEMO900
[INSTALL]
DefaultSystem=system
ClientPath=client
ClientInstallPath=EnterpriseOne Client Install
PackagePath=package
DataPath=data
HOSTS=hosts
HP9000=hp9000
SUN=sun
RS6000=rs6000
AS400=as400
Double_Byte=0
LocalCodeSet=WE_ISO88591
ActiveConsole=1
ExplorerShortCut=1
B9=D:\B9
ClientType=standalone
MobileClientDeveloper=yes
SerialNumber=808340334
[LOCK MANAGER]
RequestedService=None
[DB SYSTEM SETTINGS]
Version=43
Default User=DEMO
Default Role=*ALL
Default Env=DEMO900
Default PathCode=DEMO
Base Datasource=System Local
Object Owner=dbo
Server=(local)
Database=EnterpriseOne SSELocal
Load Library=
Decimal Shift =Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=X
Library List=
Library=
DatabaseName2=JDESY
#DatabaseInstance=JDESSELocal
DatabaseInstance=CASSDEV2005
ServerPort=
JDBNETUse=N
UnicodeFlag=Y
LOBFlag=N
ConnectionPooling=0
Default Pwd=_
[DB SYSTEM SETTINGS - SECONDARY]
Base Datasource=Versions Local
Object Owner=dbo
Server=(local)
Database=EnterpriseOne SSELocal
Load Library=
Decimal Shift=Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=X
Library List=
Library=
DatabaseName2=JDEVL
#DatabaseInstance=JDESSELocal
DatabaseInstance=CASSDEV2005
ServerPort=
JDBNETUse=N
UnicodeFlag=Y
LOBFlag=N
ConnectionPooling=0
[REPLICATION]
DataSource=
DefaultEnvironment=DEMO900
RetryInterval=3600
RepTrace=0
ForcedSync=0
[SECURITY]
SecurityServer=localhost
User=DEMO
Password=DEMO
DefaultEnvironment=DEMO900
DataSource=System Local
Default Role=*ALL
[JDENET]
serviceNameListen=6012
serviceNameConnect=6012
netTrace=0
tempFileDir=d:\temp
[JDEMAIL]
mailProfile="Default Exchange Profile"
Rule1=90|OPT|MAILSERVER=mail.jdedwards.com
Rule2=100|DEFAULT|[email protected]
Rule3=110|DEFAULT|[email protected]
Rule4=120|DEFAULT|[email protected]
Rule5=130|OPT|MERGELOCAL=1
Rule6=140|OPT|UPDATELOCAL=0
[NETWORK QUEUE SETTINGS]
UBEQueue=QE900
UBEPriority=5
PrintImmediate=FALSE
SaveOutput=TRUE
InstallSpecs=Y
JDENETTimeout=60
[INTERACTIVE RUNTIME]
DefaultMailServer=C:\Program Files\Microsoft Exchange\Exchng32.exe
DefaultBrowser=http://www.peoplesoft.com
PWndBackground=onemenu.bmp
BITMAP_StatusBar=stbr1.bmp
OBJECTQUEUE=
FONT_FaceName=Arial
FONT_Height=-12
FONT_Weight=400
COLOR_GridBackground=255,255,128
COLOR_GridForeground=0,0,0
COLOR_GridDesktop=64,128,128
COLOR_GridLines=0,0,0
CACHE_UseCache=1
CACHE_MaximumNodes=50
GRID_GridIntegralRows=1
GRID_FONT_FaceName=Arial
GRID_FONT_Height=-12
GRID_FONT_Weight=400
EXCEPTION_Enabled=True
Initial_Language_Code=
Text Limit=80
PWndLocation=0,0,768,537,262144
MirrorImage=
MaxFileUploadSize=50
[UBE]
UBEDebugLevel=0
UBESaveLogFile=0
UBEFont_FaceName=Times New Roman
UBEFont_PointSize=8
BlindRDPrinterPrompt=FALSE
UBEFormatXML=1
UBEXMLVersion=2
[OBJECT LIBRARIAN]
OLTLogMode=YES
OLTLogContents=GENERAL
[SIGNON]
LASTENV=DEMO900
LASTUSER=DEMO
Default Role=*ALL
LastRole=*ALL
SHOWOPTIONS=1
[JDENET_KERNEL_DEF2]
krnlName=UBE KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchUBEMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF4]
krnlName=SECURITY KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchSecurity@28
maxNumberOfProcesses=1
#numberofAutoStartProcesses=0
numberOfAutoStartProcesses=1
[JDENET_KERNEL_DEF6]
krnlName=CALL OBJECT KERNEL
dispatchDLLName=XMLCallObj.dll
dispatchDLLFunction=_XMLCallObjectDispatch@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF12]
krnlName=UBE SUBSYSTEM KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchUBESBSMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF13]
#So html4apps will work with workflow
krnlName=WORK FLOW KERNEL
dispatchDLLName=workflow.dll
dispatchDLLFunction=_JDEK_DispatchWFServerProcess@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF14]
krnlName=QUEUE KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_DispatchQueueMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[LOCALWEB]
# Installation flag, if it is 0, no HTML testing setup, disable all HTML testing
AppServerInstalled=1
# Datasource containing serialized specs for web runtime (F989998 F989999)
# Used for synchonization of specs through JDB
Spec Datasource=Versions Local
# Name of local web server, localhost is default but may not be valid always.
# original - webhostname=localhost
#webhostname=local
webhostname=localhost
# web server port , Websphere Express default is 7080
webport=8888
# executable for starting web server
webserverstart=D:\B9\system\oc4j\startOC4J.bat
# executable for stopping web server
webserverstop=D:\B9\system\oc4j\stopOC4J.bat
# start web server on demand, or immediately
# valid values : ONDEMAND (web server will be started on the first HTTP request) ,
MANUAL (web server has to be started manually by user on port specified),
IMME (web server starts as soon as ActivConsole starts)
# original setting StartAppServer=IMME
StartAppServer=IMME
# delay time between starting web server and launching browser window
# default value is 60 (60 secs)
WebDelay=20
[MTR VALIDATION]
LiteRecords=12
MDACVersion=2.60.6526.2
NMakeVersion=6.00.8168.0
DeployDiskInMB=5000
CDiskInMB=200
BusobjInMB=350
EnterpriseDiskInMB=3000
[XML]
#ICUPath=C:\E900\system\locale\xml
ICUPATH=D:\B9\SYSTEM\LOCALE\XML
webserverstartarg=
webserverstoparg=
Heres the jdbj:
#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#=======================================================================
#=======================================================================
# OneWorld specific information
#
# These sections apply only when accessing OneWorld data. These
# sections are ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# This information is used to sign on to provide access to system
# tables. JDBj signs this user on via the security server at bootstrap-
# time, so if it is not valid, then no OneWorld database access is
# possible.
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP SESSION]
user=DEMO
password=DEMO
environment=DEMO900
role=*ALL
#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no OneWorld database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host). AS/400,
# SQL Server
# ---------------- --------------------------------------- -----------
# database The database. Oracle, UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# ---------------- --------------------------------------- -----------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP DATA SOURCE]
name=System Local
databaseType=X
server=(local)
serverPort=
database=EnterpriseOne SSELocal
physicalDatabase=JDESY
owner=dbo
lob=false
unicode=true
databaseInstance=CASSDEV2005
#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. If this section is not specified, then JDBj will
# use the OCM to find the serialized spec table. If it is not valid, no
# OneWorld database access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------
[JDBj-SPEC DATA SOURCE]
name=Versions Local
databaseType=X
server=localhost
serverPort=3372
database=EnterpriseOne SSELocal
physicalDatabase=JDEVL
owner=dbo
lob=false
unicode=true
databaseInstance=CASSDEV2005
user=sa
password=
#=======================================================================
# END - OneWorld specific information
#
# The rest of the sections apply when accessing OneWorld and standalone
# data.
#=======================================================================
#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------
[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
#AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
#UDB=COM.ibm.db2.jdbc.app.DB2Driver
[JDBj-ORACLE]
tns=tnsnames.ora
[JDBj-LOGS]
jdbcTrace=false
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#
# These are used only when J2EE connection pooling is not available.
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
jdbcPooling=false
minConnection=1
maxConnection=5
initialConnection=1
poolGrowth=1
connectionTimeout=1800000
cleanPoolInterval=600000
maxSize=50
purgeCacheSize=5
#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------
[JDBj-RUNTIME PROPERTIES]
; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater
# dataCacheEntrySizeThreshold=500
; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater
# dataCacheEntryThreshold=100
; E1Menu cache purge property. Sets the number of
; milliseconds after which inactive spec cache entries are
; purged. 0 means to never purge spec cache entries.
;
; Valid values: 0 or greater
# E1MenuCachePurge=600000
; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false
# forceSingleDataSource=false
; No where paren property. Certain TableIO system function
; queries require a long list of selections in the where clause
; without any intermediate parentheses. Specifying a composite
; selections alone for this case creates intermediate
; parentheses. If this property is set to a true then the JDBj
; will create SQL without any intermediate parenetheses.
;
; Valid values: true, false
# noWhereParen=false
; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
;
; Valid values: -1 or greater
# resultSetTimeout=60000
; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater
# retryInterval=0
; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater
# retryMaximum=5
; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none
# specConsistencyCheck=minimal
; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false
specGenerateOnDemand=true
; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable
# transactionIsolation=default
; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater
# transactionTimeout=120000
; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to OneWorld triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: true, false
# triggerAutoFetch=false
; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater
# updatableResultSetTimeout=-1
; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater
usageExecutionThreshold=20000
; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater
usageFetchSizeThreshold=500
; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater
# usageResultSetOpenThreshold=60000
; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false
# usageTracking=false
; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception
# usageTrackingOutput=log
; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater
# usageTransactionActiveThreshold=120000
; Maximum number of parallel application generators.
; Controls how many serialized JAVA application
; objects can be generated at one time.
; For a low-power server, use a lower value.
; For a high-power server, use a higher value.
;
; valid values: 1 or greater
# ParallelAppGens=10
#=======================================================================
# END OF FILE
#=======================================================================
I'm installing JDE E1 9.0 Standalone on Windows XP Pro SP3. I've followed all of the instructions available, and tried many of the fixes others have tried, but still can't log into the system.
The following is the information on the error and my system setup. Any help is greatly appreciated.
When I try to log into JDE Edwards E9.0 Standalone, I receive the following message:
eSecSystemFailure - Security kernel encountered system problem.
The second log file has the following error messages in the first few lines:
5460/1672 MAIN_THREAD Fri Apr 24 13:00:49.437003 ipcmisc.c299
process 5460 <"D:\B9\system\bin32\jdenet_n.exe"> registered in entry 0
5460/1516 UNKNOWN Fri Apr 24 13:00:49.781005 jdeksec.c768
INITIALIZING SECURITY SERVER KERNEL
5460/1516 UNKNOWN Fri Apr 24 13:00:49.859003 Netpub.c975
JDENet already initialized
5460/1516 UNKNOWN Fri Apr 24 13:00:49.859006 Jdb_ctl.c2890
Net init failed or not initialized
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609100 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609102 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'SPEC_MASTER.DBO.F98740MASTER'.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609104 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609106 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98740MASTER, ODBC DSN EnterpriseOne SSELocal.
5460/1516 UNKNOWN Fri Apr 24 13:00:50.609108 Jdbodbc.c3285
SQL Server is setup as follows:
CAOFFICE\CASSDEV2005 (SERVER AND INSTANCE)
I can access the JDE Databases and view the files from SQL Studio Manager.
There are no JDE services running.
The ODBC is EnterpriseOne SSELocal using server CAOFFICE\CASSDEV2005 and defaults to JDEVL. If also tried JDEData. Test connections works for both.
Heres the JDE.ini file:
;OneWorld initialization file JDE.INI
;Client specific version - E900
[JDE_CG]
STDLIBDIR=$(COMP)\VC98\lib
TPLNAME=EXEFORM2
ERRNAME=CGERR
TARGET=Optimize
INCLUDES=$(COMP)\VC98\include;$(SYSTEM)\include;$(SYSTEM)\cg;$(APP)\include;$(SYSTEM)\includev
LIBS=$(COMP)\VC98\lib;$(SYSTEM)\lib32;$(APP)\lib32;$(SYSTEM)\libv32
MAKEDIR=$(COMP)\VC98\bin;$(COMP)\Common\MSDev98\Bin
USER=JDE
[DEBUG]
TAMMultiUserOn=0
Output=FILE
ServerLog=0
LEVEL=BSFN,EVENTS
;BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ
DebugFile=d:\jdedebug.log
JobFile=d:\jde.log
Frequency=10000
RepTrace=0
[Explorer]
ExplorerHomeURL=\B9\SolutionExplorer\data\index.html
ExplorerStart=INTERNET
[PORTALENVMAP]
PD9=JPD9
PY9=JPY9
DV9=JDV9
TS9=JTS9
PR9=JPR9
[EVEREST]
ColorScheme=1
ShowAlias=0
ServerHelpPath=\E900\helps
[SVR]
EnvType=1
EnvironmentName=DEMO
SpecPath=spec
SourcePath=source
ObjectPath=obj
HeaderPath=include
HeaderVPath=includev
BinPath=bin32
LibPath=lib32
LibVPath=libv32
MakePath=make
WorkPath=work
CodeGeneratorPath=cg
ResourcePath=res
IconPath=res\icons
HelpPath=helps
TreeBmpPath=res\treebmps
ModelPath=models
LocalePath=locale
IconvPath=locale\Iconv
LibraryListName=DEMO900
[INSTALL]
DefaultSystem=system
ClientPath=client
ClientInstallPath=EnterpriseOne Client Install
PackagePath=package
DataPath=data
HOSTS=hosts
HP9000=hp9000
SUN=sun
RS6000=rs6000
AS400=as400
Double_Byte=0
LocalCodeSet=WE_ISO88591
ActiveConsole=1
ExplorerShortCut=1
B9=D:\B9
ClientType=standalone
MobileClientDeveloper=yes
SerialNumber=808340334
[LOCK MANAGER]
RequestedService=None
[DB SYSTEM SETTINGS]
Version=43
Default User=DEMO
Default Role=*ALL
Default Env=DEMO900
Default PathCode=DEMO
Base Datasource=System Local
Object Owner=dbo
Server=(local)
Database=EnterpriseOne SSELocal
Load Library=
Decimal Shift =Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=X
Library List=
Library=
DatabaseName2=JDESY
#DatabaseInstance=JDESSELocal
DatabaseInstance=CASSDEV2005
ServerPort=
JDBNETUse=N
UnicodeFlag=Y
LOBFlag=N
ConnectionPooling=0
Default Pwd=_
[DB SYSTEM SETTINGS - SECONDARY]
Base Datasource=Versions Local
Object Owner=dbo
Server=(local)
Database=EnterpriseOne SSELocal
Load Library=
Decimal Shift=Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=X
Library List=
Library=
DatabaseName2=JDEVL
#DatabaseInstance=JDESSELocal
DatabaseInstance=CASSDEV2005
ServerPort=
JDBNETUse=N
UnicodeFlag=Y
LOBFlag=N
ConnectionPooling=0
[REPLICATION]
DataSource=
DefaultEnvironment=DEMO900
RetryInterval=3600
RepTrace=0
ForcedSync=0
[SECURITY]
SecurityServer=localhost
User=DEMO
Password=DEMO
DefaultEnvironment=DEMO900
DataSource=System Local
Default Role=*ALL
[JDENET]
serviceNameListen=6012
serviceNameConnect=6012
netTrace=0
tempFileDir=d:\temp
[JDEMAIL]
mailProfile="Default Exchange Profile"
Rule1=90|OPT|MAILSERVER=mail.jdedwards.com
Rule2=100|DEFAULT|[email protected]
Rule3=110|DEFAULT|[email protected]
Rule4=120|DEFAULT|[email protected]
Rule5=130|OPT|MERGELOCAL=1
Rule6=140|OPT|UPDATELOCAL=0
[NETWORK QUEUE SETTINGS]
UBEQueue=QE900
UBEPriority=5
PrintImmediate=FALSE
SaveOutput=TRUE
InstallSpecs=Y
JDENETTimeout=60
[INTERACTIVE RUNTIME]
DefaultMailServer=C:\Program Files\Microsoft Exchange\Exchng32.exe
DefaultBrowser=http://www.peoplesoft.com
PWndBackground=onemenu.bmp
BITMAP_StatusBar=stbr1.bmp
OBJECTQUEUE=
FONT_FaceName=Arial
FONT_Height=-12
FONT_Weight=400
COLOR_GridBackground=255,255,128
COLOR_GridForeground=0,0,0
COLOR_GridDesktop=64,128,128
COLOR_GridLines=0,0,0
CACHE_UseCache=1
CACHE_MaximumNodes=50
GRID_GridIntegralRows=1
GRID_FONT_FaceName=Arial
GRID_FONT_Height=-12
GRID_FONT_Weight=400
EXCEPTION_Enabled=True
Initial_Language_Code=
Text Limit=80
PWndLocation=0,0,768,537,262144
MirrorImage=
MaxFileUploadSize=50
[UBE]
UBEDebugLevel=0
UBESaveLogFile=0
UBEFont_FaceName=Times New Roman
UBEFont_PointSize=8
BlindRDPrinterPrompt=FALSE
UBEFormatXML=1
UBEXMLVersion=2
[OBJECT LIBRARIAN]
OLTLogMode=YES
OLTLogContents=GENERAL
[SIGNON]
LASTENV=DEMO900
LASTUSER=DEMO
Default Role=*ALL
LastRole=*ALL
SHOWOPTIONS=1
[JDENET_KERNEL_DEF2]
krnlName=UBE KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchUBEMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF4]
krnlName=SECURITY KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchSecurity@28
maxNumberOfProcesses=1
#numberofAutoStartProcesses=0
numberOfAutoStartProcesses=1
[JDENET_KERNEL_DEF6]
krnlName=CALL OBJECT KERNEL
dispatchDLLName=XMLCallObj.dll
dispatchDLLFunction=_XMLCallObjectDispatch@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF12]
krnlName=UBE SUBSYSTEM KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchUBESBSMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF13]
#So html4apps will work with workflow
krnlName=WORK FLOW KERNEL
dispatchDLLName=workflow.dll
dispatchDLLFunction=_JDEK_DispatchWFServerProcess@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[JDENET_KERNEL_DEF14]
krnlName=QUEUE KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_DispatchQueueMessage@28
maxNumberOfProcesses=1
numberOfAutoStartProcesses=0
[LOCALWEB]
# Installation flag, if it is 0, no HTML testing setup, disable all HTML testing
AppServerInstalled=1
# Datasource containing serialized specs for web runtime (F989998 F989999)
# Used for synchonization of specs through JDB
Spec Datasource=Versions Local
# Name of local web server, localhost is default but may not be valid always.
# original - webhostname=localhost
#webhostname=local
webhostname=localhost
# web server port , Websphere Express default is 7080
webport=8888
# executable for starting web server
webserverstart=D:\B9\system\oc4j\startOC4J.bat
# executable for stopping web server
webserverstop=D:\B9\system\oc4j\stopOC4J.bat
# start web server on demand, or immediately
# valid values : ONDEMAND (web server will be started on the first HTTP request) ,
MANUAL (web server has to be started manually by user on port specified),
IMME (web server starts as soon as ActivConsole starts)
# original setting StartAppServer=IMME
StartAppServer=IMME
# delay time between starting web server and launching browser window
# default value is 60 (60 secs)
WebDelay=20
[MTR VALIDATION]
LiteRecords=12
MDACVersion=2.60.6526.2
NMakeVersion=6.00.8168.0
DeployDiskInMB=5000
CDiskInMB=200
BusobjInMB=350
EnterpriseDiskInMB=3000
[XML]
#ICUPath=C:\E900\system\locale\xml
ICUPATH=D:\B9\SYSTEM\LOCALE\XML
webserverstartarg=
webserverstoparg=
Heres the jdbj:
#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#=======================================================================
#=======================================================================
# OneWorld specific information
#
# These sections apply only when accessing OneWorld data. These
# sections are ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# This information is used to sign on to provide access to system
# tables. JDBj signs this user on via the security server at bootstrap-
# time, so if it is not valid, then no OneWorld database access is
# possible.
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP SESSION]
user=DEMO
password=DEMO
environment=DEMO900
role=*ALL
#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no OneWorld database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host). AS/400,
# SQL Server
# ---------------- --------------------------------------- -----------
# database The database. Oracle, UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# ---------------- --------------------------------------- -----------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP DATA SOURCE]
name=System Local
databaseType=X
server=(local)
serverPort=
database=EnterpriseOne SSELocal
physicalDatabase=JDESY
owner=dbo
lob=false
unicode=true
databaseInstance=CASSDEV2005
#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. If this section is not specified, then JDBj will
# use the OCM to find the serialized spec table. If it is not valid, no
# OneWorld database access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------
[JDBj-SPEC DATA SOURCE]
name=Versions Local
databaseType=X
server=localhost
serverPort=3372
database=EnterpriseOne SSELocal
physicalDatabase=JDEVL
owner=dbo
lob=false
unicode=true
databaseInstance=CASSDEV2005
user=sa
password=
#=======================================================================
# END - OneWorld specific information
#
# The rest of the sections apply when accessing OneWorld and standalone
# data.
#=======================================================================
#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------
[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
#AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
#UDB=COM.ibm.db2.jdbc.app.DB2Driver
[JDBj-ORACLE]
tns=tnsnames.ora
[JDBj-LOGS]
jdbcTrace=false
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#
# These are used only when J2EE connection pooling is not available.
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
jdbcPooling=false
minConnection=1
maxConnection=5
initialConnection=1
poolGrowth=1
connectionTimeout=1800000
cleanPoolInterval=600000
maxSize=50
purgeCacheSize=5
#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------
[JDBj-RUNTIME PROPERTIES]
; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater
# dataCacheEntrySizeThreshold=500
; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater
# dataCacheEntryThreshold=100
; E1Menu cache purge property. Sets the number of
; milliseconds after which inactive spec cache entries are
; purged. 0 means to never purge spec cache entries.
;
; Valid values: 0 or greater
# E1MenuCachePurge=600000
; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false
# forceSingleDataSource=false
; No where paren property. Certain TableIO system function
; queries require a long list of selections in the where clause
; without any intermediate parentheses. Specifying a composite
; selections alone for this case creates intermediate
; parentheses. If this property is set to a true then the JDBj
; will create SQL without any intermediate parenetheses.
;
; Valid values: true, false
# noWhereParen=false
; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
;
; Valid values: -1 or greater
# resultSetTimeout=60000
; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater
# retryInterval=0
; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater
# retryMaximum=5
; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none
# specConsistencyCheck=minimal
; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false
specGenerateOnDemand=true
; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable
# transactionIsolation=default
; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater
# transactionTimeout=120000
; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to OneWorld triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: true, false
# triggerAutoFetch=false
; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater
# updatableResultSetTimeout=-1
; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater
usageExecutionThreshold=20000
; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater
usageFetchSizeThreshold=500
; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater
# usageResultSetOpenThreshold=60000
; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false
# usageTracking=false
; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception
# usageTrackingOutput=log
; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater
# usageTransactionActiveThreshold=120000
; Maximum number of parallel application generators.
; Controls how many serialized JAVA application
; objects can be generated at one time.
; For a low-power server, use a lower value.
; For a high-power server, use a higher value.
;
; valid values: 1 or greater
# ParallelAppGens=10
#=======================================================================
# END OF FILE
#=======================================================================
