Operational Data Stores in OPInt

[Former Member]

Hi, I am trying to generate a business scenario based on a operational data store, whose source table has three columns (all of them are primary keys):

1) the case ID ["CASE_ID"]

2) the activity description ["ACTIVITY"]

3) the timestamp (when an activity has occurred for a certain case) ["TIMESTAMP"]

When adding the events, I set the condition "ACTIVITY" = '<activity_name>' to define the event corresponding to the occurrence of the activity <activity_name>; and I set "TIMESTAMP" for the observed time.

When generating the business scenario, I see the process phases on space.me as I defined them, but there are no instances. The context has no rows.

Does anyone know why?

Many thanks.

[qurm · Accepted solution]

Hi Fabio,

I don't have direct experience of using an operational data store, but you can troubleshoot at the table level to see if there are any instances and events.

I would look at these tables (your table names will be different depending on the package naming and Scenario name) - are there any rows, and are are new rows added when you add data to the operational data store?

"SYS_PROCESS_VISIBILITY"."OPI.OPI_XXXX.gen_xxxx::SPVR_XXXX_EVT_CUR" - has the current, most recent event for each instance

"SYS_PROCESS_VISIBILITY"."OPI.OPI_XXXX.gen_xxxx::SPVR_XXXX_EVT" - has all events for the instances

Then there are also some log tables that you can check to see if the correlation is running. Like these

SPVR_XXXXX_EXEC_LOG,

"SYS_PROCESS_VISIBILITY"."sap.opi.pv::SPVR_ERROR_LOGS"

Regards,

Andy

[Former Member · Accepted solution]

Many thanks Andrew,

by doing something else than what I described in my question, I get what I want in all tables you mentioned (also in the context table). When I go on space.me, though, even if everything looks fine when I open the scenario (image1.png), when I click on an instance, the designed phases are not available in the Status section (image2.png).

This problem occurs also for other scenarios which I had already created with the process observer previously, so it may be a opint configuration problem.

Do you have any ideas how to solve this problem?