Error 314: numeric overflow: search table error: 6499 error executing physical plan: exception 6499

[Former Member]

Hello all, I'm having several troubles with PA recently and one of then, is the error below.

It happens after I execute the APRIORI algorithm, and try to visualize the results. So then appears this window:

Does anyone knows what might be happening?

Regards!

[AndreasForster]

Hi Jürgen,

I think you are almost there.

It sounds as if the Apriori execution succeeds and only when going to see the results you get this error? That error is probably related to the column type. Before changing date types, you could quickly try these two things to narrow the problem down

- Put a filter component before the Apriori component. Apply a row filter in it to restrict the number of rows. Use something very small, maybe just 1000 rows.  If this works, you are sure the error is related to the larger number of rows/values

- If the above is working, then remove the filter and add a HANA Writer component after Apriori. Now executed the analysis and do not display the results in SAP PA. Instead see if the HANA table was filled with the Apriori results.

Greetings

Andreas

[Former Member]

Hi Andreas, I'm trying to do the the steps that you recommended me, and I'm with a few doubts about it:

First I tried to add a filter, so then I've done the following:

I noticed that the only one that worked was the collumn named "NUMERONOTAVENDA" so then I realized that it was because that column is the only measure that I have (I've created an analytic view, and put that collumn as a measure) so then I put it (on HANA) as a SUM (I don't understand the difference betwenn the options I can select over there (SUM, MIN, MAX and COUNT)), so then I put it as SUM.

Ok, comming back to PA, I clicked in execute, and then it worked, and when I clicked to see the results, it gave me the same error:

Did I do anything wrong, or that is a better way to do that?

ok, so then tried to do the second step you suggested me: put on and executed the APRIORI algorithm, it worked, but I didnt changed to the results view. and after that, I used the hana writer:

and clicked ok, so then I clicked again in execute, and got this error:

Then I went to HANA Studio, the right schema, and saw the table over there, but when I try to Preview Data, it opens a blank table!

Again, did I miss anything, or am I doing anything wrong?

regards!