Converting seconds to Minutes/Hours/Days

Converting seconds to Minutes/Hours/Days

Days HH:MM:SS

CAST(FLOOR(“TimeInSeconds_Column” / 86400 ) AS VARCHAR(4)) || ‘Days ‘ || CAST(FLOOR(MOD(“TimeInSeconds_Column” , 86400 ) / 3600) AS VARCHAR(4)) ||’:’|| CAST(FLOOR(MOD(“TimeInSeconds_Column” , 3600 ) / 60) AS VARCHAR(4)) ||’:’|| CAST(MOD(“TimeInSeconds_Column” , 60) AS VARCHAR(4))

HH:MM:SS

CAST(FLOOR(MOD(“TimeInSeconds_Column” , 86400 ) / 3600) AS VARCHAR(4)) ||’:’|| CAST(FLOOR(MOD(“TimeInSeconds_Column” , 3600 ) / 60) AS VARCHAR(4)) ||’:’|| CAST(MOD(“TimeInSeconds_Column” , 60) AS VARCHAR(4))

Delete SMTP settings in OBIEE11g Enterprise Manager

To delete SMTP settings in OBIEE11g Enterprise Manager

17APR

When we configured the deliver email for OBIEE 11g using the following steps:

1. Login to Set up email in Enterprise Manager >Deployment > Email
2. Type in user name and password

After this we tried to remove these settings to configure other user account instead of old one.

1. So login to Enterprise Manager >Deployment > Email  and Remove user name and password.
2.  Click apply and re-start the server.

But the user name and password you removed are re-appear in EM. This is really an annoying issue for customer or developer to customize to required deliver service account.

May be Oracle will fix this in next release. For time being I have a workaround as follows.

1. Log in to Enterprise Manager, navigate to the WebLogic Domain -> bifoundation_domain using the left-hand navigation panel.
2. Right click bifoundation_domain and Choose ‘Security’ -> ‘Credentials’ from the menu.
3. Open the ‘oracle.bi.enterprise’ map, and select the ‘mail.server’ key.

     4. Choose ‘Delete…’

      5. Re-start the system.

Now you are able to see empty fields for the same configurations and can setup with new account.