Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
- Find Answers
- :
- About harshavrath
harshavrath
Contributor
Member since:
02-19-2014
06-05-2020
Community Statistics
| Posts | 152 |
| Solutions | 1 |
| Karma Given | 68 |
| Karma Received | 3 |
| Member Since | 02-19-2014 |
Activity Feed
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Database Connection for kaufmanm. 06-05-2020 12:46 AM
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for MuS. 06-05-2020 12:46 AM
- Karma Re: Database Connection for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for dart. 06-05-2020 12:46 AM
- Karma Re: Getting Data from Database's for Ayn. 06-05-2020 12:46 AM
- Karma Re: Splunk Forwarder,Installation for alacercogitatus. 06-05-2020 12:46 AM
- Karma Re: Installation for MuS. 06-05-2020 12:46 AM
- Karma Re: Splunk Installation for richgalloway. 06-05-2020 12:46 AM
- Karma Re: Disk Space Error for dmaislin_splunk. 06-05-2020 12:46 AM
- Karma Re: Delete/clean all the contents of splunk for chimbudp. 06-05-2020 12:46 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
04-15-2014
08:37 AM
Hi till yesterday java bridge was up & running from today its not.
2014-04-15 11:30:28,273 ERROR Java process returned error code 1! Error: Initializing Splunk context... Environment: SplunkEnvironment{SPLUNK_HOME=C:\Program Files\Splunk,SPLUNK_DB=C:\Program Files\Splunk\var\lib\splunk} Configuring Log4j... [Fatal Error] :1:1: Premature end of file. Exception in thread "main" com.splunk.config.SplunkConfigurationException: Error creating PersistentValueStore type xstream: com.thoughtworks.xstream.io.StreamException: : Premature end of file. at com.splunk.persistence.PersistentValueStoreFactory.createStoreInstance(PersistentValueStoreFactory.java:119) at com.splunk.persistence.PersistentValueStoreFactory.createStore(PersistentValueStoreFactory.java:71) at com.splunk.persistence.PersistentValueStoreFactory.createGlobalStore(PersistentValueStoreFactory.java:51) at com.splunk.env.SplunkContext.initialize(SplunkContext.java:108) at com.splunk.bridge.JavaBridgeServer.main(JavaBridgeServer.java:34) Caused by: com.thoughtworks.xstream.io.StreamException: : Premature end of file. at com.thoughtworks.xstream.io.xml.DomDriver.createReader(DomDriver.java:105) at com.thoughtworks.xstream.io.xml.DomDriver.createReader(DomDriver.java:81) at com.thoughtworks.xstream.XStream.fromXML(XStream.java:904) at com.splunk.persistence.impl.XStreamStore.loadState(XStreamStore.java:113) at com.splunk.persistence.impl.XStreamStore.<init>(XStreamStore.java:49) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.splunk.util.Utils$Reflection.instantiate(Utils.java:880) at com.splunk.persistence.PersistentValueStoreFactory.createStoreInstance(PersistentValueStoreFactory.java:117) ... 4 more Caused by: org.xml.sax.SAXParseException: Premature end of file. at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:249) at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:284) at com.thoughtworks.xstream.io.xml.DomDriver.createReader(DomDriver.java:98) ... 14 more
... View more
04-15-2014
12:29 AM
try this even this works
fieldformat new_date=strftime(dat_field,"%d-%m-%Y %H: %M: %S")
... View more
04-14-2014
11:49 PM
the date format that you are getting is an EPOCH time you can convert it by
to__char(date_field, 'DD-MON-YYYY HH24:MI:SS')
ex:SELECT to__char(date_filed, 'dd-mm-yyyy hh24:mi:ss AM') FROM table_name
... View more
04-14-2014
07:36 AM
Simple Select stmt will work under DB-Query.
... View more
04-14-2014
07:34 AM
I figured it by reading few other posts Under "DB Query" no need of using below query it gives an error the
| dbquery "DB___NAME" "SELECT * FROM TABLE-NAME" LIMIT=100
Just SELECT * FROm TABLE-NAME will work
... View more
04-14-2014
03:37 AM
The License usage states that 500MB/perDay so can i index 400MB of data today & 400MB of Data tomorrow.
... View more
04-14-2014
03:30 AM
The License usage states that 500MB/perDay so can i index 400MB of data today & 400MB of Data tomorrow.
... View more
04-14-2014
02:54 AM
HI,
I have so far indexed 38,442 of data into Splunk, how much is it when converted to MB & what will happen when i cross my 500MB limit.?
Any Help is Appreciated,
Thanks.
... View more
04-10-2014
07:16 AM
Thanks a lot Aelliott.
... View more
04-10-2014
07:15 AM
its working now the reason that it did not work the previous time is, i used CREATED_DT field twice i mean in the query as to_char(CREATED_DT,''YYYY-MM-DD HH24:MI:SS') & used the same field for Time-Stamp(Increasing Value) so it was giving an Error.
... View more
04-10-2014
02:58 AM
I found the answer myself just to_char(date_attribute,'YYYY-MM-DD HH24:MI:SS')date_attribute will work no need of trying to convert it by multiplying & dividing the current time with 1970.
... View more
04-08-2014
08:40 AM
Sorry nothing is indexed till now,i meant there are 2 Inputs under DB-Inputs.
1 dbmon-tail://DB_NM/Table_NM
2 dbmon-tail://DB_NM/Table_NM
... View more
04-08-2014
08:33 AM
I'm successfully able to run the query in DB-Query & its resulting 30 Records.
... View more
04-08-2014
08:30 AM
In the Error-log I'm getting
main:ERROR:Database - Database validation failed for database
... View more
04-08-2014
08:27 AM
after clone option there are 2 Events under Database Inputs.
... View more
04-08-2014
08:22 AM
the query that i used is
SELECT (some 18 attributes) to_char(CREATED_DT, 'DD-MON-YYYY HH24:MI:SS AM')FROM table_NM WHERE ROWNUM<=30 AND TRUNC(CREATED_DT) BETWEEN to_date('04-08-2014','mm/dd/yyyy') AND to_date('04-08-2014','mm/dd/yyyy') {{AND $rising_column$ > ?}} ORDER BY CREATED_DT ASC
... View more
04-08-2014
08:16 AM
its not working the status is still the same "waiting for Inputs" its not indexing.
... View more
04-08-2014
07:54 AM
i did not use the clone option,I deleted the index from the inputs page after that i even deleted the folder where my indexed data was placed.
... View more
04-08-2014
07:41 AM
hey after deleting the old index when i tried to index its not indexing.
... View more
04-08-2014
04:32 AM
I will be indexing my DB table under DB Inputs.Using Input_Type=tail.
... View more
04-08-2014
04:30 AM
Sorry linu i couldn't understand you, can you be a bit more specific.
... View more
04-08-2014
03:06 AM
I need the query as i would be using it to input a table & index into Splunk.
... View more
04-08-2014
02:15 AM
Hi,
I need to convert the EPOCH Time using Oracle Query,by using DB Query i have figured out using the below query it can be done
|dbquery DB_NAME limit=10 "Select * from Table_NM" |fieldformat NEW_CREATED_DT=strftime(CREATED_DT,"%d-%m-%y %H:%M:%S")
But i want the query that can be used in Oracle.
Any Help is Appreciated,
Thanks.
... View more
04-04-2014
07:07 AM
i can't do it now my manager wants to check it now,I will do it on Monday.
... View more
