Default Substitution Parameter settings - Wrong Path

[Former Member]

Hi all,

I have done fresh installation with BODS4.2 SP1 on my windows machine.

When I check Default Substitution Parameter, It is showing wrong path as shown below:

C:/Program Files (x86)/SAP BusinessObjects/Data Services//admin/repo//DataQuality/reference_data

What is the reason?

[former_member187605 · Accepted solution]

These are just default values. Nothing prevents you from entering the correct ones, does it?

[Former Member · Accepted solution]

Hi Mr. Venken,

of course you are right, that one can change these parameters, but when I do a default installation I'd expect those parameter paths at least to be correct. This is not the case so even if you install everything by default, you have to change these parameters.

In case someone didn't notice the error in the path, it is written "...Data Services//admin/repo//DataQuality/reference_data" correct path would be

"Data Services/admin/repo/DataQuality/reference_data"

[former_member187605 · Accepted solution]

Actually, correct path would be Data Services\admin\repo\DataQuality\reference_data on Windows. But all that really doesn't matter. DS is smart enough to do the necessary translations. Following 3 commands give exactly the same, correct, results:

print(exec('cmd', 'dir "C:/Program Files (x86)/SAP BusinessObjects/Data Services/DataQuality/reference_data"', 8));

print(exec('cmd', 'dir "C:/Program Files (x86)/SAP BusinessObjects/Data Services//DataQuality/reference_data"', 8));

print(exec('cmd', 'dir "C:\Program Files (x86)\\SAP BusinessObjects\\Data Services\\DataQuality\\reference_data"', 8));

[former_member106536]

We found that DS truncates UNC paths defined as substitution variables in a seemingly random way.

Some UNC paths work, some do not.  My admin checked the SAN file requests, and he said they were clearly getting chopped off but it was not due to any sort of length restriction.  (longer paths would actually work)