IBPP::SQLException error after upgrade SG from ... | MDaemon Technologies Community Forum
  1. Forum
  2. Security Gateway
  3. IBPP::SQLException error after upgrade SG from 9.0.3 to 9.5.1

IBPP::SQLException error after upgrade SG from 9.0.3 to 9.5.1

  • D

    Hi, after upgrade SG from 9.0.3 to 9.5.1 we get error, SG not working

    system.log^

    Engine Code    : 335544849
    Engine Message :
    Malformed string
    At procedure 'INSERT_MESSAGES' line: 1, col: 521
    Tue 2024-01-16 08:47:22: *** IBPP::SQLException ***
    Context: Statement::Execute( execute procedure insert_messages(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
    Message: isc_dsql_execute2 failed

    SQL Message : -104
    Invalid token

     

    routing.log^

    Engine Code    : 335544849
    Engine Message :
    Malformed string
    At procedure 'INSERT_MESSAGES' line: 1, col: 521
    Tue 2024-01-16 09:24:41: ERROR - CreateMessage failed for: C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\Inbound\e3a26e3c2d1c42baa7850268098e09f5.MSG
    Tue 2024-01-16 09:24:41: ERROR - ExplodeMessage failed for: e3a26e3c2d1c42baa7850268098e09f5.MSG
    Tue 2024-01-16 09:24:41: ----------
    Tue 2024-01-16 09:24:43: Обработка сообщения: 1a2ebb56bc2c48b78ca1f49f3a7595eb.MSG
    Tue 2024-01-16 09:24:43: Тема: Запрос предложений компанией БОКСИТ ТИМАНА к конкурсу на закупку "Конкурсный отбор поставщика ЗЧ на автогрейдер CATERPILLAR по заявке ╧1.27 для АО "Боксит Тимана" (id845321)" id845321
    Tue 2024-01-16 09:24:43: Message-ID: <1705383036.242343.96396.nullmailer@6eb1fa933cf2>
    Tue 2024-01-16 09:24:43: От: mail_m@tender.pro; Получатель: gdo@rimera.com; Размер: 25461; Queued;
    Tue 2024-01-16 09:24:43: LogMessage failed - RewrittenMsg.file=<C:\Program Files (x86)\Alt-N Technologies\SecurityGateway\Temp\18eb715e0bdd424889965f3d4cfb755d.tmp>
    Tue 2024-01-16 09:24:43: *** IBPP::SQLException ***
    Context: Statement::Execute( execute procedure insert_messages(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
    Message: isc_dsql_execute2 failed

    SQL Message : -104
    Invalid token

    0 likes
  • A

    Please upgrade to SecurityGateway 9.5.2 as we made changes that may impact the issue.  If you are still having the issue after upgrading to SG 9.5.2, please upload a copy of Security\Gateway\app\SECURITYGATEWAY.FBD, the current securitygateway system and routing logs, along with copies of the messages referenced in the errors (if they exist).  Also please check the SecurityGateway\CrashDumps and upload any recent files that exist.

    All of the files can be uploaded to https://mdaemon.sharefile.com/r-r77d4332c21ab4a28afe9e84ea94e2f3c. Please let us know when the files have been uploaded.

     

    --
    Arron Caruth

    0 likes
  • D

    @Arron Thank you for your answer, we previously updated to the latest version SG 9.5.2, the problem remained, the database files and logs were downloaded from the link you provided, there are no dumps.

     
    0 likes
  • A

    Thank you for the logs and the database.  Do you have a copy of a message that causes the issue?  There is something in the message that is causing the issue.

    --
    Arron Caruth

    0 likes
  • D

    @Arron Thank for you reply, It looks like the errors are from one sender, I looked at the letters and didn’t find anything unusual in them. The email with errors was posted via your link (https://mdaemon.sharefile.com/r-r77d4332c21ab4a28afe9e84ea94e2f3c)

    0 likes
  • A

    We will be releasing a beta version of SecurityGateway 9.5.3a today that fixes this issue.  If you'd like to try the beta version, let me know and I can provide you a download link.  If you'd rather not install the beta version, we hope to make 9.5.3 available to the public in the next week or two.

    Thank you for reporting the bug.

    --
    Arron Caruth

    0 likes
  • D

    Good afternoon, yes, we want to try the beta version of the software

    0 likes
  • A

    The beta version corrects the error with adding the message to the database, but the subject of the message still does not appear correct in the Message Log.  We will look at correcting this for future versions.

    I've sent you a link to sharefile that you can use to download the beta version.  Please let me know if you do not receive the email or if you have any issues downloading.  Beta version of our software will stop working at some point in the future, so make sure you install the public release when it is made available.

    --
    Arron Caruth

    0 likes
Please login to reply to this topic!

Participants