Hi all,
Im trying to create a column map from VARCHAR(128) to VARCHAR(128) data type using TRANS COL. There is no problem until I try to input TRANS COL with copy parameter. From the documentation it is said that "The copy= parameter is valid only for a character data type column", so I assume this can be used to CHAR and VARCHAR data type column. The command is TRANS COL ('UNIQUE,COPY=(1,4)'), when i save the column map there is an error shown in the image bellow. Ive tried to other columns, both varchar and char, and the results are the same. If I remove the COPY or change the parameter, it works as expected, e.g. TRANS COL ('UNIQUE') or TRANS COL ('UNIQUE,SEED=RANDOM'). What do I need to fix/change in order to use TRANS COL with copy parameter?
Env: Infosphere Optim 11.7 Test Data Management & Data Privacy - Windows server 2019
Thank you for your assistance.
ERRWERRH ERR_RetryMgr (0000) ENVE 04/17/2023 01:59:44 000029 00002A64 000026D0
Exception:C0000005 (Access Violation) at 00007FF8ECDE1D20
Exception occurred on 04/17/2023 at 01:59:44
PN0DSS00 dssccmcv.c parseTransCol(09221-00071D20)
Registers at Failure:
CS=0033 DS=002B ES=002B FS=0053 GS=002B SS=002B
RIP=00007FF8ECDE1D20 RAX=0000000000000001 RBX=00007FF92ED5B520 RCX=0000000000000000
RDX=0000000000000005 RBP=0000000E771FF280 RDI=0000000E771E4C1B RSI=00007FF8ECEAC823
RSP=0000000E771E4AE0 FLG=00010246 PID=00002A64 TID=000026D0
Current Stack Len:111904 Attempt to Read at Address 000000000000000C
PN0ERR00 Unknown Unknown(?????-0000C9B7)
PN0ERR00 Unknown Unknown(?????-0000862E)
PN0DSS00 dssccmcv.c CMExprCvtToDBMS$filt$0(?????-0012A6C9)
MSVCR120 Unknown Unknown(?????-0006F146)
ntdll Unknown Unknown(?????-000A4A2A)
ntdll Unknown Unknown(?????-00004CEA)
ntdll Unknown Unknown(?????-000A3799)
PN0DSS00 dssccmcv.c parseTransCol(09221-00071D1B)
PN0DSS00 dssccmcv.c CMExprCvtToDBMSInt(05179-000923F0)
PN0DSS00 dssccmcv.c CMExprCvtToDBMS(05698-00075660)
PN0DSS00 dssccmcv.c CMCvtToDBMS(00617-0006C460)
PN0DSS00 dssccm.c DSSUpdCM(00249-000660CD)
PR0DEFS rtcm.cpp RtCM Save(07419-0029CF8E)
PR0DEFS rtcm.cpp RtCM Import(06090-00298066)
PR0IMPT imptproc.cpp ImptDialog_Process ImportCM(01747-00019D1C)
PR0IMPT imptproc.cpp ImptDialog_Process ImportDefinitions(03261-000209E1)
PR0IMPT imptproc.cpp ImptDialog_Process Import(01220-00017F68)
PR0IMPT imptdlg.cpp ImptDialog OnMenuRun(00531-00009C14)
PR0IMPT imptdlg.cpp ImptDialog OnWindowActivate(00371-0000B67D)
mfc120u Unknown Unknown(?????-00269021)
PR0CTLS rtdialog.cpp RtDialog OnWndMsg(08680-00045BC6)
mfc120u Unknown Unknown(?????-00268A63)
mfc120u Unknown Unknown(?????-0026641D)
mfc120u Unknown Unknown(?????-0026679F)
PR0IMPT dllmodul.cpp AfxWndProcDllStatic(00055-00037225)
USER32 Unknown Unknown(?????-000174D1)
USER32 Unknown Unknown(?????-00016FED)
mfc120u Unknown Unknown(?????-00250FB1)
mfc120u Unknown Unknown(?????-0026CB66)
PR0CTLS rtdialog.cpp RtDialog NativeDoModal(05807-0003FD8C)
PR0CTLS rtdialog.cpp RtDialog DoModal(03818-00039CC7)
PR0IMPT pswrimpt.cpp PswrImptThread Create(00855-0002F7E5)
parseTransCol Stack Frame Length:16
0000000E771E4AE0 000000 20B5D52E F97F0000 C4C9EAEC F87F0000 ��.�...�����...
Unknown Stack Frame Length:16
0000000E771E4AF0 000000 20B5D52E F97F0000 E5581E77 0E000000 ��.�...�X.w....
DSSCCMCV CMCvtToDBMS (0880) EXCP 04/17/2023 01:59:44 000030 00002A64 000026D0
ErrMsg: Unexpected RC Func=CMExprCvtToDBMS at Line=625)
RetCode: PST_FAILED(-00001) General logic error
ExtCode: ENVERR_EXCEPTION(01023) Operating System Exception
Token1: Access Violation
Token4: Access Violation
------------------------------
Adi Wijaya S
------------------------------