Is there a limit to the length of global variable sent to Data Migrator.

April 08, 2011, 04:19 PM

With Data Migrator 7.702 (Windows 2008 64 / Apache) I ran the following bat file which calls CMRUN. (Also see ACCT.FEX and the DATAMIGRATOR LOG below.) The length of &&acct2 gets truncated at 952 characters (See the log &&acct2 ends with 1234567 not 123456789.) I tested and the cutoff is determined by length of all global variableS not just a single variable. Is there a way to overcome this restriction?

(I am actually having problems with a “javascript post” – but this seems to be the same related and this is easier to present.)

********************************
Cmruntest.bat

@ECHO OFF
set EDAHOME=e:\ibi\srv77\home
set EDACONF=e:\ibi\srv77\wfs\etc
set EDACS3=e:\ibi\srv77\wfs\etc\odin.cfg
set PATH=e:\ibi\srv77\home\bin;%PATH%
Cmrun s=UAT, u=wf7admin, p=WFocusxx, r=acCt, A=FAD_ETL, w=0, v=\"&&ACCT2=00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000123456789\"
if errorlevel 20 goto rc20
if errorlevel 16 goto rc16
if errorlevel 12 goto rc12
if errorlevel 8 goto rc8
if errorlevel 4 goto rc4
echo Request OK
goto end
:rc20
echo (20) Request timed out
goto end
:rc16
echo (16) Request failed in execution
goto end
:rc12
echo (12) Request not found
goto end
:rc8
echo (8) iWAY API Error
goto end
:rc4
echo (4) Invalid input parameter
:end
********************************

Acct.fex
-TYPE ACCT2: &&ACCT2
-TYPE LEN: &&ACCT2.LENGTH
? &&
********************************

Data Migrator Log

2011/04/08 13:16:55 (ICM18974) ------ Start of Log Record for fad_etl/acct ------
2011/04/08 13:16:55 ACCT2: 0000000000000000000000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 LEN: 957
2011/04/08 13:16:55 &&ACCT2 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000000
2011/04/08 13:16:55 00000000000000000000000000000000000000000000000000000012
2011/04/08 13:16:55 34567
2011/04/08 13:16:55 (ICM18031) Finished
2011/04/08 13:16:55 (ICM18072) Elapsed run time 0:00:00