Skip to Content
0
Former Member
Jan 25, 2016 at 01:06 PM

Max size tables Advanced DSO

2267 Views

Hi, By creating an Advanced DSO we got error message AD846 meaning the underlying database tables are too long. The specific purpose of this ADSO is to store the data derived from an WebService DataSource with a lot of CHAR 250 fields with which the max. length of 4096 is exceeded (approx. 36.000 characters). We noticed SAP Note 1512035 to increase the max. view / table length via include RADTBCON. However: the SAP Note also notices “Modify the include RADTBCON and set the value for VIEWLEN to the upper limit for your database system” (in our case: SAP HANA). We also noticed SAP Note 1837308. Our questions: 1. What is the max. size for tables / views in our situation: BW 7.4 SP12 on BW HANA? 2. Which of the parameters in include RADTBCON has to be changed in this situation (tablen, viewlen, others)? 3. Are there any adverse effects to take into account when we increase the max. table length? THNX in advance, Henk.