ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon Installation of SQLManex(Server install)
DrillDown Icon Multi-Location Sync(OPTIONAL Module)
DrillDown Icon Add Custom Quickview (test)
DrillDown Icon Introduction to MX
DrillDown Icon Setup/Security/Utilities
DrillDown Icon Product Data Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Report Manager
DrillDown Icon Tool Box
DrillDown Icon MX FAQ's
DrillDown Icon Error 1001. Exception occurred while initializing the installation
DrillDown Icon Error: Unable to create the store directory.
DrillDown Icon Object reference error on Manexcloud
DrillDown Icon Error: Store must be open for this operation
DrillDown Icon Custom Store Procedure/Tables Cannot reside within Manex Database
DrillDown Icon What if I see a Collation error when running reports?
DrillDown Icon Why am I seeing a Authentication Required pop up when accessing MX?
DrillDown Icon ManexCloud Report Permissions
DrillDown Icon Default WebSite/ManEx Http Error 403.14
DrillDown Icon How to Correct the Date Format when Exporting a Report to Excel.
DrillDown Icon Load Report Failed Error When Running a CR over the Web
DrillDown Icon Mapping of Reports to Roles
DrillDown Icon Error Source: Event Log Error
DrillDown Icon Why is Undefined being Displayed in Some Fields on the AP Aging Summary Quick View Report?
DrillDown Icon Why isn't WebManEx Accessible from the Workstations?
DrillDown Icon Why does the system require email address to be populated?
DrillDown Icon Unable to install Manex Services
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Custom Store Procedure/Tables Cannot reside within Manex Database

Upon recent review of your Manex data files we have come across some concerns that we need to make you aware of. 

We have found that you have many custom procedures, views and/or tables within our (Manex) database.  

Some of these Procedures start with "  ". . . . or "    " . . . but other's do not have any type of label or indicator for us to tell if this is a custom file or not.  

The issue with placing these Custom Procedures, Views, Etc. . . directly within the Manex Database is that any of our updates and/or conversions will go through and find any procedure, View, Table, etc . . that we (Manex) did not create and/or need and automatically remove them from the database.  This means that you will potentially lose all of these custom items you have created directly within the Manex Database.  

You need to make sure that all custom procedures, views, tables, etc . . are created and saved within a database outside of MANEX.  You can create the procedures to link to and use the Manex database, but they can not reside within the Manex database itself.  We suggest that you work with IT on moving these out of Manex database and let us know if you have any questions.   

 

 

Article ID: 5995