M20 IBM: Wellbore DDMS Write Welllog Bulk Data : 500: "Unexpected error and save bulk"
Description:
Getting error 500: "Unexpected error and save bulk" while trying to write bulk data
See steps to produce below at step:
- Writing welllog bulk record data
========================
Checking version wellbore DDMS
========================
Request:
GET https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-wellbore/api/os-wellbore-ddms/version
Total time (seconds): 0.867531
Request body:
No content
Response body: 200
{
"service": "Wellbore DDMS OSDU",
"version": "0.2",
"buildNumber": "local",
"release": "M20",
"details": {
"environment_name": "undefined",
"cloud_provider": "ibm",
"de_client_config_timeout": "10",
"enable_read_fast_track": "False",
"read_bulk_backend": "Dask",
"write_bulk_backend": "Dask"
}
}
========================
Checkin health wellbore DDMS
========================
Request:
GET https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-wellbore/api/os-wellbore-ddms/about
Total time (seconds): 0.881274
Request body:
No content
Response body: 200
{
"service": "Wellbore DDMS OSDU",
"version": "0.2",
"buildNumber": "local",
"cloudEnvironment": "ibm",
"release": "M20"
}
========================
Creating legal tag
========================
Request:
POST https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-legal/api/legal/v1/legaltags/
Total time (seconds): 1.342422
Request body:
{
"name": "opendes-chad-test-1042",
"description": "Legal Tag added for Wellbore",
"properties": {
"contractId": "123456",
"countryOfOrigin": [
"US",
"CA"
],
"dataType": "Public Domain Data",
"exportClassification": "EAR99",
"originator": "Schlumberger",
"personalData": "No Personal Data",
"securityClassification": "Private",
"expirationDate": "2025-12-25"
}
}
Response body: 201
{
"name": "opendes-chad-test-1042",
"description": "Legal Tag added for Wellbore",
"properties": {
"countryOfOrigin": [
"US",
"CA"
],
"contractId": "123456",
"expirationDate": "2025-12-25",
"originator": "Schlumberger",
"dataType": "Public Domain Data",
"securityClassification": "Private",
"personalData": "No Personal Data",
"exportClassification": "EAR99"
}
}
========================
Creating well record
========================
Request:
POST https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-wellbore/api/os-wellbore-ddms/ddms/v3/wells
Total time (seconds): 1.786024
Request body:
[
{
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"data": {
"FacilityName": "Facility_chad_4838",
"ExtensionProperties": {
"UWI": "API-123"
}
},
"id": "opendes:master-data--Well:chad_4838",
"kind": "osdu:wks:master-data--Well:1.0.0",
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
}
}
]
Response body: 200
{
"recordCount": 1,
"recordIdVersions": [
"opendes:master-data--Well:chad_4838:1696324382056624"
],
"recordIds": [
"opendes:master-data--Well:chad_4838"
],
"skippedRecordIds": []
}
========================
Getting well record
========================
Request:
Total time (seconds): 1.086779
Request body:
No content
Response body: 200
{
"id": "opendes:master-data--Well:chad_4838",
"version": 1696324382056624,
"kind": "osdu:wks:master-data--Well:1.0.0",
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"US"
]
},
"meta": null,
"data": {
"FacilityName": "Facility_chad_4838",
"ExtensionProperties": {
"UWI": "API-123"
}
},
"createTime": "2023-10-03T09:13:02.511000+00:00",
"createUser": "osdu-bvt@osdu.opengroup.org"
}
========================
Creating wellbore record
========================
Request:
POST https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-wellbore/api/os-wellbore-ddms/ddms/v3/wellbores
Total time (seconds): 1.142243
Request body:
[
{
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"id": "opendes:master-data--Wellbore:chad_4838",
"kind": "osdu:wks:master-data--Wellbore:1.0.0",
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"FR",
"US"
]
},
"data": {
"ExtensionProperties": {
"airGap": {
"unitKey": "ft",
"value": 35.0
},
"country": "United States of America",
"operator": "Francois Vinyes",
"uwi": "33-089-00300-00-01",
"wellboreType": "bypass"
},
"SpatialLocation": {
"Wgs84Coordinates": {
"features": [
{
"geometry": {
"coordinates": [
[
-103.2380248,
46.8925081,
5301.0
],
[
-103.2380248,
46.8925081,
2801.0
],
[
-103.2378748,
46.892608100000004,
301.0
],
[
-103.23742477750001,
46.89270811,
-2199.0
],
[
-103.23667470999663,
46.892808120001,
-4699.0
],
[
-103.2356245974865,
46.892908130002,
-7199.0
]
],
"type": "LineString"
},
"properties": {
"name": "Newton 2-31-Lat-1"
},
"type": "Feature"
}
],
"type": "FeatureCollection"
}
},
"FacilityName": "Faciliity_chad_4838",
"WellID": "opendes:master-data--Well:chad_4838:"
},
"meta": [
{
"kind": "Unit",
"name": "Measure depth default unit",
"persistableReference": "persistableReference",
"propertyNames": [
"symbol"
]
}
]
}
]
Response body: 200
{
"recordCount": 1,
"recordIdVersions": [
"opendes:master-data--Wellbore:chad_4838:1696324385861112"
],
"recordIds": [
"opendes:master-data--Wellbore:chad_4838"
],
"skippedRecordIds": []
}
========================
Getting wellbore record
========================
Request:
Total time (seconds): 1.06321
Request body:
No content
Response body: 200
{
"id": "opendes:master-data--Wellbore:chad_4838",
"version": 1696324385861112,
"kind": "osdu:wks:master-data--Wellbore:1.0.0",
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"FR",
"US"
]
},
"meta": [
{
"kind": "Unit",
"name": "Measure depth default unit",
"persistableReference": "persistableReference",
"propertyNames": [
"symbol"
]
}
],
"data": {
"ExtensionProperties": {
"airGap": {
"unitKey": "ft",
"value": 35.0
},
"country": "United States of America",
"operator": "Francois Vinyes",
"uwi": "33-089-00300-00-01",
"wellboreType": "bypass"
},
"SpatialLocation": {
"Wgs84Coordinates": {
"features": [
{
"geometry": {
"coordinates": [
[
-103.2380248,
46.8925081,
5301.0
],
[
-103.2380248,
46.8925081,
2801.0
],
[
-103.2378748,
46.892608100000004,
301.0
],
[
-103.23742477750001,
46.89270811,
-2199.0
],
[
-103.23667470999663,
46.892808120001,
-4699.0
],
[
-103.2356245974865,
46.892908130002,
-7199.0
]
],
"type": "LineString"
},
"properties": {
"name": "Newton 2-31-Lat-1"
},
"type": "Feature"
}
],
"type": "FeatureCollection"
}
},
"FacilityName": "Faciliity_chad_4838",
"WellID": "opendes:master-data--Well:chad_4838:"
},
"createTime": "2023-10-03T09:13:05.897000+00:00",
"createUser": "osdu-bvt@osdu.opengroup.org"
}
========================
Creating welllog record
========================
Request:
POST https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-wellbore/api/os-wellbore-ddms/ddms/v3/welllogs
Total time (seconds): 1.30426
Request body:
[
{
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"data": {
"Curves": [
{
"CurveID": "GR_ID",
"NumberOfColumns": 1,
"Mnemonic": "GR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:GammaRay:"
},
{
"CurveID": "POR_ID",
"NumberOfColumns": 1,
"Mnemonic": "NPOR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:NeutronPorosity:"
},
{
"CurveID": "Bulk Density",
"NumberOfColumns": 1,
"Mnemonic": "RHOB",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:BulkDensity:"
}
],
"WellboreID": "opendes:master-data--Wellbore:chad_4838:",
"CreationDateTime": "2013-03-22T11:16:03Z",
"VerticalMeasurement": {
"VerticalMeasurement": 2680.5,
"VerticalMeasurementPathID": "opendes:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurementUnitOfMeasureID": "opendes:reference-data--UnitOfMeasure:ft:"
},
"TopMeasuredDepth": 12345.6,
"BottomMeasuredDepth": 13856.25,
"Name": "chad_4838",
"ExtensionProperties": {
"step": {
"unitKey": "ft",
"value": 0.1
},
"dateModified": "2013-03-22T11:16:03Z"
}
},
"id": "opendes:work-product-component--WellLog:chad_4838",
"kind": "osdu:wks:work-product-component--WellLog:1.1.0",
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"US",
"FR"
]
},
"meta": [
{
"kind": "Unit",
"name": "ft",
"persistableReference": "{\"scaleOffset\":{\"scale\":0.3048,\"offset\":0.0},\"symbol\":\"ft\",\"baseMeasurement\":{\"ancestry\":\"Length\",\"type\":\"UM\"},\"type\":\"USO\"}",
"propertyNames": [
"stop.value",
"elevationReference.elevationFromMsl.value",
"start.value",
"step.value",
"reference.unitKey",
"TopMeasuredDepth",
"BottomMeasuredDepth",
"SamplingInterval"
]
},
{
"kind": "DateTime",
"name": "datetime",
"persistableReference": "{\"format\":\"yyyy-MM-ddTHH:mm:ssZ\",\"timeZone\":\"UTC\",\"type\":\"DTM\"}",
"propertyNames": [
"dateModified",
"dateCreated"
]
}
]
}
]
Response body: 200
{
"recordCount": 1,
"recordIdVersions": [
"opendes:work-product-component--WellLog:chad_4838:1696324389357957"
],
"recordIds": [
"opendes:work-product-component--WellLog:chad_4838"
],
"skippedRecordIds": []
}
========================
Getting welllog record
========================
Request:
Total time (seconds): 1.076804
Request body:
No content
Response body: 200
{
"id": "opendes:work-product-component--WellLog:chad_4838",
"version": 1696324389357957,
"kind": "osdu:wks:work-product-component--WellLog:1.1.0",
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"FR",
"US"
]
},
"meta": [
{
"kind": "Unit",
"name": "ft",
"persistableReference": "{\"scaleOffset\":{\"scale\":0.3048,\"offset\":0.0},\"symbol\":\"ft\",\"baseMeasurement\":{\"ancestry\":\"Length\",\"type\":\"UM\"},\"type\":\"USO\"}",
"propertyNames": [
"stop.value",
"elevationReference.elevationFromMsl.value",
"start.value",
"step.value",
"reference.unitKey",
"TopMeasuredDepth",
"BottomMeasuredDepth",
"SamplingInterval"
]
},
{
"kind": "DateTime",
"name": "datetime",
"persistableReference": "{\"format\":\"yyyy-MM-ddTHH:mm:ssZ\",\"timeZone\":\"UTC\",\"type\":\"DTM\"}",
"propertyNames": [
"dateModified",
"dateCreated"
]
}
],
"data": {
"Curves": [
{
"CurveID": "GR_ID",
"NumberOfColumns": 1,
"Mnemonic": "GR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:GammaRay:"
},
{
"CurveID": "POR_ID",
"NumberOfColumns": 1,
"Mnemonic": "NPOR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:NeutronPorosity:"
},
{
"CurveID": "Bulk Density",
"NumberOfColumns": 1,
"Mnemonic": "RHOB",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:BulkDensity:"
}
],
"WellboreID": "opendes:master-data--Wellbore:chad_4838:",
"CreationDateTime": "2013-03-22T11:16:03Z",
"VerticalMeasurement": {
"VerticalMeasurement": 2680.5,
"VerticalMeasurementPathID": "opendes:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurementUnitOfMeasureID": "opendes:reference-data--UnitOfMeasure:ft:"
},
"TopMeasuredDepth": 12345.6,
"BottomMeasuredDepth": 13856.25,
"Name": "chad_4838",
"ExtensionProperties": {
"step": {
"unitKey": "ft",
"value": 0.1
},
"dateModified": "2013-03-22T11:16:03Z"
}
},
"createTime": "2023-10-03T09:13:09.392000+00:00",
"createUser": "osdu-bvt@osdu.opengroup.org"
}
========================
Writing welllog bulk record data
========================
Request:
Total time (seconds): 11.813623
Request body:
{
"columns": [
"GR_ID",
"POR_ID",
"Bulk Density"
],
"index": [
0,
1,
2,
3,
4
],
"data": [
[
0,
1111.1,
2222.1
],
[
0.5,
1111.2,
2222.2
],
[
1,
1111.3,
2222.3
],
[
1.5,
1111.4,
2222.4
],
[
2,
1111.5,
2222.5
]
]
}
Response body: 500
{
"detail": "Unexpected error and save bulk"
}
========================
Getting welllog record
========================
Request:
Total time (seconds): 1.192706
Request body:
No content
Response body: 200
{
"id": "opendes:work-product-component--WellLog:chad_4838",
"version": 1696324389357957,
"kind": "osdu:wks:work-product-component--WellLog:1.1.0",
"acl": {
"viewers": [
"data.default.viewers@opendes.ibm.com"
],
"owners": [
"data.default.owners@opendes.ibm.com"
]
},
"legal": {
"legaltags": [
"opendes-chad-test-1042"
],
"otherRelevantDataCountries": [
"FR",
"US"
]
},
"meta": [
{
"kind": "Unit",
"name": "ft",
"persistableReference": "{\"scaleOffset\":{\"scale\":0.3048,\"offset\":0.0},\"symbol\":\"ft\",\"baseMeasurement\":{\"ancestry\":\"Length\",\"type\":\"UM\"},\"type\":\"USO\"}",
"propertyNames": [
"stop.value",
"elevationReference.elevationFromMsl.value",
"start.value",
"step.value",
"reference.unitKey",
"TopMeasuredDepth",
"BottomMeasuredDepth",
"SamplingInterval"
]
},
{
"kind": "DateTime",
"name": "datetime",
"persistableReference": "{\"format\":\"yyyy-MM-ddTHH:mm:ssZ\",\"timeZone\":\"UTC\",\"type\":\"DTM\"}",
"propertyNames": [
"dateModified",
"dateCreated"
]
}
],
"data": {
"Curves": [
{
"CurveID": "GR_ID",
"NumberOfColumns": 1,
"Mnemonic": "GR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:GammaRay:"
},
{
"CurveID": "POR_ID",
"NumberOfColumns": 1,
"Mnemonic": "NPOR",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:NeutronPorosity:"
},
{
"CurveID": "Bulk Density",
"NumberOfColumns": 1,
"Mnemonic": "RHOB",
"CurveUnit": "opendes:reference-data--UnitOfMeasure:m:",
"LogCurveFamilyID": "opendes:reference-data--LogCurveFamily:BulkDensity:"
}
],
"WellboreID": "opendes:master-data--Wellbore:chad_4838:",
"CreationDateTime": "2013-03-22T11:16:03Z",
"VerticalMeasurement": {
"VerticalMeasurement": 2680.5,
"VerticalMeasurementPathID": "opendes:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurementUnitOfMeasureID": "opendes:reference-data--UnitOfMeasure:ft:"
},
"TopMeasuredDepth": 12345.6,
"BottomMeasuredDepth": 13856.25,
"Name": "chad_4838",
"ExtensionProperties": {
"step": {
"unitKey": "ft",
"value": 0.1
},
"dateModified": "2013-03-22T11:16:03Z"
}
},
"createTime": "2023-10-03T09:13:09.392000+00:00",
"createUser": "osdu-bvt@osdu.opengroup.org"
}