Help WAS 6.40 installation

[Former Member]

Hi, I'm trying to install SAP Web Application Server Java 6.40 beu when installer arrive at "MAXdb internal installation(post processing)" an error occurred with this log:

ERROR 2004-03-11 16:09:51

CJS-00081 Assertion failed: in function sapdb_sql_query(db_nm, sql_s, db_node) { var ret_s = ""; var sdbInst = new sdbInstance(); sdbInst.dbName = db_nm; sdbInst.dbHost = (db_node == undefined) ? installer.getHostName() : db_node; var r_arr = sdb_sql_query(sql_s, sdbInst); ASSERT(arguments.callee, r_arr != undefined, "ERROR EXECUTING DBMCLI COMMAND!"); if (r_arr[0] == "false") { var err_msg = "ERROR EXECUTING SQL QUERY: "; for (var i_cnt = 1; i_cnt < r_arr.length; i_cnt++) { err_msg = err_msg + r_arr[i_cnt]; } ASSERT(arguments.callee, false, err_msg); } else { end_l = new RegExp("END"); for (i_cnt = 0; i_cnt < r_arr.length; i_cnt++) { if (end_l.test(r_arr[i_cnt])) { ret_s = r_arr[i_cnt + 1]; break; } } } return ret_s;}ERROR EXECUTING SQL QUERY: OKERR-24988,ERR_SQL: sql error-5015,Missing keyword:USERGROUP,TIMEOUT,STANDARD,RESOURCE,REPLICATION,NOT,LIKE,EXCLUSIVE,DBA,COSTWARNING,COSTLIMIT,CACHELIMIT

What can i do??

Thanks

Andrew

[Former Member]

Hi

Create one folder under /usr/sapsid as inst_new and run ./sapinst.Hope so this might solve this issue.

Thanks

Sachin

[stefan_seemann]

Hello,

again, the database is not in mode "Online" when the SQL command was run.

You first have to start the database with the

command dbmcli -d <SID> -u control,control db_online

Then continue with sapinst.

Best regards, Stefan

[Former Member]

Hello Stefan,

it is not working ! I think here is a hardware or Windows XP problem, otherwise I can't have a resonable reason. Also, I waiting for Netweaver for tests.

[stefan_seemann]

Hello,

no, the database is necessary.

What kind of error do you receive now ?

Please put the last 20 lines from sapinst_dev.log

and the last 10 lines from xcmdout.log into this case.

Best regards, Stefan

[Former Member]

Hello,

The last 20 lines from sapinst.log are

ERROR 2004-05-26 19:31:17

CJS-00081 Assertion failed: in function sapdb_sql_query(db_nm, sql_s, db_node) { var ret_s = ""; var sdbInst = new sdbInstance(); sdbInst.dbName = db_nm; sdbInst.dbHost = (db_node == undefined) ? installer.getHostName() : db_node; var r_arr = sdb_sql_query(sql_s, sdbInst); ASSERT(arguments.callee, r_arr != undefined, "ERROR EXECUTING DBMCLI COMMAND!"); if (r_arr[0] == "false") { var err_msg = "ERROR EXECUTING SQL QUERY: "; for (var i_cnt = 1; i_cnt < r_arr.length; i_cnt++) { err_msg = err_msg + r_arr[i_cnt]; } ASSERT(arguments.callee, false, err_msg); } else { end_l = new RegExp("END"); for (i_cnt = 0; i_cnt < r_arr.length; i_cnt++) { if (end_l.test(r_arr[i_cnt])) { ret_s = r_arr[i_cnt + 1]; break; } } } return ret_s;}ERROR EXECUTING SQL QUERY: ERR-24988,ERR_SQL: sql error1,database not running

and the last 10 lines from XCMDOUT.LOG are:

Subprocess starts at 20040526193117

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : exit

> Subprocess stops at 20040526193117

ERR

-24988,ERR_SQL: sql error

1,database not running

Regards, Altafin

[stefan_seemann]

Hello,

it looks like some ressources from the database are existing but the process itself doesn't run anymore.

Is the databasehost sapws a windows or a unix machine.

Please try this command:

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_clear

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_state

Now it should write out offline.

Best regards, Stefan

[Former Member]

Hello Stefan,

I command

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_clear

and it is OK

The I command

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_state

and I obtain

OK

State

Offline

So, reloaded installing process and unfortunately, I have the same error.

Can I install just J2EE Engine ? Or can I by pass the MaxDB processing ?

Best regards, Altafin

[stefan_seemann]

Hello,

it looks like the database is not in state Online.

Only in state Online sql statements can be processed.

Please check in a dos-box:

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u CONTROL,control db_state

You can start the database byrunning this command:

d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u CONTROL,control db_online

Hope that helps, Stefan

[Former Member]

Hello,

When try

<b>d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_state</b>, I see the follow message

<b>OK

State

Offline</b>

Now..this is strange for me. When try

<b>d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u control,control db_online</b>, I see the error message

<b>ERR,

-24994, ERR_RTE runtime environment error

1,Database J2E already started</b>

[stefan_seemann]

Hello,

as far as I could see the installation is in the phase where the database is activated. For this it is necessary that the database is in state "ADMIN"

Please check with this command:

d:\sapdb\program\pgm\dbmcli.exe -n sapws -d WAS -u control,control db_offline

d:\sapdb\program\pgm\dbmcli.exe -n sapws -d WAS -u control,control db_admin

d:\sapdb\program\pgm\dbmcli.exe -n sapws -d WAS -u control,control db_state

Then continue with the installation.

When it still fail I need the last 20 lines from sapinst_dev.log and xcmdout.log

Please paste them into this case.

Thanks, Stefan

[Former Member]

Stefan, thank you. I passed the previous problem. So, stoped the SAP WAS service from <b>Settings->Control Panel->Administrative tools->Services</b> and used d:\sapdb\program\pgm\dbmcli.exe -n sapws -d WAS -u control,control db_admin for reloading.

Unfortunately in this moment I have an other problem. In the SAPInst window see the error message

<b>Could not load the system tables. Check the files 'dbm.prt' and 'dbm.ins' in the run directory of the database (search for "load_systab") or call the Support Center.</b>

[Former Member]

Hello again,

I hope that i'm not very boring. After the all these, I have a new obstacle

In the Error View Log:

<b>

ERROR 2004-05-24 17:20:51

FKD-00037 Query did not return a result.

ERROR 2004-05-24 17:20:51

FKD-00038 Query did not return a result.Select attribute fExist, statement: WHERE fDbName = 'WAS' AND fDbSch = 'SAPJ2EDB'

</b>

In the sapinst_dev.log:

<b>Running with control file path

ERROR 2004-05-24 17:20:51 [kdxxctable.cpp:389]

CKdbTableImpl::checkResultOfselectTableElementInternAndReturnAttribute(KDBATTRIBUTENAME,PKdbRowVecVector)

FKD-00037 Query did not return a result.

ERROR 2004-05-24 17:20:51 [kdxxctable.cpp:334]

CKdbTableImpl::selectTableElementIntern(KDBATTRIBUTENAME,PKdbWhereClauseStatement,PKdbClientInternal

FKD-00038 Query did not return a result.Select attribute fExist, statement: WHERE fDbName = 'WAS' AND fDbSch = 'SAPJ2EDB'

TRACE [iaxxejsbas.hpp:156]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown exception

TRACE [iaxxgenimp.cpp:775]

showDialog()

waiting for an answer from gui

</b>

and in the XCMDOUT.log

<b>

> Subprocess starts at 20040524171415

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : exit

> Subprocess stops at 20040524171416

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040524171419

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : exit

> Subprocess stops at 20040524171419

ERR

-24988,ERR_SQL: sql error

1,database not running

</b>

[stefan_seemann]

Hello,

it seems that the database is not running.

Please run this command from a dos-box:

dbmcli -n sapws -d WAS -u control,control db_admin

Then continue the installation.

Thanks, Stefan Seemann

[Former Member]

Thanks for your quickly answer, but don't work it. Then try :<b>d:\sapdb\program\pgm\dbmcli.exe -n sapws -d WAS -u control,control db_admin</b>, get error message:

<b>ERR

-24994, ERR_RTE runtime environment error

1, Database WAS already started

</b>

[stefan_seemann]

Hello,

I assume that you have entered a special character like

*/-+/ etc. when you have entered the password for the database SQL user sapj2edb.

Passwords with special characters have to be quoted.

For example:

sql_execute create user sapj2edb password "sa+p" DBA NOT EXCLUSIVE DEFAULTCODE UNICODE

That seems to be a Bug in the installation.

When you remember the password you have entered for that user you can create this user with dbmcli.

After that you can continue sapinst with this commando to jump over the error step:

Start the installation again in a command prompt as follows

<sapinst_instdir>\sapinst SAPINST_SKIP_ERRORSTEP=true

Hope that helps, Stefan

[Former Member]

Hello Stefan,

the installation finished successfully.

Thanks and Regards,

Rudolf

[Former Member]

Hello Stefan,

I have the same problem with Andrea. I read your solution for Andrea's problem and performed:

1.) d:\sapdb\programs\pgm\dbmcli.exe -n agazi -d J2E -u control,control

2.) dbmcli on J2E> param_directget _unicode

3.) dbmcli on J2E> sql_connect superdba,admin

4.) dbmcli on J2E> sql_execute create user saptest password sap dba not exclusive defaultcode unicode

That all was ok

Then I tried to reload the installing process with

<sapinst_instdir>\sapinst SAPINST_SKIP_ERRORSTEP=true

, the installing process is stoped with the follow message

<b>SAPinst is getting started.

Please be patient ...

guiengine: login in process.

guiengine: no GUI connected; waiting for a connection on host agazi, port 21212 to continue with the installation

WARNING Could not read file control.xml. Please make sure that you called SAPinst with the correct control file (the control file is given to SAPinst as its first command line parameter or as value of the command line property SAPINST_CONTROL_URL)</b>ERROR Could not create DOM from control.xml

Exit status of child: 1</b>

What happens ? Thanks very much

[Former Member]

Sorry, I forget in my previous post. The system has Windows 2000

Also, I tried to install WAS 6.40 on Windows XP system

which fullfil the system requirements. My install process is stopped at <b>MaxDB Database Installation step</b>(step 5). In this stage on the bottom of SAPInst window I see the message: <b>MaxDB: activating the database(please wait...)</b>.

In the View Log I read:

<b>gui.update("MaxDB: activating the database (please wait, it takes a while) ...");

ASSERT(arguments.callee, sapdb_action(context.get("DatabaseName"), installer.getHostName(), "ACTIVATE", context.get("SAPDB_VERSION")), "SDB: ERROR ACTIVATING THE DATABASE! CHECK THE XCMDOUT.LOG FILE!"); gui.update("MaxDB: activating the database ... OK");}SDB: ERROR ACTIVATING THE DATABASE! CHECK THE XCMDOUT.LOG FILE!

</b>

So that, I read the XCMDOUT.LOG. Thanks in advance

<b>

...................

OK Processes

..................

-

---

> Subprocess starts at 20040521150110

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521150111

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521150347

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521150347

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521150401

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521150401

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521150458

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521150458

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521151021

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521151021

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521151037

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521151037

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521151044

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521151044

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521151101

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521151101

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521151111

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521151111

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521161904

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521161904

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521161914

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521161915

ERR

-24988,ERR_SQL: sql error

1,database not running

-

---

> Subprocess starts at 20040521175410

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n sapws -d WAS -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20040521175410

ERR

-24988,ERR_SQL: sql error

<b>

[stefan_seemann]

Hello,

I am sorry the command was wrong.

Please run this one again:

1.) d:\sapdb\programs\pgm\dbmcli.exe -n nitno03z -d J2E -u control,control

2.) dbmcli on J2E> param_directget _unicode

3.) dbmcli on J2E> sql_connect superdba,admin

4.) dbmcli on J2E> sql_execute create user saptest password sap dba not exclusive defaultcode unicode

Best regards, Stefan

[Former Member]

Hello,

D:\sapdb\programs\pgm>dbmcli.exe -n nitno03z -d J2E -u control,control

dbmcli.exe on nitno03z : J2E> param_directget _unicode

OK

_UNICODE YES

---

dbmcli.exe on nitno03z : J2E>sql_connect superdba,admin

OK

---

dbmcli.exe on nitno03z : J2E>sql_execute create user saptest password sap dba no

t exclusive defaultcode unicode

OK

Rudolf

[stefan_seemann]

Hello,

please run these commands in a dos_box:

1.) d:\sapdb\programs\pgm\dbmcli.exe -n nitno03z -d J2E -u control,control

2.) dbmcli on J2E> db_online

3.) dbmcli on J2E> param_directget _unicode

4.) dbmcli on J2E> sql_connect superdba,admin

5.) dbmcli on J2E> sql_execute create user saptest,sap dba not exclusive defaultcode unicode

Please sed me the output of these commands.

Thanks, Stefan

[Former Member]

Hello Stefan,

D:\sapdb\programs\pgm>dbmcli.exe -n nitno03z -d J2E -u control,control

dbmcli.exe on nitno03z : J2E>db_online

OK

---

dbmcli.exe on nitno03z : J2E>param_directget _unicode

OK

_UNICODE YES

---

dbmcli.exe on nitno03z : J2E>sql_connect superdba,admin

OK

---

dbmcli.exe on nitno03z : J2E> sql_execute create user saptest,sap dba not exclus

ive defaultcode unicode

ERR

-24988,ERR_SQL: sql error

-5015,Missing keyword:PASSWORD

---

dbmcli.exe on nitno03z : J2E>

Rudolf

[stefan_seemann]

Hello,

please hold on we will investigate this.

Thank you for the tracefiles.

Please do not deinstall something.

Thanks, Stefan

[stefan_seemann]

Hello,

there should be a file in the installation directory on

your machine. The name is XCMDOUT.log.

Please paste the last ten lines out of this file into this issue.

Please run also this command in a dos box:

c:\sapdb\programs\bin\dbmcli db_enum

Please paste the putput also into this case.

Thanks, Stefan

[Former Member]

Hello,

I've got the same problem too.

The last lines of the file XCMDOUT.log are:

> Subprocess starts at 20040326113350

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n nitno03z -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : sql_execute CREATE USER SAPJ2EDB PASSWORD ******** DBA NOT EXCLUSIVE DEFAULTCODE UNICODE

Execute Session Command : exit

> Subprocess stops at 20040326113350

OK

ERR

-24988,ERR_SQL: sql error

-5015,Missing keyword:TIMEOUT,COSTWARNING,COSTLIMIT,CACHELIMIT,USERGROUP,STANDARD,RESOURCE,REPLICATION,NOT,LIKE,EXCLUSIVE,DBA

and the output is:

D:\sapdb\programs\pgm>dbmcli db_enum

OK

J2E D:\SAPDB\J2E\DB 7.5.0.7 fast offline

J2E D:\SAPDB\J2E\DB 7.5.0.7 quick offline

J2E D:\SAPDB\J2E\DB 7.5.0.7 slow offline

Regards,

Rudolf

[Former Member]

Hi there,

I've got exactly the same message.

I' had it @ the first install (form scratch) and all the others ... I've tried it on XP and 2000 the same message is coming ...

Should I re-doanload the install files ..???

[Former Member]

Hi

I am also facing the same issue and not able to continue with the installation. I didnt have any maxdb installed prior to installing WAS 6.40. I also unistalled WAS 6.30 before starting the WAS intallation 6.40. What could be possible solution for this problem ?

[Benny]

start over from scratch. In your situation this message is impossible or something is completely screwed...

Regards,

Benny

[Former Member]

Hello Andrea,

do you have another MaxDB installation on your machine in parallel or did you uninstall MaxDB prior to installing Sneak Preview of Web AS 6.40 (and something possibly went wrong)?

Cheers

Ivo