Re: Relational Database Error-Production Order
David Delač
11-28-18
Hello,

Thank you for your enquiry.

I have several questions for you that might help us find out what the issue is:
- do you have any HAL customisations?
- have you added any new fields to your Production Order register that might not be defined in SQL?

- have you added any new fields to your Production Order register that might not be compatible with the field type that is set in SQL?
- have you made any changes that could be causing this problem that you have and how did this start happening?

Error "Failed Executing Prepared Insert, rc: -1" might also mean that you have indexing problem and table is corrupt. I see that you tried deleting the table, I would suggest you to drop the table and then generate it again from the scratch as that might fix your issue.


In case the issue is not fixed please provide me with answers to my questions above and also if possible try to repeat this on a newer version if Standard ERP (8.4 or 8.5).

Best Regards,
David D.
HansaWorld Support
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Piotr Wycichowski
Hi, Some incoiming external e-mails, like invitation for scheduled Zoom meeting, comes with special attachement .ics to create an event in calendars. When such e-mail is received by SERP mail syste...
15:43 12 Sep 2025
Piotr Wycichowski
Hi, I checked option "Use External Mail Software" in setting "Mail and Conferences Settings" in module "Mail and Conferences". When I create an invoice email I have a ...
17:38 8 Aug 2025