2642
Points
Questions
19
Answers
200
-
Hi Raju,
I see a similar question asked by you on BOM Nth level data which few of the folks responded in the below thread
https://myagileplm.com/questions/query-to-fetch-bom-upto-nth-level/Can you let us know the exact issue you are facing while using the existing query with the new conditions you shared. Your requirement seems specific to particular list values of items across level. So along with items you can join the P2 value and define your where-used condition. Should be simple to achieve. Let us know if you try and get stuck.
Regards,
Arif- 1413 views
- 1 answers
- 0 votes
-
Hi James,
Can you share the error getting printed in the History tab of the associated ATO of the change and what does the Status of ATO reads e.g. Release Or Complete. It can be attribute to many reason starting from poor node performances to space issue.
The primary level of troubleshoot that you can try out
1. Test Destination, disable and Enable.
2. Disable and Enable Subscribers.
3. Bouncing the Node where you have configured ACS destination in a clustered environment.Regards,
Arif- 1313 views
- 4 answers
- 0 votes
-
- 1424 views
- 1 answers
- 0 votes
-
SELECT
–a.item,
LEVEL,
NVL(N1.DESCRIPTION,”) AS “Part Type / Document Type”,
I1.ITEM_NUMBER,
I1.DESCRIPTION AS “Part Description”,
NVL (N2.DESCRIPTION, ‘Preliminary’) AS “Lifecycle Phase”,
I2.ITEM_NUMBER AS “Part Number / Item Number”,
A.QUANTITY AS “QTY”,
NVL (N3.DESCRIPTION, ‘Preliminary’) AS “Lifecycle Phase1”,
I2.DESCRIPTION AS “Part Description1”
FROM AGILE.BOM A,AGILE.ITEM I1,AGILE.NODETABLE N1,AGILE.NODETABLE N2,AGILE.REV R,AGILE.ITEM I2,AGILE.NODETABLE N3,AGILE.REV R1
WHERE A.ITEM=I1.ID(+)
AND I1.SUBCLASS=N1.ID(+)
AND I1.ID = R.ITEM(+) AND I1.DEFAULT_CHANGE = R.CHANGE(+)
AND R.RELEASE_TYPE = N2.ID(+)
AND A.COMPONENT=I2.ID(+)
AND I2.ID = R1.ITEM(+) AND I2.DEFAULT_CHANGE = R1.CHANGE(+)
AND R1.RELEASE_TYPE = N3.ID(+)
START WITH (A.COMPONENT = (SELECT DISTINCT B.COMPONENT
FROM agile.item i, agile.bom b
WHERE i.item_number = b.item_number AND i.item_number = ‘Your Input Part Numbr’)
AND NVL (A.change_out, 0) = 0
AND (SUBSTR (A.flags, 5, 1) = 1)
AND A.id NOT IN (SELECT C.prior_bom
FROM AGILE.bom C
WHERE C.item = A.item))
CONNECT BY PRIOR A.ITEM=A.COMPONENT
AND NVL (A.change_out, 0) = 0
AND (SUBSTR (A.flags, 5, 1) = 1)
AND A.id NOT IN (SELECT B.prior_bom
FROM AGILE.bom B
WHERE B.item = A.item)
ORDER BY LEVELThis answer accepted by raju1. on July 16, 2019 Earned 15 points.
- 1985 views
- 2 answers
- 0 votes
-
- 1585 views
- 3 answers
- 0 votes
-
As i see you are using 9.3.5. In case you have SSO enabled, Can you check what is the value of agile.sso.expirationTime is set in agile.properties file. By default it is set to 120, if that’ s the case then you can try to set it to a higher value once say 120
Go for a clean restart i.e. shutting down admin and other nodes. Deleting server cache folders and bring up the Admin and nodes thereafter.
- 4518 views
- 7 answers
- 0 votes
-
Hi Mayur,
That can be due to multiple reasons. Can you ensure this two things to start with:
1. Check if your file manager server is up and running. Generally your file-server is “http://ServerName:8080/Filemgr/Configuration Check if this page loads properly or not. If not then try re-starting it once.
2. If 1 is alright then Check if there is enough space on server.Regards,
Arif- 4518 views
- 7 answers
- 0 votes
-
- 4518 views
- 7 answers
- 0 votes
-
Hi Steven,
You can look up to this thread –> https://myagileplm.com/questions/reg-agile-automation/
I have shared step by step details of bulk attachment upload using File-Load utility.Regards,
Arif- 2501 views
- 7 answers
- 0 votes
-
Hi Mayur,
Are you trying to get the lifecycle phase of BOM-Items ? You can elaborate the question.
If your requirement is to get Lifecycle phase you can use the below code.
You can use the below code for reference.
IItem item = (IItem) m_session.getObject(IItem.OBJECT_TYPE, “711-021263”);
String lifecycle = item.getValue(ItemConstants.ATT_TITLE_BLOCK_LIFECYCLE_PHASE).toString();
System.out.println(lifecycle);ITable bomTable = item.getTable(ItemConstants.TABLE_BOM);
Iterator<?> myIter = bomTable.iterator();
while (myIter.hasNext()) {
IRow m_row = (IRow) myIter.next();
String life = m_row.getCell(ItemConstants.ATT_BOM_ITEM_LIFECYCLE_PHASE).toString();
System.out.println(
“Lifecycle of bom ” + m_row.getValue(ItemConstants.ATT_BOM_ITEM_NUMBER) + ” is ” + life);}
Regards,
Arif- 1656 views
- 2 answers
- 0 votes