Error importing folder (Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'ZBD1SIMDAT'

Less than one minute read time.

When importing a folder, you receive the following error,

 WARN  - <0001 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'ZBD1SIMDAT'. : SQL Server Error

WARN  -

WARN  - <0001

WARN  - Create view BABDEV.ZBD1SIMDAT

WARN  - Validate view BABDEV.ZBD1SIMDAT

WARN  - <0001 View BABDEV.ZBD1SIMDAT :

WARN  - <0001 Error when validating the view

WARN  - <0001 Error No 76

 

This error is referring to a view that has an issue with it that the system is not recognising,

To correct this, either process needs to be followed. 

  1. Back up the folder.
  2. Delete the view with the concern, in the above it is “ZBD1SIMDAT” and recreate it.
  3. Try the import again.
  4. Validate the folder. 

If the import fails again, then you would need to follow step 2. 

  1. Back up the folder.
  2. Delete the view.
  3. Import the folder.
  4. Recreate the view in the new folder.
  5. Validate the folder. 

The 3rd option to look at is the below. 

  1. Create a backup of the folder.
  2. Create a patch for the views in the current environment.
  3. Delete the views and import the folder.
  4. Run the patch you created for the views.
  5. Validate the folder.