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

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

Mahis — Mon, 12 Feb 2024 15:51:58 GMT

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

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

Madelyn_SAS — Tue, 13 Feb 2024 19:40:45 GMT

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

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

Mahis — Wed, 14 Feb 2024 12:16:09 GMT

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

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

SASKiwi — Wed, 14 Feb 2024 19:05:39 GMT

Please update your post as answered in that case.