Home Knowledge Articles IBM Cognos 8 Planning Load data fails - The string 'Folder path' should not be blank, but it is
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 37
Yesterday: 111
Last Week: 3360
This Month: 9189
Last Month: 16191
Total: 382842


Load data fails - The string 'Folder path' should not be blank, but it is Print E-mail
(1 vote, average 5.00 out of 5)

Symptom
There is an error loading the file. PlanningErrorLog.csv shows:
Unable to Bulk Load the data.~~~~bcp.exe is used to bulk load data for SQL Server~~~~Unable to find file 'bcp.exe' on the path ';C:\Program Files\Support Tools\;c:\windows\system32;c:\windows\;c:\windows\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn'.~~~~The string 'Folder path' should not be blank, but it is.

Problem
When importing data in COntributor Admin Console, loading the import file fails.  

Cause
In the system PATH env variable, there is a few nested env variables with the "%" symbol, such as %systemroot%. Contributor Admin Console cannot evaluate the nested env variable within the %PATH% variable. 
or
The system PATH env variable is starting with the ';' character 
 
Resolving the problem
Replace the env variables nested in PATH with their values. ie. replace "%systemroot" with "C:\Windows\System32". 
or
Remove the first ';' character from the PATH variable. ie. PATH=;c:\windows\temp to PATH=c:\windows\temp

Reboot server in order to let the changes take effect.

 

Comments

Please login to post comments or replies.
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?