Question:
I am converting Personal Data Keeper using the Project Accounting utilities. I have not yet updated Personal Data Keeper, but the checkbox is grayed out. What can I do?
Answer:
The conversion utility is checking the table structure of the PDK_Palette_Master_MSTR (PDK01800) to enable or disable the PDK checkbox. So, in the case that it is grayed out when it should not be, replacing the PDK01800 should resolve the problem.
On MSSQL:
1. If you have access to an install that has updated successfully, you could restore the DYNAMICS database to a different database name. After that, open up MSSQL Enterprise Manager. Expand the DYNAMICS database (restored copy) and select Tables. On the tables list at the right pane of the window, highlight PDK01800, right click, select all tasks-Generate SQL Scripts. This will create a sql file that will have the table definition of the PDK01800 table. You would then need to run this against your live DYNAMICS database. Doing so will drop and recreate the PDK01800 according the table structure of the previous version.
2. If you don't have access to an install that updated successfully you would need to install PA that is compatible with the older version of PDK on a test machine. Run PDK initialize sql in PA to create all PDK files. After that, open up MSSQL Enterprise Manager. Expand the DYNAMICS database and select Tables. On the tables list at the right pane of the window, highlight PDK01800, right click, select all tasks-Generate SQL Scripts. This will create a sql file that will have the table definition of the PDK01800 table. You could use the sql script to change the updated PDK01800 table definition on the customers’ data to that of the old PDK PDK01800 table definition. This will enable the PDK checkbox in the conversion utility.
On Pervasive and Ctree:
1. If you have access to an install that was successful, restore the PDK01800 from a pre-update backup of the system folder that was successful.
2. If you don't have access to an install that updated successfully, you would need to install PA that is compatible with the older version of PDK on a test machine. Then run PA Initialize PDK. Then copy the PDK01800 to the live system folder.
This article was TechKnowledge Document ID:23798
I am converting Personal Data Keeper using the Project Accounting utilities. I have not yet updated Personal Data Keeper, but the checkbox is grayed out. What can I do?
Answer:
The conversion utility is checking the table structure of the PDK_Palette_Master_MSTR (PDK01800) to enable or disable the PDK checkbox. So, in the case that it is grayed out when it should not be, replacing the PDK01800 should resolve the problem.
On MSSQL:
1. If you have access to an install that has updated successfully, you could restore the DYNAMICS database to a different database name. After that, open up MSSQL Enterprise Manager. Expand the DYNAMICS database (restored copy) and select Tables. On the tables list at the right pane of the window, highlight PDK01800, right click, select all tasks-Generate SQL Scripts. This will create a sql file that will have the table definition of the PDK01800 table. You would then need to run this against your live DYNAMICS database. Doing so will drop and recreate the PDK01800 according the table structure of the previous version.
2. If you don't have access to an install that updated successfully you would need to install PA that is compatible with the older version of PDK on a test machine. Run PDK initialize sql in PA to create all PDK files. After that, open up MSSQL Enterprise Manager. Expand the DYNAMICS database and select Tables. On the tables list at the right pane of the window, highlight PDK01800, right click, select all tasks-Generate SQL Scripts. This will create a sql file that will have the table definition of the PDK01800 table. You could use the sql script to change the updated PDK01800 table definition on the customers’ data to that of the old PDK PDK01800 table definition. This will enable the PDK checkbox in the conversion utility.
On Pervasive and Ctree:
1. If you have access to an install that was successful, restore the PDK01800 from a pre-update backup of the system folder that was successful.
2. If you don't have access to an install that updated successfully, you would need to install PA that is compatible with the older version of PDK on a test machine. Then run PA Initialize PDK. Then copy the PDK01800 to the live system folder.
This article was TechKnowledge Document ID:23798