SQLPDE error Invalid column name 'cln_pde_processed'

Modified on Wed, 20 Dec 2017 14:24 by Kevin Ricciardo — Categorized as: Uncategorized

CAREWare has an option to export data to a database in the CAREWare SQL Server database instance. In build 945, some users encountered an error message when exporting to SQL.

The error message was:

Source: jProgBusiness - Invalid column name 'cln_pde_processed'.

To resolve this error:

  1. Go to C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier.
  2. Right click CW Admin.
  3. Click Run as Administrator.
  4. Click Stop Server.
  5. Click Common Storage Settings.
  6. Click cmm_st_pk to set the list in alphabetical order.
  7. Scroll to SQLPDIVersion.
  8. Change the value in cmm_st_number to 7.
  9. Click a blank field to save.
  10. Click Server Settings.
  11. Click Start Server.

To download these instructions click here.

Back to Bugs