3236059 - Indentity Jump after Dump and Load from SAP ASE 16.0 SP04 PL02 to SAP ASE 16.0 SP03 PL09

Identity Jump while inserting a dump from from SAP ASE 16.0 SP04 PL02 to SAP ASE 16.0 SP03 PL09

Context:

• following are the events that happened with respect to identity changes.
  
  1. Initially both servers were at "16.0 SP03 PL09 ", no issues were observed while testing after identity columns were altered. 
  2. Then one of the 2 servers was patched with "16.0 SP04 PL02", no identity issues then.
  3.  Alter tables/identity column were implemented beforehand in the server which is still at "16.0 SP03 PL09" . It was in replicated environment as a REPLICATE database and did not see any issues. (still identity changes are pending in PRIMARY production server in replicated environment). 
  4. After alter identity column(s) was implemented in one of the REPLICATE server, while using those database dump in  server which is at "16.0 SP04 PL02 " cropped up this identity jump issue. 
  
  

Source: SAP Adaptive Server Enterprise/16.0 SP03 PL09/EBF 29247 SMP/P/x86_64/SLES 11.1/ase160sp03pl09x/3839/64-bit

Target:  SAP Adaptive Server Enterprise/16.0 SP04 PL02/EBF 29987 SMP/P/x86_64/SLES 12.4/ase160sp04pl02x/3545/64-bit

Identity gap; Dump and load with Identity gap; Identity, gap; , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed