Unable to connect for Direct Generation using "gen.bat"

Manohar Gunti

Active Member
Unable to connect for Direct Generation using \"gen.bat\"

Unable to connect for Direct Generation using "gen.bat"

I receive the following error message when I click on connet on the E-Generator screen
--------------------------------------------------------------------------------------------------------------------------------------------
Index checking did not finish processing in 12 Seconds
If your database is Oracle, Please grant the dbuser ANALYSE_ANY authority to check for indices.
Incomeplete indices on DB, please check the dos screen for details.
--------------------------------------------------------------------------------------------------------------------------------------------

I am able to sign on to webclient and also from the application P95921, Enable role check box is checked.


EnterpriseOne Environment Details :

1) EnterpriseOne 8.11 Tools Release 4 (Enterprise & Deployment Server - Windows 2000 Service Pack 4)
2) Webserver is running on Windows 2000 Service Pack 4
3) Websphere Application Server : 5.0.2 Fixpack 10
4) Database : Oracle (9.2.0.1.0)
5) JAS : EnterpriseOne 8.94


Given below the details of JAS.INI, JDBJ.INI & GEN.BAT

============================================
JAS.INI
============================================
# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#

[SECURITY]
DataSource=System - 811
SecurityServer=ENT811
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=

[OWWEB]
PathCodes=('DV811')
MO QUEUE=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=200
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QB9
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE

# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/


[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000



[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader

[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6013

# JAS Server JDENET Listening port
serviceNameListen=6013

# Maximum number of dedicated kernel types
maxKernelRanges=1

# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000

# JDENET socket connection pool size
maxPoolSize=50

# Directory for JDENET temporary file
tempFileDir=d:\temp

# Clustered logical datasource retry interval
ClusterRetryInterval=60000

# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3


[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=ENT811:6013

# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252

[LOGS]

# JDBC Trace (in stdout)

rtdebugTrace=FALSE
rtlog=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\logs\rt.log
rtdebug=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\logs\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).


# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\logs\stderr.txt
stdout=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\logs\stdout.txt

[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance

[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2


[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=

[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.

# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#

ReapInterval=5
MaxAge=10

[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000
====================================================

====================================================
JDBJ.INI
====================================================
#=======================================================================
# 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.
#
# IMPORTANT: All keys in this file are case sensitive.
#=======================================================================

#=======================================================================
# ERP specific information
#
# These sections apply only when accessing ERP data. These sections are
# ignored for standalone database access.
#=======================================================================

#-----------------------------------------------------------------------
# Bootstrap session
#
# The user, password, role information is optional. It is used by the
# the JDBJ Unit tests and JDBExplorer only if these parameters are not
# specified on the command line. The environment is required field otherwise
# JAS cannot signon to the HTML client.
#
# NOTES: * This information in this section corresponds to the information
# specified in the [DB SYSTEM SETTINGS] section of this installation's
# JDE.INI file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=PSFT
environment=DV811
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 ERP 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
# M = MSDE
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host), or AS/400,
# "localhost". SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# 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,
# MSDE
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB,
# MSDE
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# databaseInstance The instance name of server. (JDELocal) MSDE
# ---------------- --------------------------------------- -----------
# translateOn AS400 translate on (default is FASLE) AS400
# ---------------- --------------------------------------- -----------
#-----------------------------------------------------------------------
#
# 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 - 811
databaseType=O
server=ENT811
serverPort=1521
database=PSFT
physicalDatabase=
owner=SY811
lob=true
unicode=true
databaseInstance=
translateOn=

#-----------------------------------------------------------------------
# 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. JDBj first looks for the name specified in this
# section in the Data Source Master table (F98611). If it finds a data
# source there, it uses it to read the serialized spec tables. If it
# does not find the data source in the Data Source Master table, then
# it initializes a new data source based on the rest of the fields in
# this section.
#
# If this section is not specified, then JDBj uses the OCM to find the
# serialized spec tables. If it is not valid, then no ERP 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=
;databaseType=
;server=
;serverPort=
;database=
;physicalDatabase=
;owner=
;lob=false
;unicode=true
;user=
;password=

#=======================================================================
# END - ERP specific information
#
# The rest of the sections apply when accessing ERP 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.jdbc.sqlserver.SQLServerDriver
# UDB=COM.ibm.db2.jdbc.app.DB2Driver

[JDBj-ORACLE]
tns=D:\Program Files\WebSphere\AppServer\installedApps\aselvam\EA_JS_81_aselvam.ear\webclient.war\WEB-INF\tnsnames.ora

[JDBj-LOGS]
jdbcTrace=false

[JDBj-SERVER]
dbcsConversionTolerant=true

#-----------------------------------------------------------------------
# Connection pool settings
#-----------------------------------------------------------------------

[JDBj-CONNECTION POOL]

; The minimum number of connections to a data source. When closing old connections,
; the value set by this parameter will remain in the pool regardless of use.
;
; Valid values: 0 or greater
; Default value: 5

minConnection=5

; The maximum number of connections to a data source for all users. Additional
; database connection requests beyond this value will be queued for the next available
; connection.
;
; Valid values: 1 or greater (must be equal to or greater than "minConnection")
; Default value: 50

maxConnection=50

; The number of connections to initialize upon pool creation.
;
; Valid values: a value equal to or greater than "minConnection" AND equal to or
; less than "maxConnection"
; Default value: 5

initialConnection=5

; The increment of connections the system will create when a request for a connection
; cannot be satisfied with the current allocation as long as the maxConnection value
; has not been reached.
;
; Valid values: The rule of thumb is (poolGrowth >= maxConnection/10)
; Default value: 5

poolGrowth=5

; Amount of time in milliseconds that a connection remains idle before it is flagged
; to be cleaned up. Keeping this value high may or may not add to performance. Reducing
; the value may reduce memory consumption.
;
; Valid values: 0 or greater
; Default value: 1800000 (30 minutes)

connectionTimeout=1800000

; Amount of time in milliseconds that the pool cleaner is set to clean data sources
; that have a validation string. When cleaning occurs, any connections which have been
; flagged as idle will be cleaned up. The amount of time between a connection
; becoming idle and being cleaned up can be as long as the connectionTimeout value plus
; the cleanPoolInterval value.
;
; Valid values: 0 or greater
; Default value: 600000 (10 minutes)

cleanPoolInterval=600000

; The maximum number of JDBC prepared statements cached on each JDBC connection.
;
; Valid values: 0 or greater
; Default value: 50

maxSize=50

; The number of JDBC statements purged from a JDBC connection if the maxSize limit is
; reached. The statements purged will be the statements in the cache which have not
; been used for the longest amount of time.
;
; Valid values: The rule of thumb is (cachePurgeSize >= maxSize/10 + 2)
; Default value: 5

cachePurgeSize=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]

; AS400 Database ASP property. Use this setting if you are running your iSeries
; server with multiple user databases or IASP (Independent Auxiliary Storage Pool)
; and have your EnterpriseOne tables located on the IASP. The IASP name can be found
; by using the command WRKRDBDIRE. This entry is not needed if you only have *LOCAL
; configured on your system in the WRKRDBDIRE Remote Location name.
;
; Valid values: Any valid string

# AS400DatabaseASP=null

; AS400 package name property. Overrides the default sql package
; name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400Package=JDBj

; AS400 package library name property. Overrides the default sql package
; library name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400PackageLibrary=JDBj-Library

; AS400 extended dynamic property. Overrides the default extended dynamic
; setting with the specified setting. If specified to a false, AS400 database
; will not use packages. This will have a negative impact on performance.
;
; Valid values: true, false

# as400ExtendedDynamic=true

; 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

; Data varification property. Enable or disable the data verification
; between actual data and EnterpriseOne specification for insert and
; update operations.
; The verification is performed on the following types:
; - EVDT_CHAR
; - EVDT_STRING
; - EVDT_NID
; - EVDT_TEXT
; - EVDT_VARSTRING
; - EVDT_VARCHAR
; - EVDT_MATH_NUMERIC
;
; This property will have a negative impact on performance.
;
; Valid values: true or false

# dataVerification=false

; Oracle NCHAR Trimming property. Indicates if the Oracle NCHAR
; Trimming logic is turned or off. True means the returned NCHAR
; data is intact. False means always right trim the returned
; NCHAR data.
;
; Valid values: true or false

# disableOracleNcharTrimming=false

; 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

; 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.
; -1 means that result sets will not timeout.
;
; 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

; OCM cache purge property. Sets the number of
; milliseconds after which inactive OCM cache entries are
; purged. 0 means to never purge OCM cache entries.
;
; Valid values: 0 or greater

# ocmCachePurge=3600000

; Personal Spec Versions property. Indicates if user's personal
; version can be read. This is only enforced during a read and not
; during a spec generation. If it set to a true, the personal version
; will be returned if it exists, otherwise the public version will be
; returned. If the property is set to a false, then the personal
; version will not even be read and we will default to the public
; version
;
; Valid values: true , false

# personalSpecVersions=false

; Service cache purge property. Sets the number of
; milliseconds after which inactive service cache entries are
; purged. 0 means to never purge service cache entries.
;
; Valid values: 0 or greater

# securityCachePurge=3600000


; Service cache purge property. Sets the number of
; milliseconds after which inactive service cache entries are
; purged. 0 means to never purge service cache entries.
;
; Valid values: 0 or greater

# serviceCachePurge=3600000

; Spec 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

# specCachePurge=3600000

; 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=false

; 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 ERP triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: none, single, all

# triggerAutoFetch=none

; 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

#=======================================================================
# END OF FILE
#=======================================================================



====================================================
GEN.BAT
====================================================
@echo off
:please change to your Java SDK1.3 (IBM or SUN only) location on your machine
rem set JDK=C:\jdk
rem set JDK=C:\j2sdk1.4.2_03

set JDK=D:\Progra~1\PeopleSoft\JAS\JS_81_aselvam\_jvm

if exist %JDK%\bin\java.exe goto start

echo No JDK found at location : %JDK%
goto error

:start

:please change for your 'local jas.ini' directory on your machine ( ONLY REQUIRED FOR >>Direct Generation<<)
rem set JAS_INI=C:\B9\internet\dist\jas
set JAS_INI=D:\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF

rem set JASLOGGER=WEB-INF\lib\log4j.jar;<folder containing jdelog.properties>
set JASLOGGER=D:\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF\lib\log4j.jar;D:\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF

:please choose the appropriate Database Drivers ( ONLY REQUIRED FOR >>Direct Generation<<)
:AS400 jt400.jar
:Oracle classes12.jar
:UDB db2java.zip
:SQLServer2000 msbase.jar;msutil.jar;mssqlserver.jar


rem set DBDRIVERS=jt400.jar;classes12.zip;db2java.zip;msbase.jar;msutil.jar;mssqlserver.jar
set DBDRIVERS=classes12.zip

:please set classpath to the required Files
set GEN_CLASSPATH=WEB-INF\classes;WEB-INF\lib\images.jar;WEB-INF\lib\xalan.jar;WEB-INF\lib\xerces.jar;WEB-INF\lib\OWResource.jar;%DBDRIVERS%;%JASLOGGER%

set GENERATOR_OPT="-Xss1m -classic -ms128m -mx512m -Djava.compiler=NONE"

echo Starting Generator with :
%JDK%\bin\java -version

%JDK%\bin\java %GENERATOR_OPT% -Ddefault_path=%JAS_INI% -classpath %GEN_CLASSPATH% com.jdedwards.runtime.generator.Generator %1
rem %JDK%\bin\java -Ddefault_path=%JAS_INI% -classpath %GEN_CLASSPATH% com.jdedwards.runtime.generator.Generator %1
goto check

:check
if errorlevel 1 goto error
goto end
:error
Echo Error!!!
pause
:end
========================================================
 

Attachments

  • 89745-Gen_Error3.jpg
    89745-Gen_Error3.jpg
    102.1 KB · Views: 80

Alex_Pastuhov

Legendary Poster
Re: Unable to connect for Direct Generation using \"gen.bat\"

That's an unusually descriptive message you've got.

Try doing what it tells you to do:
If your database is Oracle, Please grant the dbuser ANALYSE_ANY authority to check for indices.
 

Manohar Gunti

Active Member
Re: Unable to connect for Direct Generation using \"gen.bat\"

I have given Analyse any permission to PSFT user and DV811 user, but the problem could not be solved.
 

jstooge

VIP Member
Re: Unable to connect for Direct Generation using \"gen.bat\"

Although I can't imagine you facing this in 8.11, I know some time back, the indicies on the F989999 and F989998 changed. Perhaps you can try to rebuild the indexes on these two tables in the path code you're attempting to build for.

Regards,
 

Manohar Gunti

Active Member
Re: Unable to connect for Direct Generation using \"gen.bat\"

I have regenerated indexes for the tables F989998 and F989999 through OMW. But i am still getting the error message.

-----------------------------------------------------
Index checking did not finish processing in 12 Seconds
If your database is Oracle, Please grant the dbuser ANALYSE_ANY authority to check for indices.
Incomeplete indices on DB, please check the dos screen for details.
-------------------------------------------------------
and in the dos window, the error message show :

=======================================================
**Generator Diagnostics completed successfully**

\

JAS Connection established

Checking Database indicies
Error Message: <Errors on JAS: >, Error list: :
szError: SVPX03
subText:
alphaDescriptionTemplate: Unknow Exception
glossaryTextTemplate:
errorLevel: 1
idItem: -1
fileName: null
lineNumber: 0


Please manually check for following Indicies in your Serialized Database
Indicies on : F989998
WBJOBID, WBOID,

Indicies on : F989999
WBUID, WBOID, WBLNGPREF,

WBOID, WBUID, WBJVER,

WBOID, WBLNGPREF,

Error Message: <Errors on JAS: >, Error list: :
szError: SVPX03
subText:
alphaDescriptionTemplate: Unknow Exception
glossaryTextTemplate:
errorLevel: 1
idItem: -1
fileName: null
lineNumber: 0



Matching JAS-Gen Code

java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletRequest
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.getMethod0(Unknown Source)
at java.lang.Class.getDeclaredMethod(Unknown Source)
at java.io_ObjectStreamClass.getPrivateMethod(Unknown Source)
at java.io_ObjectStreamClass.access$1300(Unknown Source)
at java.io_ObjectStreamClass$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.io_ObjectStreamClass.<init>(Unknown Source)
at java.io_ObjectStreamClass.lookup(Unknown Source)
at java.io_ObjectStreamClass.<init>(Unknown Source)
at java.io_ObjectStreamClass.lookup(Unknown Source)
at java.io_ObjectOutputStream.writeObject0(Unknown Source)
at java.io_ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io_ObjectOutputStream.writeSerialData(Unknown Source)
at java.io_ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io_ObjectOutputStream.writeObject0(Unknown Source)
at java.io_ObjectOutputStream.writeObject(Unknown Source)
at com.jdedwards.base.util.Statics.obj2binary(Unknown Source)
at com.jdedwards.runtime.generator.engine.ConnectionEngine.matchJASGenCo
de(Unknown Source)
at com.jdedwards.runtime.generator.engine.ConnectionEngine.makeConnectio
n(Unknown Source)
at com.jdedwards.runtime.generator.engine.GeneratorEngine.makeConnection
(Unknown Source)
at com.jdedwards.runtime.generator.view.InitialView.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Logging off successfully
=========================================================
 

Soul Glo

VIP Member
Re: Unable to connect for Direct Generation using \"gen.bat\"

I have had this issue with 8.0 since we installed in and that was 1 employer back. I have applied the ESU that was recommended and still no solution, I have PSFT webexed and they found no solution. The good news is that if I clicked ok/cancel whatever to make the message go away my generation worked. So what I ended up doing was adding the nodiag to the gen.bat so that the error did not show or create any issues. I even raised the question and gave it to the JAS instructor when I took WebSphere/JAS course last october and he did not have a clue.

Back then I was on Oracle 8i.

So i will say if you generation is working once you get passed the error ignore it.
laugh.gif
 

eSky

Well Known Member
Re: Unable to connect for Direct Generation using \"gen.bat\"

Your Jas.ini seems to be very accurate

What i find is the causes in gen.bat file
We have faced the same issue of Database indices in Xe JAS installation and we modify the path which resolved the problem.
In E811 JAS we take same precuation in GEN.bat file and the direct generation works successfully.

Also keep in mind that you modify your GEN.bat located on workstation in folder E811\system\generator\gen.bat


Here are some changes that i would like to bring in notice to you from Our JAS ini. Teh command in @@@@ are what we have in our setup
******************************************************
set JDK=D:\Progra~1\PeopleSoft\JAS\JS_81_aselvam\_jvm

@@@@ set JDK=drive\completepath\java.exe
****************************************************************************************************************

set JAS_INI=D:\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF

@@@@ set JAS_INI= drive\e811\system\Generator\WEB-INF
*****************************************************************************************************************

set JASLOGGER=drive\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF\lib\log4j.jar;drive\PROGRA~1\WEBSPH~1\APPSER~1\INSTAL~2\aselvam\EA_JS_~1.EAR\WEBCLI~1.WAR\WEB-INF

@@@@ set JASLOGGER=drive\e811\system\Generator\WEB-INF\lib\log4j.jar;drive\e811\system\Generator\WEB-INF
***********************************************************************************************************************

set DBDRIVERS=classes12.zip

@@@@ set DBDRIVERS=drive\oracle\ora92\jdbc\lib\classes12.zip
**************************************************************************************************************************

set GEN_CLASSPATH=WEB-INF\classes;WEB-INF\lib\images.jar;WEB-INF\lib\xalan.jar;WEB-INF\lib\xerces.jar;WEB-INF\lib\OWResource.jar;%DBDRIVERS%;%JASLOGGER%

@@@@@ GEN_CLASSPATH=drive\e811\system\Generator\WEB-INF\classes;drive\e811\system\Generator\WEB-INF\lib\images.jar;drive\e811\system\Generator\WEB-INF\lib\xalan.jar;WEB-INF\lib\xerces.jar;D:\e811\system\Generator\WEB-INF\lib\OWResource.jar;%DBDRIVERS%;%JASLOGGER%

*************************************************************************************************************************


--------------------
Sam

--------------------
XE SP22 V5R1M0
EO8.9 8.94_F1 win/oracle 9.2.0.3
 
Top