Giter Site home page Giter Site logo

Comments (6)

spaghettidba avatar spaghettidba commented on September 23, 2024 1

Hey, thanks for the feedback! I don't think XelToCsv can read a file on a blob storage directly, I'm afraid you will have to download it first. Sorry about that

from xesmarttarget.

IanMoroney avatar IanMoroney commented on September 23, 2024

@spaghettidba , i'm also getting a similar issue after installing 1.5.3 on windows.
I tried doing a regsvr32 on CommandLine.dll to see if it was that, but it looks like that dll doesn't need registering.

Any ideas how to solve this problem? I'm unable to run XelToCsv.exe

I added the XESmartTarget folder to the PATH.

C:\Program Files\XESmartTarget> .\XelToCsv.exe

Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'CommandLine, Version=1.9.71.2, 
Culture=neutral, PublicKeyToken=de6f01bd326f8c32' or one of its dependencies. 
The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
   at XelToCsv.Program.Main(String[] args)

from xesmarttarget.

spaghettidba avatar spaghettidba commented on September 23, 2024

OK, I have a new release that should fix that. Sorry it took me this long
https://github.com/spaghettidba/XESmartTarget/releases/tag/v1.5.4

from xesmarttarget.

mdumdei avatar mdumdei commented on September 23, 2024

from xesmarttarget.

IanMoroney avatar IanMoroney commented on September 23, 2024
Info - XelToCsv.Program : XelToCsv, Version=1.5.4.0, Culture=neutral, PublicKeyToken=null 1.5.4
Info - XelToCsv.Program : Converting https://storageaccount.blob.core.windows.net/sqldbauditlogs/servername/databasename/SqlDbAuditing_ServerAudit/2023-06-32/32_36_32_254_56.xel to test22.csv
Error - XelToCsv.Program : Conversion Error
Error - XelToCsv.Program : System.ArgumentException: filename
   at Microsoft.SqlServer.XEvent.Linq.Internal.XEventFileReaderMessageHandler.NotifyInvalidParameter(XEventFileReaderMessageHandler* , UInt16* paramName, UInt64 value)
   at XE_FileReader<XE_FileReaderDefaultPolicy>.SetIsSequentialScan(XE_FileReader<XE_FileReaderDefaultPolicy>* , Int32 )   at Microsoft.SqlServer.XEvent.Linq.Internal.XEventInteropFileReader..ctor(String[] fileList, String[] mdFiles)
   at Microsoft.SqlServer.XEvent.Linq.XEventFileProvider`1..ctor(QueryableXEventData queryable, String[] fileList, String[] metadataFiles)
   at Microsoft.SqlServer.XEvent.Linq.QueryableXEventData..ctor(String fileName)
   at XESmartTarget.Core.Utils.XELFileCSVAdapter.Convert() in C:\GitHub\XESmartTarget\XESmartTarget.Core\Utils\XELFileCSVAdapter.cs:line 34
   at XelToCsv.Program.Convert(String sourceFile, String destinationFile) in C:\GitHub\XESmartTarget\XelToCsv\Program.cs:line 56
Info - XelToCsv.Program : Conversion finished at 12/06/2023 10:51:50
Info - XelToCsv.Program : 0.1550185 seconds taken

I'd expect that the response being given to XelToCsv.exe is:

<?xml
version="1.0" encoding="utf-8"?>
<Error>
    <Code>PublicAccessNotPermitted</Code>
    <Message>Public access is not permitted on this storage account.
RequestId:7c0fa3c6-d99f-4c31-993c-5325dba89ad9
Time:2023-06-12T09:55:42.0066658Z</Message>
</Error>

but maybe it's not handling that response correctly?

from xesmarttarget.

IanMoroney avatar IanMoroney commented on September 23, 2024

When run on a local file, it worked fine this time:

xeltocsv -s testfile.xel -d test23.csv
Info - XelToCsv.Program : XelToCsv, Version=1.5.4.0, Culture=neutral, PublicKeyToken=null 1.5.4
Info - XelToCsv.Program : Converting testfile.xel to test23.csv
Info - XelToCsv.Program : Conversion finished at 12/06/2023 10:58:26
Info - XelToCsv.Program : 2.6795824 seconds taken

from xesmarttarget.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.