How to Fix: An error occurred during creation of the local repository. (BODI-300054)

How to Fix: An error occurred during creation of the local repository. (BODI-300054)

I had encountered above error when creating local repository. The details log list as below from Repository Manager.

……

commit

BODI-320001: Reading SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\options.sql>.

BODI-320002: Executing SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\options.sql>.

BODI-300077: Verifying repository…

An error occurred during creation of the local repository. (BODI-300054)

Data Services version 14.2.6.1082 installed on Windows Server 2012, repository is built on Oracle 11g. I had ignored the error after trying few time still facing same error . I was able to assign the repository to job server as well as import objects. However later I noticed that when I right click on file format BODS Designer was terminated without any notice. While if I double click the file format the file format properties windows pops up. It’s so annoying.

I already installed the latest version of BODS, I didn’t think it’s bug or need some kind of patches. Finally I solved the problem by right clicking on the repository management console and selecting ‘Run as administrator’.

Even though you have “administrator” privileges in your Windows Server systems, you need to elevate your privilege.

Now the repository creation moved on!

…………

commit

BODI-320001: Reading SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\options.sql>.

BODI-320002: Executing SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\options.sql>.

BODI-300077: Verifying repository…

BODI-300036: Importing objects…

BODI-300133: Adding Data Quality new substitution configuration…

BODI-300038: Installing the calculate usage dependency job…

BODI-300039: Installing the load balancing job…

BODI-300002: Adding miscellaneous objects…

BODI-300004: Adding XML Template Format…

BODI-300003: Adding new system functions…

BODI-300133: Adding Data Quality new substitution configuration…

BODI-300125: Adding Data Cleanse transform…

BODI-300126: Adding Country IDs transform…

BODI-300127: Adding Global Address Cleanse transform…

BODI-300128: Adding Global Suggestion List transform…

BODI-300129: Adding Match transform…

BODI-300130: Adding Associate transform…

BODI-300131: Adding USA Regulatory Address Cleanse transform…

BODI-300132: Adding User Defined transform…

BODI-300189: Adding Global Geocoder transform…

BODI-300212: Adding Extraction transform…

BODI-300226: Adding DSF2WS transform…

BODI-300230: Installing the JIT viewdata job…

BODI-300246: Adding CTID transform…

BODI-300257: Adding DataMask transform…

The local repository was successfully created. (BODI-300055)