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.
SAP Knowledge Base Article - Preview