During Normalize Run Error Related to "tmp_tblRecoverCmds"

[dcarlin11]

Cannot find the object "tmp_tblRecoverCmds" because it does not exist or you do not have permissions. @l_subscription_id2971 Create NC_UNSUB_MAP table(PUBLISH_SUBSCRIPTION_TABLES) DROP TABLE NC_UNSUB_MAP SELECT * INTO NC_UNSUB_MAP FROM BDNA.dbo.NC_UNSUB_MAP_VW CREATE INDEX NC_UNSUB_MAP_IDX ON NC_UNSUB_MAP(TABLE_NAME,SUB_ID) @p_inv_id:-1 @p_subscription_id:2971

Above is the error being seen and is keeping data from being imported/normalized. Anyone seen this before? Occurred after applying patches.

[blalvani]

HI Devan,

A good check would be to see if "tmp_tblRecoverCmds" actually exists in your database.

select * from tmp_tblRecoverCmds

tmp_tblRecoverCmds is a temp table that stores the SQL statement for some backend operations.

This is not a common error and it would be best to investigate it via a case.

Hope this helps.

[blalvani]

A reinstall was done which resolved this issue.