Agile Developer

Unable to Save Tran...
 
Notifications
Clear all

[Solved] Unable to Save Transactions in Live Environment

2 Posts
2 Users
0 Reactions
164 Views
Posts: 609
Topic starter
(@banupriya)
Noble Member
Joined: 1 year ago

We are encountering a critical issue where transactions cannot be saved in the live environment. Here are the steps to reproduce the issue:

1. Log in to the Developer environment.
2. Navigate to the "Recon - Stock In Transit" screen.
3. Attempt to save a transaction.

Please find the trace file attached for further investigation.

1 Reply
Posts: 602
Admin
(@axpertsupport)
Honorable Member
Joined: 2 years ago

Could you please update the script and inform us once it's done?

Note: Ensure you take a backup of the current script before making changes.

Here are the updates to apply:

UPDATE coretstructhdr
SET dbdecimal = fdecimal
WHERE customdatatype = 'Decimal Number'
AND dbdecimal = 0
AND fdecimal < 10;

UPDATE coretstructhdr
SET dbdecimal = 9
WHERE customdatatype = 'Decimal Number'
AND dbdecimal = 0
AND fdecimal > 10;

Reply
Share: