Why is status not changing to Processing in /api/analytics/recommendations/recommender?

[PavanKrishna]

Hi

Kind attention:

@Philip.mugglestone, @thierrybrunet, @abdeldadaouche

philip.mugglestone

I am working on the tutorial HCP Predictive Services: Recommendations from the link https://youtu.be/JxuJ5OzD8Yg.

As mentioned in the video when I click on Post after copying the code I get the message as shown in the screen below:

For me the status is always NEW as against "Processing" shown in the tutorial. How many ever times I hit on Post I get the status as NEW but each time the ID is changing from 1 to 2 to 3 to 4 and 4 to 5. Why is the status not changing to Processing?

And then when I hit on the GET for the API /

api/analytics/recommendations/recommender/{jobID}/status

I get the status as Failed whereas actually I should be getting Success as mentioned in the tutorial.

Why is the status Failed in the above screen shot? In this case I am not writing any code also. Simply following the instructions as it is mentioned in the tutorial but don't where I am going wrong.

Please help me fix this issue.

Thank you.

Regards,

Pavan.

[pmugglestone · Accepted solution]

Hi Pavan,

Looks like predictive services cannot access your table.

Maybe try a call to /api/analytics/dataset/{datasetID} to see if you get a more explicit message?

You can try creating a new datasetID for your table with a call to /api/analytics/dataset/sync using the new body syntax:

{ "location" : { "schema" : "YOUR_SCHEMA", "table" : "YOUR_TABLE" } }

If that works OK (you can check with /api/analytics/dataset/{datasetID} then you should be able to use that datasetID in subsequent calls.

If not, check that your HANA MDC tenant database is up and running (in the free trial it gets stopped/deleted automatically if not used for a certain time). Check that the table exists in your HANA MDC tenant database (access it via Eclipse?) and check that the aac4paservices java app in your account has the data source binding to your HANA MDC tenant database correctly configured and that the HANA database user you specify has access to your table (if needed, restart the java app).

Hope this helps?

Philip

[pmugglestone]

Hi,

Each time you do a POST to /api/analytics/recommendations/recommender you are starting a new batch job - that's how it's intended to work and that's why it always says NEW and you see a new jobID.

If a given job is failing when you do a GET to /api/analytics/recommendations/recommender/{jobID}/status then do a GET to /api/analytics/recommendations/recommender/{jobID} and you should see a list of errors returned looking similar to this:

{ "errors": [ { "errorCode": "EXX102", "errorMessage": "The \"UserID\" variable used as userColumn was not found in the dataset." }, { "errorCode": "EXX102", "errorMessage": "The \"ItemPurchased\" variable used as itemColumn was not found in the dataset." } ] }

There could be any number of reasons why the job is failing, perhaps the datasetID is not the correct one or the table referenced by the datasetID no longer exists perhaps there was an error in the body section of the POST?

Hope that helps?

Philip

[PavanKrishna]

Hi Phillip,

Thanks a lot for your response. I am getting the error with code EXX108 - The service cannot access the dataset 1. Can you please advise how to fix the same.

{
"errors": [
{
"errorCode": "EXX108",
"errorMessage": "The service cannot access the dataset 1."
}
]
}

Thank you.

Regards,

Pavan.

[PavanKrishna]

Hi Phillip,

Thanks a lot for your reply. I got the following error message. Can you please advise how to fix this error. A google search took me to this page

https://help.sap.com/doc/20cd1b0396db4826a9b76b4ce869f00a/Cloud/en-US/88a0a69c7ac049acbbed20520606c3... which just gives the description of the error message.

{
"errors": [
{
"errorCode": "EXX108",
"errorMessage": "The service cannot access the dataset 1."
}
]
}

Thank you.

Regards,

Pavan.