Cancel
Showing results for 
Search instead for 
Did you mean: 

Naming rule skipping numbers

Creator
Creator

hellor everyone

 

I have TC 11.4  and naming rule for ECN and ECR is skipping numbers.

 

I saw this problem in GTAC but I don't know how to solved 

 

https://solutions.industrysoftware.automation.siemens.com/view.php?sort=desc&pd=teamcenter&file_type...

 

help me pelase

2 REPLIES

Re: Naming rule skipping numbers

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom
I assume you are using Oracle as your DB software. As stated in the PR you need to reduce the "chunk" of numbers that Oracle pulls at one time from 20 to 1.

You start by creating the file seq_nocache.sql:
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>"

Now login to sqlplus as the TC database user and run the script.
@seq_nocache.sql

Then validate it was successful by running:
select SEQUENCE_NAME, CACHE_SIZE, LAST_NUMBER from user_sequences;
Where CACHE_SIZE should now be 0.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Naming rule skipping numbers

Creator
Creator

thank's Randy!