dcarlin11 asked a question.
During Normalize Run Error Related to "tmp_tblRecoverCmds"
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.
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.
A reinstall was done which resolved this issue.