I am getting an ORA-01804 error in my Sensu check. Although when I ran my sensu script in the terminal, I get the result that I want. But when Sensu Client picks it up, I can see in Uchiwa and the log files the following:
{“timestamp”:“2017-09-10T12:11:44.300319+0000”,“level”:“info”,“message”:“publishing check result”,“payload”:{“client”:“OTM”,“check”:{“type”:“metric”,“command”:"/opt/sensu/embedded/bin/metrics-stale-transmissions.rb -s 30",“interval”:600,“handle_when”:{“reset”:600},“standalone”:true,“payload-type”:“json”,“name”:“stale-transmission”,“issued”:1505045504,“executed”:1505045504,“duration”:0.283,“output”:"oci8lib.c:280:in oci8lib_240.so: Error while trying to retrieve text for error ORA-01804 (OCIError)\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:55:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/gems/2.4.0/gems/ruby-oci8-2.2.4.1/lib/oci8.rb:107:in<top (required)>’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:inrescue in require’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:40:in require'\n\tfrom /opt/sensu/embedded/bin/sqlcore.rb:4:in<top (required)>’\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in require_relative'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in
'\n",“status”:3}}}
``
I researched and found that I just need to properly set my environment variables. And after looking into them, they are indeed properly set but still this error persists
Hey Peter! I know it’s been a little while on this one. Have you made any progress you can share? If not, bumping this back up into people’s inbox. Good luck!
On Sunday, September 10, 2017 at 5:37:56 AM UTC-7, Peter wrote:
Hi Experts,
I am getting an ORA-01804 error in my Sensu check. Although when I ran my sensu script in the terminal, I get the result that I want. But when Sensu Client picks it up, I can see in Uchiwa and the log files the following:
{“timestamp”:“2017-09-10T12:11:44.300319+0000”,“level”:“info”,“message”:“publishing check result”,“payload”:{“client”:“OTM”,“check”:{“type”:“metric”,“command”:“/opt/sensu/embedded/bin/metrics-stale-transmissions.rb -s 30”,“interval”:600,“handle_when”:{“reset”:600},“standalone”:true,“payload-type”:“json”,“name”:“stale-transmission”,“issued”:1505045504,“executed”:1505045504,“duration”:0.283,“output”:"oci8lib.c:280:in oci8lib_240.so: Error while trying to retrieve text for error ORA-01804 (OCIError)\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:55:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/gems/2.4.0/gems/ruby-oci8-2.2.4.1/lib/oci8.rb:107:in<top (required)>‘\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:inrescue in require’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:40:in require'\n\tfrom /opt/sensu/embedded/bin/sqlcore.rb:4:in<top (required)>'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in require_relative'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in
'\n",“status”:3}}}
``
I researched and found that I just need to properly set my environment variables. And after looking into them, they are indeed properly set but still this error persists