on 05-22-2015 10:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.