millerhoo / journey4-adwc Goto Github PK

hi,

i am using sample data with "|" as a delimiter as attached
coun_v3.txt

When i tried to do data load , using SQL, from object storage to ADW, i got an error as below.
Error report -
ORA-44003: invalid SQL name
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 798
ORA-06512: at "SYS.DBMS_ASSERT", line 216
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 699
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 816
ORA-06512: at line 2
44003. 0000 - "invalid SQL name"
*Document: Yes
*Cause: The input parameter string was not a valid simple SQL name.
*Action: Check with the DBMS_ASSERT spec to verify that the parameter
string is a valid simple SQL name.

When i use import wizard from SQL developer, it seems to have more columns than expected.
screenshot

how to fix this?

Hi ,
I have created Data integration platform cloud instance in oracle cloud. But I am not able to get IP address of the instance. I raised request to Oracle cloud support for same. But they are saying it is oracle managed and I cannot access VM for this service.

I want to create data store connection in EDQ with autonomous data warehouse . as per below link i should access VM to modify jvm.properties to accss Autonomous data warehouse from EDQ data store via tns files

https://oracle.github.io/learning-library/workshops/journey4-adwc/?page=LabGuide10.md#

please help me regarding how to access VM for Data integration platform service when oralce is saying i cannot access it

ADWC Workshop Lab 300
https://oracle.github.io/learning-library/workshops/journey4-adwc/?page=LabGuide300.md

Goal:
Import data using SQL Developer for data located in object storage.

Tried using:
1/ template (https://swiftobjectstorage.<region_name>.oraclecloud.com/v1/<tenant_name>/<bucket_name>/<file_name>)
2/ URL Path (URI) (from clicking on 'details' of the object)

Error received:
ORA-20404: Object not found

Application Used:
SQL Developer, import data

Values used:
https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/gse00013865/ADW-Lab/customers.csv
https://objectstorage.us-ashburn-1.oraclecloud.com/n/gse00013865/b/ADW-Lab/o/customers.csv

Auth Token Created:
Yes

Not sure if I have a typo in my constructed URL... Please advise.

Thanks!
Thuymy Tran

Hi, LabGuideDIPC.md (https://github.com/millerhoo/journey4-adwc/blob/master/workshops/journey4-adwc/LabGuideDIPC.md) - STEP 1, the instructions link to provision DBCS and DIPC service is not working.

Page no long exists (https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/create-user-managed-data-integration-platform-cloud-instances.html)

Can you pls provide the working link?

Lab 3 Step 7 - Detailed URI no longer shown in object storage details

Thanks,
Greg Walters (Oracle ECA)

Hi,
Please help to check the following issue.
Hit error while trying to load data from object store in sql developer.

1. create the credential.
   --If you have your own OCI Object Store username and password, replace them here.
   set define off
   begin
   DBMS_CLOUD.create_credential(
   credential_name => 'OBJ_STORE_CRED',
   username => 'adwc_oss_access',
   password => '6:rg1JlPUKge&&)jO$_v'
   );
   end;
   /
   set define on

2. hit error in sql developer.
   An error was encountered performing the requested operation:

ORA-20401: Request failed with status 401 - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/dwcsdemo/DEMO_DATA/channels.csv
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 886
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_INTERNAL", line 2165
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_REQUEST", line 939
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_REQUEST", line 667
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_REQUEST", line 904
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_INTERNAL", line 2127
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD_INTERNAL", line 2188
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 876
ORA-06512: at line 1

Vendor code 20401

regards
Henry

Lab 4 of the above named subject is missing the below final exercise
Learn how to create data warehouse user

I am not able to see "Admin" in data set after selecting the connection.

In the ADWC workshop:
https://apexapps.oracle.com/pls/apex/f?p=44785:50:17343741868160:::50:P50_COURSE_ID,P50_EVENT_ID:251,5925

Lab 10 has a link in Step 1 called "instructions" for setting up the DIPC & DBCS services
this link is returning a 404:
https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/oci-classic.html

We few hubsters at SM hub, cloud coaching the customers on ADWC labs and we are following https://oracle.github.io/learning-library/workshops/journey4-adwc/?page=LabGuide3.md (step 10) . While trying to load data from Object Storage we are facing the issues (Screenshot attached). We have double checked all connection details and url , everything seems to be correct . So unable to figure out what else is causing the issue. Any idea what is missing ? Any help is appreciated!

Hi,

In the https://oracle.github.io/learning-library/workshops/journey4-adwc/?page=LabGuide100StartHereNEW.md lab, there is a step: Step --> Then specify the password for the instance The screen shots change from 2 CPUs and 1 TB to 2 CPUs and 8 TB of storage. They should be consistant to 1 TB. Image name and beyond in the steps - https://oracle.github.io/learning-library/workshops/journey4-adwc/images/100/Picture100-29.jpeg

Observation: I am working on the OCI environment. I connected visual desktop to ADWC and running a query. Query times are extremely slow. I scaled the service to 2 OCPUs and still running slow. Is this expected behavior? I am unsure since I dont have a baseline. Any recommendations are appreciated.

Instance: SachinDW

Thanks
Sachin