Create pull - The Export which you are trying to create is not of type sandbox but it has LookupCache reference with _id: XXX which is of type sandbox

Integrator.io
1

When attempting to "Create pull" from Production to pull in my Sandbox flow, it Fails due to an error:
The Export which you are trying to create is not of type sandbox but it has LookupCache reference with _id: {idno} which is of type sandbox.
So, it appears that the Lookup Cache from Sandbox is not published to Production, nor can you use a Production Lookup Cache in Sandbox. Has anyone discovered a way around this? (Short of creating an actual table in a database and looking up there instead.) Thank you.

2

I'm not sure if you're on EU or NA, but lookup caches are currently only supported in the EU region. The NA deployment is happening now and should be done sometime tomorrow. You can review the release notes here: https://docs.celigo.com/hc/en-us/articles/36183789042715-Celigo-platform-2025-5-1-release-notes#integration-lifecycle-management-ilm-now-supports-lookup-caches-4

3

Thank you. Apparently I just needed a little bit of patience. Sorry, I apparently just wanted to promote the ongoing upgrade!

4

Spoke too soon, while the Integration was successfully copied over (hooray!), the run still fails with The lookup cache could not be evaluated. Check the value in the key '1', and try again. I see that the caches copied over, but not the data (despite "include data when lookup cache is cloned or donwloaded" being checked). I can repopulate in Production, but am concerned if/when changes are made to the cache in the future.

5

Hi Sean,

You’re absolutely right in observing that Lookup Caches are environment-specific, and we don’t support transferring data as part of ILM revisions. The metadata can move between environments, but the data itself doesn’t publish or sync to avoid accidental overwrites & references, especially across environments.

At the moment, the recommended approach would be to repopulate the necessary data in the target environment. This is to ensure clear separation of data between sandbox and production environments.