SAP Knowledge Base Article - Preview

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


When trying to upgrade to new Data Services repository from version is 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'' 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'' 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'' WHERE NAME =                                                                        
N'Repository Version'>.>. (BODI-20004)                                                                                              
The local repository upgrade was cancelled. (BODI-300056)           





SAP Data Services XI 3.2


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.