![]() 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. RazorSQL provides a MySQL PHP bridge so that Host Name or Server, Your databases host name. Using Razor SQL inspect the LCMOVERRIDES table for any corruption. In the Connection Name text box, type a name for the connection. 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) Then view the contents for any corruption.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:.When you have the Connection Type created, fill out the remaining information for the remote MySQL server. When the driver has downloaded, click OK. Download the Razor SQL tool onto a machine that has access to the overrides database. Select JDBC (MySQL Connector), click Auto Download Driver, and then when prompted click Continue.2 comments davidpharrington closed this as completed on Sign up for free to join this conversation on GitHub.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 db.query does not execute for remote database but does for local database 225 Closed davidpharrington opened this issue on Identify problematic overrides held in the Overrides database (which is a file based 'derby' database) and remove the corrupt override or reset the overrides database removing all the overrides. Corruption in the 'Promotion Management Overrides' database causing overrides not to be applied.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |