Is it common that advisor has no idea about what is going on and totally helpless?
No, it is not common. 

However, everyone in academia probably will meet someone like your supervisor along the years. Incompetence and unprofessionalism can be found in every corner of society and academia is not an exception.

If you are able, change to another supervisor as soon as possible.