topic Add a non modeled Numbering Sequence in MS SQL in Windchill

topic Add a non modeled Numbering Sequence in MS SQL in Windchill https://community.ptc.com/t5/Windchill/Add-a-non-modeled-Numbering-Sequence-in-MS-SQL/m-p/18224#M2073 <HTML><HEAD></HEAD><BODY>I am configuring a numbering sequence to begin at 10000000 and increment by 1 in SQL. So far I followed the clear steps in the Windchill Customization Guide with no success. If anyone has configured this customization successfully please share. Here's what I have done. I created the sql file create_DMT_sequence.sql with the following content in the Windchill\db\sqlServer CREATE TABLE wt_sequence_DMT (dummy CHAR(1), value BIGINT IDENTITY(10000000,1)) go CREATE PROCEDURE wt_get_next_sequence_DMT AS INSERT wt_sequence_DMT (dummy) VALUES ('x') RETURN SCOPE_IDENTITY() go And ran the command: e:\ptc\Windchill_9.1\Windchill\db\sqlServer>\ptc\Windchill_9.1\Windchill\db\exec ute_sql_script.bat create_DMT_sequence.sql e:\ptc\Windchill_9.1\Windchill\db\sqlServer>echo off Connected: datastore=Microsoft SQL Server(Microsoft SQL Server Yukon - 9.00.1399 ) jdbcVersion=♥. driver=SQLServer(3.70.0 (029604.012900.017403)) driverVersion= ♥.F create_DMT_sequence.sql.. Warnings: 0 Errors: 0 DONE I added the sequence name"DMT" in the OIR. Created a new part in Pro-E, the file name prt0001 was inserted, which tells me it is not working.</BODY></HTML> Wed, 02 May 2018 16:47:52 GMT rserhan 2018-05-02T16:47:52Z Add a non modeled Numbering Sequence in MS SQL https://community.ptc.com/t5/Windchill/Add-a-non-modeled-Numbering-Sequence-in-MS-SQL/m-p/18224#M2073 I am configuring a numbering sequence to begin at 10000000 and increment by 1 in SQL. So far I followed the clear steps in the Windchill Customization Guide with no success. If anyone has configured this customization successfully please share.Here's what I have done.I created Wed, 02 May 2018 16:47:52 GMT https://community.ptc.com/t5/Windchill/Add-a-non-modeled-Numbering-Sequence-in-MS-SQL/m-p/18224#M2073 rserhan 2018-05-02T16:47:52Z