My Oracle Support Banner

[nQSError: 27047] Nonexistent table after Snapshot Import From A Different Environment (Doc ID 3028174.1)

Last updated on JUNE 13, 2024

Applies to:

Oracle Analytics Server - Version 5.5.0.0.210922 and later
Information in this document applies to any platform.

Symptoms

From Instance Making a Copy - Create Snapshot

  1. Click Console.
  2. Click Snapshots.
  3. Click Create Snapshot.
  4. Enter a short description for the snapshot to help you remember later why you took it.
  5. Choose Everything - Include everything about your environment in the snapshot except for file-based data, plug-ins, and extensions.
  6. Select the snapshot that you want to export.
  7. Click Snapshot Actions Snapshot actions menu.
  8. Click Export.
  9. In Snapshot Password, enter and confirm a password for the snapshot.

  The password must be between 8 and 50 characters long and contain at least one numeric character, one uppercase letter, and one lowercase letter.

  10. Click Export.

To Instance moving Snapshot to:

  1. Click the Page actions menu Page actions menu and select Import Snapshot.
  2. Click Select to locate the snapshot that you want to upload.
  3. Select the snapshot file (.bar) that contains your snapshot. You can upload snapshots taken from Oracle Analytics Server and Oracle Analytics Cloud excluding file-based data, plug-ins, and extensions.
  4. Enter the snapshot password.

  This is the password that you specify whenever you export a snapshot to your local file system.

  5. Click Import.
  6. Now try to access dashboards or reports. The following error is produced:

 Refefrence: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/export-and-import-snapshots.html#GUID-EA2778B4-8B7C-4135-91F0-90A223A35A80

Changes

 Export Snapshot from one environment to another environment.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.