Subject | Occasional error |
---|---|
Author | Andrew Guts |
Post date | 2002-10-23T12:27:04Z |
Hello IB support.
I have working database application. It works with Firebird since July.
Sometimes users inform me about error during warehouse operation 'error
conversion from string "308" '. This operation is implemented as a SP.
All tables modified by this SP and all cascaded triggers do not contain
any string fields. The SP itself does not contain any string parameters
or variables. Tracing SP code points to insert statement that fires a
trigger. The trigger operates with float fields only. Error disappears
after recompilation of all triggers and SPs. Database validation and
backup/restore works with no errors. How to locate the error? Now I have
another similar error, but I need to investigate it first.
Thanks ahead.
Andrew
I have working database application. It works with Firebird since July.
Sometimes users inform me about error during warehouse operation 'error
conversion from string "308" '. This operation is implemented as a SP.
All tables modified by this SP and all cascaded triggers do not contain
any string fields. The SP itself does not contain any string parameters
or variables. Tracing SP code points to insert statement that fires a
trigger. The trigger operates with float fields only. Error disappears
after recompilation of all triggers and SPs. Database validation and
backup/restore works with no errors. How to locate the error? Now I have
another similar error, but I need to investigate it first.
Thanks ahead.
Andrew