Metadata Repository (SVD) issues

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Md1.png


Metadata Repository(SVD) Issues

Version 1.0

1. DOCUMENT MANAGEMENT

1.1. PURPOSE

The purpose of this section of the document is to provide a mechanism for controlling the version releases of this document including appendices where applicable.

1.2. DOCUMENT INFORMATION

Category Details

Document Name Sage Alchemex Metadata Repository (SVD) Issues Version 1.0


Author Name Nicholas Hanafey


Creation Date Friday, 03 August 2012


Status Version 1.0.


2. WHAT IS THE METADATA REPOSITORY (SVD)

The metadata repository is a proprietary database file (Alchemex.svd) that stores the internal application information required for the Sage Intelligence module. Anything configurable inside Sage Intelligence is stored in this file, e.g. reports, containers and company information.


3. TYPICAL LOCATION

This depends on the ERP that Sage Intelligence is integrated into and is at times decided by the ERP developers themselves. Typically the location is inside the user application data location (C:\Users\**USER_NAME**\AppData\Local) or the default program data location (C:\ProgramData), within a sub folder named after the appropriate ERP (e.g. Alchemex).

The location of the metadata repository is visible inside the Report Manager module when the Home Node is selected:


Md2.png


4. FIXES FOR METADATA REPOSITORY CORRUPTION

Occasionally the metadata repository can become corrupt; this can cause various issues inside the Sage Alchemex application. In most cases, the PLMAINT.exe tool can be used to resolve the corruption:


• Navigate to the Sage Intelligence application install folder in Windows Explorer.

• Locate and run the PLMAINT.exe tool found in the root of the above folder.


Md3.png


• Click on the Compact SVD button and follow the prompts.


This will compact and repair the metadata repository which will resolve most corruption issues, any remaining issues will need to be resolved by the Sage Alchemex support desk.


5. ISSUES REGARDING SECURITY AND NETWORKS

In certain integrations the metadata repository is stored on a network path; when this is the case, issues can arise around network permissions. Make sure that the user running the Sage Intelligence software has been explicitly granted read and write permissions to the metadata repository folder – often this will need to be done by the network Administrator:

• Right click on the metadata folder in Windows Explorer.

• Click Properties and then select the Security tab.

• Click the Edit button

• Add the user that you are currently logged in as.

• Make sure that the user has Modify, Read and Write permissions and select OK.

Md4.png