2 Replies Latest reply: Aug 21, 2013 5:04 PM by Matt J RSS

    What is the maximum value of spec number ?

    Terry Huang

      Hi ,

      What is the maximum value of spec number? when I set number by "UPDATE SpecNumManager SET StartingBlockNumber = 99999999“

      I create some specs, I meet error that show below when I try to save them. is it a bug? my version is v6111, Thanks

       

      Thanks

      Terry

       

      Error executing sql command 'insert into specSummary ( pkid , ActiveSigDocGroupSequence, AmberSLA, CreatedDate, EffectiveDate, fkAffiliate, fkCountry, fkGlobalSuccessionSpec, fkOriginatingTemplate, fkPermissionTemplate, fkProcessTemplate, fkSpecBusinessUnit, fkTaxonomyNode, SpecStatusID, GlobalSuccessionState, InactiveDate, IsHidden, IssueNum, IsTemplate, langCreatedIn, LastEdit, OriginatorID, OriginatorNameHistorical, OrigLangID, RedSLA, securityAccessLevel, SpecID, SpecNum, SpecNumber, SpecType, Supercedes, theOriginator, WorkflowStartDate ) values ( '20205484dea2-2ca6-41eb-9806-cce52513e7d4', '0', '0', '08/19/2013 10:01:27', '08/19/2013 10:01:27', NULL, NULL, NULL, NULL, '6000d0acb239-b9c6-478a-8c99-4ec741d2a1a5', '57566dc3c46b-b2fe-4276-ae7f-f7f1c28a913f', NULL, '2141e3469193-4a05-4953-9ef4-8bc08c1b1fb8', '2090111c6416-6de4-4707-b498-48a18671ca27', '-1234567890', '12/31/9999 00:00:00', '0', N'001', '0', '0', '08/19/2013 10:01:45', '0', N'Admin, Prodika', '0', '0', '0', '2147d635d721-2ca2-411c-beed-d1584f7498ff', N'100000002', '100000002-001', '2147', NULL, '20533b94710f-5396-4487-bdd5-08d21365eefa', '08/19/2013 10:01:45' )'