Sorry to bring up an old thread but I was wondering what the SQL query of the states or state lineages table you ran against the GDB was to generate the WIL_sde_states.txt parse file? Thanks!
We use Oracle user-schema geodatabases, so you have to define the schema geodatabase of interest. My SQL file I use contains the following:
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 240
SET PAGESIZE 1500
SET TRIMSPOOL ON
COLUMN state FORMAT a10 HEADING 'STATE'
COLUMN parent FORMAT a10 HEADING 'PARENT'
COLUMN version FORMAT a50 HEADING 'VERSION'
COLUMN lineage FORMAT a10 HEADING 'LINEAGE'
DEFINE SDE = (name of user-schema geodatabase)
SELECT TO_CHAR(st.state_id) AS state
,TO_CHAR(st.parent_state_id) AS parent
,vr.name AS version
,TO_CHAR(st.lineage_name) AS lineage
from &SDE..states st
LEFT JOIN &SDE..versions vr
ON st.state_id = vr.state_id
ORDER BY st.state_id;