Compile Error Dbmon
Contents |
and to help other users in the Splunk community with their own questions. This quick tutorial will help you get started with key features to help you find the answers you need. outputdebugstring example You will receive 10 karma points upon successful completion! Get Started Skip Tutorial Splunk.com
Debugview
Documentation Splunkbase Answers Wiki Blogs Developers Sign Up Sign in FAQ Refine your search: Questions Apps Users Tags Search Home Answers ask a question Badges Tags Users Welcome to Splunk Answers! Not what you were looking for? Refine your search. Search Splunk DB Connect 1: Using a SQL variable as a rising column to create a dbmon-tail, how do I resolve error "Column unique_concat not found"? 0 Hi all, I have a confusing issue here. I have a proprietary SQL system that I am connecting to, to get data from. It is AttacheBI which runs C-tree Ace SQL in the back end and I only have read-only access to the data. I have established my connection through the use of an JDBC-ODBC bridge and I can browse the tables and fields using DB Query. So the connection is good there. I am trying to setup a dbmon-tail, however, there is no single unique field in the data. I have spoken with Attache support and I would need to concat 3 fields in order to get my unique field to use as a Rising Column. Here is the SQL command I am using: select TO_NUMBER(concat(concat(TO_CHAR(so.financialyearstart, 'YYYYMMDD'), LPAD(TO_CHAR(glt.batchnum), 10, '0')), LPAD(TO_CHAR(glt.seqnum), 10, '0'))) AS unique_concat, glt.*, glte.*, gl.description FROM admin.systemgloptions2 so, (admin.generalledger_transaction glt LEFT JOIN admin.generalledger_transactionextension glte ON glt.code = glte.code AND glt.seqnum = glte.seqnum AND glt.batchnum=glte.batchnum) LEFT JOIN admin.generalledger gl ON gl.code = glt.code WHERE char_length(glt.code) > 0 {{AND $rising_column$ > ?}} ORDER BY unique_concat Here is a screen shot of the Input: This query works fine in the DB Query part of DBX, but when I use it to create the dbmon-tail, I get this error: Encountered the following error while trying to save: In handler 'dbx-monitors': Unable to xml-parse the following data: Failed to validate: com.splunk.config.SplunkConfigurationException: Error validating dbmonTail for monitor=dbmon-tail://AttacheBi... See splunkd.log for full data. Looking at the logs, I can see that DBX has issues that the field unique_concat is not in the data. From the splunkd.log
Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question about this article Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ https://answers.splunk.com/answers/296947/splunk-db-connect-1-using-a-sql-variable-as-a-risi.html / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter http://www.codeproject.com/Articles/13345/DbMon-NET-A-simple-NET-OutputDebugString-capturer The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Articles » Web Development » Trace and Logs » Debug and Tracing ArticleBrowse CodeStatsRevisionsAlternatives Comments (30) Add your ownalternative version Tagged as C#C++.NETWindowsVisual-StudioDev Stats 120.2K views2.8K downloads81 bookmarked Posted 7 Mar 2006 DbMon.NET - A simple .NET OutputDebugString capturer Christian Birkl, 7 Mar 2006 CPOL 4.93 (70 votes) 1 2 3 4 5 4.93/5 - 70 votes1 removedμ 4.81, σa 0.89 [?] Rate this: Please Sign up or sign in to vote. A .NET port of the VC++ 6.0 sample, 'dbmon'. Down
kernal amd phenom compile native apps iphone how to compile java to compile your e-mail to compile into binary file cross compile kernel x86 64 compile 32 bit x compile php 5.2.6 compile perl executable linux to compile vmware http://precisioncollision.net/h/compile.mtu/ for linux cemu compile windows to compile linux kernel-devel to compile a java file simh compile errors how to compile pro c to compile and install kernel compile 0s or 02 ibp compile solaris compile named for dns compile error in hidden module autoexecnew compile link assemble ecos tutorial to compile cmake compile source code compile file how to compile a bibliography to compile vb6 compile time polymorphism examples in java compile failed rpg maker compile 64 how compile error macros compile in c programming vista java compile compile mp3 to compile a dictionary to compile survey data microsoft visual basic compile error distmon compile source bytecode compile 2.6.23 fedora to compile apple darwin illinois compile statutes to compile in puppy linux to compile from source linux howto compile gnome finding endevor compile error compile java bytecode regular expression compile to compile using javac oracle toad compile show errors macro link button compile error linux compile c compile error dbmon swf dynamic compile debug vs compile different between debug and compile compile optimize firefox compile trace mode datastage compile error for without next to compile a binary php get compile date compile search engines how to compile the kernel recherche carried goldman to compile a kernel ppc compile swatch is compile time polymorphism to compile watcom fortran compile aion bre to compile animations gentoo transcode imagemagick compile error mib compile choice compile java to compile in linux mingw compile to compile c file ppp kernel compile linux 2.6 java compile with text pad jcl to compile cobol to compile several vob videos unable to compile class for jsp to compile java dos classpath compile access to exe file to compile file compile mde files to compile debian source packages compile error dlerror compile fedora core 5 kernel how to compile ns2 program to compile mailing list to compile c in ubuntu to compile mibs to compile borland c to compile java in windows compile apache 2 apr how does compile multiple search engines advanced windows sample souce compile error compile humic compile time defines allows you to compile database program compile release not debug to compile angband on dev-cpp compile ubuntu kernel lame compile binary lua compile readline compile command line break compatibility compile instructions studio 10 compile tcl compile dsniff compile kernel mandriva access compile error using len function com