Sort maximo start centre inbox assignments

Sorting Maximo 7.x start center inbox assignments :

I used below logic to set order by to due date (Descending) on start centre inbox assignments.

Create a custom class and extend WFAssignmentSet. Write a code in getInboxAssignment() method.

Sample Code:

package test.workflow;

import java.rmi.RemoteException;

import psdi.mbo.MboServerInterface;
import psdi.util.MXException;
import psdi.workflow.WFAssignmentSet;
import psdi.workflow.WFAssignmentSetRemote;

public class TestWFAssignmentsSet extends WFAssignmentSet implements WFAssignmentSetRemote
{
     public TestWFAssignments(MboServerInterface ms) throws RemoteException {
super(ms);
}

public void getInboxAssignments() throws RemoteException, MXException
         {
            super.getInboxAssignments();
            setOrderBy(" DUEDATE desc");
            reset();
         }
}

Error deploying maximo.ear file in Websphere

Error:

A composition unit with name MAXIMO already exists. Select a different application name.

ADMA5011I: The cleanup of the temp directory for application MAXIMO is complete
ADMA5014E: The installation of application MAXIMO failed.

Delete caches in websphere:
1. Stop the maximo server

2. Go to services.msc  : stop ctgCellManager01 and node agent

3. Delete Maximo directory -- IF FOUND IN BELOW PATH:    

• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\config\cells\ctgCell01\blas
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\config\cells\ctgCell01\cus

4. Delete maximo.ear -- IF FOUND IN BELOW PATH:

• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\config\cells\ctgCell01\applications

• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\config\cells\ctgCell01\applications

5. Delete all files in the following directories:

• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\temp
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\wstemp
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\config\temp
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\temp
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\wstemp
• <Drive>:\IBM\WebSphere\AppServer\profiles\ctgDmgr01\config\temp

6. Start services. I think automatically server will start. So stop the server again.

7. Deploy maximo.ear file. After successful deployment, save the changes into master repository.

8. Start the maximo server.

   

Restricting Synonym domain lookup values in List tab

This can be done by using Security Group data restrictions.

1) Create a condition as below:
Condition Name : TESTSTATUS
Condition expression is VALUE IN ('APPR','WAPPR','DRAFT') <Make sure there is no colon (:) in the expression and also no validation required>

2) Apply condition in Security group :
Select require security group and go to data restrictions tab.
Enter new row :
Object : SYNONYMDOMAIN
Application : <Application name>
Type : Qualified
Condition : TESTSTATUS
Reevaluate : Checked

Save the security group and signout & signin again.
Now you can able to see the only require statuses in List and Advanced Search Tab.

Note : 
1. In condition, make sure there will be no COLON ':' in condition expression. No validation require at condition.
2. By applying condition to SYNONYMDOMAIN at security group data restrictions, it will be applicable all synonymdomains for that application. Usually for any application, synonym domains values (not maxvalue) will be unique.

Increase a field value like workorder/jobplan taskid.

1. Create a seed name and seed interval in MAXVARS table.

For example : if you want as 10, 20, 30 40..etc

insert into MAXVARS (varname,varvalue,orgid,siteid,maxvarsid) values ('TESTSEED',10,NULL,'SITENAME',<MAXVARSID.NEXTVAL>);

insert into MAXVARS (varname,varvalue,orgid,siteid,maxvarsid) values ('TESTSEEDINTERVAL',10,NULL,'SITENAME',<MAXVARSID.NEXTVAL>);

For example : if you want as 5, 10, 15, 20..etc

insert into MAXVARS (varname,varvalue,orgid,siteid,maxvarsid) values ('TESTSEED',5,NULL,'SITENAME',<MAXVARSID.NEXTVAL>);

insert into MAXVARS (varname,varvalue,orgid,siteid,maxvarsid) values ('TESTSEEDINTERVAL',5,NULL,'SITENAME',<MAXVARSID.NEXTVAL>);

2. Write a mbo code to set value in 'TESTID' : <set default value of TESTID is 0>

Modify add() method of main MBO :

super.add();

int testID = this.getInt("TESTID");

int newTestID = CommonUtil.getNextTaskID(testID, "TESTSEED", "TESTSEEDINTERVAL", getOrgSiteForMaxvar("TESTSEED"));

this.setValue("TESTID",newTestID,MboConstants.NOACCESSCHECK);

Hope it will be usefull. :)

Increase MAXSEQUENCE in SQL Server

Some times developers will insert records using sql script.

Oracle database : you can get sequenceid by using NEXTVAL.

SQL Server : There is no function called NEXTVAL. Below are the steps you can follow :

SET NOCOUNT ON;

--Declare integer variable

declare @seqid int

--Update MAXSEQUENCE table by increasing MAXRESERVED value+1.

update [maxsequence] set [maxreserved] = [maxreserved]+1 where [tbname] = 'MAXATTRIBUTE' and [name] = 'MAXATTRIBUTEID'

GO

--Get MAXRESERVED from MAXSEQUENCE table and Set to integer variable (in this case @seqid)

SET @seqid = (select maxreserved from maxsequence  where [tbname] = 'MAXATTRIBUTE' and [name] = 'MAXATTRIBUTEID')

--When inserting use @seqid at your sequenceid value. Below case, MAXATTRIBUTEID value replaced with @seqid.

INSERT INTO MAXATTRIBUTE

 (MAXATTRIBUTEID,OBJECTNAME,ATTRIBUTENAME,.................) VALUES

( @seqid,<OBJECTNAME>,<ATTRIBUTENAME>,.........)

GO

For multiple inserts, add 'update step' and 'set sequenceid in variable step' before every insert :

--Update MAXSEQUENCE table by increasing MAXRESERVED value+1.

update [maxsequence] set [maxreserved] = [maxreserved]+1 where [tbname] = '<OBJECTNAME>' and [name] = '<OBJECTSEQUENCEIDNAME>'

GO

--Get MAXRESERVED from MAXSEQUENCE table and Set to integer variable (in this case @seqid)

SET @seqid = (select maxreserved from maxsequence  where [tbname] = '<OBJECTNAME>' and [name] = '<OBJECTSEQUENCEID NAME>')

INSERT INTO <OBJECTNAME>

 (OBJECTSEQID,,.................) VALUES

( @seqid,,.........)

GO

Hope it will be useful. :)

Add default value to long description field.

It is same as assigning default values to other fields.

Go to Application Designer --> Select your application --> go to require section --> drag and drop default value control from control palette --> select control properties for default value :

Attribute : Click on lookup and select attribute as DESCRIPTION_LONGDESCRIPTION for your object.

Value : <Add your default text>

Default Type : Insert <this will work while inserting new record in your application>

Save the application designer and try to insert new record in your application. Long description field will display your default text value entered in VALUE field.

Hope it will be useful :)

Maximo 7: System properties objects/tables

System properties are storing in below objects:

1. MAXPROP
2. MAXPROPVALUE
3. MAXPROPINSTANCE

1. MAXPROP: This object stores the header information of system property. "propname" is unique.
2. MAXPROPVALUE: This object stores the system property value. "propname" is unique.
3. MAXPROPINSTANCE: This object stores the information of instance properties.