PLM Teamcenter : Activity Tasks

 

Teamcenter repeated Activity

  

·       Update volume  path set

·       Deletion of PLM Teamcenter users at object level on TCPRODMANAGER schema and object name ASSIGNME_1773957227_113294481

·       Deletion of DBA group on infodba schema on ppom_group

·       IR#9912325 (P2) A Solution Proposal to the Incident Report Provided- ImanNextId counter is inconsistent

 

 

 

 

·       Update volume  path set

 

 

select * from PIMANVOLUME

 

 

1.         MAIN_Volume -  Unix path Name “/u01/SMRProdTC12/MAIN_Volume”

2.         Volume – Unix Path Name ““/u01/SMRProdTC12/volume”

 

UPDATE infodba.PIMANVOLUME  SET PUNIX_PATH_NAME ='/u01/SMRProdTC12/MAIN_Volume' WHERE puid='RsclYsjlaDPwJD';

 

UPDATE infodba.PIMANVOLUME  SET PUNIX_PATH_NAME ='/u01/SMRProdTC12/volume' WHERE puid='A4UhkecDaDPwJD';

commit;

 

  ·       Deletion of PLM Teamcenter users at object level on TCPRODMANAGER schema and object name ASSIGNME_1773957227_113294481

 

 Check Application user based on ESESSION_ID provided by client or application team

 

select * from TCPRODMANAGER.ASSIGNME_1773957227_113294481 where ESESSION_ID like '%cwezel%';

 

 

 

delete from TCPRODMANAGER.ASSIGNME_1773957227_113294481 where ESESSION_ID='cwezel~PSTG031.SharedSession';

 

commit;

   

·                Deletion of DBA group on infodba schema on ppom_group

 

 As per request of application team deletion and creation of DBA group

 Insert into infodba.ppom_group (PUID,PNAME,PPRIVILEGE,RPARENTU,RPARENTC,PGROUP_DATA_SOURCE,PGROUP_LAST_SYNC_DATE,VLA_12_6) values ('AvUl3RrgaDPwJD','DBA',0,'AAAAAAAAAAAAAA',-1,0,null,1);

 

 select * from infodba.ppom_group where puid='AvUl3RrgaDPwJD'

 select * from infodba.ppom_group where pname='DBA'

  Backup Name before activity : expdp-SMRPRODB22021-08-08_13-44-56.dmp

 

 Backup permanent location : /u04/MasterDB/expdp/onrequest_bkp

 

 

·                IR#9912325 (P2) A Solution Proposal to the Incident Report Provided- ImanNextId counter is inconsistent

 

Issue with the Database sequence default cache size of 20.

 

To resolve this issue on infodba schema only 

Create "seq_nocache.sql" file with following content:

 

/*Start of File*/

SET HEADING OFF;

SET ECHO OFF;

SET VERIFY OFF;

SET FEEDBACK OFF;

SET WRAP OFF;

SET LINESIZE 300;

SET SQLP "REM SQL"

 

spool update_sequences.sql

SELECT 'ALTER SEQUENCE ' || SEQUENCE_NAME || ' NOCACHE;' FROM USER_SEQUENCES;

spool off

 

@update_sequences.sql

 

SELECT 'All sequences updated.' FROM DUAL;

SET SQLP "SQL>"

/* End of File */

 

It is an SQL script which should be run from sqlplus logging in as the TC user. It will do the following:

 

Get a list of all sequences in that schema.

 

Construct the commands to alter them and write this to a temporary file called update_sequences.sql. This is created in the current working directory.

 

Update all sequences to NOCACHE.

 

To verify this has occurred you can run the following SQL:

select SEQUENCE_NAME, CACHE_SIZE, LAST_NUMBER from user_sequences;

 

The CACHE_SIZE column will have a value of 0 after the script has been run.

 

To run the script, please do the following:

Save the attached script and change into the directory containing this script.

Start sqlplus and log in as the TC user.

Run the following:

 

 

@seq_nocache.sql

 

Please perform above steps in Test Environment first.