cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Rapid Installer 2.1 Problem

Go to solution
detlev_beutner
Active Contributor

on ‎07-28-2005 10:23 PM

0 Kudos

Hi there,

I just tried to install EP6 NW04 by using the Rapid Installer 2.1. Everything worked fine until Step 11 (last "Deploying Componente"). After about 3 to 5 minutes, the installation stopped with the following error message:

ERROR 2005-07-28 23:06:00

CJS-20065 Execution of JLoad tool 'c:\Java\JDK1.4.2/bin/java.exe -classpath ./sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;C:\usr\sap/J2E/JC00/j2ee\jdbc\base.jar;C:\usr\sap/J2E/JC00/j2ee\jdbc\util.jar;C:\usr\sap/J2E/JC00/j2ee\jdbc\sqlserver.jar;C:\usr\sap/J2E/JC00/j2ee\jdbc\spy.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jce.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/w3c_http.jar -showversion -Xmx512m com.sap.inst.jload.Jload -sec J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key -dataDir D:/RAPIDINSTALLER/EXPORT_CD/JDMP -job C:\Programme\sapinst_instdir\j2ee_wp\central\default/IMPORT.XML -log C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.log' aborts with returncode 1. Check 'C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.log' and 'C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.java.log' for more information.

The error message from jload.log is as follows:

28.07.05 23:01 com.sap.inst.jload.Jload main
INFO: Jload -sec J2E,jdbc/pool/J2E,C:usrsapJ2ESYSglobal/security/data/SecStore.properties,C:usrsapJ2ESYSglobal/security/data/SecStore.key -dataDir D:/RAPIDINSTALLER/EXPORT_CD/JDMP -job C:Programmesapinst_instdirj2ee_wpcentraldefault/IMPORT.XML -log C:Programmesapinst_instdirj2ee_wpcentraldefault/jload.log

28.07.05 23:01 com.sap.inst.jload.db.DBConnection connectViaSecureStore
INFO: connected to J2E on jdbc/pool/J2E

28.07.05 23:01 com.sap.inst.jload.JobStatus readStatus
INFO: commencing restart

28.07.05 23:01 com.sap.inst.jload.Jload dbImport
INFO: trying to delete from table J2EE_CONFIGENTRY

28.07.05 23:02 com.sap.inst.jload.Jload dbImport
INFO: J2EE_CONFIGENTRY deleted

28.07.05 23:06 com.sap.inst.jload.Jload dbImport
SEVERE: DB Error during import of J2EE_CONFIGENTRY

28.07.05 23:06 com.sap.inst.jload.Jload printSQLException
SEVERE: Message: [DataDirect][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.

28.07.05 23:06 com.sap.inst.jload.Jload printSQLException
SEVERE: SQLState: 08000

28.07.05 23:06 com.sap.inst.jload.Jload printSQLException
SEVERE: ErrorCode: 0

28.07.05 23:06 com.sap.inst.jload.Jload dbImport
INFO: trying to drop table J2EE_KEYSEQUENCE

28.07.05 23:06 com.sap.inst.jload.Jload logStackTrace
SEVERE: com.sap.dictionary.database.dbs.JddException: DROP TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.drop(DBTable.java:116)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:266)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)


28.07.05 23:06 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

The error message from jload.java.log is as follows:

java version "1.4.2_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)
Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)
java.sql.SQLException: [DataDirect][SQLServer JDBC Driver]Object has been closed.
	at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.ddtek.jdbc.base.BaseConnection.createStatement(Unknown Source)
	at com.ddtek.jdbc.base.BaseConnection.createStatement(Unknown Source)
	at com.sap.sql.jdbc.basic.BasicConnection.createStatement(BasicConnection.java:121)
	at com.sap.sql.jdbc.direct.DirectConnection.createStatement(DirectConnection.java:181)
	at com.sap.sql.jdbc.common.CommonConnectionImpl.createDirectStatement(CommonConnectionImpl.java:1038)
	at com.sap.sql.services.OpenSQLServices.createNativeStatement(OpenSQLServices.java:132)
	at com.sap.sql.NativeSQLAccess.createNativeStatement(NativeSQLAccess.java:108)
	at com.sap.dictionary.database.mss.DbMssTable.retrieveSchemaName(DbMssTable.java:839)
	at com.sap.dictionary.database.mss.DbMssTable.setColumnsViaDb(DbMssTable.java:114)
	at com.sap.dictionary.database.dbs.DbTable.setCommonContentViaDb(DbTable.java:183)
	at com.sap.dictionary.database.dbs.DbObjectModificationAnalyser.modify(DbObjectModificationAnalyser.java:72)
	at com.sap.dictionary.database.dbs.RuntimeObject.create(RuntimeObject.java:62)
	at com.sap.dictionary.database.dbs.RuntimeObjectTable.create(RuntimeObjectTable.java:179)
	at com.sap.dictionary.database.dbs.RuntimeObjectTable.createIfNecessary(RuntimeObjectTable.java:188)
	at com.sap.dictionary.database.opentools.DbTableOpenTools.<init>(DbTableOpenTools.java:32)
	at com.sap.inst.jload.db.DBTable.drop(DBTable.java:114)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:266)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)
Exception caught while preparing Statement
DROP TABLE [J2EE_KEYSEQUENCE]

E R R O R ******* (DbObjectSqlStatements)
23:06:00 2005-07-28 dbs-Error:  Ausnahme beim Prepare des Statements: DROP TABLE [J2EE_KEYSEQUENCE]
28.07.2005 23:01:06 com.sap.inst.jload.Jload main
INFO: Jload -sec J2E,jdbc/pool/J2E,C:usrsapJ2ESYSglobal/security/data/SecStore.properties,C:usrsapJ2ESYSglobal/security/data/SecStore.key -dataDir D:/RAPIDINSTALLER/EXPORT_CD/JDMP -job C:Programmesapinst_instdirj2ee_wpcentraldefault/IMPORT.XML -log C:Programmesapinst_instdirj2ee_wpcentraldefault/jload.log
28.07.2005 23:01:09 com.sap.inst.jload.db.DBConnection connectViaSecureStore
INFO: connected to J2E on jdbc/pool/J2E
28.07.2005 23:01:09 com.sap.inst.jload.JobStatus readStatus
INFO: commencing restart
28.07.2005 23:01:09 com.sap.inst.jload.Jload dbImport
INFO: trying to delete from table J2EE_CONFIGENTRY
28.07.2005 23:02:35 com.sap.inst.jload.Jload dbImport
INFO: J2EE_CONFIGENTRY deleted
28.07.2005 23:06:00 com.sap.inst.jload.Jload dbImport
SCHWERWIEGEND: DB Error during import of J2EE_CONFIGENTRY
28.07.2005 23:06:00 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: Message: [DataDirect][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.
28.07.2005 23:06:00 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: SQLState: 08000
28.07.2005 23:06:00 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: ErrorCode: 0
28.07.2005 23:06:00 com.sap.inst.jload.Jload dbImport
INFO: trying to drop table J2EE_KEYSEQUENCE
28.07.2005 23:06:00 com.sap.inst.jload.Jload logStackTrace
SCHWERWIEGEND: com.sap.dictionary.database.dbs.JddException: DROP TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.drop(DBTable.java:116)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:266)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)

28.07.2005 23:06:00 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

A restart of the installation brought up the same messages and exceptions.

Anyone has a clue what the problem could be about?

In fact, at this moment, the table J2EE_CONFIGENTY exists, while the table J2EE_KEYSEQUENCE does not.

Thanks in advance

Detlev

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎07-29-2005 3:54 PM
0 Kudos

With SQL, are you at SP3, with 929 hotfix and did you run the newest version of the instcoll?

With RI 2.1 I had to reboot between each component install or RI would fail.

Show replies
Show replies
Former Member
‎07-29-2005 3:55 PM
0 Kudos

Also use java version 1.4.2_08 there are issues with _06.

detlev_beutner
Active Contributor
‎07-29-2005 8:17 PM
0 Kudos

Hi David,

I have now upgraded SQL Server to SP4 and the JDK to 1.4.2_08. In fact, the installation process got a little bit further, but still failed at step 11...

The error message sounds as follows:

ERROR      2005-07-29 20:50:52 
           CJSlibModule::writeError_impl() 
CJS-20065  Execution of JLoad tool 'c:JavaJDK1.4.2/bin/java.exe -classpath ./sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;C:usrsap/J2E/JC00/j2eejdbcbase.jar;C:usrsap/J2E/JC00/j2eejdbcutil.jar;C:usrsap/J2E/JC00/j2eejdbcsqlserver.jar;C:usrsap/J2E/JC00/j2eejdbcspy.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jce.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/w3c_http.jar -showversion -Xmx512m com.sap.inst.jload.Jload -sec J2E,jdbc/pool/J2E,C:usrsapJ2ESYSglobal/security/data/SecStore.properties,C:usrsapJ2ESYSglobal/security/data/SecStore.key -dataDir D:/RAPIDINSTALLER/EXPORT_CD/JDMP -job C:Programmesapinst_instdirj2ee_wpcentraldefault/IMPORT.XML -log C:Programmesapinst_instdirj2ee_wpcentraldefault/jload.log' aborts with returncode 1. Check 'C:Programmesapinst_instdirj2ee_wpcentraldefault/jload.log' and 'C:Programmesapinst_instdirj2ee_wpcentraldefault/jload.java.log' for more information.

jload.log has the following issue:

29.07.05 20:50 com.sap.inst.jload.Jload dbImport
SEVERE: DB Error during import of J2EE_CONFIGENTRY

29.07.05 20:50 com.sap.inst.jload.Jload printSQLException
SEVERE: Message: [DataDirect][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.

29.07.05 20:50 com.sap.inst.jload.Jload printSQLException
SEVERE: SQLState: 08000

29.07.05 20:50 com.sap.inst.jload.Jload printSQLException
SEVERE: ErrorCode: 0

29.07.05 20:50 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_KEYSEQUENCE

29.07.05 20:50 com.sap.inst.jload.Jload logStackTrace
SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)


29.07.05 20:50 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

jload.java.log as follows:

29.07.2005 20:44:30 com.sap.inst.jload.Jload dbImport
INFO: table EP_ID_COUNTERS created
29.07.2005 20:44:30 com.sap.ins
E R R O R ******* (DbMssTable)
20:50:51 2005-07-29 mss-Error:  retrieveSchemaName failed: [DataDirect][SQLServer JDBC Driver]Object has been closed.

E R R O R ******* (tools.DbTableOpenTools)
20:50:51 2005-07-29 ope-Error:   Caused by: [DataDirect][SQLServer JDBC Driver]Object has been closed. Stack trace: java.sql.SQLException: [DataDirect][SQLServer JDBC Driver]Object has been closed.
	at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.ddtek.jdbc.base.BaseConnection.createStatement(Unknown Source)
	at com.ddtek.jdbc.base.BaseConnection.createStatement(Unknown Source)
	at com.sap.sql.jdbc.basic.BasicConnection.createStatement(BasicConnection.java:121)
	at com.sap.sql.jdbc.direct.DirectConnection.createStatement(DirectConnection.java:181)
	at com.sap.sql.jdbc.common.CommonConnectionImpl.createDirectStatement(CommonConnectionImpl.java:1038)
	at com.sap.sql.services.OpenSQLServices.createNativeStatement(OpenSQLServices.java:132)
	at com.sap.sql.NativeSQLAccess.createNativeStatement(NativeSQLAccess.java:108)
	at com.sap.dictionary.database.mss.DbMssTable.retrieveSchemaName(DbMssTable.java:839)
	at com.sap.dictionary.database.mss.DbMssTable.setColumnsViaDb(DbMssTable.java:114)
	at com.sap.dictionary.database.dbs.DbTable.setCommonContentViaDb(DbTable.java:183)
	at com.sap.dictionary.database.dbs.DbObjectModificationAnalyser.modify(DbObjectModificationAnalyser.java:72)
	at com.sap.dictionary.database.opentools.DbTableOpenTools.createTable(DbTableOpenTools.java:67)
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:105)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)

t.jload.Jload dbImport
INFO: EP_ID_COUNTERS loaded (2 rows)
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_LOCK_APPLS
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: table EP_LOCK_APPLS created
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: EP_LOCK_APPLS loaded (1 rows)
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_LOCK_ENTRIES
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: table EP_LOCK_ENTRIES created
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: EP_LOCK_ENTRIES loaded (0 rows)
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_OBJECTS
29.07.2005 20:44:31 com.sap.inst.jload.Jload dbImport
INFO: table EP_OBJECTS created
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: EP_OBJECTS loaded (38774 rows)
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_OBJECT_TYPES
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: table EP_OBJECT_TYPES created
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: EP_OBJECT_TYPES loaded (2 rows)
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_PRT_CACHE
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: table EP_PRT_CACHE created
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: EP_PRT_CACHE loaded (0 rows)
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_SHORT_STRS
29.07.2005 20:44:47 com.sap.inst.jload.Jload dbImport
INFO: table EP_SHORT_STRS created
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: EP_SHORT_STRS loaded (4073 rows)
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_VERSION_INFO
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: table EP_VERSION_INFO created
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: EP_VERSION_INFO loaded (5 rows)
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_CONFIG
29.07.2005 20:44:50 com.sap.inst.jload.Jload dbImport
INFO: table J2EE_CONFIG created
29.07.2005 20:44:54 com.sap.inst.jload.Jload dbImport
INFO: J2EE_CONFIG loaded (6619 rows)
29.07.2005 20:44:54 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_CONFIGENTRY
29.07.2005 20:44:54 com.sap.inst.jload.Jload dbImport
INFO: table J2EE_CONFIGENTRY created
29.07.2005 20:50:51 com.sap.inst.jload.Jload dbImport
SCHWERWIEGEND: DB Error during import of J2EE_CONFIGENTRY
29.07.2005 20:50:51 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: Message: [DataDirect][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.
29.07.2005 20:50:51 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: SQLState: 08000
29.07.2005 20:50:51 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: ErrorCode: 0
29.07.2005 20:50:51 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_KEYSEQUENCE
29.07.2005 20:50:51 com.sap.inst.jload.Jload logStackTrace
SCHWERWIEGEND: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)

29.07.2005 20:50:51 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

The table J2EE_KEYSEQUENCE in fact is not to be found within the DB.

Thanks in advance

Detlev

Former Member
‎07-29-2005 8:38 PM
0 Kudos

I do not recall the exact note, but it was advised NOT to use SP 4.

My advice is to completely uninstall MS SQL. Get note 600027. That says SP 4 is ok but another note says no.

Load MS SQL. Reboot.

Load QFE 929. Reboot.

Load SP3. Reboot.

Load the updated collation. Reboot.

It is a pain, but this is the only way I have gotten past 11 doing RI. RI is great, it is just VERY picky.

detlev_beutner
Active Contributor
‎07-29-2005 9:22 PM
0 Kudos

Hi David,

SP4 is definitely officially supported by SAP, see note 62988. Un- and reinstalling is not acceptable at the moment, because there is still a SP2 installation using this DB (of course, only one installation will run at the same time, but I will have to hold this SP2 some weeks to months in parallel).

The SQL server with the SP2 installation works now for 1.5 years without any problems (and heavy patching); so of course, the SAP collation is installed, too.

I have opened an OSS message, with no further results until now. I have also ordered RI 2.1.1, but I'm not really expecting different results... And I need this environment asap (of course...). Hm...

Any further ideas?!

Thanks in advance

Detlev

Former Member
‎08-01-2005 12:25 PM
0 Kudos

Have you put in the 929 hotfix? Maybe if you are only going to run the sp2 you need the one hotfixy lower. 919 I think was the number.

detlev_beutner
Active Contributor
‎08-01-2005 12:51 PM
0 Kudos

Hi David,

after having patched MS SQL to SP4, the hotfix should be inside, shouldn't it? And as said, the new collation has been installed, too (long before).

Today I received RI 2.1.1, but, somehow as expected, more or less the same result.

jload.log:

01.08.05 11:50 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_CONFIGENTRY

01.08.05 11:50 com.sap.inst.jload.Jload dbImport
INFO: table J2EE_CONFIGENTRY created

01.08.05 11:57 com.sap.inst.jload.Jload dbImport
SEVERE: DB Error during import of J2EE_CONFIGENTRY

01.08.05 11:57 com.sap.inst.jload.Jload printSQLException
SEVERE: Message: [SAP NetWeaver][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.

01.08.05 11:57 com.sap.inst.jload.Jload printSQLException
SEVERE: SQLState: 08S01

01.08.05 11:57 com.sap.inst.jload.Jload printSQLException
SEVERE: ErrorCode: 0

01.08.05 11:57 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_KEYSEQUENCE

01.08.05 11:57 com.sap.inst.jload.Jload logStackTrace
SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)


01.08.05 11:57 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

jload.java.log:

01.08.2005 11:50:22 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_SHORT_STRS
01.08.2005 11:50:22 com.sap.inst.jload.Jload dbImport
INFO: table EP_SHORT_STRS created
01.08.2005 1
E R R O R ******* (DbMssTable)
11:57:14 2005-08-01 mss-Error:  retrieveSchemaName failed: [SAP NetWeaver][SQLServer JDBC Driver]Connection reset by peer: socket write error

E R R O R ******* (tools.DbTableOpenTools)
11:57:14 2005-08-01 ope-Error:   Caused by: [SAP NetWeaver][SQLServer JDBC Driver]Connection reset by peer: socket write error Stack trace: java.sql.SQLException: [SAP NetWeaver][SQLServer JDBC Driver]Connection reset by peer: socket write error
	at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.sap.nwmss.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)
	at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.execute(Unknown Source)
	at com.sap.nwmss.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
	at com.sap.nwmss.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at com.sap.nwmss.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
	at com.sap.nwmss.jdbc.base.BaseStatement.executeQuery(Unknown Source)
	at com.sap.sql.jdbc.basic.BasicStatement.executeQuery(BasicStatement.java:190)
	at com.sap.sql.jdbc.mss.MssInetStatement.executeQuery(MssInetStatement.java:49)
	at com.sap.sql.jdbc.direct.DirectStatement.executeQuery(DirectStatement.java:137)
	at com.sap.sql.jdbc.direct.DirectStatement.executeQuery(DirectStatement.java:107)
	at com.sap.dictionary.database.mss.DbMssTable.retrieveSchemaName(DbMssTable.java:841)
	at com.sap.dictionary.database.mss.DbMssTable.setColumnsViaDb(DbMssTable.java:114)
	at com.sap.dictionary.database.dbs.DbTable.setCommonContentViaDb(DbTable.java:183)
	at com.sap.dictionary.database.dbs.DbObjectModificationAnalyser.modify(DbObjectModificationAnalyser.java:72)
	at com.sap.dictionary.database.opentools.DbTableOpenTools.createTable(DbTableOpenTools.java:67)
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:105)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)

1:50:25 com.sap.inst.jload.Jload dbImport
INFO: EP_SHORT_STRS loaded (4308 rows)
01.08.2005 11:50:25 com.sap.inst.jload.Jload dbImport
INFO: trying to create table EP_VERSION_INFO
01.08.2005 11:50:25 com.sap.inst.jload.Jload dbImport
INFO: table EP_VERSION_INFO created
01.08.2005 11:50:25 com.sap.inst.jload.Jload dbImport
INFO: EP_VERSION_INFO loaded (5 rows)
01.08.2005 11:50:25 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_CONFIG
01.08.2005 11:50:25 com.sap.inst.jload.Jload dbImport
INFO: table J2EE_CONFIG created
01.08.2005 11:50:30 com.sap.inst.jload.Jload dbImport
INFO: J2EE_CONFIG loaded (8010 rows)
01.08.2005 11:50:30 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_CONFIGENTRY
01.08.2005 11:50:30 com.sap.inst.jload.Jload dbImport
INFO: table J2EE_CONFIGENTRY created
01.08.2005 11:57:11 com.sap.inst.jload.Jload dbImport
SCHWERWIEGEND: DB Error during import of J2EE_CONFIGENTRY
01.08.2005 11:57:11 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: Message: [SAP NetWeaver][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
01.08.2005 11:57:11 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: SQLState: 08S01
01.08.2005 11:57:11 com.sap.inst.jload.Jload printSQLException
SCHWERWIEGEND: ErrorCode: 0
01.08.2005 11:57:11 com.sap.inst.jload.Jload dbImport
INFO: trying to create table J2EE_KEYSEQUENCE
01.08.2005 11:57:14 com.sap.inst.jload.Jload logStackTrace
SCHWERWIEGEND: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed
	at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)
	at com.sap.inst.jload.Jload.dbImport(Jload.java:276)
	at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
	at com.sap.inst.jload.Jload.main(Jload.java:551)

01.08.2005 11:57:14 com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected

Hm, getting desperate...

Best regards

Detlev

Former Member
‎08-01-2005 1:04 PM
0 Kudos

C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.log' aborts with returncode 1. Check 'C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.log' and 'C:\Programme\sapinst_instdir\j2ee_wp\central\default/jload.java.log' for more information.

jload.log has the following issue:

29.07.05 20:50 com.sap.inst.jload.Jload dbImport

SEVERE: DB Error during import of J2EE_CONFIGENTRY

29.07.05 20:50 com.sap.inst.jload.Jload printSQLException

SEVERE: Message: [DataDirect][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.

___________________________________________________

I also noted at another part about your SSL info being loaded. I remember that I had an issue with both of my installs that all of the ssl files did not load correctly.

First, do you have the newest SSL crypto pack?

detlev_beutner
Active Contributor
‎08-01-2005 1:20 PM
0 Kudos

Hi David,

a) I have realized that the part quoted by yours somehow has been the "central problem" - but how to avoid?!?!

b) The newes SSL crypto pack?! From the logs, C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_ssl.jar is used - this comes with RI. Or am I on the wrong track and are you thinking of something different?!

Thanks in advance

Detlev

Former Member
‎10-29-2005 2:21 AM
0 Kudos

SAME jload.log errors any ideas? how do I get this to work on WINDOWS XP? some one please comment on the SAP WEBAS INSTALL ON WINDOWS XP!

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: EP_OBJECTS loaded (19353 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table EP_OBJECT_TYPES

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table EP_OBJECT_TYPES created

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: EP_OBJECT_TYPES loaded (2 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table EP_PRT_CACHE

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table EP_PRT_CACHE created

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: EP_PRT_CACHE loaded (17 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table EP_SHORT_STRS

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table EP_SHORT_STRS created

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: EP_SHORT_STRS loaded (1755 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table EP_VERSION_INFO

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table EP_VERSION_INFO created

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: EP_VERSION_INFO loaded (5 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table J2EE_CONFIG

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table J2EE_CONFIG created

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: J2EE_CONFIG loaded (9027 rows)

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: trying to create table J2EE_CONFIGENTRY

28.10.05 07:55 com.sap.inst.jload.Jload dbImport

INFO: table J2EE_CONFIGENTRY created

29.10.05 02:46 com.sap.inst.jload.Jload main

INFO: Jload -sec J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key -dataDir C:/temp/NW04SneakPrevJavaSP11/NW04SneakPrevJavaSP11/NWSneakPreviewSP11/SAP_NetWeaver_04_SR_1_Installation_Master_DVD__ID__51030843\IM01_NT_I386\..\..\SneakPreviewContent\JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.log

29.10.05 02:46 com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://karkera/J2E [Restart required].

29.10.05 02:49 com.sap.inst.jload.Jload main

INFO: Jload -sec J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key -dataDir C:/temp/NW04SneakPrevJavaSP11/NW04SneakPrevJavaSP11/NWSneakPreviewSP11/SAP_NetWeaver_04_SR_1_Installation_Master_DVD__ID__51030843\IM01_NT_I386\..\..\SneakPreviewContent\JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.log

29.10.05 02:50 com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to J2E on jdbc/pool/J2E

29.10.05 02:50 com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

29.10.05 02:50 com.sap.inst.jload.Jload dbImport

SEVERE: DB Error during import of J2EE_CONFIGENTRY

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: Message: [200]: Duplicate key

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: SQLState: 23000

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: ErrorCode: 200

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: Message: [200]: Duplicate key

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: SQLState: 23000

29.10.05 02:50 com.sap.inst.jload.Jload printSQLException

SEVERE: ErrorCode: 200

29.10.05 02:50 com.sap.inst.jload.Jload dbImport

INFO: trying to create table J2EE_KEYSEQUENCE

29.10.05 03:02 com.sap.inst.jload.Jload logStackTrace

SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed

at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)

at com.sap.inst.jload.Jload.dbImport(Jload.java:276)

at com.sap.inst.jload.Jload.executeJob(Jload.java:395)

at com.sap.inst.jload.Jload.main(Jload.java:551)

29.10.05 03:02 com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

java version "1.4.2_09"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_09-b05)

Java HotSpot(TM) Client VM (build 1.4.2_09-b05, mixed mode)

E R R O R ******* (DbObjectSqlStatements)

3:02:05 2005-10-29 dbs-Error: Exception caught during SQL execution [-708] Shutdown CREATE TABLE "J2EE_KEYSEQUENCE"("SEQUENCE_ID" INTEGER NOT NULL, "INC_VALUE" FIXED(19) )

Oct 29, 2005 2:49:59 AM com.sap.inst.jload.Jload main

INFO: Jload -sec J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key -dataDir C:/temp/NW04SneakPrevJavaSP11/NW04SneakPrevJavaSP11/NWSneakPreviewSP11/SAP_NetWeaver_04_SR_1_Installation_Master_DVD__ID__51030843\IM01_NT_I386\..\..\SneakPreviewContent\JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.log

Oct 29, 2005 2:50:00 AM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to J2E on jdbc/pool/J2E

Oct 29, 2005 2:50:01 AM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload dbImport

SEVERE: DB Error during import of J2EE_CONFIGENTRY

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: Message: [200]: Duplicate key

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: SQLState: 23000

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: ErrorCode: 200

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: Message: [200]: Duplicate key

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: SQLState: 23000

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload printSQLException

SEVERE: ErrorCode: 200

Oct 29, 2005 2:50:02 AM com.sap.inst.jload.Jload dbImport

INFO: trying to create table J2EE_KEYSEQUENCE

Oct 29, 2005 3:02:05 AM com.sap.inst.jload.Jload logStackTrace

SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE J2EE_KEYSEQUENCE failed

at com.sap.inst.jload.db.DBTable.create(DBTable.java:106)

at com.sap.inst.jload.Jload.dbImport(Jload.java:276)

at com.sap.inst.jload.Jload.executeJob(Jload.java:395)

at com.sap.inst.jload.Jload.main(Jload.java:551)

Oct 29, 2005 3:02:05 AM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

detlev_beutner
Active Contributor
‎10-29-2005 12:07 PM
0 Kudos

Hi,

in the end, I got a complete and successful installation with RapidInstaller 2.5; give it a try (2.1.x seems to be quite buggy, the OSS support wan't able to help one centimeter...).

Hope it helps

Detlev

Former Member
‎10-29-2005 10:35 PM
0 Kudos

where can I download RapidInstaller 2.5?

Please let me know

Thanks

detlev_beutner
Active Contributor
‎10-30-2005 12:40 PM
0 Kudos

Hi,

RI isn't downloadable. Go to http://service.sap.com/swcat and choose "SAP NetWeaver" - "Rapid Installer 2.5". Then choose the version corresponding to your installation to order the software. Shipment is quite fast, you should retrieve the package only a few days later.

Hope it helps

Detlev

Former Member
‎10-30-2005 3:07 PM
0 Kudos

Thanks for all your helpful help.

I am terribly dismayed by the pathetic quality level of software releases posted for download by SAP Corporation matched by the equally pathetic support responses from SAP engineers in this forum on such issues. SAP needs to stick to .Net and Microsoft style installs and give up on their J2EE strategy. What a waste of time! when it comes to Java/J2EE I know what am going to suggest to my SAP clients now!!!

detlev_beutner
Active Contributor
‎10-31-2005 8:44 AM
0 Kudos

Hi,

I can only partly agree. I can agree concerning quality assurance of the delivered software, which is partly simply not acceptable. And the (first level) support often also blocks more the messages then trying immediately to help. BUT: This definitely has nothing to do with Java/J2EE. A bad Q/A organsation, which just doesn't test even standard use cases before delivering software would fail on each technology platform. Also big software systems are known enough running on the Java platform without equivalent problems.

Best regards

Detlev

Former Member
‎10-31-2005 12:36 PM
0 Kudos

Detlev,

I agree with you 100%. There are of the JAVA platforms out there that work much better. When I have my bosses look at the results of the portal platform, (I did RI 2.1) They are amazed of the poor performance and bugs. I try to make this run as smooth as possible, but with all the garbage that is happening (i.e. memory leaks, poor garbage collection) it makes me look bad.

Ever try to create a second or third engine on an RI install? You know how many days it took to figure out that RI will not take the defaults of the first engine and that it take the defaults of WHEN IT WAS INSTALLED? Engine ID, settings, everything.

We will be building our next portal on a 64-bit Windows Platform. RI 2.5 is not in consideration.

Answers (0)

Ask a Question