Skip to Content
0
Former Member
Feb 23, 2009 at 12:22 AM

Data Services should be changed to read only mode

241 Views

We have an ODBC connection configured to connect to a Synergex (DBL)

system via xfODBC drivers. The ODBC is configured as a System DSN. We

can successfully query the data via Microsoft Query Excel, Microsoft

SSIS, Microsoft Access, etc...

When connecting to the same ODBC with Data Services 3.0, we get the

attached error message.

BODI-1112346: Error: Cannot load metadata table <name=all>

ODBC data source <Domino_BMM> error message for operation <SQLTables>:<

[TOD][ODBC][GENESIS]WORM: Cannot open 'GENESIS_TABLES',No privilege to

this file or directory>.

It looks like Data Integrator requires read/write access to the system

catalog tables (GENESIS_*)

We have been advised by Synergex that the issue is caused by the

Transaction Mode used (i.e. read/write).

Could you please advise which parameter in Data Services should be

changed to use Read only Transaction Mode on the datastore?

I had a look through the DSConfig.txt configuration file as well and

could not find any suitable parameters.

Please also advice if there is a workaround