topic Error while creating the export definition in SAS Customer Intelligence

Error while creating the export definition

Prashant_82 — Wed, 08 Nov 2017 08:36:15 GMT

I was trying the create the export definition. In this export definition am trying to use the "output type : table" option and at the same time am using the oracle library which is already created i.e, "ORA_CMDM", but when am trying to save the export definition am getting the error "lib name does not exits. You must enter a Libname that exists" . Kindly help me on this.

Re: Error while creating the export definition

Damo — Wed, 08 Nov 2017 15:46:54 GMT

Hi @Prashant_82

Not sure which version you are using but a possible workaround could be to define the library (libname statement) inside your appserver_autoexec.

Can you try that?

Cheers,
Damo

Re: Error while creating the export definition

Dmitry_Alergant — Wed, 08 Nov 2017 19:41:46 GMT

Sorry, that's not the best possible advice. appserver_autoexec gets called way too often in many other situations and you may not want the library to be assigned every time.

The intended solution is to add this library definition into sashome/9.4/SASFoundation/sasautos/mausrexp.sas script. Read the comments there carefully and follow the example provided. It needs to be some macro variable definition, not just a plain libname statement.

P.S> It's definitely a disappointing gap in the product that it requires you to go this far around, rather than automatically and cohesively assigning the library from the metadata definition.