Replace_sub_String length issue

dataservices job design
1

Hi All

I have transported a job from v4.0 BODS to v4.2 using ATL file, but when executing the job we get the below error…

(14.2) 10-26-15 11:17:50 (W) (25332:19964) VAL-030299: |DATAFLOW DF_DETAILED_ERROR_REPORT|STATEMENT <GUID::‘c4104939-e088-4713-8333-e77e015eec11’ QUERY “Q_FormatFlags-Join12”>
Warning: The data returned by the <replace_substr> function could be truncated because return size is reduced from <160894> to
<8192>. If data truncation occurs, adjust the Replace_Substr_Max_Return_Size_Characters parameter in the DSConfig.txt file.

I have updated the DSConfig, but just wanted to check whether anyone come across this before…

amuh10 :uk: (BOB member since 2012-04-11)

2

I worked around this warning today in DS 14.2.8.1354, without modifying the DSConfig.txt file.

What I had was code like this:

replace_substr_ext($LV_Some_Varchar, '*', word_ext($LV_Another_Varchar, 3, '_'), 1, 1);

The problem seemed to be with the word_ext() function. The variable $LV_Another_Varchar was populated higher up in the code using another instance of word_ext from a very large variable (32K). The workaround was this:

$LV_temp = word_ext($LV_Another_Varchar, 3, '_');
replace_substr_ext($LV_Some_Varchar, '*', $LV_temp, 1, 1);

eganjp :us: (BOB member since 2007-09-12)