BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

BODI-320009: Repositories on MySQL require InnoDB storage ..


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
its_ranjan
Forum Associate
Forum Associate



Joined: 16 Feb 2011

Posts: 647



PostPosted: Wed Oct 05, 2016 8:20 am 
Post subject: BODI-320009: Repositories on MySQL require InnoDB storage ..

Hi,

I am getting following error while creating local repository on mysql database on linux machine.

BODI-320009: Repositories on MySQL require the InnoDB storage engine. Enable InnoDB in MySQL for the repository <MySQL.localhost.root>.

Please help.
Back to top
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1110
Location: Wellington, NZ


flag
PostPosted: Wed Oct 12, 2016 5:30 pm 
Post subject: Re: BODI-320009: Repositories on MySQL require InnoDB storag

The repository database was probably created using the default MyISAM engine which isn't transaction-safe.

Have the repository database recreated using the InnoDB storage engine in MySQL and you should be good to go.
Back to top
its_ranjan
Forum Associate
Forum Associate



Joined: 16 Feb 2011

Posts: 647



PostPosted: Fri Oct 14, 2016 3:19 am 
Post subject: Re: BODI-320009: Repositories on MySQL require InnoDB storag

Hi Erik,

Thanks for response.

Looked at the my.cnf file to check for default storage engine. It is innodb already.

datadir=/usr/local/mysql-5.7.11-linux-glibc2.5-x86_64/data/
log-error=/var/log/mysql/mysqld.err
socket=/tmp/mysql.sock
port = 3306
bind-address = 10.238.7.35
default-storage_engine=innodb
innodb_buffer_pool_size=10M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Back to top
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1110
Location: Wellington, NZ


flag
PostPosted: Sun Oct 16, 2016 10:39 pm 
Post subject: Re: BODI-320009: Repositories on MySQL require InnoDB storag

That may have been your default config file, but can you verify that the repository database was actually created in the correct storage engine?

If it was, I would log a call with SAP.
Back to top
mcotrim
Forum Member
Forum Member



Joined: 28 Sep 2018

Posts: 1



PostPosted: Fri Sep 28, 2018 9:47 am 
Post subject: Re: BODI-320009: Repositories on MySQL require InnoDB storag

Hi, its_rajan.

I´m having the same situation here (trying to move a repository to MySQL).

Have you got any answer to this issue already?

Thanks!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0303 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0267)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo