Problem with installation - CRM2007

[Former Member]

Hello,

I try to install CRM 2007 on SLES 10 64bit (with Oracle 10.2)

During installation I have faced a problem with ABAP import.

import_monitor_java.log points me to SAPSSEXC.log, where I see this information:

DbSl Trace ORA-3113 occured when writing to a LOB

What can I do with this ? Does anybody know what is the solution?

I tried to search for it, but couldn't find any hint.

I have checked shared_pool_size with sqlplu command "show parameter shared_pool_size;" and it shows me 340M

The last lines in SAPSSEXC.log says this:

DbSl Trace: OCI-call 'OCILobWrite' failed with rc=24811

DbSl Trace: ORA-24811 occured when writing to a LOB

(IMP) ERROR DbSlExeModify/DbSlLobPutPiece failed

rc= 99, table "REPOSRC"

(SQL error 24811)

error message returned by DbSl:

ORA-24811: less data provided for writing than indicated

regards

Rafal

PS. I created new thread because the old one was deleted by forum moderator (strange that they cannot just edit and remove some lines from the thread instread of deleting the whole thread)

Uday: thanks for previous suggestion. I included the reply to it in this new thread.

[JPReyes · Accepted solution]

Hi Rafal,

ORA-24811 is usually called when the buffer lengh is not big enough, please increase the size of db_block_buffers and try again.

Read the oracle recommended parameters at SAP Note 830576

Regards

Juan

[Former Member · Accepted solution]

my db_block_size is 8192 (I think this is ok)

I couldn't find any value of db_block_buffers in my initCRM.ora file.

What value do you advise ?

I don't see this in mentioned SAP note. Only init file includes this information:

Database Buffers = db_block_buffers * db_block_size

regarding Oracle versus Vmware - NO, I was not aware, but since I successfully tested it for Solman, I though will work fine (for the purpose). Maybe you can advise me similar solution (like - not Vmware, but something similar).

Few months ago I have as well installed SCM system (IDES) - as well on vmware with oracle and so far it works fine (though with SCM I have used physical hard drive and not pure virtual drive)

Regarding purpose - this is only IDES system , which will be used by few consultants for training purpose. I don't think we will have more than 2-4 people using it (at least not for the moment). Vmware is for me very flexible solution.

regards

Rafal

[markus_doehr2 · Accepted solution]

> regarding Oracle versus Vmware - NO, I was not aware, but since I successfully tested it for Solman, I though will work fine (for the purpose). Maybe you can advise me similar solution (like - not Vmware, but something similar).

Technically it may work, yes, but in case of any database or performance related issues.

> Few months ago I have as well installed SCM system (IDES) - as well on vmware with oracle and so far it works fine (though with SCM I have used physical hard drive and not pure virtual drive)

>

> Regarding purpose - this is only IDES system , which will be used by few consultants for training purpose. I don't think we will have more than 2-4 people using it (at least not for the moment). Vmware is for me very flexible solution.

Read Note 1173954 - Support of Oracle for VMWare and XEN

So again the question: How did you install the databaes and which patchlevel are you running?

Markus

[JPReyes · Accepted solution]

I couldn't find any value of db_block_buffers in my initCRM.ora file.
What value do you advise ?

I have a value of 80000 in my training system... that should be more than enough

Regards

Juan

[Former Member · Accepted solution]

it is Oracle 10.2.0.1.0 64 bit

regards

Rafal

[markus_doehr2 · Accepted solution]

> it is Oracle 10.2.0.1.0 64 bit

That version is also not supported, it contains severe errors and the one you face may be one of them. Loading data into that database version may corrupt data.

If you read the installation guide you'd notice that you should

- install the version from the DVD (which is 10.2.0.1)

- update to the latest patchlevel (10.2.0.4)

- install the latest interim patches/minipatch for that version

and then start the installation with sapinst.

10.2.0.1 was never supported.

Markus

[Former Member · Accepted solution]

Hi Markus,

thanks for this hint. I will upgrade and let you know if this solved the problem.

We are using the same Oracle version as well for ERP 6.0 IDES (but this is not vmware) , SCM and Solman...so I think maybe I should apply the patch for other systems as well.

I will update the post.

regards

Rafal

[Former Member · Accepted solution]

Hi,

I restarted everything. After installation of Oracle 10, I patched it successfully to 10.2.0.4

Unfortunately with this Oracle version there is another problem (before the one described in this post)

Installation fails in step 13 (Create database') with this error:

+FCO-00011 The step runCatprocSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|

NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|

ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR .+

I found solution here:

Note 972263 - Inst.NW 7.0(2004s)SR2/Business Suite 2005 SR2-UNIX/Oracle

And it worked.

I used a quicker option and edited control.xml

Installation process is moving forward.

I will keep you posted if the installation will stop with ABAP import (as for Oracle 10.2.0.1)

regards

Rafal

[Former Member · Accepted solution]

Hi

I had a lot of troubles with the installation of CRM on Vmware.

For unknown reason vmware fails and is causing restart of host machine. I have tested on host with SLES 10.2, Ubuntu 8.10 and Windows XP Pro 64 and its always the same. While transporting system crashed (host + guest).

Finally (after restart) I tried to restore system in vmware machine. I performed a recovery and continued with installation (last step in ABAP import).

I have faced this problem:

ERROR: 2009-07-27 10:30:46

1 objects have error/ignore/execute or unknown status in the task lines.

Invalid objects are saved in 'invalid_objects.txt' file.

and 'invalid_objects.txt' shows this:

checkObjects=

dbType=ORA

strDirs=/oracle/instalacje-exporty/51034993_1/EXP1/DATA:/oracle/instalacje-exporty/51034993_2/EXP2/DATA:/oracle/instalacje-exporty/51034993_2/EXP3/DATA:/oracle/instalacje-exporty/51034993_2/EXP4/DATA

trace=all

tskDir=/tmp/sapinst_instdir/CRM2007/SYSTEM/ORA/CENTRAL/AS

-

---

package object type action status

-

---

SAPDFACT ?N pkey create

Despite of the error I was able to continue with installation and currently is at stage "Create database statistics"

My question is following:

what can I do about obeject 'SAPDFACT' ? What could be a risk of ignoring this error?

It looks like BI object.

What will be a procedure to repeat load after installation finish.

regards

Rafal

[markus_doehr2 · Accepted solution]

> I had a lot of troubles with the installation of CRM on Vmware.

It's unsupported with Oracle anyway (as previously lined out)

> For unknown reason vmware fails and is causing restart of host machine. I have tested on host with SLES 10.2, Ubuntu 8.10 and Windows XP Pro 64 and its always the same. While transporting system crashed (host + guest).

I would contact VMWare/EMC support.

Is this VMWare ESX?

> SAPDFACT ?N pkey create

Do you have a SAPDFACT.log?

Markus

[Former Member · Accepted solution]

Hi

It is Vmware Server 1.0.9.

though we have license to use ESX (or we can use free ESXi) it does not support the hardware i want to use. Another option I have in mind is to use XEN (SLES 11 have option to install host prepared for Xen). As far as I know Oracle VM is based on XEN. For the moment I want try all options for vmware.

The only problem I see in SAPDFACT.log is this:

/usr/sap/CRM/SYS/exe/run/R3load -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log - stop_on_error

DbSl Trace: ORA-1403 when acessing table SAPUSER

after those lines I see everything went ok.

regards

Rafal

[markus_doehr2 · Accepted solution]

> It is Vmware Server 1.0.9.

OK.

> though we have license to use ESX (or we can use free ESXi) it does not support the hardware i want to use. Another option I have in mind is to use XEN (SLES 11 have option to install host prepared for Xen). As far as I know Oracle VM is based on XEN. For the moment I want try all options for vmware.

Yes - but neverless, neither VMWare nor Xen are supported (officially) for Oracle databases (Read Note 1173954 - Support of Oracle for VMWare and XEN). If you get I/O related or performance problems you're on your own.

> The only problem I see in SAPDFACT.log is this:

>

> /usr/sap/CRM/SYS/exe/run/R3load -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log - stop_on_error

> DbSl Trace: ORA-1403 when acessing table SAPUSER

>

That's not a critical error.

The last line of that logfile contains "completed"?

Markus

[Former Member · Accepted solution]

yes. The last lines are:

job completed & END OF LOG

IDES is only available for DB2 or Oracle, so I have chosen Oracle.

Is there any DB supported for Vmware or XEN ?

If everything fails, then maybe I will try with OracleVM on the other machine (only for DB).

Do you know if SAP supports OracleVM?

regards

Rafal

[Former Member · Accepted solution]

I have another question/problem

During installation I have changed IP address in /etc/host

Now I get error unable to open RFC connection

When I checked log, I see that system tries to connect to 127.0.0.2 which is not current IP address maintained in /etc/hosts

Where in the profile do I change the IP used by system ?

Thank you in advance for your help

regards

Rafal

[markus_doehr2 · Accepted solution]

> IDES is only available for DB2 or Oracle, so I have chosen Oracle.

Where did you get that information? I see installations for Oracle, MaxDB, SQL-Server and DB2 LUW...

http://service.sap.com/installations

--> Installations and Upgrades - Entry by Application Group

--> SAP Application Components

--> SAP CRM

--> SAP CRM 2007

--> <OPERATING SYSTEM>

Markus

[markus_doehr2 · Accepted solution]

> When I checked log, I see that system tries to connect to 127.0.0.2 which is not current IP address maintained in /etc/hosts

>

> Where in the profile do I change the IP used by system ?

Did you set up your network properly?

Installation Guide, page 35, entry last but three...

Markus

[Former Member · Accepted solution]

this is probably connected to the user profile and license agreement with SAP.

I think everybody gets different view on SAP marketplace.

Rafal

[markus_doehr2 · Accepted solution]

> this is probably connected to the user profile and license agreement with SAP.

> I think everybody gets different view on SAP marketplace.

Ok - I see. So your company has only licenses for DB2 and Oracle.

Btw: DB2 is supported in VMWare and Xen.

If you need help/suggestions for this SAPDFACT problem I suggest you open an OSS call and let the support have a look on the system. Without checking more logfiles/entries in various other files it's hard so suggest anything.

Markus

[hannes_kuehnemund · Accepted solution]

Do you know if SAP supports OracleVM?

SAP does not support Oracle VM, please see notes [997990|https://service.sap.com/sap/support/notes/997990] and [1122387|https://service.sap.com/sap/support/notes/1122387].

Thanks,

Hannes

[Former Member · Accepted solution]

Hi,

My installation almost finished, but there is an error in step 93:

ERROR 2009-08-01 23:57:02.387

CJS-00030 Assertion failed: in

function (application, args) {

var mgt = new ProcessMgt();

var app = mgt.createChildApplication(application, args);

var retcode = app.run();

ASSERT(arguments.callee, retcode == 0, "retcode is " + retcode);

}

retcode is 127

ERROR 2009-08-01 23:57:04.449

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2009-08-01 23:57:05.922

FCO-00011 The step Perform_XSL_Profile_Conversion with step key |NW_Onehost|ind|ind|ind|ind|0|0|SAP_Software_Features_Configuration|ind|ind|ind|ind|5|0|NW_Usage_Types_Configuration_PI|ind|

ind|ind|ind|1|0|PiExchangeProfile|ind|ind|ind|ind|5|0|Perform_XSL_Profile_Conversion was executed with status ERROR .

INFO 2009-08-02 00:16:39.591

An error occured and the user decide to stop.\n Current step "|NW_Onehost|ind|ind|ind|ind|0|0|SAP_Software_Features_Configuration|ind|ind|ind|ind|5|0|NW_Usage_Types_Configuration_PI|ind|

ind|ind|ind|1|0|PiExchangeProfile|ind|ind|ind|ind|5|0|Perform_XSL_Profile_Conversion".

sapinst_dev.log:

ERROR 2009-08-01 23:57:02.387 [iaxxinscbk.cpp:282]

abortInstallation

CJS-00030 Assertion failed: in

function (application, args) {

var mgt = new ProcessMgt();

var app = mgt.createChildApplication(application, args);

var retcode = app.run();

ASSERT(arguments.callee, retcode == 0, "retcode is " + retcode);

}

retcode is 127

TRACE 2009-08-01 23:57:04.413 [iaxxejsbas.hpp:388]

handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

ERROR 2009-08-01 23:57:04.449

CJSlibModule::writeError_impl()

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

TRACE 2009-08-01 23:57:05.895 [iaxxejsbas.hpp:460]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

ERROR 2009-08-01 23:57:05.922

FCO-00011 The step Perform_XSL_Profile_Conversion with step key |NW_Onehost|ind|ind|ind|ind|0|0|SAP_Software_Features_Configuration|ind|ind|ind|ind|5|0|NW_Usage_Types_Configuration_PI|ind|

ind|ind|ind|1|0|PiExchangeProfile|ind|ind|ind|ind|5|0|Perform_XSL_Profile_Conversion was executed with status ERROR .

TRACE 2009-08-01 23:57:10.402

An error occurred while processing service SAP CRM 2007 > SAP Systems > Oracle > Central System > Central System Installation. You may now </p> <ul> <li> choose <i>Retry</i> to repeat the current step. </li> <li> choose <i>View Log</i> to get more information about the error. </li> <li> stop the task and continue with it later. </li> </ul> <p> Log files are written to /tmp/sapinst_instdir/CRM2007/SYSTEM/ORA/CENTRAL/AS.

TRACE 2009-08-01 23:57:10.406 [iaxxgenimp.cpp:1155]

showDialog()

waiting for an answer from gui

INFO 2009-08-02 00:16:39.591 [iaxxgenimp.cpp:782]

showDialog()

An error occured and the user decide to stop.\n Current step "|NW_Onehost|ind|ind|ind|ind|0|0|SAP_Software_Features_Configuration|ind|ind|ind|ind|5|0|NW_Usage_Types_Configuration_PI|ind|

ind|ind|ind|1|0|PiExchangeProfile|ind|ind|ind|ind|5|0|Perform_XSL_Profile_Conversion".

I tried to find a solution, but I couldn't find anything.

Does anybody know what to do ?

regards

Rafal

Edited by: Rafal Drezek on Aug 3, 2009 10:43 AM

[Former Member · Accepted solution]

problem was solved (after I shutdown the system, started again and waited for java startup - installation finished without problems)

regards

Rafal

[Former Member]

Thanks Markus

Regards

Uday

[Former Member]

Hi

If SCM and solman was installed with same 10.2.0.1.0 then you should have not got this error.

Any way you should always install oracle path set

Regards

Uday

[markus_doehr2]

> If SCM and solman was installed with same 10.2.0.1.0 then you should have not got this error.

There is an error when importing data using fastload in tablespaces; under certain circumstances data may get corrupted. "older" installation don't use the fastloader so it depends on the Oracle version, the R3load and libdbsl version and the import options. Neverless, Oracle 10.2.0.1 is not supported anyway.

Markus

[Former Member]

Hi

Is this installation for Test purpose or Production ?

Regards

uday

[Former Member]

Hi Rafal

Quick question did you install Oracle patch ?

Regards

Uday

[Former Member]

No. I haven't installed anything

All installation files were downloaded from SAPmarketplace

3 weeks ago I have installed Solman using the same files (of course apart of CRM Extract files). I did it successfully.

I am using as well exactly the same OS settings, because this is the same vmware files set

This is IDES version of CRM.

regards

Rafal

[markus_doehr2]

- How did you install Oracle?

- What Oracle patchlevel are you running?

You're aware that Oracle on VMWare is not supported?

Markus