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
Add Log administration
Enabling SQL Trace for versions 9.3 and later can be done without restarting the application server: 1. Log into Web Client as the user with administrator role, go to Administration>Logging Configuration Read More
You have exceeded the number of allowable login attempts
SELECT VALUE FROM PROPERTYTABLE WHERE PARENTID = 2545 AND PROPERTYID = 260; SELECT ATTEMPTS FROM USER_POLICY WHERE USER_ID IN (SELECT ID FROM AGILEUSER WHERE LOGINID=’administrator’); update USER_POLICY set Attempts=0 WHERE 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