Knowledge Management

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

ksarpol
Explorer

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?

Tags (1)
0 Karma

ksarpol
Explorer

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

dgladkikh_splun
Splunk Employee
Splunk Employee

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.

0 Karma

stephanefotso
Motivator

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) ?.

SGF

ksarpol
Explorer

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.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...