Installing IDES ERP 6.0 incl. EHP7 on HANA fails at Import ABAP importing LOB data

[Former Member]

Hello,

i'm trying to install IDES ERP 6.0 incl. EHP7 on HANA on our P8 Linux Server.

At the Import ABAP stage i get failed imports like:

(DB) INFO: ENHCROSSINXSPOT created #20160922141925

(IMP) INFO: finished create for object "ENHCROSSINXSPOT" of type "table" in 0 sec #20160922141925

(DB) INFO: loading data in table "ENHCROSSINXSPOT" with DBSL #20160922141925

(IMP) INFO: starting import for object "ENHCROSSINXSPOT" of type "table" #20160922141925

DbSl Trace:   closeLob() of C_0071, rc=1, rcSQL=598

DbSl Trace: LOB_CLOSE C_0071 on connection 0, rc=598

(IMP) ERROR: insert failed for table "ENHCROSSINXSPOT", rc = 99

  (SQL error 598)

  error message returned by DbSl:

failed to execute the external statement: no such data type: type_code=0, index=1

(IMP) INFO: starting create for object "ENHCROSSINXSPOT" of type "merge" #20160922141926

(DB) INFO: ENHCROSSINXSPOT merged #20160922141926

(IMP) INFO: finished create for object "ENHCROSSINXSPOT" of type "merge" in 0 sec #20160922141926

(IMP) INFO: starting create for object "ENHCROSSINXSPOT~0" of type "primary index" #20160922141926

(DB) INFO: ENHCROSSINXSPOT~0 created #20160922141926

(IMP) INFO: finished create for object "ENHCROSSINXSPOT~0" of type "primary index" in 0 sec #20160922141926

(IMP) INFO: starting create for object "ENHCROSSINXSPOT" of type "unload" #20160922141926

(DB) INFO: ENHCROSSINXSPOT unloaded #20160922141926

(IMP) INFO: finished create for object "ENHCROSSINXSPOT" of type "unload" in 0 sec #20160922141926

It looks as if all tables with some kind of LOB content fail.

Trying to load the tables directly with R3load also fail.

i've tried the install with K_742_U_LINUX_PPC64 (51049724_4), K_745_U_LINUX_PPC64 (51050554_4) as well with a modified SAPEXEDB.SAR with R3ldctl_214-80001037.SAR and R3load_213-80001037.SAR (note 1826587).

Do you have any hints how i could install IDES on our Power8 SUSE linux machine?

Might be there is some setting on the HANA instance missing?

Regards,

Rudolf Zimmer.

[Former Member]

Hello Rudolf,

Just for starters could you answer/do the following:

1. What revision of HANA did you install.

2. How much memory do you have on the LPAR ?

3. Could you attach the indexserver trace file please.

could you move this thread over to the SAP HANA and In-Memory Computing space please.

Kind Regards,

Amerjit

[Former Member]

Hello,

the HANA DB is SPS12 (Version 1.00.121.00.1466466057) with 1T allocation limit on a 1.5T P8 box with SUSE Linux.

Regards,

Rudolf.

[Former Member]

Hello Rudolf,

Could you please upload the following files:

1. indexserver trace file

2. import_monitor.log file

3. Package log file corresponding to the package that contains the failed import(s). You will find the package name in the import_monitor.log file.

KR,

Amerjit

[Former Member]

Hello,

the files are collectet in a 28MB zip-file now.

How can i upload them (i didn't find the upload option)?

Regards,

Rudolf.

[Former Member]

Hello,

The upload (attach) becomes visible when you select "Use advanced editor".

28MB will be too big. Max size limit is 1MB.

1. Save the last 500 lines of the indexserver trace file to a new text file and put that file in the zip

2. Add the import_monitor.log file to the zip.

From the import_monitor.log file we'll determine what package failed and from there you can look in that package log file.

nb: before you try to upload the .zip file, please rename it to .zip.txt and then upload it. I think you can't upload .zip files directly.

KR,

A.

[Former Member]

Hello,

here are the log- and trace files.

I left the executed statements traces because they didn't contain the create table statements of the tables in charge (while had beeing created).

Regards,

Rudolf.

IMP_Issue_reduced.zip.txt.zip