Where do the workflows store in oracle database ?

[Former Member]

Hello experts,

I need the table name in which the mdm workflows are stored

We are using oracle database

Kindly help on this issue...

[Former Member · Accepted solution]

Hi Mahesh,

You can check the contents in Data base table A2i_CM_TABLES. This should contain the table name which would be having the data related to Workflows. Then you can check the contents of corresponding table. Please check and let me know. Thank you.

[Former Member · Accepted solution]

Thanks for your reply Ankush,

When we queried for the table , we found the description as :

desc
MATERIALENP_M000.A2I_CM_TABLES;

Name                                    
Null?    Type

-----------------------------------------
-------- ----------------------------

TABLEID                                 
NOT NULL NUMBER(10)

TABLENAME_L0                            
NOT NULL NVARCHAR2(128)

CODENAME                                
NOT NULL NVARCHAR2(255)

DESCRIPTION                                      
NCLOB

TABLETYPE                               
NOT NULL NUMBER(10)

FLAGS                                   
NOT NULL NUMBER(10)

LOOKUP                                  
NOT NULL NVARCHAR2(255)

NEXTAUTOID                              
NOT NULL NUMBER(10)

PRIMARYDISPLAYFIELD                     
NOT NULL NUMBER(10)

The basic idea here is we want the corresponding work flows, which are getting stored in
the DATAMANAGER its corresponding table in the database.

We have 1000+ workflows available for our repository,but when checked in this table
there were 44 entries listed.

I think I have explained what I am looking for

[Former Member · Accepted solution]

Hi Mahesh,

It seems you are looking into the number of workflows available and not the workflow jobs.Please confirm this by asking number of workflows defined in MDM.

Try accessing A2I_Data_WFJob.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Mahesh,

Though i am not much into SQL language, but i think DESC will only list down the Structure of the table and not the contents. You need to see the contents of the table A2i_CM_TABLES. It will list down all the table names and there would be one for MDM Workflows as well. You need to note down Table ID for workflow table. Then using Table ID you need to query table A2i_X_Text where X = Table ID.

This way you will be able to see the contents of Workflow table and use them as per your requirement.

Please check this and let me know the results.

Thanks and Regards,

Ankush

[Former Member · Accepted solution]

Hi Mahesh,

Can you please update the thread with your findings?

Thank you.

[Former Member · Accepted solution]

Hello Ankush,

Thanks for your reply.

As you said i was able to query the A2I_CM_Tables.

I want to find all the work flows associated with this table.

This table has ID =1;

When i queried A2I_i_Text i get the table structure as

ID, LangID, Field ID, TextField.

In data manager for this corresponding table I find the number of workflows as - 927.

But the similar view I am not able to get in DB.

@Ravi

A2I_Data_WF - when i try to access this table, it says it does not exist

[Former Member · Accepted solution]

Hi Mahesh,

I think we are not on the same page regarding checking the contents for Workflow.

I will list down the steps:

First use Select query to list down all the contents of table A2i_CM_TABLES.

This will list down all the table names for corresponding repository along with Table ID and other details.

You need to look for the table and then note down Table ID for that.

Then use select query on Table A2i_X_Text where X is the Table ID you just noted down.

Here you will see all the entries related to workflows.

Looking at database, you will not be able to see the contents as you see in Data Manager because in Database there may be different fields and the structure in which it stores the contents would be different than how we see in Data Manager. You would need to spend some time to understand the same. Database does not show exact picture in User Friendly way.

You can see below post as well as it might be helpful in how to access data base for particular repository:

http://scn.sap.com/thread/3199205

Please get back if you still have any doubts.

Thanks and Regards,

Ankush Bhardwaj

[Former Member · Accepted solution]

Hello Ankush,

As you said i agree with the views in Database and DataManager

are different.

As per my client all the workflows must be saved in some

place and must not be deleted.

So i do keep moving the completed

workflows to archive status in DM.

My motive is to create a new schema in

the database and move all the workflows seperately as part of

tracking.

So if i find the corresponding table regarding the workflow it

would be helpful.

But after your clear statements I think this is not

achievable.

As per my understanding only the completed workflows are in

the memory of MDS and during its load,

in the phase Intialising WorkFlow all

these completed workflows get loaded.

Kindly let me know whther my

understanding is correct regarding the workflows.

Thanks & Regards,

Mahesh Babu Lanke

[Former Member · Accepted solution]

Hi Mahesh,

I also think the same way.

It will be difficult to achieve your requirement requirement here. Thank you.

[Former Member · Accepted solution]

Hello Ankush,

Thanks for the confirmation

Kindly clarify me one thing, whether completed workflows only are in the memory or all the
statuses(archived,error...) are also in the memory of the MDS server

Thanks in advance

[Former Member · Accepted solution]

Hi Mahesh,

I am not sure though but i think all statuses should be there in MDS server i suppose.

It is stored in MDM repository itself because in Data Manager Reference guide itself it mentions that these workflows are indeed Microsoft Visio files which are stored in Repository itself. Pasting the exact lines from Reference guide:

"DEFINING AND EDITING WORKFLOWS

Recall that each workflow is stored as a record of the Workflows table, and that the actual workflow object is a Microsoft Visio file that is stored in the MDM repository and accessed through the Workflow field of each workflow record."

So all workflows should be there in MDM repository itself and displayed in Data Manager. Thank you.

Message was edited by: Ankush Bhardwaj

[Former Member · Accepted solution]

Hi Mahesh,

Kindly update/close the thread. Thank you.