Issue deploying dcr data to a specific database table

System

I have now managed to successfully deploy some data from my TeamSite dcr's to an Oracle database. This was achieved by running command C:\iw-home\OpenDeployNG\bin>c:\iw-home\opendeployng\bin\iwsyncdb -initial /default/main/linde/linde_global_intranet/WORKAREA/default linde_global_intranet/1_column

I was hoping the data was going to populate a database table named 'tbl_news_items'. But instead, a new table named 'IWT_2ADB925AF9BD' was created within the database, containing all the data. Any suggestions as to why this happend and what I might need to tweak, to get it behaving.?

dbschema.cfg file attached.

Ambuj

I have now managed to successfully deploy some data from my TeamSite dcr's to an Oracle database. This was achieved by running command C:\iw-home\OpenDeployNG\bin>c:\iw-home\opendeployng\bin\iwsyncdb -initial /default/main/linde/linde_global_intranet/WORKAREA/default linde_global_intranet/1_column I was hoping the data was going to populate a database table named 'tbl_news_items'. But instead, a new table named 'IWT_2ADB925AF9BD' was created within the database, containing all the data. Any suggestions as to why this happend and what I might need to tweak, to get it behaving.? dbschema.cfg file attached.

Open Deploy will create a new table in below cases..

1. If there's any CONSTRAINT on the table which is not allowing OD to insert data.

-- You can remove all the constraints on this table and then test it.

2. If OD user has got write (create table) access on DB schema.

-- Remove the create table access on DB schema for OD user.

Also you can try inserting fixed values (not from dcr) in a simple dummy table to see if it works well.