Problem Note 46468: "ERROR: Library LIBREF is not assigned" might occur in SAS® Forecast Analyst Workbench ETL job logs in non-English environments
SAS Forecast Analyst Workbench might fail to assign DBMS libraries that are registered in metadata with the Pre-assigned attribute. This problem occurs only when you are running ETL jobs in non-English environments. The current workaround is to allocate these libraries manually with LIBNAME statements in the autoexec.sas file.
Modify the default SASCONFIG/LevN/AppData/SASForecastAnalystWorkbench/autoexec.sas file as shown in the following example:
%macro init;
%global DDCFRoot;
%if &SYSSCP eq WIN %then %do; /* Windows Operating System */
%let DDCFRoot=!sasroot\ddcfsrv\sasmisc;
%let macpath=!sasroot\ddcfsrv\cmacros;
%end;
%else %do; /* UNIX Operating System */
%let DDCFRoot=!sasroot/misc/ddcfsrv;
%let macpath=!sasroot/cmacros/ddcfsrv;
%end;
libname ddfmacr "&macpath";
options mstored sasmstore=ddfmacr ;
%ddcf_load_global_parameters;
/* modifications begin here */
%if %sysfunc(exist(config.Global_parameter_list)) %then %do;
%if &GL_FRAMEWORK_DB_IND. eq &GL_SHORT_YES. %then %do;
%ddcf_get_framework_server_dtls;
LIBNAME uiart SASTS SERVER="&GL_TRANS_DB_SERVER." port=&GL_DB_PORT.
protocol=&GL_DB_PROTOCOL. user=&GL_DB_USER.
password=&GL_DB_PASSWORD. dsn=&GL_TRANS_DATABASE_NM.
INSERTBUFF=&GL_MYSQL_INSERTBUFF. DBINDEX=YES;
%end;
%else %do;
libname uiart MYSQL INSERTBUFF=&GL_MYSQL_INSERTBUFF. DBINDEX=YES
bulkload = yes MYSQL_PORT=3306 DBCONINIT = &GL_MYSQL_DBCONINIT.
DATABASE=&GL_TRANS_DATABASE_NM. SERVER="&GL_TRANS_DB_SERVER."
authdomain = &GL_MYSQL_AUTH_DOMAIN. ;
%end;
%end;
/* modifications end here */
%mend;
%init
%put &sysscp.;
Note that the character set options are passed during LIBNAME statement connection via the DBCONINIT option with the GL_MYSQL_DBCONINIT global parameter. The value for this parameter differs for each language. Please refer to page 37 of the SAS® Forecast Analyst Workbench 5.1: System Administration Guide for a full description of this parameter.
Operating System and Release Information
| SAS System | SAS Forecast Analyst Workbench | Microsoft® Windows® for x64 | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 for x64 | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2008 | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows Server 2008 for x64 | 5.1 | | 9.3 TS1M1 | |
| Microsoft Windows XP Professional | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Enterprise 32 bit | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Enterprise x64 | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Home Premium 32 bit | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Home Premium x64 | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Professional 32 bit | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Professional x64 | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Ultimate 32 bit | 5.1 | | 9.3 TS1M1 | |
| Windows 7 Ultimate x64 | 5.1 | | 9.3 TS1M1 | |
| Windows Vista | 5.1 | | 9.3 TS1M1 | |
| Windows Vista for x64 | 5.1 | | 9.3 TS1M1 | |
| 64-bit Enabled AIX | 5.1 | | 9.3 TS1M1 | |
| 64-bit Enabled HP-UX | 5.1 | | 9.3 TS1M1 | |
| 64-bit Enabled Solaris | 5.1 | | 9.3 TS1M1 | |
| HP-UX IPF | 5.1 | | 9.3 TS1M1 | |
| Linux for x64 | 5.1 | | 9.3 TS1M1 | |
| Solaris for x64 | 5.1 | | 9.3 TS1M1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-08-07 16:00:33 |
| Date Created: | 2012-05-02 09:19:04 |