English
Chinese (Simplified)
French
German
Italian
Japanese
Russian
Spanish
Vietnamese
IBPP::SQLException error after upgrade SG from 9.0.3 to 9.5.1
-
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 failedSQL Message : -104
Invalid tokenrouting.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 failedSQL Message : -104
Invalid token
-
Arron Staff
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 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.
-
Arron Staff
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 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)
-
Arron Staff
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.
-
Good afternoon, yes, we want to try the beta version of the software
-
Arron Staff
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.
