DMIS 2011 SP9 - Rename Target Field

[Former Member]

Dear all,

for test purposes we installed a DMIS 2011/SP09. We read a specific table via RFC and transfer the Data in a non SAP Database ( Oracle ).

Everything works fine but i have a Problem when i want to change a specific Field Name on the Target DB.

The creation of the table and the change of the field name is successful, but the data transfer is not possible anymore.

Table SAIRPORT

Source Field Name: NAME  -> Target Field Name: AIRPORT

Error message :

The following error messages occurred on: 29.10.2015 08:12:02

SQL exception occurred in receiver system (rfc dest. NONE)

Execution of program /1CADMC/OLC_100000000000091 failed, return code 3

Database error 904 at INS access to table /1CADMC/S0000222

con=2(SM6): ORA-00904: "NAME": invalid identifier

What have i done wrong.

greetings

oliver

[Former Member]

[Former Member]

This is the change i made in order to transform the data out of Field NAME ( SOURCE DB ) into Field AIRPORT ( TARGET DB ).

[Former Member]

B Tue Nov  3 14:40:10 2015

B  Connect to X01 as sapsr3 with X01

C  Connecting as sapsr3/<pwd>@X01 on connection 2 (nls 0) ... (dbsl 721 180915, UNICODE[2])

C  OCIHandleAlloc(con=2): Service svc=6d08950 created, rc=0

C  OCIServerAttach(con=2, svc=6d08950): New server hdl. srv=72ff878 attached to 'X01'

C  OCISessionBegin(con=2, svc=6d08950, srv=72ff878='X01'): start session usr=7957ba0='sapsr3', rc=0

C  Now 'sapsr3/<pwd>@X01' is connected: con=2, nls=0, session=134, time='2015-11-03 14:40:10'

C  DB instance X01 is running on <Target_Server> with ORACLE version 10.2.0.4.0 since JUL 31, 2013, 17:18:58.

C  con=2, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8

C   # CharacterSet                   NCharSet   envhp            errhp            er2hp            bathp

C   0 UTF16                          AL16UTF16  6b221e0          6b2a418          6b3f2a8          6b3ec38

B  Connection 6 opened (DBSL handle 2)

C  check2: OCIStmtExecute() failed with -1=OCI_ERROR

C          SQL error 904:

C  *** ERROR => Error 904 in stmt_execute() from oci_execute_stmt(), orpc=0

[dbsloci.c    18480]

C  {root-id=005056A70E5F03D48FA5C632A8794F68}_{conn-id=5638C182B75E664DE1000000A15914F1}_1

C  *** ERROR => ORA-00904 occurred at SQL stmt (parse error offset=45)

[dbsloci.c    18481]

C  {root-id=005056A70E5F03D48FA5C632A8794F68}_{conn-id=5638C182B75E664DE1000000A15914F1}_1

C  Dump statement cache (after SQL error):

C  sc_p=6ae7018,no=211,idc_p=6afd230,con=2,act=1,slen=72,smax=1280,#vars=3,stmt=7525fd0,table=/1CADMC/S0000222

C  INSERT INTO "/1CADMC/S0000222" ("MANDT","ID","NAME") VALUES(:A0,:A1,:A2);

C     statement for table '/1CADMC/S0000222              ':

C         INSERT INTO "/1CADMC/S0000222" ("MANDT","ID","NAME") VALUES(:A0,:A1,:A2)

C     stmt_execute() -> orc=904 (orc1=904), rc=99=DBSL_ERR_DB

C  Dump statement cache (rc=99=DBSL_ERR_DB):

C  sc_p=6ae7018,no=211,idc_p=6afd230,con=2,act=1,slen=72,smax=1280,#vars=3,stmt=7525fd0,table=/1CADMC/S0000222

C  Dumping stmt. cache (DBSL private attributes):

C  sch=6ae7018, scp=6af7520, ups_sch=NULL, stp=700b688, r_c=0

C  prep=0, dbds=0, lit_cnt=0, lob_cnt=0, fae_cnt=0, xop=1, dbcount=0

C  IN : col_cnt=3, row_max=1756, row_xcnt=4, row_pcnt=0, row_i=47433618817028, row_total=4,

C       row_upto=4294967295, row_size=62, vda_max=96, bound=1, itp=7058d60, vda_arr=6c51bd0

C       lob_anz=0, lob_max=0, lob_pw=0,  lobarr=NULL, rows_ret=0

C  OUT: col_cnt=3, row_max=393, row_xcnt=0, row_pcnt=0, row_i=47433618817024, row_total=0,

C       row_upto=0, row_size=324, vda_max=96, bound=0, itp=NULL, vda_arr=7838560

C       lob_anz=0, lob_max=0, lob_pw=0,  lobarr=NULL, rows_ret=0

C  INSERT INTO "/1CADMC/S0000222" ("MANDT","ID","NAME") VALUES(:A0,:A1,:A2);

B  ***LOG BY4=> sql error 904    performing INS on table /1CADMC/S0000222               [dbtran       7695]

B  ***LOG BY0=> con=2(X01): ORA-00904: "NAME": invalid identifier [dbtran       7695]

The Target Table is fine.

Target DB :

SQL>  desc "/1CADMC/S0000222"

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

MANDT                                     NOT NULL VARCHAR2(9)

ID                                        NOT NULL VARCHAR2(9)

AIRPORT                                   NOT NULL VARCHAR2(75)

SQL> desc zsairport

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

MANDT                                     NOT NULL VARCHAR2(9)

ID                                        NOT NULL VARCHAR2(9)

AIRPORT                                   NOT NULL VARCHAR2(75)

Source DB:

SQL> desc sairport

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

MANDT                                     NOT NULL VARCHAR2(9)

ID                                        NOT NULL VARCHAR2(9)

NAME                                      NOT NULL VARCHAR2(75)

TIME_ZONE                                 NOT NULL VARCHAR2(18)

It look like the mapping is not working between Source System - RFC SAP ABAP -> Target System - Oracle DB