If you see application engine has failed with error message as "Temporary Table processing failure during allocation phase" then this issue has happened due to one of the below changes
1) In application engine program that has failed, temporary table instance count has been changed to more than the number of temporary table instances available in the database.
For example, Application Engine program SAMPLE_1 was developed by including a temporary table XYZ_TMP with instance count as 3. During this initial development, developer might have built the temporary table XYZ_TMP after specifying the instance count in SAMPLE_1. Latter if the instance count has been increased and temporary table wasn't rebuilt then you will see this error message.
2) If the online temporary table instance count has been increased in PeopleTools Options page. After this instance count was increased developer might not have re-built the temporary tables.
Normally, Psae.exe begins with the lowest instance number available for each temporary table, until all of the instances are in use. After the instance counts are increased in the above specified scenario's and temporary table wasn't rebuilt, then when Psae.exe tries to allocate a record instance based on increased instance count this "Temporary Table processing failure during allocation phase" message will be logged.
Developer's should rebuild the temporary tables whenever there is change in instance counts either in Application Engine properties or online temporary table instance count.
1) In application engine program that has failed, temporary table instance count has been changed to more than the number of temporary table instances available in the database.
For example, Application Engine program SAMPLE_1 was developed by including a temporary table XYZ_TMP with instance count as 3. During this initial development, developer might have built the temporary table XYZ_TMP after specifying the instance count in SAMPLE_1. Latter if the instance count has been increased and temporary table wasn't rebuilt then you will see this error message.
2) If the online temporary table instance count has been increased in PeopleTools Options page. After this instance count was increased developer might not have re-built the temporary tables.
Normally, Psae.exe begins with the lowest instance number available for each temporary table, until all of the instances are in use. After the instance counts are increased in the above specified scenario's and temporary table wasn't rebuilt, then when Psae.exe tries to allocate a record instance based on increased instance count this "Temporary Table processing failure during allocation phase" message will be logged.
Developer's should rebuild the temporary tables whenever there is change in instance counts either in Application Engine properties or online temporary table instance count.
No comments:
Post a Comment