Traces data not uploaded to APM with automatic instrumentation

[savansonii]

I have a simple python script that connects with Oracle Database using python-oracledb(oracle db driver) and does db operations.
I am trying to upload the traces to the APM without modifying my script, but I am failing to upload the traces.

I have the following env variable available for automatic:

$ env | grep OTEL
OTEL_EXPORTER_OTLP_TRACES_PROTOCOL=http/protobuf
OTEL_EXPORTER_OTLP_TRACES_HEADERS=api-key=XXXXXXXXX
OTEL_EXPORTER_OTLP_TRACES_ENDPOINT=https://abcabcabc.oci.oraclecloud.com/20200101/opentelemetry/public/v1/traces

I am not getting errors though but data is not uploaded to APM.

Alternatively, I tried modifying my script to instrument it manually, and data traces were uploaded successfully.

Below is the manual instrumented script:

from opentelemetry import trace
from opentelemetry.exporter.otlp.proto.http.trace_exporter import OTLPSpanExporter
from opentelemetry.sdk.trace import TracerProvider
from opentelemetry. sdk.resources import Resource
from opentelemetry.sdk.trace.export import SimpleSpanProcessor

trace.set_tracer_provider(TracerProvider(resource=Resource.create({'service.name': 'database_operation'})))
tracer = trace.get_tracer(__name__)
otlp_exporter = OTLPSpanExporter(endpoint='https://abcabcabc.oci.oraclecloud.com/20200101/observations'
'/public-span?dataFormat=otlp-span&dataFormatVersion=1&dataKey=XXXXXXXX' )
span_processor = SimpleSpanProcessor(otlp_exporter)
trace.get_tracer_provider().add_span_processor(span_processor)

# adding annotation to insert
def insert(_cursor, _emp_info):
    with tracer.start_as_current_span("database_operatation_insert") as span:
        # insert operation 


# adding annotation to select 
def select(_cursor):
    with tracer.start_as_current_span("database_operation_read") as span:
        # read operation

I have tried multiple things, but none of them is working for me, Please let me know how I can upload the traces without modifying the script.
Can someone please look into this and guide me.

[pmcollins]

One debugging option you have is to use a ConsoleSpanExporter to see if any spans are getting exported.

[savansonii]

With ConsoleSpanExporter, Spans are generated.