SAP Knowledge Base Article - Preview

1464215 - Getting BODI-300070 error when Upgrading Repository from 12.2.0.0 to 12.2.2.0 - Data Services

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

SAP Data Services XI 3.2

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.