Problem Note 43800: Error loading base facts, driver rates, and exchange rates
The
TYPE=myISAM option is specified in SAS macros in the <sesfms.sas>,
<cycdrate.sas>, and <cycxrate.sas> programs in the
<installdrive>:\Program Files\SAS\SASFoundation\9.2\finance\sasmacro
directory on the SAS application tier. The use of the TYPE= option is no longer valid in MySQL 5.1 or later, which corresponds with SAS Financial Management release 5.1 and later.
For example, the TYPE= option in the code below (SESFMS_UPLOADSTATUSTABLETOSDM
macro):
proc sql noprint;
connect to &sesetl_EngineType ( &sesetl_BestLogin &sesetl_ConnectionOptions
);
execute(CREATE TABLE &cTrgTable (
TIME_ID INT(11),
ANALYSIS_ID INT(11),
PERIOD_ID INT(11),
STATUS_ID INT(11),
IMPORTED_TRANS_CNT INT(11),
ZERO_TRANS_CNT INT(11),
INVALID_ERROR_CNT INT(11),
ORG_EQ_TRADER_CNT INT(11),
IC_ERROR_CNT INT(11),
NON_IC_ERROR_CNT INT(11),
REMOVE_CNT INT(11)
)TYPE=myISAM
) by &sesetl_EngineType ;
disconnect from &sesetl_EngineType ;
quit;
produces the following error in the SAS log:
ERROR: Execute error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near
'TYPE=myISAM' at line 1
To correct this problem back up the existing <sesfms.sas>,
<cycdrate.sas>, and <cycxrate.sas> programs in the
<installdrive>:\Program Files\SAS\SASFoundation\9.2\finance\sasmacro
directory on the data tier. Then extract the SAS programs (sesfms.sas,
cycxrate.sas, and cycdrate.sas) from the zip file in the 'Downloads' tab, above, to the
<installdrive>:\Program
Files\SAS\SASFoundation\9.2\finance\sasmacro directory.
