Opentelemetry is not tracing database (oracle) calls via .net application hosted on iis manager #4039
Replies: 3 comments 7 replies
-
|
Could you please share with us reproducible example? We do not need your closed source application, only the scaffolding with the dummy logic. It will be easier to advice what can be wrong. |
Beta Was this translation helpful? Give feedback.
-
|
I cannot download oracle.managedDataAccess lower version 4.122.23.1, i couldn't find. See below recent logs shows it got loaded, but i don't see db metrics / traces yet [2025-02-14T13:51:53.721490100Z] [67636|39200] [debug] ModuleLoadStarted: 140728332771224 |
Beta Was this translation helpful? Give feedback.
-
|
|
Beta Was this translation helpful? Give feedback.
-
|
Hi Kielek, Thanks for your reply. OracleManagedDataAccess version is 23 but i am not sure why assembly take version 4. see below version PS C:\Windows\system32> [System.Reflection.Assembly]::LoadFrom("C:\Program Files\OpenTelemetry .NET AutoInstrumentation Major Minor Build Revision 4 122 23 1 Do i need to have oracleManagedDataAccess version of 4, if yes, i don't see nuget package available for older version. |
Beta Was this translation helpful? Give feedback.
-
|
I have recently downgraded oracleManagedDataAccess.dll version 12.1.21, but still same no improvement. see below why i am getting null and assembly closure event comes from opentelemetry logs [2025-02-20T07:21:12.5282629Z] [Debug] Requester [] requested [Oracle.ManagedDataAccess] [2025-02-20T07:21:31.960252200Z] [51636|44440] [debug] GetAssemblyReferences extending assembly closure for Oracle.ManagedDataAccess to include 0000024CC620FB20. Path=000000B931BF9DF0 |
Beta Was this translation helpful? Give feedback.
-
|
@francisxx01 were you able to get this resolved? |
Beta Was this translation helpful? Give feedback.
-
|
Application:- Apriso hosted on IIS manager as app pool We want to monitor application (Apriso) using opentelemetrics .net agent. Opentelemetric agent send the logs, traces and metrics to Elastic search cluster, we use kibana for visulization. It is auto instrumentation, we just added environment variable for system and restarted iis. we have shared open telemetry agent logs above. In kibana we can see application metrics and traces but it couldn't show db traces at kibana console. |
Beta Was this translation helpful? Give feedback.
-
|
SIG: @francisxx01 closing this due to lack of activity, feel free to ping us if you can give more details about it |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Hi Team,
We have installed opentelmetry agent using auto instrumentation for iis manager, it is collecting application response time etc., but it failed to collect db tracing like db calls, db query which application makes db calls etc.,
I have added below environment variable however all of below didn't help us to get db related metrics.
OTEL_DOTNET_AUTO_INSTRUMENTATION_ENABLED
OTEL_DOTNET_AUTO_INSTRUMENTATION_INCLUDE_SQLCLIENT
OTEL_DOTNET_AUTO_TRACE_ENABLED
OTEL_DOTNET_AUTO_METRICS_ENABLED
OTEL_DOTNET_AUTO_LOGS_ENABLED
OTEL_DOTNET_AUTO_SQLCLIENT_SET_DBSTATEMENT
OTEL_DOTNET_AUTO_INSTRUMENTATION_LOG_LEVEL
OTEL_DOTNET_AUTO_DEBUG=TRUE
OTEL_DOTNET_AUTO_TRACES_ADDITIONAL_SOURCES=Oracle.ManagedDataAccess.Client
OTEL_DOTNET_AUTO_SQLCLIENT_SET_DBSTATEMENT_FOR_TEXT
OTEL_DOTNET_AUTO_ENTITYFRAMEWORKCORE_SET_DBSTATEMENT_FOR_TEXT
OTEL_DOTNET_AUTO_ORACLEMDA_SET_DBSTATEMENT_FOR_TEXT
OTEL_DOTNET_AUTO_GRAPHQL_SET_DOCUMENT
ELASTIC_APM_OPENTELEMETRY_BRIDGE_ENABLED
OTEL_DOTNET_AUTO_LOG_DIRECTORY: C:\Program Files\OpenTelemetry .NET AutoInstrumentation
OTEL_LOG_LEVEL: debug
OTEL_EXPORTER_OTLP_ENDPOINT: http://:8200
OTEL_METRICS_EXPORTER: otlp
OTEL_LOGS_EXPORTER: otlp
OTEL_TRACES_EXPORTER=otlp
OTEL_RESOURCE_ATTRIBUTES: service.name=Apriso,service.version=2019,deployment.environment=development
At logs
[2025-02-12T18:40:43.2038278Z] [Debug] Requester [] requested [Oracle.ManagedDataAccess]
[2025-02-12T18:40:43.2038278Z] [Debug] Requester [] requested [Oracle.ManagedDataAccess]
[2025-02-12T18:40:43.2038278Z] [Debug] Requester [] requested [Oracle.ManagedDataAccess]
[2025-02-12T18:40:43.2194449Z] [Debug] Requester [] requested [Oracle.ManagedDataAccess]
[debug] GetAssemblyReferences extending assembly closure for System.Data.OracleClient to include 000001C331E19560. Path=0000000E75DF8380
[debug] GetAssemblyReferences extending assembly closure for Oracle.ManagedDataAccess to include 000001C331E19560. Path=0000000E75D77910
[debug] RedirectAssemblyReferences: AssemblyRef for [System.Data.OracleClient] version=4.0.0.0
[2025-02-12T18:40:38.821516800Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [Oracle.ManagedDataAccess] version=4.122.1.0
[debug] ModuleLoadFinished: 140728333178504 Oracle.ManagedDataAccess AppDomain 140729914484016 [EE Shared Assembly Repository] | IsNGEN = false | IsDynamic = false | IsResource = false
[2025-02-12T18:40:43.192839100Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [mscorlib] version=4.0.0.0
[2025-02-12T18:40:43.192850700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System] version=4.0.0.0
[2025-02-12T18:40:43.192857900Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Configuration] version=4.0.0.0
[2025-02-12T18:40:43.192863700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Data] version=4.0.0.0
[2025-02-12T18:40:43.192908700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Data.Entity] version=4.0.0.0
[2025-02-12T18:40:43.192913600Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Transactions] version=4.0.0.0
[2025-02-12T18:40:43.192917700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Xml] version=4.0.0.0
[2025-02-12T18:40:43.192921700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Core] version=4.0.0.0
[2025-02-12T18:40:43.192925700Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.DirectoryServices.Protocols] version=4.0.0.0
[2025-02-12T18:40:43.192930200Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.EnterpriseServices] version=4.0.0.0
[2025-02-12T18:40:43.192935100Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Xml.Linq] version=4.0.0.0
[2025-02-12T18:40:43.192940400Z] [7960|13644] [debug] RedirectAssemblyReferences: AssemblyRef for [System.Drawing] version=4.0.0.0
[2025-02-12T18:40:43.192943100Z] [7960|13644] [debug] RedirectAssemblyReferences: EnumAssemblyRefs returned S_FALSE assembly_refs_count=0
[2025-02-12T18:40:43.192950700Z] [7960|13644] [debug] ModuleLoadFinished: done Oracle.ManagedDataAccess v4.122.1.0
[2025-02-12T18:40:43.192956000Z] [7960|13644] [debug] RejitHandler::EnqueueRequestRejitForLoadedModules
[2025-02-12T18:40:43.193093000Z] [7960|21392] [debug] Requesting Rejit for Module: Oracle.ManagedDataAccess
[2025-02-12T18:40:43.193133200Z] [7960|21392] [debug] Loading Assembly Metadata...
[2025-02-12T18:40:43.193146100Z] [7960|21392] [debug] Assembly Metadata loaded for: Oracle.ManagedDataAccess(4.122.1.0).
[2025-02-12T18:40:43.193185400Z] [7960|13644] [debug] Total number of ReJIT Requested: 0
[2025-02-12T18:40:43.193196600Z] [7960|13644] [debug] AssemblyLoadFinished: 1957819355264 0
[2025-02-12T18:40:43.315996000Z] [7960|13644] [debug] AssemblyLoadStarted: 1957819353824
[2025-02-12T18:40:43.316007600Z] [7960|13644] [debug] ModuleLoadStarted: 140728333633312
[2025-02-12T18:40:43.316150400Z] [7960|13644] [debug] ModuleLoadFinished: 140728333633312 Microsoft.GeneratedCode AppDomain 1957483854288 [/LM/W3SVC/1/ROOT/Apriso/Portal-1-133838592291341809] | IsNGEN = false | IsDynamic = true | IsResource = false
[2025-02-12T18:40:43.316154400Z] [7960|13644] [debug] ModuleLoadFinished skipping Dynamic module: 140728333633312 Microsoft.GeneratedCode
[2025-02-12T18:40:43.316158000Z] [7960|13644] [debug] AssemblyLoadFinished: 1957819353824 0
Beta Was this translation helpful? Give feedback.
All reactions