If when you run "Oracle EPM System - Foundation Services - EPM System Configurator" for the first time, and you can't select "Perform 1st-time configuration of Shared Service Database", you may see the following solution.
Description:
The selection is defaulted to Connect to previously configured shared service database. Server is Windows 2008R2 64bit. Hyperion installed is v.11.1.2.2 64bit. When you try to log in, the returned message says that the database you connect to isn't preconfigured with shared service.
Solution:
Try running "configtool.bat -forceRegistry". It should do the trick. The location of configtool.bat can be found by right clicking on "Oracle EPM System - Foundation Services - EPM System Configurator" from the start menu, and select properties. The location of configtool.bat is stated on the "Target" field of the properties window.
Tech Revisit
Revisiting Past Technical Issues...
Wednesday, August 1, 2012
Monday, June 25, 2012
Quickly Duplicate an Existing Table [SQL Server]
This is a tip for quickly duplicating an existing table.
While this is another tip for quickly creating a table with the same column name of an existing table.Select * Into new_table_name From existing_table_name
Notice the where condition. You could actually change it to any condition that returned false (e.g 1=0). The select statement will select nothing.Select * Into
new_table_name
From
existing_table_name
Where 1 = 2
Subscribe to:
Posts (Atom)