SSIS Execute Package Utility Issue

Question

Post reply

SSIS Execute Package Utility Issue

Jobs90312

Mr or Mrs. 500

Points: 533

April 8, 2024 at 10:25 am

#4408737

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

April 8, 2024 at 11:16 am

This was removed by the editor as SPAM

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

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

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

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

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 2

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.