BookmarkSubscribeRSS Feed
Albert0
Quartz | Level 8

Hi All,

 

I experience the error below when trying to migrate my Data Query from development to production :

 

received_1912573395429395.jpeg

 

Do anyone know what cause the error and how to fix it? It is working properly in the development.

 

Thanks.

Albert0

 

2 REPLIES 2
JuanS_OCS
Amethyst | Level 16

Hello @Albert0,

 

good question. Have you done partial promotion (export/import) of this query from development to production? Did you had errors or warnings during the export, in the log? Did you exported with all the dependencies with a user with full permissions?

 

I can imagine that it did not came with all required dependencies. The "no instance xxxx found" tells me that a metadata object from this query cannot be referenced. And this is what can be fixed. 

 

If you see that it takes too much time by yourself, I would ask for some help to SAS Technical Support.

Madelyn_SAS
SAS Super FREQ

Query information is stored in metadata and also in the SharedServices database. The metadata is basically a pointer to the information stored in the SharedServices database. The "no matching instance" error means that the database piece is missing in the target environment. Try creating a new package from the copy that is working and review the log on the last page of the wizard. If it looks OK, then try importing again. Look at the import log and see if there are any errors.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 835 views
  • 1 like
  • 3 in conversation