Skip to Content
0
Former Member
May 11, 2018 at 07:53 PM

Exporting CMS from Production

87 Views

Hi Experts,

I have been using the following tool for a while to synchronise CMS content between production.

https://wiki.hybris.com/display/~/Data+Exporter

Sadly on this last attend the SQL generated has been incredible large and gives a ORA-01745: invalid host/bind variable name error though the large amount of SQL generated and the prepared statements placeholders (? marks) being > 65k.

I know the CMS is customised and I am exporting custom components and models from the type system but I can't understand why the SQL is so large.

Short of debugging into the code to try and work out if there are any particular models or cms components which are at fault, or cloning the db and copying over the media folder (then cleaning user data from the database - which isn't my ideal choice.) Is there another way to easily sync the content between systems?

I can post the CSV and Media ZIPs and type exporter config should anyone like to take a look.

Thanks, Craig.