oracle-samples / adbs-tools Goto Github PK

The sql installation script prompts for a number of inputs. there is no guidance on what to enter.
i merely click ok with null value and eventually the install completes.
the signon into the app sometimes does not work. when i do get in and select an icon to install an app i get an error that the session was lost.

hi, finally got the app installed.

OCI_USAGE_DATA_COMPLETE_LOAD
ORA-20000: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-06512: at "ADB$_COST_USAGE.OCI_COST_USAGE_COMPLETE_LOAD", line 264 ORA-06512: at line 2

[unsupported data type]

how do i resubmit the full load ?

seems this is only run during install ? should i run the install again or can i call the procedure from the front end ? what values do i specify here for region id and tenant id. i assume it is not merely the tenancy name

appreciate the feedback.

regards

anton van niekerk

Can we please have a version identifier in the Cost&Usage app? We have the version in the AppStore C&U card but there is no way I have found to see the version of C&U when in the app.

What us the data loading timeframe? I have installed it in a tenancy with data going back several years, will it get all of the data eventually? (I can see two partial days right now). Is this something that can be set?

If someone wants to modify the cost analysis is there any documentation on how to do it? Is it a simple fork in Github, or are there embedded links as part of the install process?

There are installation issues with the AWS_PIPELINE_SETUP procedure. I am attempting to install this in an always free ADB transaction processing database.

The error message I get when I try compiling the procedure is

Error(123,5): PL/SQL: SQL Statement ignored
Error(123,83): PL/SQL: ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5": invalid identifier

The install order is not quite clear. On my first pass I tried to setup the security before running the install and fail on :

EXEC DBMS_CLOUD_ADMIN.ENABLE_AWS_ARN (username => 'ADB$_COST_USAGE');

as the schema is created during the install. I setup the dynamic group and policy, although I wish there was a way of seeing is a resource actually qualifies.

When I install the app first I get an error downloading a cvs file from object storage, although it is a weird namespace (Bling).

On my 4th try it seems to be up. I ran both uninstall scripts and the install script, got the URL, ran the two exec DBMS_CLOUD_ADMIN (note the enable AWS one ran - so I do not think the schema was deleted), then installed the app.

1 error has occurred
Ajax call returned server error ORA-00907: missing right parenthesis for Top Compartments By Cost.

Cost Analysis filters were
Start/End Dates: Mar-24 to Apr-22
Service: Database
Consumed Quantity: All
Group By: Region
Group By Interval: Monthly
Top N: 5
rest are the default settings.

ORA-20000: ORA-29913: error in executing ODCIEXTTABLEFETCH callout-https://objectstorage.eu-amsterdam-1.oraclecloud.com/n/bling/b/ocid1.tenancy.oc1..aaaaaaaahwndog27k6v3fdqj5jgbkrvhhondq6l7i5y47nyfxs24srasd2iq/o/reports/cost-csv/0001000001421182-00001.csv.gz-INSERT INTO oci_cost_usage_summary (reference_number , tenant_id , interval_usage_start , interval_usage_end , service_name , compartment_id , compartment_name , region , availability_domain , resource_id , billed_quantity , billed_quantity_overage, subscription_id , product_sku , product_description , unit_price , unit_price_overage , my_cost , my_cost_ove

[unsupported data type]