eGenerator error

[oleg_d]

I have a problem with eGenerator.
Environment: JDE 8.10
Tools 8.95.R1
eGenerator 5.0
WebSphere Express 5.0
There are separate computers for deployment, enterprise, JAS server and generation machine.
On generation machine
1. was performed all actions for preparing JAS setup
(installation JAS server on separate computer, setup WebSphere Express from CD and eGenerator from "\\DepServer\E810\OneWorld Client Install\ThirdParty\WebDevFeature\setup.exe" on Client computer), preparing jas.ini, jdbc.ini, tnsnames.ora in eGenerator directory), installation plan and installation workbench.
2. run eGenerator
3. loging into JDV810 environment
4. select Direct generation and press Connect:
error:
<font class="small">Code:</font><hr /><pre>
19 Feb 2007 17:18:19,922 [ConectionThread] ERROR: {com.jdedwards.jas} - OneWorld JAS startup complete
19 Feb 2007 17:18:19,969 [ConectionThread] DEBUG: {com.jdedwards.system.net} - netTrace in [JDENET] read and set to false
19 Feb 2007 17:18:20,016 [ConectionThread] DEBUG: {com.jdedwards.jas} - User Authenticated
19 Feb 2007 17:18:20,016 [ConectionThread] ERROR: {com.jdedwards.system.none} - SecurityServer already exists, no override allowed
19 Feb 2007 17:18:20,031 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Signing on user PSFT to OneWorld environment JDV810 with role *ALL.
19 Feb 2007 17:18:20,062 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Sign on: valid = true
19 Feb 2007 17:18:20,062 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Sign on: password about expired = false
19 Feb 2007 17:18:20,062 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Sign on: password expired = false
19 Feb 2007 17:18:20,062 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Sign on: status = 0
19 Feb 2007 17:18:20,062 [ConectionThread] INFO : {com.jdedwards.database.impl.signon.JDBSignon} - Sign on: error message ID = 330
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - JDBj version information:
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Specification title: null
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Specification version: null
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Specification vendor: null
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Implementation title: null
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Implementation version: null
19 Feb 2007 17:18:20,078 [ConectionThread] INFO : {com.jdedwards.database.jdb.JDBVersion} - Implementation vendor: null
19 Feb 2007 17:18:20,109 [ConectionThread] DEBUG: {com.jdedwards.database.impl.config.JDBSystemProperties} - Using runtime property AS400 Database ASP default value null.
19 Feb 2007 17:18:20,109 [ConectionThread] DEBUG: {com.jdedwards.database.impl.config.JDBSystemProperties} - Using runtime property AS400 Package default value JDBj.
19 Feb 2007 17:18:20,109 [ConectionThread] DEBUG: {com.jdedwards.database.impl.config.JDBSystemProperties} - Using runtime property AS400 Package Library default value null.
19 Feb 2007 17:18:20,109 [ConectionThread] DEBUG: {com.jdedwards.database.impl.config.JDBSystemProperties} - Using runtime property AS400 Extended Dynamic default value true.
19 Feb 2007 17:18:20,109 [ConectionThread] INFO : {com.jdedwards.database.impl.physical.JDBConnectionManager} - JDBC Driver [oracle.jdbc.driver.OracleDriver] is registered. Major Version [1] Minor Version [0]
19 Feb 2007 17:18:20,234 [ConectionThread] INFO : {com.jdedwards.database.services.bootstrap.JDBBootstrap} - JDBj bootstrap spec map initialized.
19 Feb 2007 17:18:20,234 [ConectionThread] INFO : {com.jdedwards.database.services.bootstrap.JDBBootstrap} - JDBj bootstrap data source initialized: System - 810.
19 Feb 2007 17:18:20,234 [ConectionThread] INFO : {com.jdedwards.database.services.bootstrap.JDBBootstrap} - JDBj serialized access override found in config file.
Unable to connect JAS in logs
[ConectionThread] ERROR: {com.jdedwards.database.base.JDBException} - com.jdedwards.database.base.JDBException: [BOOTSTRAP_ERROR] An error occurred during bootstrap.
com.jdedwards.services.objectlookup.MalformedDataSourceException: Data source name attribute not specified correctly.
at com.jdedwards.services.objectlookup.BaseDatabaseDataSource.<init>(Unknown Source)
</pre><hr />

[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=
environment=JDV810
role=*ALL

[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 810
databaseType=O
server=HS201
serverPort=
database=ORCL
physicalDatabase=
owner=SY810
lob=false
unicode=true
#databaseInstance=

All in
[JDBj-SPEC DATA SOURCE]
section is commented

When I uncomment this section and enter parameters from Oracle, for example

name=Local - JDV810
databaseType=M
server=PCNAME
serverPort=3372
database=JDELocal_DV810
physicalDatabase=JDELocal_DV810
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=sa
password=

first error about bootstrap disappeared and it attempts to communicate with MSSQL server with such error:
<font class="small">Code:</font><hr /><pre>
[ConectionThread] INFO : {com.jdedwards.database.impl.physical.JDBConnectionManager} - Connecting to JDELocal_DV810 with URL : jdbc:microsoft:sqlserver://localhost\JDELocal DBUser : JDE
[ConectionThread] ERROR: {com.jdedwards.database.base.JDBException} - com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - JDV810.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

</pre><hr />
I don't know, why there is such connection string?
I think, there should be PCNAME instead of localhost at least.

So, I have 2 such problems.
Maybe someone can give me advice?

Thanks

 

[riko44]

[JDBj-SPEC DATA SOURCE] should be commented out.
E1 will generate everything based on the OCMs for tables F989999 and F989998 in JDV810 environment.
Normally those tables are pointed to Central Objects - DV811

Did you comment out section name as well ?
it should be like
# [JDBj-SPEC DATA SOURCE]
# ... rest of the stuff

I had an issues when I commented out content of the section but didn't comment out the section name itself.

 

[oleg_d]

Thanks for help.
I just set there ([JDBj-SPEC DATA SOURCE]) correct data source and uninstall/install WebSphere Express and eGenerator(with reboot and cleaning directories) and all start to work (but with some errors in log files)

Thanks