BookmarkSubscribeRSS Feed
RyanK
Obsidian | Level 7

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.

Any insight is appreciated.

Thanks,

Ryan

2 REPLIES 2
jakarman
Barite | Level 11

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).

---->-- ja karman --<-----
RyanK
Obsidian | Level 7

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.

Sounds like it is time to open a track.

Thanks,

Ryan

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1397 views
  • 3 likes
  • 2 in conversation