indexes and stats are rebuilt /updated every Sunday. Job has been scheduled for this. This issue happened on Thursday.

this was the first time it has happened on our Production Servers.

no, nothing of that sort happened

I tried removing -c option and doing it. but still it gives me the same result that is it still fails.

Also I tried creating ms-access database and table structures manually...

I have a primary key and 1 index on that table.