Monday, October 21, 2013

Creating SQL queries, escalations, and notifications for work records


  1. In the Work View application, select Advanced Search > Where Clause and copy one of the code samples to the Current Query area.
  2. Name the query and make it public.
  3. Save the record.
Sample queries
SQL WHERE clause to list Priority 1 work view records that are open and do not have log data entered in the previous sixty minutes
((((exists (select recordkey from worklog where workview.recordkey = worklog.recordkey and workview.class=worklog.class and (worklog.createdate < sysdate - 60/1440)) or not exists (select recordkey from worklog where workview.recordkey = worklog.recordkey and workview.class=worklog.class )and ((status != 'CLOSE')))) and ((status != 'RESOLVED'))) and ((status != 'COMP'))) and ((priority = 1))
SQL WHERE clause to list Priority 2 work view records that are open and do not have log data entered in the previous four hours
((((exists (select recordkey from worklog where workview.recordkey = worklog.recordkey and workview.class=worklog.class and (worklog.createdate < sysdate - 240/1440)) or not exists (select recordkey from worklog where workview.recordkey = worklog.recordkey and workview.class=worklog.class )and ((status != 'CLOSE')))) and ((status != 'RESOLVED'))) and ((status != 'COMP'))) and ((priority = 2))

How to reset user's Start Centers



First of all you have to identify the set of start centers to be reset. In this example I want to reset all the start centers of the user's belonging to MYGROUP security group. Run this select and check the results.
SELECT * FROM scconfig WHERE groupname='MYGROUP';

Now replace the star (*) character with scconfigid and you will have something like this.

SELECT scconfigid FROM scconfig WHERE groupname='MYGROUP'

Now replace [SCLIST] in the following SQL delete statements with the previous select and execute them.
DELETE FROM rsconfig WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM faconfig WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM inbxconfig WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM kpilconfig WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM kpigconfig WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM actionscfg WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));

If everything is fine you can run the last two deletes.
DELETE FROM layout WHERE layoutid IN (SELECT layoutid FROM layout WHERE scconfigid IN ([SCLIST]));
DELETE FROM scconfig WHERE scconfigid IN ([SCLIST]);

Monday, July 22, 2013

Run an .exe file from an Escalation in Maximo



An escalation may be set up in order to run an executable file at a specified interval of time.
The steps are:
1. Log in into Maximo as maxadmin user.
2. Go to -> System Configuration -> Platform Configuration -> Escalations
Create a new escalation with the following information:
Escalation: autonumber; description: any;
Applies To: ACTIONGROUP
Schedule: 1m – just for the test case, otherwise the needed interval;
Check “Create Successful Execution Entry” check box.
3. On the Escalation Points tab, click New Row;
Make sure to set
-Applies To – ACTIONGROUP
-Elapsed Time Interval to a value of -1 DAY (a negative value will indicate a time period in the future)
-Repeat check box checked.
4. On the Action tab, click New Row;
5. Action -> Go to Actions application
6. On Action application, create new Action, with the following information:
Action: autonumber ; description: ;
Object: ACTION
Type: Command Line Executable
Value: C:WINDOWSSystem32notepad.exe (or any .exe file you want to be launched)
Accessible From: ALL
This new Action will automatically be assigned to an Action Group, which is visible on the escalation tab under the Actions section (upper right corner), and it’s also present in the Actions application. It is essential in order for the executable to be run only once that the Action running the .exe file is only present once as Member in the ACTIONGROUP table.
7. Save Action;
8. “Return With Value” to Escalation application
9. Save Escalation
10. Select Action -> Validate; (should display a pop-up with “Validation successful.”)
11. Select Action -> Activate/Deactivate Escalation (should set the escalation to Active)
12. Save.
13. Log out/ Log back in.
Wait for 1 or 5 minutes, depending on time scheduled on the escalation.
The executable should be launched.

BMXAA6815E - The database connection failed running encryptproperties.bat


Problem(Abstract)

After trying to run encryptproperties.bat, the process completed with the following error message:
BMXAA6815E - The database connection failed: [xxx] Cannot open database "" 
requested by the login. The login failed.

Resolving the problem

Please, check the following information in your environment: 

1) Check to see if you are able to connect to the database using the SQL Studio Management tool using the same user and password 

2) Check to see if the procedure reported in the Technote 1314942 was run properly 
http://www-01.ibm.com/support/docview.wss?uid=swg21314942

JMS Messaging - High availability, scalability and Maximo Integration Framework using a single Service Integration Bus

T he first is configuring the JMS resources for scalability and the second is configuring the messaging engines for highly availability. For...