Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got a QVF file in which I'm connecting to a database using OLEDB
when I run the script it finishes successfully
however when I created a task on this QVF file and I run the task I get the below error every time:
Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80004005. ErrorSource: OraOLEDB, ErrorMsg: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Any idea what could possibly be wrong?
kindly advise
Are you running this on the same server machine? If you have multiple nodes, you may be running your manual reload on one node, and the task-based reload on another node which may lack the required TNS information.
Are you running this on the same server machine? If you have multiple nodes, you may be running your manual reload on one node, and the task-based reload on another node which may lack the required TNS information.
I assume this is it
yes the installation is multi-node
sounds reasonable