Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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"
}
}
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
Friendly reminder @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
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