Error: Some formats could not be loaded in the LASR SAS VA 7.5 (SAS 9.4)

[Mahis]

Hello everyone,

We have a datasource that contains a column named address with max length of 222 character, when we tried to preview a sample of its content in sas data query everything was ok, after loading it to the LASR server we have tried to work with it in a  list table but we got this error:

An error occured.com.sas.lasr.LASRException:ERROR:Some formats could not be loaded in the LASR Anatytic Server

[Madelyn_SAS · Accepted solution]

A couple of suggestions: 

• Are you using any picture formats? If so, please see https://support.sas.com/kb/56/402.html
• Are you using any custom / user-defined formats? If so, see https://support.sas.com/kb/47/100.html 

[Mahis]

Thank you for the suggestions.

The issue was with the length of the address column. The original csv file had a maximum length of 222 characters for the address column. but after importing it to the LASR server and working with it in a data query, I found that the length had changed to 145. I tried to change it back to 222, but when I tried to use that column in my list table, I encountered that error of 'some formats ...' and to address this I imported the csv file again using a SAS program instead of the Data Builder import interface and I added the option guessingrows=max to ensure the full length of each column was imported, which resolved the problem.

Thank you 

[SASKiwi]

Please update your post as answered in that case.