Error Message: Metadata contains a reference that cannot be resolved: ''
Action:
When running package manually the package runs fine, but when running the package through a SQL Agent job it fails with the following error message.
Error Message:
Metadata contains a reference that cannot be resolved: ''
Note: Error Message indicates an address that cannot be resolved.
Solutions:
COZYROC's connector will follow certain back and forth communication with the service to find what specific service address it should connect to. The error above states that it cannot resolve the specific address shown. This indicates that the network domain configuration is not permitting the SQL Job agent service to connect to the remote URL address. You may need to log into the server as the SQL Service account and manually add proxy settings for Internet Explorer to allow the account to browse remote URL's.
You may also be able to accomplish the same result by specifying parameters in the "Proxy" tab of the Dynamics CRM connection manager.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: "Could not initialize component for use in the designer."
Action: While creating a new CRM destination, the following error is encountered. Error Message: TITLE: Microsoft Visual Studio ------------------------------ The component could not be added to the Data Flow task. Verify that this component is ...Can I use Modern Authentication with the Dynamics CRM Adapters?
COZYROC Dynamics CRM Components do not support Modern Authentication. Our Dynamics CRM components use Microsoft Dynamics CRM WCF API, which is not compatible with Modern Authentication. If you prefer to use Modern Authentication to connect to ...When I try to select entity in Dynamics CRM Source component I get error: "No connection could be made because the target machine actively refused it". Dynamics CRM Connection Manager 'Test Connection' command works fine.
If you have recently reinstalled your Dynamics CRM server and selected different access port, you have to make additional updates on your server. For more information review KB947423.Error Message:Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds.
Action: We started having random failures with an SSIS package that loads data from SQL Server to Dynamics (and back). Error Message: “Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 ...Error Message: Delegate token node not found.
Action: When using the Dynamics CRM source from the CozyRoc CRM connection manager, the following error message is received. The connection tests successfully and viewing data through the data flow task is possible, but it failed with the error ...