Error

  • 22 Apr

    Error while searching files: Invalid signature message

    Q: We have the problem with deletion rules for different SANs that the error message “Error while searching files: Invalid signature” appears in the log. I have attached a screenshot of the error message and the rule as pdf. It’s nothing complicated. The P-drive on which should be deleted in several folders is a Quantum SAN \\MyServer\production which is connected via smb in windows and the used user has RW rights. But there are also rules on the same storage that work without this error message. Do you have any idea what this could be or what the error message means? In the blog I have unfortunately found nothing about this error message.
    The customer was using our File Mover as Application and this combined with a mapped network drive (+drive letter) which he added within Windows. This is not something we prefer certainly not when using our File Mover as Service where it is absolute necessary to use our Network Drive option to map network shares.
    Since he was using our File Mover as Application we adviced him to enter the full path instead of the mapped drive letter. We received the following feedback:
    Thanks for the tip. I have been running the rules since our last mail and it seems that it really was that. With the full UNC path, the error message does not appear so far.
    Other links about this topic:
    #FileTransfer
    If you need any help with this ‘Invalid signature’ error message, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Error ,
  • 29 Nov

    Q&A 32: Error during sftp file upload with Limagito File Mover

    Q: We have installed Limagito version v2020.11.21.0 with the Site+ license on a W2K19 server. When we try to transfer files to an external sftp server it doesn’t work out fine (Error during sftp file upload). The SSH connection seems fine to me , but the files won’t be uploaded. Unfortunately the other side can’t help me out and I can’t find out what is happening and why.

    25-11-2020 19:39:31 [SFTP] SFTPUploadFile, CK UploadFileByName Error, ChilkatLog:
     
    [SFTP]   UploadFileByName:
    [SFTP]     DllDate: Jul  2 2020
    [SFTP]     ChilkatVersion: 9.5.0.83
    [SFTP]     UnlockPrefix: CPSFTB.CB1062022
    [SFTP]     Architecture: Little Endian; 64-bit
    [SFTP]     Language: Delphi DLL
    [SFTP]     VerboseLogging: 0
    [SFTP]     SshVersion: SSH-2.0-XpertSuite
    [SFTP]     SftpVersion: 4
    [SFTP]     Component successfully unlocked using purchased unlock code.
    [SFTP]     uploadFileByName:
    [SFTP]       remoteFilePath: /XX/XX_2020-11-24_08-00-00-werknemers.xml
    [SFTP]       localFilePath: \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml
    [SFTP]       localFileSize: 4485
    [SFTP]       sftpOpenFile:
    [SFTP]         remotePath: /XX/XX_2020-11-24_08-00-00-werknemers.xml
    [SFTP]         access: writeOnly
    [SFTP]         createDisposition: createTruncate
    [SFTP]         v3Flags: 0x1a
    [SFTP]         buildLongPath_xFilePath: \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml
    [SFTP]         Sent FXP_OPEN
    [SFTP]         StatusResponseFromServer:
    [SFTP]           Request: FXP_OPEN
    [SFTP]           InformationReceivedFromServer:
    [SFTP]             StatusCode: 5
    [SFTP]             StatusMessage: Error while parsing request.
    [SFTP]           --InformationReceivedFromServer
    [SFTP]         --StatusResponseFromServer
    [SFTP]       --sftpOpenFile
    [SFTP]       Failed to open file.
    [SFTP]     --uploadFileByName
    [SFTP]     Failed.
    [SFTP]   --UploadFileByName
    [SFTP] --ChilkatLog
     
    25-11-2020 19:39:31 [SFTPPUT] Copy Error \\MyDomain\proces\XX_2020-11-24_08-00-00-werknemers.xml

    A: It’s look like the SFTP server is trying to use SFTP Version v4 but .. not correctly. The solution here is to only allow SFTP Version v3.

    FYI: The customer is using our Second SFTP Vendor (CK).

    Limagito File Mover SFTP v3 Only

    Feedback from customer:

    Great !! that did the trick. J J J

    Thanks for your support  !!!

     

    If you need any help with this ‘Error during sftp file upload’, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Error Q&A SFTP , ,
  • 25 Jun

    SQLite ERROR: database disk image is malformed

    2020-06-24 13:57:08.764 [WINGET] CheckQrySelect Exception: [FireDAC][Phys][SQLite] ERROR: database disk image is malformed

    One of my moving rules is logging a SQLite error. Some files are processing, but the error was discovered because a select few files aren’t moving. I’m not sure that these failures are related to the error message. The files in question aren’t listed in the log. The rule seems to load OK, as does the file memory database. I’m not sure where else to look.

    Q: Can you help me track down the database and resolve the error?

    A: This is the first time we received feedback about this error message. It seems the File memory database file is damaged.

    We googled a bit and decided to share this in a post.

    1.- First we installed the latest (free) version of sqlitebrowser

    2.- Check your settings directory. The File Memory file starts with LimagitoX.MemXY.sqlite where XY is the ID of the Rule.

    In the example the Rule has ID120 so the File Memory Database file will be LimagitoX.Mem120.sqlite

    LimagitoX File Mover Rule ID

    LimagitoX File Mover Settings Directory File Memory Database File

    3.- Copy the damaged File Memory database file first and open it with the installed SQLiteBrowser tool

    4.- When opened select Tools > Integrity Check

    SQLiteBrowser Integrity Check

    5.- Click OK to start the Integrity Check

    6.- We’re getting error messages so it seems the File Memory database file was damaged. Normally we should get an OK message only.

    7.- Export the content of the damaged database to a temporary SQL File. You’ll be asked to name this SQL file (any name is ok).

    SQLiteBrowser Export

    8.- The File Memory database only contains one table, tblFileMemory

    9.- Exporting ..

    10.- Export completed

    11.- Restart SQLite Browser Tool and select Import, Database from SQL File. Select the SQL file you exported in step 7.

    SQLiteBrowser Import

    12.- Now you’ll have to set the filename of this new database. It must be the same as the damaged database file. You’ll have to replace this file later.

    13.- Import completed

    14.- To be sure we did an integrity check on this new database file, result OK

    15.- Finally you’ll have to replace the new File Memory database file with the damaged one. You’ll have to stop the LimagitoX Application or Service because the damaged File Memory database file will be locked as long as our File Mover Application or Service is running.

    If you need any help with the ‘database disk image is malformed error’, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Error SQL ,
1 2 3 4 5 6 9
SEARCH