Application cannot update / delete table in Deploy Result

[badrudubradu]

Hi everyone,

Currently I have an issue. I made a table, a business view and an interactive application. The application doing fine in my FAT. Deploy result was also fine until PY environment. But after it was deployed in PD, it seems the update function didn't work. The build and deployment process finished succesfully with no error message.

I used Table Interconnect function "Update" to update my data. I didn't update the table from headerless or fix/inspect form.

Insert function doing fine, but both update and delete function (from Table Interconnect) didn't work. So I guess it was caused by some error in table index. I tried to rebuild the Index then deploy it again but it didn't repair anything. I even tried to rebuild the table and index but it didn't work either. Then I tried to update from Business View (not from table) but it also failed. My last resort was to build a new table and business function, but that mean I also have to rebuild many application that use the table.

Please let me know if you have any suggestion to resolve this issue.

 

[badrudubradu]

Here's what I did yesterday:

I made an application (P5549252) with a simple function to update the that table when I click a button. I built and deployed it, the update function run well.

Then I made some change on my previous application (P5549250), I made a button that call P5549252 with form interconnect function. Try it in FAT and it was able to update. Then I deployed it to PD environment (deploy only P5549250, not the P5549252). From Fast Path, I run P5549250, click the button to call P5549252, and tried to press the update button. It didn't work! Then I try to run P5549252 from fast path, and it didn't work either. Now I'm confused, I didn't change or include my P5549252 in the second deploy but after I deploy P5549250 again, it become unable to update.

Now I figured maybe the problem was on my P5549250 application.

 

[badrudubradu]

Here's the log

Thu Sep 05 07:20:30 - Local repository SPEC__PD900FC attached.
Thu Sep 05 07:20:30 - Repository created/attached.
Thu Sep 05 07:20:30 - Update parent package specs 'asvrhdr' specs for Applications.
Thu Sep 05 07:20:34 - pkgSpec.cpp:3288 PKGSPC0036 ERROR: Failed to insert record in object P5549250. Error JDESPECRESULT_JDBFAILED
Thu Sep 05 07:20:34 - Update parent package specs 'asvrdtl' specs for Applications.
Thu Sep 05 07:20:34 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Applications - P5549250 not built. Correct previous errors and try again.
Thu Sep 05 07:20:34 - Updated parent package specs.
Thu Sep 05 07:20:34 - Update parent package specs 'fdaspec' specs for Applications.
Thu Sep 05 07:20:34 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Applications - P5549250 not built. Correct previous errors and try again.
Thu Sep 05 07:20:34 - Updated parent package specs.
Thu Sep 05 07:20:34 - Update parent package specs 'dstmpl' specs for Data Structures.
Thu Sep 05 07:20:37 - pkgSpec.cpp:3288 PKGSPC0036 ERROR: Failed to insert record in object W5549250A. Error JDESPECRESULT_JDBFAILED
Thu Sep 05 07:20:41 - pkgSpec.cpp:3288 PKGSPC0036 ERROR: Failed to insert record in object W5549250B. Error JDESPECRESULT_JDBFAILED
Thu Sep 05 07:20:44 - pkgSpec.cpp:3288 PKGSPC0036 ERROR: Failed to insert record in object W5549250C. Error JDESPECRESULT_JDBFAILED
Thu Sep 05 07:20:44 - Update parent package specs 'smrttmpl' specs for Smart Templates.
Thu Sep 05 07:20:44 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Smart Templates - W5549250A not built. Correct previous errors and try again.
Thu Sep 05 07:20:44 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Smart Templates - W5549250B not built. Correct previous errors and try again.
Thu Sep 05 07:20:44 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Smart Templates - W5549250C not built. Correct previous errors and try again.
Thu Sep 05 07:20:44 - Updated parent package specs.
Thu Sep 05 07:20:44 - Building GBRSPEC/GBRLINK records for APPL.
Thu Sep 05 07:20:44 - Update parent package specs 'fdatext' specs for Applications.
Thu Sep 05 07:20:44 - pkgXML.cpp:411 PKGXML0006 ERROR: Object Applications - P5549250 not built. Correct previous errors and try again.
Thu Sep 05 07:20:44 - Updated parent package specs.
Thu Sep 05 07:20:46 - pkgSpec.cpp:322 PKGSPC0035 ERROR: Failed to update the parent package manifest.
Thu Sep 05 07:20:46 - Parent package specs updated.
Thu Sep 05 07:20:46 - Detaching the local repository on the build machine. This will take some time.
Thu Sep 05 07:20:46 - Detaching local repository SPEC__PD900FC.
Thu Sep 05 07:21:16 - Local repository detached.
Thu Sep 05 07:21:17 - Copying detached files to the deployment server.
Thu Sep 05 07:21:17 - Copying from c:\e900\PD900\package\PD900FC\pkgspec\ to \\KAPUBA\E900\PD900\package\PD900FC\pkgspec.
Thu Sep 05 07:23:56 - Copy spec files to the spec location and rename.