I am encountering a failure in fscreate that is posting an error message to the user's HPF log. It is something we have encountered before, and know how to resolve. Unfortunately, the HPF log is not stating the exact timeseries that is causing the error.
eERROR: Exception caught during diagnostics of the variable TOTAL_ADJ_SALES_QTY_PSA.
nNOTE: BY line has been truncated at least once.
nNOTE: The above message was for the following BY group:
n CLASS_CLUSTER=00012038 JCE/DRINKS-SHLF STBL_123481 SUBCLASS_CLUSTER=' 35 POWDERED_123481'
In this case, I know the BY variable is SKU_CLUSTER, which is not being listed in the error at all. The apparent answer is to set linesize=max, from the current setting of 102. However, I cannot get the setting to take. It is being set in a custom options.sas file, which is being called in appserver_autoexec_usermods.sas. This method is being used successfully for other options and variables. My best guess is that the setting is being overridden somewhere else, but I have been able to determine where. Any other references to linesize that have been found also set to max. I have cycled all the associated services to no avail.
There is not one autoexec_usermods.sas there are many.
a/ The autoexec is for statements the config for options, check the config.sas files. b/ It is at each appserver level as default and usermods, it is at each server (WS SP) as default and usermods
c/ It is at the configuration-level and
d/ and the installation level (Foundation) and as default within modules installation and config-files.
f/ It can be hidden in the startup-source of a solution. Having seen this with Eminer start.
g/ A solution can offer his own modifications after the start.
That are a very lot locations and files were some sas setting can be done.
You have to deduce that to a more understandable selection. When this process is started using a WS server. Start a SAS session using the WS-os script there and verify all options/settings (using a base-foundation classic approach).
Thanks Jaap. I mapped out all the references to different autoexecs and configuration files, but could only find the definition to be max. I am leaning towards your options f or g, especially after a text search of the configuration directories and SAS installation did not turn up anything else. When I use EG to connect to the SASApp workspace server, I get 102, but when I connect to SASMeta it picks up the max setting.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.