topic Re: Unable to load data to SAS Public LASR server in SAS Visual Analytics

Unable to load data to SAS Public LASR server

chiragjain — Wed, 17 Jan 2018 00:33:13 GMT

Hello,

I have configured SAS/Access ODBC & Oracle libraries in my distributed environment

I am unable to load the data in the Public LASR registered through ODBC.

I receive the following error

ERROR: File VAPUBLIC.{tablename}DATA does not exist.

However, I am able to load the data to ODBC library from the database using the same data library.

Please advise.

Re: Unable to load data to SAS Public LASR server [how to improve your question]

Community_Guide — Wed, 17 Jan 2018 08:29:04 GMT

Hello @chiragjain,

Your question requires more details before experts can help. Can you revise your question to include more information?

Review this checklist:

Specify a meaningful subject line for your topic. Avoid generic subjects like "need help," "SAS query," or "urgent."
When appropriate, provide sample data in text or DATA step format. See this article for one method you can use.
If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.

SAS experts are eager to help -- help them by providing as much detail as you can.

This prewritten response was triggered for you by fellow SAS Support Communities member @JuanS_OCS

Re: Unable to load data to SAS Public LASR server

JuanS_OCS — Wed, 17 Jan 2018 08:31:22 GMT

Hello @chiragjain,

this question seems to be interesting, however, It is not very clear to me, so I don't know right now how to help you.

I would need the code you use for the data load, or details on the steps, tables and flow you follow. Also not very clear your last sentence. Load to ODBC from database? What database?

Thank you in advance,

Kind regards,

Juan

Re: Unable to load data to SAS Public LASR server

alexal — Wed, 17 Jan 2018 13:06:40 GMT

@chiragjain,

Do we have a chance to see full SAS log?