Expert Analytics crashes Hana indexserver

[Former Member]

Hi Gurus,

we have been digging for this problem for 2 days, but we have not got any solution.

We had tried all the articles that we had found about roles (AFL, PAL) set all the stuff, but we still get error message at Expert Analytics:

Error [-708] Connection T0 could not send data[socket closed].

We think that this is a result of the indexserver crash in SAP Hana.

Error message from SAP Hana diagnosis files:

SQL: INSERT INTO "USER_SCHEMA_NAME"."null"

( "row_id" , "PreRule" ,"PostRule" ,"Support" ,"Confidence" ,"Lift" ,"__Summary__" ,"__pmml__"  )

select "row_id" , "PreRule" ,"PostRule" ,"Support" ,"Confidence" ,"Lift" ,"__Summary__" ,"__pmml__"

from "USER_SCHEMA_NAME"."AUT_PAS4_1_RV"

We are trying to to make a basket analysis with Apriori.

(Note that the "USER_SCHEMA_NAME" is obviously not the real name of the schema...)

The "null" table does not look good, but it is generated by the Expert Analytics, we have no control over it.

Predicitve Analytics - 2.3

SAP Hana SPS09 Rev.97

Any idea is greatly appreaciated!

Thanks,

David.

[achab]

Hi David,

Thanks for raising the issue and sorry for the inconvenience faced. The engineering teams are investigating this and will update you when they have more information to share.

To investigate they need the extra bits of information below:

• Index server logs
• Sample data exported from HANA with correct data types (not a CSV export).
• A screenshot of the chain with configuration details and/or the lums file.

If you feel more comfortable sharing this via SAP Support, please create a support ticket and update with the number of the ticket here.

Thanks & regards

Antoine

[Former Member]

Hi Antoine,

thanks for the help!

All the requested files are zipped - renamed to .txt - and attached!

Thanks & regards,

David

indexserver_crashdump.20150929-180430.019271.zip.txt.zip

BASKETSAMPLE.zip.txt.zip

lum_and_docx.zip.txt.zip

[achab]

Hi David,

This is now being investigated.

Engineering asks for the additional elements:

1. index server logs (not the crash dump)
2. hana sql trace logs

Can you please provide to them via this thread when time allows?

I think it would be also best practice that you raise an incident with SAP Support so that this is not only traced via SCN.

Thanks & regards

Antoine

[achab]

Hi , do you have news on this?

Thanks & regards

Antoine

[Former Member]

Hi Antoine!

It is working now, but it is a shame as it is working... (sorry did not want to offense anybody!)

The solution was:

The table types that a given algorithm uses must be present at the users schema.

Basically when a new user would like to run a given algorithm than we have to add those table types with a procedure. (Instead of using a schema for that and giving rights for that schema...

We also assumed that PA would check all the artifacts needed and if any of them is missing it creates them.)

What I wanted to say that the whole process is least user friendly.

Thanks for taking the time,

Best regards,

David.