Knowledge base

Other Options



Jonathan Wilson
Nov 1, 2001 7:42:00 PM

Do not understand error message

I do not understand why the query below: select sam.warehouse, sam.code, sam.description, sam.sales_diss, sam.cost_diss from nexus.samaster sam where (sam.sales_diss = 'SALES-800') group By sam.warehouse, sam.code produces the error: Error: -20022 Non-group-by expression in select clause (State:42523, Native Code: FFFFB1CA) Do you have to place all select fields in the group by clause (this gets rid of the error)?? I am not an SQL guru, but this seems rather useless and inefficient?? Or is this just standard SQL??


IndusSoft support engineer
Nov 1, 2001 8:33:00 PM

Do not understand error message

Hi, The group by clause is used if you have an aggregate function (SUM, AVG, COUNT, MIN, MAX) in the select statement. Since you do not have any aggregate function, there is no need for the group by. It seems that you want to order the output by warehouse and code, in which case you should use "order by" rather than "group by" Thanks, IndusSoft support >I do not understand why the query below: > >select sam.warehouse, sam.code, sam.description, sam.sales_diss, sam.cost_diss >from nexus.samaster sam >where (sam.sales_diss = 'SALES-800') >group By sam.warehouse, sam.code > >produces the error: > >Error: -20022 Non-group-by expression in select clause (State:42523, Native Code: FFFFB1CA) > >Do you have to place all select fields in the group by clause (this gets rid of the error)?? I am not an SQL guru, but this seems rather useless and >inefficient?? Or is this just standard SQL??


olivier laurec
Aug 8, 2022 3:56:34 AM

connection to localhost failed

Hello,
 
After updating our server, the connection to the localhosts no longer works. (service is running well)
I copied the last lines of the log file.
What can I do?
Thanks
 

2022-08-06 00:06:02,496 INFO  util.A - Enabling UPnP on port 16384, IP: 172.19.93.120
2022-08-06 07:21:24,439 INFO  util.VersionManager - Step1.xml file has been downloaded successfully.
2022-08-06 07:21:24,470 INFO  util.a - Processing tasks in step 1
2022-08-06 07:21:26,970 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/SyncrifyUpd.zip to C:\Syncrify\patches\SyncrifyUpd.zip
2022-08-06 07:21:34,126 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/SyncrifyUpd.zip to C:\Syncrify\patches\SyncrifyUpd.zip
2022-08-06 07:21:34,642 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxOFD.zip to C:\Syncrify\patches\AjaxOFD.zip
2022-08-06 07:21:36,876 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxOFD.zip to C:\Syncrify\patches\AjaxOFD.zip
2022-08-06 07:21:37,267 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/theme.zip to C:\Syncrify\patches\theme.zip
2022-08-06 07:21:40,783 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/theme.zip to C:\Syncrify\patches\theme.zip
2022-08-06 07:21:42,361 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/mail.jar to C:\Syncrify\patches\mail.jar
2022-08-06 07:21:43,720 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/mail.jar to C:\Syncrify\patches\mail.jar
2022-08-06 07:21:44,080 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxFU.zip to C:\Syncrify\patches\AjaxFU.zip
2022-08-06 07:21:45,142 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxFU.zip to C:\Syncrify\patches\AjaxFU.zip
2022-08-06 07:21:45,502 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxFE.zip to C:\Syncrify\patches\AjaxFE.zip
2022-08-06 07:21:47,970 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/AjaxFE.zip to C:\Syncrify\patches\AjaxFE.zip
2022-08-06 07:21:48,345 INFO  task.EnhancedGet - Downloading https://s3.wasabisys.com/synawebpublic/Syncrify/SyncrifyClient.jar to C:\Syncrify\patches\SyncrifyClient.jar
2022-08-06 07:21:53,345 INFO  task.EnhancedGet - Successfully downloaded https://s3.wasabisys.com/synawebpublic/Syncrify/SyncrifyClient.jar to C:\Syncrify\patches\SyncrifyClient.jar
2022-08-06 07:21:53,923 INFO  util.C - Finished downloading files.
2022-08-06 07:22:00,151 WARN  loader.WebappClassLoaderBase - The web application [ROOT] appears to have started a thread named [Thread-457] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(Unknown Source)
 java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
 java.util.concurrent.FutureTask.get(Unknown Source)
 org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:1001)
 org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
 org.apache.catalina.core.StandardService.stopInternal(StandardService.java:486)
 org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
 org.apache.catalina.core.StandardServer.stopInternal(StandardServer.java:814)
 org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
 org.apache.catalina.startup.Tomcat.stop(Tomcat.java:437)
 com.synametrics.p.k.a(EmbeddedTomcat8.java:597)
 com.synametrics.sradef.BootLoader.stopTomcat(BootLoader.java:451)
 com.synametrics.sradef.util.o.run(Application.java:43)
 java.lang.Thread.run(Unknown Source)
2022-08-06 07:22:00,151 WARN  loader.WebappClassLoaderBase - The web application [ROOT] appears to have started a thread named [Tomcat-startStop-2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(Unknown Source)
 java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
 java.util.concurrent.FutureTask.get(Unknown Source)
 org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:1001)
 org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
 org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1439)
 org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1428)
 java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
 java.util.concurrent.FutureTask.run(Unknown Source)
 java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 java.lang.Thread.run(Unknown Source)
2022-08-06 07:22:05,436 INFO  syncrify.Shutdown - Shutting down derby...
2022-08-06 07:22:05,827 INFO  syncrify.Shutdown - Shutting down...
2022-08-06 07:22:05,827 INFO  p.i - Running 'DiscoveryPinger' before terminating...
2022-08-06 07:22:05,827 INFO  p.i - Running 'Graph Data Manager' before terminating...
2022-08-06 07:22:05,827 INFO  p.i - Running 'Who Is On' before terminating...
2022-08-06 07:22:05,827 INFO  p.i - Running 'BackupRecords' before terminating...
2022-08-06 07:22:05,842 ERROR sradef.BootLoader - Unable to stop web server. An invalid Lifecycle transition was attempted ([before_stop]) for component [StandardServer[-1]] in state [DESTROYED]
2022-08-06 07:22:34,077 INFO  sradef.BootLoader - -------------------- New Instance started --------------.
2022-08-06 07:22:34,155 INFO  sradef.BootLoader - Working directory: C:\Syncrify
2022-08-06 07:22:34,264 INFO  syncrify.Ignition - Starting up. Build number: 1118, instance #: 235
2022-08-06 07:22:34,358 INFO  p.B - Status server is now ready to accept connections...

Navigation

Social Media

Powered by 10MinutesWeb.com