E-AD: Application Designer Crashes when Building Large Projects
Last updated on NOVEMBER 07, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
On : 8.54.08 version, Application Designer
Application Designer Crashes
When using the build and execute script option in application designer the program aborts and closes unexpectedly. The issue is most commonly observed with larger projects, i.e. over 1000 records.
The build logs all seem to have index errors like the one show below.
Error: The handle is invalid.
Error: CA_ACCTG_LN_PC - SQL Error. Error Position: 53 Return: 1408 - ORA-01408: such column list already indexed
CREATE INDEX PSACA_ACCTG_LN_PC ON PS_CA_ACCTG_LN_PC (PROCESS_INSTANCE, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, ACCOUNT, DEPTID, PRODUCT, FUND_CODE, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, CHARTFIELD1) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
The issue can be reproduced at will with the following steps:
1. Open a large project in Application Designer.
2. Build the records in the project selecting the build and execute script option.
3. The program aborts and closes unexpectedly.
The issue has the following business impact:
Due to this issue, users cannot use the Build script and execute option in Application Designer.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms