PLM Diaries

I have received the following error while deploying ADF application as an EAR file. weblogic.management.DeploymentException: The EAR file has no META-INF/application.xml and no modules could be found in it Solution: 1. Read More

I have received the above error when deployed the ADF project in to the WebLogic server. The reason to the error is it is missing the jar file ‘adfmweb-<version>.jar‘. My Read More

select /*+ ALL_ROWS */ ITEM_P2P3_QUERY.ID,ITEM_P2P3_QUERY.CLASS,ITEM_P2P3_QUERY.SUBCLASS,ITEM_P2P3_QUERY.FLAGS,ITEM_P2P3_QUERY.REV_FLAGS,NULL,NULL,ITEM_P2P3_QUERY.ITEM_NUMBER,ITEM_P2P3_QUERY.ITEM_NUMBER,BOM.ITEM_NUMBER,BOM.COMPONENT,MANU_PARTS_P2.PART_NUMBER,BOM.ITEM_NUMBER,BOM.COMPONENT,MANUFACTURERS_P2.NAME,MANU_PARTS_P2.PART_NUMBER,ITEM_P2P3_QUERY.PRODUCT_LINES,ITEM_P2P3_QUERY.MULTILIST02,ITEM_P2P3_QUERY.CATEGORY,ITEM_P2P3_QUERY.MULTILIST01,ITEM_P2P3_QUERY.DESCRIPTION,ITEM_P2P3_QUERY.DESC_REV,ITEM_P2P3_QUERY.LATEST_FLAG,ITEM_P2P3_QUERY.MULTILIST04,ITEM_P2P3_QUERY.ITEM_NUMBER,MANUFACTURERS_P2.NAME,ITEM_P2P3_QUERY.MULTILIST03,ITEM_P2P3_QUERY.RELEASE_TYPE,ITEM_P2P3_QUERY.LIST12,ITEM_P2P3_QUERY.LIST08,ITEM_P2P3_QUERY.CREATE_USER,ITEM_P2P3_QUERY.CREATE_USER,NULL,NULL,ITEM_P2P3_QUERY.ITEM_NUMBER from ITEM_P2P3_QUERY,BOM,MANU_PARTS_P2,MANUFACTURERS_P2,MANU_BY where (( ITEM_P2P3_QUERY.RELEASE_DATE IS NOT NULL) AND ITEM_P2P3_QUERY.ITEM_NUMBER LIKE ‘%XXXXXX%’ ESCAPE ‘\’) AND ITEM_P2P3_QUERY.CLASS = 10000 AND (NVL(ITEM_P2P3_QUERY.DELETE_FLAG,0) = 0) AND ITEM_P2P3_QUERY.ID = Read More

Take 3 pin ping sensor The keyboard functions enable 32u4 or SAMD micro based boards to send keystrokes to an attached computer through their micro’s native USB port. Note: Not Read More

Connecting to your Raspberry Pi remotely with VNC is fine as long as your Pi does not reboot. If it does, then you either have to connect with SSH and Read More

private static void printList(IAgileList list, int level) throws APIException { if (list != null) { System.out.println(indent(level * 4) /*+ list.getLevelName()*/ + “:” + list.getValue() /*+ “:” + list.getId()*/); Object[] children Read More

Login into WebLogic Admin console (http://agileserver.domain.com:<port>/console) with superadmin user From the left pane (Domain Structure), goto agileDomain > Deployments On the right pane, click on AgilePLM For Core Service, scroll Read More

Incase item import messed up and needed to import new set with exact same name,   look for the item number in Item table and change the item number and Read More

SELECT ‘<<item number>>’ AS PARENT_ITEM, a.item_number, LEVEL FROM AGILE.BOM A START WITH (A.ITEM = (SELECT DISTINCT i.id FROM agile.item i, agile.bom b WHERE i.id = b.item AND i.item_number = ‘<<item Read More