Cant use Oracle onprem as source - Queued

[mariussve1]

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"
    }
}

[mariussve1]

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

[mariussve1]

Friendly reminder @Anonymous 🙂

[Anonymous]

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

[mariussve1]

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

br

Marius