Page History: SQLPDE error Invalid column name 'cln_pde_processed'
Compare Page Revisions
Page Revision: Wed, 20 Dec 2017 13:56
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 seven.
9. Click a blank field to save.
10. Click
Server Settings.
11. Click
Start Server.
Back to
Bugs