Where are the actual documents stored in solution manager (KW)?

[Former Member]

Hello,

I have a question regarding Solution Manager and storing documentation.

When we in our process structure in a project uploads a word document

(as documentation), where are the file then physically stored?

I have checked the table SA01PHIO (a KW table), here I see a new entry every time I

upload a new word document (or other type of documentation). But this

table does not grow accordingly to the size of the word documents I

upload, so the physical document must be stored somewhere else in the

database.

The description of field 'PHIO_ID' in table SA01PHIO is "Physical document", but since the field is of type char (size 32), then it can only be a link to the actual file?

We need to know where the documents are stored, so that we can plan our

storage strategy and database space management accordingly.

Anyone knows where the files are stored in the database?

Thanks in advance.

Regards

[Former Member]

Hello,

I have exactly the same question as Kenneth, even though it was originally asked 3 years ago.

We would like to store video files in Solman, describing the Business Processes. I need then to know where those files would be stored in order to request database space extension.

Could anyone give some help on this matter?

Thank you very much in advance.

Regards,

Rémi.

[Former Member]

In a standard Solution Manager 7.1 system the documents are stored in document area IWBSOLAR, content category SOLAR01 and content repository SOLARCONTENTDB which uses the database table SACONT01.

[Former Member]

Samuli,

Thank you for your help.

After further searches, I have found exactly what I was looking for.

Samuli, as you said, documents are stored in table SACONT01, but I did not understand how they were stored, as all the data you have in this table is something like:

FF06010102028000343130320000000074040000121F9D02A37D7259692086C2F0D7761017222...

So the information can be benefit to other people searching, I will share it here.

The string of alpha-numeric characters you see above is a "part" of the document.

Document data is cut into clusters, and stored in table SACONT01 (in field CLUSTD, coupled with CLUSTR).

In order to retrieve all the clusters for a given document, you need to get its logical ID (LOIO - LOgical Information on Object):

- Select the document (SOLAR01/02 for projects, SOLMAN_DIRECTORY for solutions)

- Enter DOC_INFO in the transaction code field

- Copy the Object ID

In table SA01PHIO, retrieve the physical id(s) from the logical id (PHIO - PHysical Information on Object).

Search SACONT01 with the physical id(s).

Just as an example:

- 340 entries for a Word document (about 50 pages)

- 57000 entries for a video (200 MB)

Hope it will help.

Regards,

Rémi.

[deepak_h3]

The OBJID is the object id to retrieve the document from the content server which is defined by SOLARCONTENTDB in transaction OAC0. It is a content repository.

In solar02 - click on URL under document attributes and it will show the direct URL link to access the physical document. You can paste it in browser to retrieve the document. It has the object id in the URL.