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.
- Back up the folder.
- Delete the view with the concern, in the above it is “ZBD1SIMDAT” and recreate it.
- Try the import again.
- Validate the folder.
If the import fails again, then you would need to follow step 2.
- Back up the folder.
- Delete the view.
- Import the folder.
- Recreate the view in the new folder.
- Validate the folder.
The 3rd option to look at is the below.
- Create a backup of the folder.
- Create a patch for the views in the current environment.
- Delete the views and import the folder.
- Run the patch you created for the views.
- Validate the folder.