Data Model Loading Failing Even When A Table SAS Name Is Less Than 32 Characters Long
Last updated on JUNE 28, 2018
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.4 to 2.4.7 [Release 2.4]
Information in this document applies to any platform.
Data model with the table having SAS name of length 30 characters is failing in Data Loading.
In DMW SAS log:
ERROR: Invalid macro name LOAD_macro_name. It should be a valid SAS identifier no longer than 32 characters.
ERROR: A dummy macro will be compiled.
The issue can be reproduced at will with the following steps:
1. Have a table with SAS name of 32 characters length within a data model.
2. Install the data model.
3. Load the data.
How many characters long can a SAS identifier have?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms