OHDSI Home | Forums | Wiki | Github

Usagi - Java Number Format Error

I am attempting to create a mapping with Usagi and getting the following error that is applied to my counts column:

java.lang.NumberFormatException: For Input string: “”

I know it relates to the counts column because I can perform the import if I do not specify a counts column. I have checked and do not believe that there are any blank string values for this column (e.g. I am able to import the file into a dataframe and assign type Int to the column with all rows having a value).

Has anyone run into a similar problem or does anyone have any suggestions?

I am running Usagi on Linux.



Attempted this on a Windows server and got the same error.

Solved by deleting last line of the file, unclear why this caused an error, but will leave this thread up in case others run into this problem in the future.

We are encountering the same problem.
Have checked deleted rows with symbols that may not be acceptable such as asterixis
Have deleted empty rows
Have deleted rows that are no consistent with what is expected
Can anyone help ?

same here. error is unknown

problem fixed, it seems that one cannot has a column with null name.
try that if you have an error

These issues should be fixed with release 1.4.3.

If problems still persist, please open an issue on Github and we can pick it up for a next release.

Hello, the null name column issue exists in 1.4.3. I have just started using usagi recently.

will open an issue if I have the time.

1 Like

Thanks for opening the issue, I will follow-up there and add the resolution to the roadmap