SSIS Execute Package Utility Issue

  • Hi everyone,

    So I have a ssis package that performs various operations like import, export etc based on values provided in config files.

    Today I have added some more code in the script task that downloads a pdf file, converts it to excel format and then reads this file and perform ETL operations.

    It loads the data into MySQL database tables.

    These all steps are working without any issue on my machine when I run this package from Visual Studio.

    But on the server where I have deployed it, it is only working till excel conversion part and then it crashes and give error (check screenshot).

    I run the deployed package via batch file.

    error screenshot

    It also creates the file:

    SQLDUMPER_ERRORLOG.log

    It contains this data:

    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 7244
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 00007FF7A1CBEC68
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 7244
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00007FF7A1CBEC68
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, PatternForExtraFiles = <NULL>
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
    (3F90:B9C) 04/08/24 15:08:30, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Remote process didn't specify a dump file name
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Target suspended
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Callback type 11 not used
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Callback type 15 not used
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Callback type 7 not used
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, MiniDump completed: C:\Program Files\Microsoft SQL Server\130\Shared\ErrorDumps\SQLDmpr0013.mdmp
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Total Buffer pool data pages filtered out: 0 KB
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Total Hekaton data pages filtered out: 0 KB
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Total Free memory (from non top level allocators) filtered out: 0 KB
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Total top level free memory filtered out: 0 KB
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Total Log pool memory filtered out: 0 KB
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, File version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll' : '6.12:2.633'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Product version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll' : '6.12:2.633'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, File version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE' : '2015.130:1601.5'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Product version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE' : '13.0:1601.5'
    (3F90:B9C) 04/08/24 15:08:30, ACTION, DTExec.exe, Send_To_Watson flag is set to true
    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, Watson Invoke: Yes
    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, Creating WER report...

    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, Created the report.

    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, WerReportAddFile Mini Dump succeeded.
    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, WerReportAddFile Extra File succeeded.
    (3F90:B9C) 04/08/24 15:08:31, ACTION, DTExec.exe, Submitted report asynchronously.

    Can anyone explain what exactly is the issue here? This log file doesnt really explain anything...

     

    Regards

     

  • Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • This was removed by the editor as SPAM

  • Phil Parkin wrote:

    Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?

     

    Sorry for late reply. I found the solution. It  was because of using 64-bit version in batch file of DTExec.exe: "C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe"

    When I changed above to this: "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe"

    This issue didnt occur again.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply