Replication Agent and selecting field names with special characters from Oracle PDS

[Former Member]

Hello All,

I have SAP Replication Server SP200 set up and working from Oracle to HANA. I'm creating a subscription with the direct_load option on the SAP table MARA. This is failing at the "SELECT" stage with the Oracle error "ORA-00936: missing expression". This is because the MARA table contains a few fields that begin with a forward slash e.g. /BEV1/LULEIHN. In order for this to work each field name needs to be enclosed in double quotes ("/BEV1/LULEIHN"). Does anybody know if there is an option in Replication Server to make it use double quotes in select statements?

If not I'll end up creating views for all the tables containing special characters.

Thanks

Matt

[Former Member · Accepted solution]

Hello All,

I've had a reply about this from SAP after logging a support call. There is a configuration parameter called dsi_quoted_identifier the has to be set to 'on' in the connection to the primary db. It seems that you then subscribe using the quoted key word to the table concerned.

Once I have the exact syntax worked out and I've managed to replicate a table with special characters successfully I'll post here what worked for me.

Thanks

Matt

[Former Member · Accepted solution]

Hello,

I've now got this working but setting the dsi_quoted_identifier to "always" when creating both primary and replicate connections. The syntax I used was as follows:

create connection to pds.pdb

using profile <profile_name>

set username <username>

set password <password>

set dsi_quoted_identifier to "always"

go

Thanks

Matt