SELECT i.item_number As “Parent Item”,a.item_number As “Component”,LEVELFROM AGILE.BOM A,agile.item iwhere a.item=i.id and level=1START WITH (A.ITEM In (SELECT DISTINCT i.idFROM agile.item i, agile.bom bWHERE i.id = b.item AND i.item_number in (‘500040-505’))AND Read More
Setting Up File Server
The File Manager URL in the server.conf file should match the one specified in Java client under the Admin tab > Server settings > Locations > File Manager In Agile Read More
~/.bash_profile before installing Agil
.bash_profile Get the aliases and functions if [ -f ~/.bashrc ]; then. ~/.bashrcfi User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=01scqaagl05.XXXXXX.natus.com export ORACLE_BASE=/app/oracle Read More
Changing SYS password in Oracle 12cR2 and 18c
starting from Oracle 12cR2 you need to configure password file to change SYS account password. as you know when accessing the database as software owner (OS authentication), no need for password to Read More
Query to get attachments from item
SELECT AGILE.ITEM.ITEM_NUMBER, AGILE.REV.REV_NUMBER, AGILE.FILES.FILENAME, AGILE.FILES.CONTENT_URL, AGILE.REV.LATEST_FLAG FROM AGILE.ATTACHMENT_MAP INNER JOIN AGILE.VERSION_FILE_MAP ON AGILE.ATTACHMENT_MAP.LATEST_VSN = AGILE.VERSION_FILE_MAP.VERSION_ID INNER JOIN AGILE.FILES ON AGILE.VERSION_FILE_MAP.FILE_ID = AGILE.FILES.ID INNER JOIN AGILE.ITEM ON AGILE.ATTACHMENT_MAP.PARENT_CLASS = AGILE.ITEM.CLASS AND Read More
Run all the sql files in a folder
for f in *.sql; do echo “processing $f file..”;echo exit | sqlplus agile/tartan @$f; done
Agile PLM forcing GC at a specific time
Create a cron job 0 5 * * * /path/filename.sh which can run the following script source ~/.bash_profile processId=$(ps -ef | grep ‘agileDomain’ | grep -v ‘grep’ | awk ‘{ Read More
When you get error : Unable to save. You have one error, when you try to view or search
When you get error : Unable to save. You have one error, when you try to view or search check the nodetable of that class select * from nodetable where Read More
Agile personal searches messes up
In agile plm if the user’s persoanl searches messes up, run the below query and check is the exact user ids are facings problemsselect * from query where type=0 and Read More
weblogic.management.DeploymentException
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