# The data is not syncing automatically from CouchDB to RDBMS

**URL:** <https://forum.communityhealthtoolkit.org/t/the-data-is-not-syncing-automatically-from-couchdb-to-rdbms/3044>\
**Category:** Technical Support\
**Tags:** couch2pg\
**Created:** [September 20, 2023, 8:37am UTC](https://forum.communityhealthtoolkit.org/t/the-data-is-not-syncing-automatically-from-couchdb-to-rdbms/3044 "2023-09-20T08:37:52Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![yuv](https://communityhealthtoolkit.b-cdn.net/user_avatar/forum.communityhealthtoolkit.org/yuv/32/320_2.png) [@yuv](https://forum.communityhealthtoolkit.org/u/yuv)\
**Post date:** [September 26, 2023, 9:36pm UTC](https://forum.communityhealthtoolkit.org/t/the-data-is-not-syncing-automatically-from-couchdb-to-rdbms/3044/11 "2023-09-26T21:36:45Z")

</div>

> [@Marcelo\_De\_Guzman](#):
>
> [2023-09-21T02:13:45.925Z ERROR]: XMLForms support failed  
> [2023-09-21T02:13:45.925Z ERROR]: { error: must be owner of materialized view useview\_telemetry  
> at Parser.parseErrorMessage (/app/node\_modules/pg-protocol/dist/parser.js:287:98)  
> at Parser.handlePacket (/app/node\_modules/pg-protocol/dist/parser.js:126:29)  
> at Parser.parse (/app/node\_modules/pg-protocol/dist/parser.js:39:38)  
> at Socket.stream.on (/app/node\_modules/pg-protocol/dist/index.js:11:42)  
> at Socket.emit (events.js:198:13)  
> at addChunk (\_stream\_readable.js:288:12)  
> at readableAddChunk (\_stream\_readable.js:269:11)  
> at Socket.Readable.push (\_stream\_readable.js:224:10)  
> at TCP.onStreamRead [as onread] (internal/stream\_base\_commons.js:94:17)

Hi @Marcelo_De_Guzman , the error on couch2pg suggests that the user that is running couch2pg doesn’t have access to some objects. In this case its throwing error for `useview_telemetry `. You can change the ownership of these objects by using sql like below:

```auto
ALTER MATERIALIZED VIEW useview_telemetry OWNER TO user_group;

```

Here, you need to replace user\_group by the user name or user group for a postgres user that you configured on couch2pg.

---

_[View the full topic](https://forum.communityhealthtoolkit.org/t/the-data-is-not-syncing-automatically-from-couchdb-to-rdbms/3044)._