SQL Table was not found error during database restore on Store

SQL Table was not found error during database restore on Store

Problem Statement:


Customer tried to restore the backup database from Enterprise on Store Server, the process failed because table TrxTransactionFulfillment was not found at the database. 

Error Screenshot:



Resolution:

  • Verify whether any custom objects have been created in the Head Office (HO) database.
  • If custom objects exist, stop the Replication Service and drop the custom objects from the HO database after taking the backup.
  • Take a fresh backup of the HO Management Console (MC) .
  • After the backup is completed successfully, recreate the custom objects in the HO database.
  • Now try to Restore the backup from Store Server


      • Related Articles

      • Found error while login MC "Error encountered found in application"

        Environment: 6.6.7989 Short Description: Error found in the application Product Query:  While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...

      • Cannot open database 'CXSIntegration' login failed

        Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...

      • ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"

        Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...

      • Addon information was not updated for newly created store

        Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...

      • Problem In Store Database Backup Restore.

        Problem : Unable to Create Store Database from HO Management console. Script.xml is not created in the backup file. Reason : Earlier backups were corrupts because following SQL statement was throwing error as: Select A.* From InvSerial A ...