Export Asset Package does not include all sequences

CarlVon_Stetten1

The export asset package tool appears to examine the attribute rules of all the feature classes that are being exported and automatically includes any sequences that are explicitly named in attribute rules.

However, we have hundreds of sequences tied to map book grids so that new sewer structures are named using unique numbers per map grid.  The attribute rule dynamically calculates the sequence name based on the map grid polygon the structure is placed in, so the individual map grid number sequences are never explicitly named.

How can we get the export asset package tool to include those sequences?

MikeMillerGIS

NextSequenceValue should require a string literal, so you need to make a switch yard that list out every call to NextSequenceValue using a string and not a variable.  Once you do this, the export AP and copy/paste and other functions will properly copy/export sequences.

 

Databases have hundreds of sequences by default, we do not want to blindly copy all of them.  So we rely on the requirement that NextSequenceValue uses a string literal.