Monday 18 February 2013

Oracle Table Synonym in Information Design Tool

Battling with using Synonyms in IDT upgrade to SP5 Patch 5:

Go to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle

Look for oracle.sbo and edit it with notepad

Look for : <Parameter Name="Include Synonyms">False</Parameter>

Change this true and save: <Parameter Name="Include Synonyms">True</Parameter>

Restart Services and then you are Good to go!!!

Thursday 7 February 2013

Adaptive Job Server Fails to Start disabled BO 4.0/ BOBj Release 4

Facing problems with the BO 4.0 Adaptive Job Server, here is the solution. Create a new server node and name it what ever you want. Copy the cluster and paste it on the new server node after adding your db connection. After doing this create a new job server in CMC and add all required services and enable it and start it. Good to go!!!!