xp_cmdshell Error code: 0x80004005

Question

xp_cmdshell Error code: 0x80004005

vprunic

SSC Eights!

Points: 850
More actions
August 19, 2016 at 7:40 am

#312632

Hello all,
what does this mean?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
The file that is being accessed has FULL rights for EVERYONE in Security setting
A dtsx package is being started and fails when it wants to populate the Excel file
Thank you in advance

Viewing 13 posts - 1 through 12 (of 12 total)

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

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 1

vprunic (8/19/2016)
Hello all,
what does this mean?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
The file that is being accessed has FULL rights for EVERYONE in Security setting
A dtsx package is being started and fails when it wants to populate the Excel file
Thank you in advance

Suspect that the file is open by a user, check the hidden files in the directory for the lock file or use sysinternals to see if the file is open.

😎

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

vprunic (8/19/2016)
Hello all,
what does this mean?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
The file that is being accessed has FULL rights for EVERYONE in Security setting
A dtsx package is being started and fails when it wants to populate the Excel file
Thank you in advance

Is your 2012 server 32 bit or 64 bit?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 3

vprunic (8/19/2016)
Hello all,
what does this mean?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
The file that is being accessed has FULL rights for EVERYONE in Security setting
A dtsx package is being started and fails when it wants to populate the Excel file
Thank you in advance

Working with Excel I've had similar problems in the past which never made sense. This may not have anything to do with your problem but firstly I would check to see if the job has the following option enabled. "Use 32 bit runtime". If you go to your Job properties Steps and under the "Execution Options" it should be there.

Secondly, try running the package through BIDs. You will get a more detailed reason, you will probably need to change the properties on the Package itself to "Run64BitRuntime" to false (it might already be false- but just double check)

vprunic SSC Eights! Points: 850 More actions · Answer 4

vprunic

SSC Eights!

Points: 850

August 22, 2016 at 6:23 am

#1896615

64bit

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 5

Further on my previous post, even having the preview on in Windows File Explorer and that particular file selected will block the file, have you checked if the file is open/locked by any process?

😎

vprunic SSC Eights! Points: 850 More actions · Answer 6

Hi Tava,

its saved as a file (dtsx), so how can i edit it. In VS i cant find the property

vprunic SSC Eights! Points: 850 More actions · Answer 7

@Eirikur Eiriksson it isnt. i checked

and when i try to start from CMD it works fine

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 8

vprunic (8/22/2016)
@Eirikur Eiriksson it isnt. i checked
and when i try to start from CMD it works fine

But not from SSDT?

😎

vprunic SSC Eights! Points: 850 More actions · Answer 9

When i add it to a project it works fine when its executed in 32 bit

But when I start it SQL server

Code: 0xC0209303

Source: TransferMappings Connection manager "DestinationConnectionExcel"

Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 10

vprunic (8/22/2016)
When i add it to a project it works fine when its executed in 32 bit
But when I start it SQL server
Code: 0xC0209303
Source: TransferMappings Connection manager "DestinationConnectionExcel"
Description: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Are you running this as an SQL job? If so you need to check the "run as 32 bit runtime" option i mentioned in my post earlier. Go to job properties, steps and go to execution options.

I can't see any other possible solution. The fact it runs as a project in 32bit this would be the solution

vprunic SSC Eights! Points: 850 More actions · Answer 11

It turned out that the Proxy User was not set up propertly (Did not have write rights)

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 12

Again (and I haven't read back through this entire thread), I hope that you did NOT give a non systemadmin privs to run xp_CmdShell directly.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)