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:
Go to
C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier
.
Right click
CW Admin
.
Click
Run as Administrator
.
Click
Stop Server
.
Click
Common Storage Settings
.
Click cmm_st_pk to set the list in alphabetical order.
Scroll to
SQLPDIVersion
.
Change the value in
cmm_st_number
to 7.
Click a blank field to save.
Click
Server Settings
.
Click
Start Server
.
To download these instructions click
here
.
Back to
Bugs