Ask Your Question

ambiguous column name [closed]

asked 2017-09-16 09:56:43 +0100

the_watchmann gravatar image

updated 2020-10-28 01:21:01 +0100

Alex Kemp gravatar image

Libreoffice 5.4 (not the distro version) Linux Mint 17.3 64BIT When trying to access a report I am getting the following reply. [unixODBC][SQLite]ambiguous column name: SALES (1) [unixODBC][SQLite]ambiguous column name: SALES (1) at at$_SOReportJobFactory.execute( Caused by: [unixODBC][SQLite]ambiguous column name: SALES (1) at at Source) at Source) at Source) at Source) at Source) at Source) at Source) at Source) at ... 1 more Not sure if its related to SQLITE or to ODBC or Libreoffice report builder. I created this report with a previous version of LO and it worked perfectly until I upgraded the system to 64 bit and upgraded LO to 5.4. Any pointers on where I can look or what to look for? It looks like java to me... :-D

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-28 01:21:56.869262

2 Answers

Sort by » oldest newest most voted

answered 2018-01-31 14:22:16 +0100

the_watchmann gravatar image

Thanks ratslinger. It was the sqliteodbc driver. once installed everything worked again. My apologies for the late reply

edit flag offensive delete link more

answered 2017-09-16 16:04:04 +0100

Ratslinger gravatar image

updated 2017-09-16 20:30:06 +0100

It appears since you went to 64-bit OS that you also installed 64-bit LO. Then the question is did you also install 64-bit JRE (Oracle or Open JRE). If not, do so. Once installed or if already installed, from LO menu, go to Tools->Options then under LibreOfice->Advanced insure Use a Java runtime environment is checked. Also in pane below that, select a JRE to use (can have multiple on system). If none appear, either the incorrect one is installed or you may have to manually add it by clicking on the Add.. button and selecting the location where it is.

Example: image description


Found some time for test. Have SQLite3 on Xubuntu so switched over. Had LO v5.3.2.2 installed. Started DB with SQLite3 using ODBC (have JDBC but it has its' problems). Had no reports so created simple one. No problem.

Then removed LO & installed v5.4.1.2 (not distro). Ran same report without a problem.

All systems are 64-bit as well as LO.

edit flag offensive delete link more


Finally found the driver used, installed through Synaptic - libsqliteodbc 0.9992-0.1

Ratslinger gravatar imageRatslinger ( 2017-09-16 21:12:19 +0100 )edit

Question Tools

1 follower


Asked: 2017-09-16 09:56:43 +0100

Seen: 187 times

Last updated: Jan 31 '18