Why am I getting this error? - "Error in 'outputlookup' command: The lookup table 'Permission denied for collection 'mycollection'' is invalid."

[ksarpol]

I'm attempting to create my first kvstore collection and I get this error when I try to write to the collection.

Error in 'outputlookup' command: The lookup table 'Permission denied for collection 'mycollection'' is invalid.

Here's the search

| savedsearch mysavedsearch | outputlookup mykvstore

Any ideas what might be causing this?

[ksarpol]

I moved the collections.conf file from my private user directory to the application directory and it works now.

[dgladkikh_splun]

Could you give us more details about how you created these collection and lookup table?
It seems that something is wrong with the collection, your user does not have access to it and he cannot write into it.

[stephanefotso]

Why don't you try this? | savedsearch mysavedsearch | outputlookup mykvstore.csv, to Write to mykvstore.csv lookup file (under $SPLUNK_HOME/etc/system/lookups or $SPLUNK_HOME/etc/apps/*/lookups) ?.

[ksarpol]

I'm currently using outputcsv. I want to switch to kvstore since it supports CRUD operations and scales better whereas, outputcsv and outputlookup do not.