How to be in this case? FreeBSD 11 costs at me right now.
If you look closely, the kagbe utility hints "no manifest found". And that means, probably there is no manifest file. There is none at all. Fully.
Conclusion? Need a manifest file. It is necessary to take it where the archive was taken. If this is not possible, try to generate (write) it yourself. To begin with, I think it is a good idea to smoke this man (namely the section "MANIFEST FILE DETAILS"), search the network for examples, construct it, and feed it to the utility pkg.
PS: Paid services for generating manifest files, I, alas, have never provided. The very knowledge of conceptual. But I can almost sure)