cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.

(2) Replies

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.