Symptom
When trying to upgrade to new Data Services repository 12.2.2.0 from version is 12.2.0.0000 using the Repository Manager, getting the following error when you hit the UPGRADE button:
Upgrading local ODBC repository to 12.2.2. (BODI-300070)
Reading SQL file <C:\Business Objects\BusinessObjects Data
Services\admin\repo\MySql\mysql_upgrade1222.sql>. (BODI-20001)
Executing SQL file <C:\Business Objects\BusinessObjects Data
Services\admin\repo\MySql\mysql_upgrade1222.sql>. (BODI-20002)
Error or warning in executing the SQL statement <ALTER TABLE AL_COLMAP
ADD COLUMN SRC_COL_USAGE NCHAR VARCHAR(64) NULL
UPDATE AL_VERSION SET VERSION = N'12.2.2.0000' WHERE NAME =
N'Repository Version'>. The message from the underlying database is:
<SQL submitted to ODBC data source <DataServices> resulted in error <
[MySQL][ODBC 3.51 Driver][mysqld-5.0.34-enterprise-nt]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 'UPDATE AL_VERSION SET
VERSION = N'12.2.2.0000' WHERE NAME = N'Repository Version' at line 3>.
The SQL submitted is <ALTER TABLE AL_COLMAP ADD COLUMN SRC_COL_USAGE
NCHAR VARCHAR(64) NULL
UPDATE AL_VERSION SET VERSION = N'12.2.2.0000' WHERE NAME =
N'Repository Version'>.>. (BODI-20004)
The local repository upgrade was cancelled. (BODI-300056)
Read more...
Environment
MYSQL
Product
Keywords
DS, Repo, DSXI , KBA , EIM-DS , Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.