Run this query on the CAREWare database:

Use cw_data

ALTER TABLE cw_tdi_import_log

ALTER COLUMN tdi_imp_lg_tdi_src_fk uniqueidentifier NULL

Delete the bCrypt.dll file in the CAREWare Business Tier folder. That file is located in the folder C:/Program Files/CAREWare Business Tier by default.

Make sure to keep the file called BCrypt.Net.Next.dll. That file is currently used by the latest version of CAREWare and needs to be retained.

Then replace the PDI Template and PDIMDBToCSVConverter in the CAREWare Business Tier.

Here is the new PDI Template.

To replace the template, follow these instructions:

1. On the CAREWare server, go to the CAREWare Business Tier folder, which is located at C:/Program Files/CAREWare Business Tier by default.
2. Download that PDI Template.mdb file.
3. Extract that file to the C:/Program Files/CAREWare Business Tier.
4. Select the Replace option.

We also created a new MDB converter application to resolve timeout issues when exporting MDB files.

Here is the new MDB Converter application.  The process for replacing the converter is as follows:

1. Download the file.
2. Extract it.
3. Open Task Manager.
4. Click PDIMDBToCSVConverter.
5. Click End Task.
6. Copy the file.
7. Paste the file in the CAREWare Business Tier folder.
8. Select the option to replace the file.   

If the file is still listed as in use by another application, the CAREWare Business Tier service may need to be stopped after users are logged out.