Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline #89

Closed
richb-hanover opened this issue Sep 15, 2024 · 3 comments
Closed

Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline #89

richb-hanover opened this issue Sep 15, 2024 · 3 comments

Comments

@richb-hanover
Copy link
Contributor

Using qStudio 3.10 on macOS 12.7.5. I get this error when I first launch qStudio. I have a PRQL query (below) that auto-opens in the top pane. The Console also auto-opens.

To demonstrate the problem, click in the PRQL query, hit Cmd-/ to comment a line, and then again to uncomment, then hit Cmd-E to run the query. This gives the error message above. This is repeatable as many times as I like.

I can get rid of the error message by:

  • Closing the Console
  • Opening the Results pane

Then Cmd-E compiles the PRQL query and runs the SQL. If you want to test against the database, use Property_In_Lyme.sqlite

PRQL Query

# =======================================
# Generate a "CleanedScrapedData" SQL View that derives the following:
# - Select the current zoning data (SD_Version=14 as of 2024-03-13)
# - Tweak up the zoning districts 
#   - Correct Vision inconsistencies (ES,R,SFR,UFD,SD,etc => "RD" )
#   - Join with CorrectedZoningDistrict to add districts that Vision lacks
#   - Properties in Rural district with addresses on state roads 
#      get 3 acre minimum (Orford, Dorchester,
#      East & North Thetford, Dartmouth College Highway)
#   - ZDistrict is coded value (RD, LCD, etc.)
#   - RealDistrict is nice printable names 
# - Create StateRoad column
# - Join in the Exempt, muni and conservation easements
# - also include frontage values
# =======================================

prql target:sql.sqlite

# dollars displays a numeric value as dollars with commas
let dollars = d -> s"""printf("$%,d",{d})"""

# pct computes the amount (percent) the new differs from old
let pct = o n -> 100.0*( n - o ) / o

# prtpct prints a floating point number with "%"
let prtpct = v -> s'printf("%1.1f%", {v})'

# sig_fig - print a value with n decimal places
# inserts comma for thousands/millions 
let sig_fig = v n -> s"printf('%,1.{n}f', {v})"

# implement a "like" function in lieu of a regex
let like = fld str -> s"{fld} like '%' || {str} || '%' "

# isStateRoad == 1 if it's a state road
let isStateRoad = road -> case [
  (like road "ORFORD ") => 1,
  (like road "DARTMOUTH COLLEGE") => 1,
  (like road "DORCHESTER") => 1,
  (like road "THETFORD") => 1, # North Thetford and East Thetford
  true => 0,
]
# Clean up zoning districts
# Returns two or three character district
# or null if it's ""
let CleanZoningDistrict = zd -> case [
  zd == "ES" => "RD",
  zd == "R" => "RD",
  zd == "SFR" => "RD",
  zd == "URD" => "RD",
  zd == "SD" => "RD",
  zd == "LCD" => "LCD",
  zd == "CD" => "LCD",
  zd == "LDC" => "LCD",
  zd == "" => null,
  true => zd,
]
# SubDistrict distinguishes between on-state-road and not
# Take a two/three character district, return pleasing name
# Also might (but doesn't) distinguish between Lyme Center and Lyme Common
let SubDistrict = dist road -> case [
  dist == "RD" && road == 1 => "Rural-State Road",
  dist == "RD" && road == 0 => "Rural-Town Road",
  dist == "BD" => "Commercial",
  dist == "LCD" => "LymeCommon/Ctr",
  dist == "ELD" => "EastLyme",
  dist == "SKIWAY" => "Skiway",
  dist == "MFD" => "MtnForest",
  true => dist,
]

# ============ begin  query ==============

from sd=ScrapedData
filter SD_CollectedOn == '2024-07-15' # latest data
join side:left czd = CorrectedZoningDistrict (sd.SD_PID == czd.CZD_PID)
join side:left ef = EasementsFrontage(sd.SD_PID == ef.EF_PID)

derive { StateRoad = isStateRoad sd.SD_Street_Address }

# Fix zoning districts
# DistrictName distinguishes between on-state-road and not
derive { zd = CleanZoningDistrict sd.SD_Zoning_District }
derive { District =  zd ?? czd.CZD_Actual }
derive { DistrictName = SubDistrict District StateRoad }

select {
    PID=sd.SD_PID,
    Owner=sd.SD_Owner,
    Street_Address=sd.SD_Street_Address,
    MBLU=sd.SD_MBLU,
    Map=sd.SD_Map,
    Lot=sd.SD_Lot,
    Unit=sd.SD_Unit,
    Subunit=sd.SD_Subunit,
    Book_Page=sd.SD_Book_Page,
    Book=sd.SD_Book,
    Page=sd.SD_Page,
    Assessment=sd.SD_Assessment,
    Appraisal=sd.SD_Appraisal,
    Lot_Size=sd.SD_Lot_Size,
    Land_Use_Code=sd.SD_Land_Use_Code,
    Description=sd.SD_Description,
    #Zoning_District=sd.SD_Zoning_District,
    District,
    #ZDistrict,
    DistrictName,
    StateRoad,
    ef.EF_LotSize,
    ef.EF_Exempt,
    ef.EF_MuniEasement,
    ef.EF_ConsEasement, 
    ef.EF_Frontage,
    ef.EF_FrontSuffix,
    Num_Buildings=sd.SD_Num_Buildings,
    Recent_Sale_Price=sd.SD_Recent_Sale_Price,
    Recent_Sale_Date=sd.SD_Recent_Sale_Date,
    Prev_Sale_Price=sd.SD_Prev_Sale_Price,
    Prev_Sale_Date=sd.SD_Prev_Sale_Date,
    Ass_ImpCurr=sd.SD_Ass_ImpCurr,
    Ass_LandCurr=sd.SD_Ass_LandCurr,
    Ass_TotCurr=sd.SD_Ass_TotCurr,
    Ass_ImpPrev=sd.SD_Ass_ImpPrev,
    Ass_LandPrev=sd.SD_Ass_LandPrev,
    Ass_TotPrev=sd.SD_Ass_TotPrev,
    App_ImpCurr=sd.SD_App_ImpCurr,
    App_LandCurr=sd.SD_App_LandCurr,
    App_TotCurr=sd.SD_App_TotCurr,
    App_ImpPrev=sd.SD_App_ImpPrev,
    App_LandPrev=sd.SD_App_LandPrev,
    App_TotPrev=sd.SD_App_TotPrev,
    Version=sd.SD_Version,
    CollectedOn=sd.SD_CollectedOn,
}

sort { PID }
# Check for fixed-up districts
# filter (sd.SD_Zoning_District != ZDistrict)

Log file - the interesting exception is BEFORE the SQL code

Last login: Sat Sep 14 22:35:03 on ttys004
You have mail.
√ ~ % cd /Applications
√ /Applications % java -jar qstudio.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader loadInstances
INFO: Searching for plugins in folder: /Users/richb/qstudio/libs
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader visitJarFileJavaClasses
INFO: Looking for plugins inside: /Users/richb/qstudio/libs/sqlite-jdbc-3.42.0.0.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader loadInstances
INFO: Searching for plugins in folder: /Users/richb/qstudio/libs
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader visitJarFileJavaClasses
INFO: Looking for plugins inside: /Users/richb/qstudio/libs/sqlite-jdbc-3.42.0.0.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader$InstanceFinderVisitor visit
INFO: Found Plugin with correct interface: org.sqlite.JDBC
Sep 14, 2024 11:40:52 PM com.timestored.qstudio.QStudioLauncher main
SEVERE: Could not load a plugin due to Unable to make protected void java.net.URLClassLoader.addURL(java.net.URL) accessible: module java.base does not "opens java.net" to unnamed module @40f9161a
/Applications
Sep 14, 2024 11:40:53 PM com.timestored.docs.OpenDocumentsModel addDocument
INFO: addDocument: new 1
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: Starting QStudioLauncher  launch() ###################################
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: version = 3.10
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: current dir = /Applications/.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: PATH = /Users/richb/.local/bin:/Applications/Tools-Developer/Racket:/Users/richb/.pyenv/shims:/Users/richb/.pyenv/bin:/Users/richb/.deno/bin:/Users/richb/.pyenv/bin:/Users/richb/.nvm/versions/node/v20.9.0/bin:/Users/richb/.cargo/bin:/opt/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/Library/Apple/usr/bin:/Library/Apple/bin:/usr/libexec:/Applications/Tools-Developer/Racket/bin:/Users/richb/.rvm/bin
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: JAVA_HOME = null
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: java.version =16.0.1
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: os.name =Mac OS X
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: user.home =/Users/richb
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: user.dir =/Applications
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: stored conns and current conns disagreed, using stored values
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: serverConns = []
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: sConns = [ServerConfig{name=\Users\richb\github\TaxFairness\Property_In_Lyme.sqlite, username=, host=localhost, port=0, cstoreType=SQLITE_JDBC, database=jdbc:sqlite:/Users/richb/github/TaxFairness/Property_In_Lyme.sqlite}]
SLF4J(W): No SLF4J providers were found.
SLF4J(W): Defaulting to no-operation (NOP) logger implementation
SLF4J(W): See https://www.slf4j.org/codes.html#noProviders for further details.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioFrame <init>
INFO: Starting QStudioFrame Constructor
MODELS = 126.47598
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Sep 14, 2024 11:40:55 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:40:56 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:40:56 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
ENDER = 1189.735135
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.model.AdminModel refresh
INFO: AdminModel hard Refresh
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.QStudioFrame <init>
INFO: Finished QStudioFrame Constructor
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedFolder
INFO: setSelectedFolder: null
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel addDocument
INFO: addDocument: new 2
Sep 14, 2024 11:40:56 PM com.timestored.docs.BackgroundDocumentsSaver restoreDocuments
INFO: attempting to restore existing known document
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel openDocument
INFO: openDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel closeDocument
INFO: closeDocument: new 1
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: Ending QStudioLauncher launch()
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: new 6
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.plugins.PluginLoader getCClass
INFO: Could not find class already loaded. Refreshing from folders / jars.
Sep 14, 2024 11:40:57 PM com.timestored.connections.ConnectionManager statusUpdate
INFO: \Users\richb\github\TaxFairness\Property_In_Lyme.sqlite Connected = true
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.model.AdminModel$2 run
INFO: refreshing \Users\richb\github\TaxFairness\Property_In_Lyme.sqlite
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:41:11 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
	at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
	at java.desktop/java.awt.Component.processEvent(Component.java:6394)
	at java.desktop/java.awt.Container.processEvent(Container.java:2264)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:11 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:11 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:11 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:13 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
	at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
	at java.desktop/java.awt.Component.processEvent(Component.java:6394)
	at java.desktop/java.awt.Container.processEvent(Container.java:2264)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:13 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:13 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:13 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:14 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
	at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
	at java.desktop/java.awt.Component.processEvent(Component.java:6394)
	at java.desktop/java.awt.Container.processEvent(Container.java:2264)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:14 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:14 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:14 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:15 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
	at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
	at java.desktop/java.awt.Component.processEvent(Component.java:6394)
	at java.desktop/java.awt.Container.processEvent(Container.java:2264)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:15 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:15 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:15 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
2024-09-14 23:41:20.770 java[48455:2786603] Apple AWT Internal Exception: java.lang.NullPointerException
Sep 14, 2024 11:41:22 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.SwingUtilities.processKeyBindings(SwingUtilities.java:1730)
	at java.desktop/javax.swing.UIManager$2.postProcessKeyEvent(UIManager.java:1544)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:886)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:22 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:22 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:22 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:24 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main



	at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
	at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
	at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
	at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
	at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
	at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
	at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
	at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
	at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
	at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
	at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
	at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
	at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
	at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
	at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
	at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
	at java.desktop/javax.swing.SwingUtilities.processKeyBindings(SwingUtilities.java:1730)
	at java.desktop/javax.swing.UIManager$2.postProcessKeyEvent(UIManager.java:1544)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:886)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
	at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
	at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
	at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
	at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
	at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
	at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
	at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
	at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
	at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:24 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:24 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:24 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:26 PM com.timestored.docs.BackgroundDocumentsSaver requestSave
INFO: store currently open documents to scratch.
Sep 14, 2024 11:41:26 PM com.timestored.docs.BackgroundDocumentsSaver saveDocumentsScratch
INFO: Saving docs to scratch
Sep 14, 2024 11:41:34 PM com.timestored.qstudio.CommonActions sendQuery
INFO: Send Query->WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"

Sep 14, 2024 11:41:34 PM com.timestored.qstudio.model.QueryManager sendQuery
INFO: run() sendingQuery: WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"

Sep 14, 2024 11:41:34 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"
, wasResult=false, wasException=false}
Sep 14, 2024 11:41:35 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:35 PM com.timestored.sqldash.chart.JdbcChartPanel update
INFO: could not create chartResultSet
java.sql.SQLException: getDouble failed on value (  ) in column 10
	at java.sql.rowset/com.sun.rowset.CachedRowSetImpl.getDouble(CachedRowSetImpl.java:2026)
	at com.timestored.sqldash.chart.ChartResultSetBuilder.getDoubles(ChartResultSetBuilder.java:145)
	at com.timestored.sqldash.chart.ChartResultSetBuilder.getChartResultSet(ChartResultSetBuilder.java:94)
	at com.timestored.sqldash.chart.ChartResultSet.getInstance(ChartResultSet.java:58)
	at com.timestored.sqldash.chart.JdbcChartPanel.update(JdbcChartPanel.java:208)
	at com.timestored.sqldash.model.ChartWidget.tabChanged(ChartWidget.java:187)
	at com.timestored.qstudio.ChartResultPanel$1.queryResultReturned(ChartResultPanel.java:106)
	at com.timestored.qstudio.model.QueryManager.sendQRtoListeners(QueryManager.java:366)
	at com.timestored.qstudio.model.QueryManager.sendQuery(QueryManager.java:247)
	at com.timestored.qstudio.model.QueryManager.access$200(QueryManager.java:56)
	at com.timestored.qstudio.model.QueryManager$2.run(QueryManager.java:188)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
	at java.base/java.lang.Thread.run(Thread.java:831)
@ryanhamilton
Copy link
Collaborator

When you comment, then uncomment it leaves an area of text highlighted.
So when you press control+E it is then running an empty or bad query.
I think that's what's happening here.

I can recreate the error when I query an empty string.

@richb-hanover
Copy link
Contributor Author

Good sleuthing!

I'm glad I mentioned the bit about using Cmd-/. I was only doing this to ensure that I was using 3.10. But of course, I now see that qStudio only sends the single commented-out line.

I am now groping for a solution - I don't think this is anything qStudio could (reasonably) address, so I will submit a request over at PRQL.

PS @ryanhamilton Could I ask a favor? You posted two issues on PRQL, both of which have been addressed. Would you close them? Many thanks. PRQL/prql#4540 and PRQL/prql#4502

@richb-hanover richb-hanover reopened this Sep 15, 2024
@richb-hanover richb-hanover mentioned this issue Sep 15, 2024
Open
@richb-hanover
Copy link
Contributor Author

I changed my mind. I made a proposal at #90 that qStudio could implement. Thanks

@richb-hanover richb-hanover mentioned this issue Sep 15, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@richb-hanover @ryanhamilton