Using Razor SQL either remove the row for any corrupted correction, or completely 'reset' the overrides database by following: 1801682 - How to reset the "LCM Overrides database" in BI 4. I thought I would do: select from db1.table1 as table1 inner join db2.table2 as table2 on lumn Any help would be great. Using Razor SQL inspect the LCMOVERRIDES table for any corruption. 1 Can someone please tell me how I can connect two databases at once I need to get two sets of data for a conversion we are doing. Start the LifeCycle Management Services on the BI Platform (being sure you have completely quit Razor SQL, since only 1 process can access this overrides database at any one time) Visually create, edit, alter, drop, and view objects as well as import and. Then view the contents for any corruption. RazorSQL - SQL editor, database query tool, database browser, and db admin tool.Database Location: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\LCM\LCMOverride (or whereever your database is located as per step 1 above).Driver Location C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\derby.jar.Enter a profile name: My overrides database.Connection type: leave as JDBC (Derby embedded).Stop the LifeCycle Management Services on the BI Platform (since only 1 process can access this overrides database at any one time).The location of the overrides database can be identified within the Central Management Console-Applications-Promotion Management-Properties-LCM Override Settings:. ![]() ![]() Download the Razor SQL tool onto a machine that has access to the overrides database.Based on your project reference, you are using version 4.2.0 of .CosmosDB. Razor SQL tool to read the 'local derby database' (applicable prior to BI4.1 SP3)Įasily see all the overrides held in the system and validate they are present and correct Angelo Peca Thanks for posting your question in Microsoft Q
0 Comments
Leave a Reply. |