topic unable to load data in data integration in Developers

unable to load data in data integration

sukalyan — Thu, 07 Mar 2024 09:40:53 GMT

getting error while loading tables in data integaration

while trying to load data in the tables loader getting the following errors.

Re: unable to load data in data integration

LinusH — Thu, 07 Mar 2024 11:34:04 GMT

If you haven't done so already, work closely with you SAS admin to figure out the root cause.

It could be anything from authorization to product/module configuration.

Re: unable to load data in data integration

Patrick — Thu, 07 Mar 2024 12:59:12 GMT

What you see in the prompt as per your screenshot should also be available in the SAS log (the log tab).

Based on the error message there is likely something not o.k. with authdomain odbc_auth_core. If you look into the generated code of this job then you should find somewhere a libname statement that uses this auth domain: libname ... odbc authdomain=odbc_auth_core ....

To isolate the error copy/paste this libname into an EG session and connect to the SAS server the same way as you connect to it via DIS. Then share the error log with your SAS Admin for resolution.