Workflow data repository limitations

OL Connect Professional Workflow
1

Is there a limit to the size of the data repository?
In other words are there limits to the number of groups and the number of records in each group?

Where is the data repository database located? Is there a limit to the file size on disk?

Can the data repository be exported\imported from one server to another?

Can the data repository handle concurrent access to the same group and data from one or more different self-replicating process? Or is there a limit to the number of processes which can update or write to the same group and keysets at the same time?

2

The Repository is a SQLite file. You can read about any limitation on this SQLite web page.

The files are located in C:\ProgramData\Objectif Lune\PlanetPress Workflow 8\PlanetPress Watch\Repository and can be backed up/copied to another server.

Concurrent access is allowed as long as you use the Repository API which has been tailored specifically for that. If you were to attempt direct access to the database, you would have to implement your own locking mechanism across all processes.

2 Likes
3

Hi Phil,

When data is saved in data repository, do they expire? If they do can you set the expiration?

Also with content sets when a job has ran on the Worfklow, the server keeps them for certain amount of time, can you also set how long they can stay?

Thanks

4

No, the Data Repository’s content is under your control and responsibility. You will have to impelement cleanup processes yourself.

As for the contents of the Connect database, you can set the persistence time through the Clean-up service options in the OL Connect Server Configuration application.

1 Like