Troubleshooting

This page provides help for common issues users may encounter when working with the SME Adapter UI.

---

1. Product Form – Submission Issues

❌ Error: "An unhandled error has occurred"

• Cause: Required fields are missing or invalid input has been provided.
• Solution:
  • Check that all mandatory fields (marked with *) are filled in.
  • Make sure you entered valid values (e.g., Zip Code must be numeric).
  • Try submitting again.

---

❌ Error: "Invalid object name 'Products'"

• Cause: The database tables have not yet been created.
• Solution (for developers):
  • Run the following command in the Package Manager Console:

    Update-Database

  • This will create the required tables (e.g., Products) in the database.
  • Restart the application and try again.

---

❌ No confirmation after saving a product

• Cause: The product is saved in the database, but the UI does not display a success message.
• Solution:
  • Check the Product List to confirm your entry was stored.
  • (Planned improvement: The UI will show a success notification in future versions.)

---

2. Product List – Display Issues

❌ Products are missing from the list

• Cause: The database is empty or filters/search options are hiding entries.
• Solution:
  • Add at least one product via the input form.
  • Reset any active filters.

---

❌ Wrong or incomplete information in the list

• Cause: Fields were left empty during form input.
• Solution:
  • Edit the product entry and update missing details.
  • Use consistent naming for Product Designation and Product Family.

---

3. Database Connection Problems (Developers)

❌ "Cannot connect to SQL Server"

• Cause: The local SQL Server instance is not running or the connection string is incorrect.
• Solution:
  • Ensure that SQL Server Express is installed and running (localhost\SQLEXPRESS).
  • Check appsettings.json for a valid connection string:

    "Server=localhost\\SQLEXPRESS;Database=BlazorAppDb;Trusted_Connection=True;TrustServerCertificate=True"

---

4. General Tips

• ✅ Always check that mandatory fields are filled in.
• ✅ Use consistent data formats (e.g., avoid mixing product codes with free text).
• ✅ If unsure about a field, click the Help button (?) next to it.
• ✅ For persistent errors, contact the system administrator.

---

Quick Checklist

Before reporting an error:

1. Have you filled in all required fields?
2. Is your database connection active?
3. Did you check the Product List to confirm the save?
4. Have you restarted the application after updating the database?