topic Re: Cant use Oracle onprem as source - Queued in Pipelines

Cant use Oracle onprem as source - Queued

mariussve1 — Tue, 16 Jul 2024 10:17:41 GMT

Hi,

I want to use the Lookup activity against my Oracle Onprem database, but the pipeline is just getting status Queued:

What is really strange is that it works to use the preview:

What can this be? Really need help 🙂

Br
Marius

Here is also the json for the whole pipeline:

{ "name": "OracleOnpremTest", "objectId": "<ObjectId>", "properties": { "activities": [ { "name": "SimpleLookup", "type": "Lookup", "dependsOn": [], "policy": { "timeout": "0.12:00:00", "retry": 0, "retryIntervalInSeconds": 30, "secureOutput": false, "secureInput": false }, "typeProperties": { "source": { "type": "OracleSource", "oracleReaderQuery": "SELECT DATE_KEY FROM SCHEMA.TABLE WHERE DATE_KEY = 20240716", "partitionOption": "None", "queryTimeout": "02:00:00" }, "firstRowOnly": false, "datasetSettings": { "annotations": [], "type": "OracleTable", "schema": [], "externalReferences": { "connection": "<connectionid>" } } } } ], "lastModifiedByObjectId": "<ObjectId>", "lastPublishTime": "2024-07-16T10:07:02Z" } }

Re: Cant use Oracle onprem as source - Queued

Anonymous — Wed, 17 Jul 2024 09:03:56 GMT

Hi mariussve1 ,

A couple of points I wanted to confirm with you: is this the first time you've run this activity, and has there been a similar situation before?

Best Regards,
Adamk Kong

Re: Cant use Oracle onprem as source - Queued

mariussve1 — Fri, 19 Jul 2024 11:28:07 GMT

Hi Anonymous,

I have not been able to use oracle as source or destination in copy activity. Its not working on lookup either. Been like this since day one. But the preview data has worked all the time on both activity.

Does Anyone Get oracle to work in pipeline?

It does work from dataflows, but i need it to work from pipelines as well

Marius

Re: Cant use Oracle onprem as source - Queued

mariussve1 — Mon, 22 Jul 2024 10:32:37 GMT

Friendly reminder Anonymous 🙂

Re: Cant use Oracle onprem as source - Queued

mariussve1 — Sun, 29 Sep 2024 15:21:07 GMT

Hi team,

I still have issues with this, even after the onprem is in GA:
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-2024-release/

Please, does anyone got oracle onprem to work? Let me know