I have a cloud service configured to save off custom ETW logs with Azure Diagnostics. I can browse the table fine with table explorer and it has data in it. When trying to consume the table with the azurewadtable plugin, I get: Oh My, An error occurred. {:exception=>#<Azure::Core::Http::HTTPError: InvalidInput (400): One of the request inputs is not valid.
I verified these tables do have PreciseTimeStamp fields and have verified the account name/key.
Whats the best way to troubleshoot this?
Full debug output / stacktrace:
←[36mReading config file {:file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/agent.rb", :level=>:debug, :line=>"309", :method=>"local_config"}←[0m
←[36mCompiled pipeline code:
@inputs = []
@filters = []
@outputs = []
@periodic_flushers = []
@shutdown_flushers = []
@input_azurewadtable_1 = plugin("input", "azurewadtable", LogStash::Util.hash_merge_many({ "account_name" => ("my_account_name") }, { "access_key" => ("my_account_key") }, { "table_name" => ("WADReceivedMessageTable") }))
@inputs << @input_azurewadtable_1
def filter_func(event)
events = [event]
@logger.debug? && @logger.debug("filter received", :event => event.to_hash)
events
end
def output_func(event)
@logger.debug? && @logger.debug("output received", :event => event.to_hash)
end {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb", :line=>"29", :method=>"initialize"}←[0m
←[36mPlugin not defined in namespace, checking for plugin file {:type=>"input", :name=>"azurewadtable", :path=>"logstash/inputs/azurewadtable", :level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/plugin.rb", :line=>"133", :method=>"lookup"}←[0m
←[33mazurewadtable plugin is using the 'milestone' method to declare the version of the plugin this method is deprecated in favor of declaring the version inside the gemspec. {:level=>:warn, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"139", :method=>"milestone"}←[0m
←[32mUsing version 0.9.x input plugin 'azurewadtable'. This plugin should work but would benefit from use by folks like you. Please let us know if you find bugs or have suggestions on how to improve this plugin. {:level=>:info, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"227", :method=>"print_version_notice"}←[0m
←[36mPlugin not defined in namespace, checking for plugin file {:type=>"codec", :name=>"plain", :path=>"logstash/codecs/plain", :level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/plugin.rb", :line=>"133", :method=>"lookup"}←[0m
←[36mconfig LogStash::Codecs::Plain/@charset = "UTF-8" {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@account_name = "my_account_name" {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@access_key = "my_account_key" {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@table_name = "WADReceivedMessageTable" {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@debug = false {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@codec = <LogStash::Codecs::Plain charset=>"UTF-8"> {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@add_field = {} {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@entity_count_to_process = 100 {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@collection_start_time_utc = "2015-08-27 15:53:36 UTC" {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@etw_pretty_print = false {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mconfig LogStash::Inputs::AzureWADTable/@idle_delay_seconds = 15 {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/config/mixin.rb", :line=>"111", :method=>"config_init"}←[0m
←[36mStarting process method @2015-08-27 08:53:36 -0700 {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb", :line=>"41", :method=>"run"}←[0m
←[32mPipeline started {:level=>:info, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb", :line=>"87", :method=>"run"}←[0m
←[36m2015-08-27 15:53:36 UTC {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb", :line=>"53", :method=>"process"}←[0m
←[36mcollection time parsed successfully 2015-08-27 15:53:36 UTC {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb", :line=>"109", :method=>"partitionkey_from_datetime"}←[0m
Logstash startup completed
←[36mConverting time to ticks {:level=>:debug, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb", :line=>"121", :method=>"to_ticks"}←[0m
←[31mOh My, An error occurred. {:exception=>#<Azure::Core::Http::HTTPError: InvalidInput (400): One of the request inputs is not valid.
RequestId:ab95e112-0002-006f-1ce0-e033e2000000
Time:2015-08-27T15:53:42.3490985Z>, :level=>:error, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb", :line=>"98", :method=>"process"}←[0m
←[31mA plugin had an unrecoverable error. Will restart this plugin.
Plugin: <LogStash::Inputs::AzureWADTable account_name=>"my_account_name", access_key=>"my_account_key", table_name=>"WADReceivedMessageTable", debug=>false, codec=><LogStash::Codecs::Plain charset=>"UTF-8">, entity_count_to_process=>100, collection_start_time_utc=>"2015-08-27 15:53:36 UTC", etw_pretty_print=>false, idle_delay_seconds=>15>
Error: InvalidInput (400): One of the request inputs is not valid.
RequestId:ab95e112-0002-006f-1ce0-e033e2000000
Time:2015-08-27T15:53:42.3490985Z
Exception: Azure::Core::Http::HTTPError
Stack: c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/http_request.rb:151:in call' org/jruby/RubyMethod.java:116:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/signer_filter.rb:29:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/http_request.rb:84:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/service.rb:47:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/filtered_service.rb:33:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/signed_service.rb:39:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/table/table_service.rb:252:in
query_entities'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:57:in process' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:42:in
run'
org/jruby/RubyKernel.java:1511:in loop' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:40:in
run'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb:177:in inputworker' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb:171:in
start_input' {:level=>:error, :file=>"/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb", :line=>"182", :method=>"inputworker"}←[0m
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/http_request.rb:151:in call' org/jruby/RubyMethod.java:116:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/signer_filter.rb:29:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/http/http_request.rb:84:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/service.rb:47:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/filtered_service.rb:33:in
call'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/core/signed_service.rb:39:in call' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/azure-0.6.4/lib/azure/table/table_service.rb:252:in
query_entities'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:57:in process' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:42:in
run'
org/jruby/RubyKernel.java:1511:in loop' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-azurewadtable-0.9.2/lib/logstash/inputs/azurewadtable.rb:40:in
run'
c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb:177:in inputworker' c:/elk/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-1.5.4-java/lib/logstash/pipeline.rb:171:in
start_input'