Start a new topic

app periodically stalls after executing sql for about a minute....

[This topic is migrated from our old forums. The original author name has been removed]

Hi.. I think i only noticed it with 9.1.5 version... Periodically, after clicking on execute, the app would become unresponsive for about 40sec-1min before actually returning to sanity.. Any idea what could be going on here?: you can see a 40 sec wait below... 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:11 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:11 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsEOD' 14:04:11 [DEBUG pool-3-thread-4 E.?] RootConnection: SybDatabaseMetaData.getPrimaryKeys("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsEOD") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:11 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:11 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsEOD' Column='%' *14:04:11* [DEBUG pool-3-thread-4 E.?] DefaultEditor22: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsEOD", "%") *14:04:50* [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:50 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:50 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") Product: DbVisualizer Pro 9.1.5 Build: #2105 (2013/12/16 09:38) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_65 Java Vendor: Sun Microsystems Inc. OS Name: Windows 7 OS Arch: x86 OS Version: 6.1 Edited by: AlexML on Jan 17, 2014 2:14 PM

[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, The log shows that it is the "DatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsEOD", "%")" call that takes a long time. It gets information about all columns in the specified table and is usually a very fats call. Are you accessing a remote database over a slow connection? Does then table have a huge number of columns? If by "unresponsive" you mean that you cannot do anything else in the GUI, this delay should not cause that behavior. Please clarify what you mean by "unresponsive." We have found another problem introduced in 9.1.5 where clicking Execute more than once very fast (or using the keybinding in a similar fashion) may cause the script to be executed twice. Can that be what you see? This issue will be fixed in the next maintenance release, to be available soon. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hi. By 'unresponsive' i mean that the app does not respond to any mouse clicks or keystrokes. It freezes, and only after 40-60secons it starts to display the execution progress bar...
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, It sounds like it may be the issue I mentioned ail be fixed in the next maintenance version that is causing this. It ail be released soon, so please upgrade when it becomes available and let us know if it solved the problem. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans The behavior persists: (Table presently has 11,275 rows and 53 columns...) this time is was stuck for 9 seconds before executing after i hit F9 (execute shortcut) *11:51:23* [DEBUG pool-3-thread-42 E.?] DefaultEditor14: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "cemr_TrdBudgetStats", "%") 11:51:*31* [DEBUG ExecutorRunner-pool-2-thread-29 AbstractFacade.getColumn] executing "select user_name()" 11:51:31 [DEBUG pool-3-thread-42 C.?] DefaultEditor14: SybConnection.createStatement() 11:51:31 [DEBUG pool-3-thread-42 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()")
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, Okay, so then it was not related to the bug we fixed in 9.1.6 as I had assumed. Once again the log shows that it is the getColumns() call that actually takes 8 seconds. Are you doing something else while you execute the statement in the SQL Commander, such as navigating the tree or opening Object View tabs for database objects? Are using the latest supported driver for the database version? Have you tested with the jTDS driver (unclear which driver you use)? Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans I am not doing anything esle other than waiting for the app to unfreeze... I am using jConnect-7_0 jconn4.jar driver
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, Please try with the jTDS driver bundled with DbVisualizer. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, One more thing. Can you please run this again with debugging enabled and post the complete debug output from the execution. I can't match the logs you have posted so far to exactly what I get when running a test. It looks like you may have cut off parts of the log. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans I will post the complete debug output the next time the issue occurs. Thanks.
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans, This happened again today. The app was unresponsive for 1min 20sec.. Code executed: declare @ErrNum int declare @ErrMsg varchar(255) declare @UnitID int declare @AvgDayN int declare @AsOfTD smalldatetime select @UnitID = 1 ,@AvgDayN = 20 ,@AsOfTD = null I attached the full log from today's session. (scroll to *09:19:34) ...* 08:03:04 [DEBUG pool-3-thread-177 C.?] RootConnection: SybConnection.createStatement() 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 08:03:04 [DEBUG pool-3-thread-177 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("SELECT 1") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 J.execute] Executing... 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.execute("select * from iTB_FuncParams where APP_ID = 'CEMRXP' and FunctionName = 'AMTRDPERF'") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:04 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:04 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:04 [DEBUG ExecutorRunner-pool-2-thread-105 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='iTB_FuncParams' Column='%' 08:03:04 [DEBUG pool-3-thread-177 E.?] DefaultEditor14: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "iTB_FuncParams", "%") 08:03:05 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:05 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:05 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='iTB_FuncParams' Where='APP_ID = $$^^APP_ID (where)||CEMRXP||String||where pk ds=10 dt=VARCHAR$$^^ and FunctionName = $$^^FunctionName (where)||AMTRDPERF||String||where pk ds=32 dt=VARCHAR$$^^ and P1 = $$^^P1 (where)||2014-02-11 08:22:32.0||String||where pk nullable ds=255 dt=VARCHAR$$^^ and P2 = $$^^P2 (where)||custom message||String||where pk nullable ds=255 dt=VARCHAR$$^^ and P3 = $$^^P3 (where)||04/26/2013 13:59:10||String||where pk nullable ds=255 dt=VARCHAR$$^^ and P4 is null and N1 = $$^^N1 (where)||1||Integer||where pk nullable ds=11 dt=INTEGER$$^^ and N2 is null and N3 is null and V1 is null and D1 is null and D2 is null and D3 is null and Description = $$^^Description (where)||Americas Trader Perf. Stats N1=1{Ready}||String||where pk nullable ds=50 dt=VARCHAR$$^^' 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.execute] Executing... 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 08:03:10 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.prepareStatement("SELECT count_big(*) FROM dbo.iTB_FuncParams where APP_ID = ? and FunctionName = ? and P1 = ? and P2 = ? and P3 = ? and P4 is null and N1 = ? and N2 is null and N3 is null and V1 is null and D1 is null and D2 is null and D3 is null and Description = ?") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[1] name=[APP_ID (where)] value=[CEMRXP] type=[String] options=[where pk ds=10 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(1, "CEMRXP") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[2] name=[FunctionName (where)] value=[AMTRDPERF] type=[String] options=[where pk ds=32 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(2, "AMTRDPERF") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[3] name=[P1 (where)] value=[2014-02-11 08:22:32.0] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(3, "2014-02-11 08:22:32.0") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[4] name=[P2 (where)] value=[custom message] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(4, "custom message") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[5] name=[P3 (where)] value=[04/26/2013 13:59:10] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(5, "04/26/2013 13:59:10") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[6] name=[N1 (where)] value=[1] type=[Integer] options=[where pk nullable ds=11 dt=INTEGER] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setInt(6, 1) 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[7] name=[Description (where)] value=[Americas Trader Perf. Stats N1=1{Ready}] type=[String] options=[where pk nullable ds=50 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.setString(7, "Americas Trader Perf. Stats N1=1{Ready}") 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybPreparedStatement.execute() 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 F.?] Creating new connection: unnamed4 for SYBAMR_ETMA_DEV_DS01 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 G.?] Connecting: SYBAMR_ETMA_DEV_DS01 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc4.jdbc.SybDataSource 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 L.?] Loading class using dynamic ClassLoader: com.sybase.jdbc4.jdbc.SybDataSource 08:03:10 [DEBUG pool-3-thread-177 D.?] unnamed4: SybDataSource.acceptsURL("jdbc:sybase:Tds:etma-dx001-d.apps.ml.com:50000?HOSTNAME=AE_DEV011&PACKETSIZE=8192") 08:03:10 [DEBUG pool-3-thread-177 D.?] unnamed4: SybDataSource.connect("jdbc:sybase:Tds:etma-dx001-d.apps.ml.com:50000?HOSTNAME=AE_DEV011&PACKETSIZE=8192", {user=********, password=*************}) 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.setAutoCommit(true) 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 G.?] Using facade: sybase-ase for SYBAMR_ETMA_DEV_DS01 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.createStatement() 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybStatement.executeQuery("select user_name()") 08:03:10 [DEBUG pool-3-thread-177 E.?] unnamed4: SybDatabaseMetaData.getDatabaseProductName() 08:03:10 [DEBUG pool-3-thread-177 E.?] unnamed4: SybDatabaseMetaData.getDatabaseProductVersion() 08:03:10 [DEBUG pool-3-thread-177 E.?] unnamed4: SybDatabaseMetaData.getDriverName() 08:03:10 [DEBUG pool-3-thread-177 E.?] unnamed4: SybDatabaseMetaData.getDriverVersion() 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.setAutoCommit(false) 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.execute] Executing... 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.prepareStatement("UPDATE dbo.iTB_FuncParams SET P1 = ? WHERE APP_ID = ? and FunctionName = ? and P1 = ? and P2 = ? and P3 = ? and P4 is null and N1 = ? and N2 is null and N3 is null and V1 is null and D1 is null and D2 is null and D3 is null and Description = ?") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[1] name=[P1] value=[2014-02-12 08:03:09.0] type=[String] options=[pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(1, "2014-02-12 08:03:09.0") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[2] name=[APP_ID] value=[CEMRXP] type=[String] options=[where pk ds=10 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(2, "CEMRXP") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[3] name=[FunctionName] value=[AMTRDPERF] type=[String] options=[where pk ds=32 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(3, "AMTRDPERF") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[4] name=[P1] value=[2014-02-11 08:22:32.0] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(4, "2014-02-11 08:22:32.0") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[5] name=[P2] value=[custom message] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(5, "custom message") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[6] name=[P3] value=[04/26/2013 13:59:10] type=[String] options=[where pk nullable ds=255 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(6, "04/26/2013 13:59:10") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[7] name=[N1] value=[1] type=[Integer] options=[where pk nullable ds=11 dt=INTEGER] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setInt(7, 1) 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 O.?] index=[8] name=[Description] value=[Americas Trader Perf. Stats N1=1{Ready}] type=[String] options=[where pk nullable ds=50 dt=VARCHAR] 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.setString(8, "Americas Trader Perf. Stats N1=1{Ready}") 08:03:10 [DEBUG pool-3-thread-177 B.?] unnamed4: SybPreparedStatement.execute() 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 G.?] Commit: SYBAMR_ETMA_DEV_DS01 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.commit() 08:03:10 [DEBUG pool-3-thread-177 C.?] unnamed4: SybConnection.setAutoCommit(true) 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 F.?] Freeing connection: unnamed4 for SYBAMR_ETMA_DEV_DS01 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.execute] Executing... 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:10 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 08:03:10 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.execute("select * from iTB_FuncParams where APP_ID = 'CEMRXP' and FunctionName = 'AMTRDPERF'") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:10 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 AbstractFacade.getColumn] executing "select user_name()" 08:03:10 [DEBUG pool-3-thread-177 C.?] DefaultEditor14: SybConnection.createStatement() 08:03:10 [DEBUG pool-3-thread-177 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 08:03:10 [DEBUG ExecutorRunner-pool-2-thread-105 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='iTB_FuncParams' Column='%' 08:03:10 [DEBUG pool-3-thread-177 E.?] DefaultEditor14: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "iTB_FuncParams", "%") 09:00:10 [DEBUG pool-3-thread-179 C.?] RootConnection: SybConnection.createStatement() 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:10 [DEBUG pool-3-thread-179 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:00:10 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:10 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("SELECT 1") 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.getColumn] executing "select user_name()" 09:00:10 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:10 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("select user_name()") 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 J.execute] Executing... 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.getColumn] executing "select user_name()" 09:00:10 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:10 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("select user_name()") 09:00:10 [DEBUG ExecutorRunner-pool-2-thread-106 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:00:10 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:10 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.execute("update index statistics gmtpl_Warehouse") 09:00:10 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: EXCEPTION -> java.sql.SQLException: Table 'gmtpl_Warehouse' does not exist. java.sql.SQLException: Table 'gmtpl_Warehouse' does not exist. at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2526) at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2323) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:253) at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2252) at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2239) at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1078) at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.B.?(Z:104) at com.onseven.dbvis.g.B.F$A.call(Z:1474) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 09:00:14 [DEBUG pool-3-thread-179 C.?] RootConnection: SybConnection.createStatement() 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:14 [DEBUG pool-3-thread-179 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:00:14 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:14 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("SELECT 1") 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.getColumn] executing "select user_name()" 09:00:14 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:14 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("select user_name()") 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 J.execute] Executing... 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.getColumn] executing "select user_name()" 09:00:14 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:14 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.executeQuery("select user_name()") 09:00:14 [DEBUG ExecutorRunner-pool-2-thread-106 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:00:14 [DEBUG pool-3-thread-179 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:14 [DEBUG pool-3-thread-179 B.?] DefaultEditor958: SybStatement.execute("update index statistics gmtpl_WareHouse") 09:00:34 [DEBUG ExecutorRunner-pool-2-thread-107 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='null' Type(s)='null' 09:00:34 [DEBUG pool-3-thread-180 E.?] RootConnection: SybDatabaseMetaData.getTables("tss_ds_dev2", "dbo", "%", null) 09:00:36 [DEBUG AWT-EventQueue-1 A.?] AutoComplete: Using cached popupList of tables: "SYBAMR_ETMA_DEV_DS01TSS_DS_DEV2DBO" 09:00:39 [DEBUG pool-3-thread-180 C.?] RootConnection: SybConnection.createStatement() 09:00:39 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:39 [DEBUG pool-3-thread-180 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:00:39 [DEBUG pool-3-thread-180 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:39 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:00:39 [DEBUG pool-3-thread-180 B.?] DefaultEditor14: SybStatement.executeQuery("SELECT 1") 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.getColumn] executing "select user_name()" 09:00:40 [DEBUG pool-3-thread-180 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:40 [DEBUG pool-3-thread-180 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-107 J.execute] Executing... 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-107 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.getColumn] executing "select user_name()" 09:00:40 [DEBUG pool-3-thread-180 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:40 [DEBUG pool-3-thread-180 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-107 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:00:40 [DEBUG pool-3-thread-179 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:40 [DEBUG pool-3-thread-179 B.?] DefaultEditor14: SybStatement.execute("select * from cemr_CurBudgetStatsGators") 09:00:40 [DEBUG ExecutorRunner-pool-2-thread-106 AbstractFacade.getColumn] executing "select user_name()" 09:00:40 [DEBUG pool-3-thread-180 C.?] DefaultEditor958: SybConnection.createStatement() 09:00:40 [DEBUG pool-3-thread-180 B.?] DefaultEditor958: SybStatement.executeQuery("select user_name()") 09:00:46 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.getColumn] executing "select user_name()" 09:00:46 [DEBUG pool-3-thread-179 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:46 [DEBUG pool-3-thread-179 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:00:46 [DEBUG ExecutorRunner-pool-2-thread-107 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsGators' 09:00:46 [DEBUG pool-3-thread-179 E.?] RootConnection: SybDatabaseMetaData.getPrimaryKeys("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsGators") 09:00:46 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.getColumn] executing "select user_name()" 09:00:46 [DEBUG pool-3-thread-179 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:46 [DEBUG pool-3-thread-179 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:00:46 [DEBUG ExecutorRunner-pool-2-thread-107 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsGators' Column='%' 09:00:46 [DEBUG pool-3-thread-179 E.?] DefaultEditor14: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsGators", "%") 09:00:52 [DEBUG ExecutorRunner-pool-2-thread-107 AbstractFacade.getColumn] executing "select user_name()" 09:00:52 [DEBUG pool-3-thread-179 C.?] DefaultEditor14: SybConnection.createStatement() 09:00:52 [DEBUG pool-3-thread-179 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:19:09 [DEBUG pool-3-thread-182 C.?] RootConnection: SybConnection.createStatement() 09:19:09 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:19:09 [DEBUG pool-3-thread-182 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:19:09 [DEBUG pool-3-thread-182 C.?] DefaultEditor1510: SybConnection.createStatement() 09:19:09 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:19:09 [DEBUG pool-3-thread-182 B.?] DefaultEditor1510: SybStatement.executeQuery("SELECT 1") 09:19:09 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:09 [DEBUG pool-3-thread-182 C.?] DefaultEditor1510: SybConnection.createStatement() 09:19:09 [DEBUG pool-3-thread-182 B.?] DefaultEditor1510: SybStatement.executeQuery("select user_name()") 09:19:09 [DEBUG ExecutorRunner-pool-2-thread-108 J.execute] Executing... 09:19:10 [DEBUG ExecutorRunner-pool-2-thread-108 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:19:10 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:10 [DEBUG pool-3-thread-182 C.?] DefaultEditor1510: SybConnection.createStatement() 09:19:10 [DEBUG pool-3-thread-182 B.?] DefaultEditor1510: SybStatement.executeQuery("select user_name()") 09:19:10 [DEBUG ExecutorRunner-pool-2-thread-108 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:19:10 [DEBUG pool-3-thread-182 C.?] DefaultEditor1510: SybConnection.createStatement() 09:19:10 [DEBUG pool-3-thread-182 B.?] DefaultEditor1510: SybStatement.execute("use tss_ds_dev2 select posTrader = au.last_name+' '+au.first_name ,salesTrader = t1.TRDR_NAME ,salesTID = gtr.SRT_TID ,orderEntBy = t2.TRDR_NAME ,instrument = gtr.symbol ,salesChannel = gtr.sales_channel ,execSource = gtr.exec_source ,execHandlType = es.exec_handler_name ,gicsIndustry = gic.mkt_sct_desc ,cmmGross = round(convert(float, sum(gtr.COMM+gtr.OTC)),0) ,cmmNet = round(convert(float, sum((gtr.COMM+gtr.OTC) * case rec_type when 'I' THEN IsNull(ipsr.Inst,pts.Inst) when 'B' THEN IsNull(ipsr.BCC,pts.BCC) when 'C' THEN IsNull(ipsr.Citation,pts.Citation) when 'M' THEN IsNull(ipsr.IAD,pts.IAD) when 'R' THEN IsNull(ipsr.Retail,pts.Retail) end)),0) ,cmmPC = sum(gtr.production_credit) ,shares = sum(gtr.SHARES) ,ntnl = round(sum(gtr.ntnl_usd),0) from GatorSumNegRate gtr (index idx1_PRD_CDE1) left join nasd_apps_PTS_Rates pts (index idx1) on pts.RptType = 'CNR_REG' and pts.ProductID = 1 and (pts.EffDate <= gtr.trade_date and gtr.trade_date <= isnull(pts.EndDate, gtr.trade_date)) left join nasd_apps_IPSPTS_Rates ipsr (index PK_IPSPTS_Rates_1) on ipsr.ProductID = 1 and ipsr.cust_rollup_id = gtr.cust_rollup_id left join nasd_apps_PL_NTLogin nt on nt.EmpID = gtr.pos_emp_id left join iTB_audit_user au on au.user_id = nt.PrmFidUID and au.from_date <= gtr.trade_date and isnull(au.to_date,gtr.trade_date) >= gtr.trade_date and au.status = 'A' left join iTB_audit_user au2 on au2.trader_code = gtr.SRT_TID and au2.from_date <= gtr.trade_date and isnull(au2.to_date,gtr.trade_date) >= gtr.trade_date and au2.status = 'A' left join gtr_gic_map gic on gtr.ind_subgrp_cd = gic.ind_subgrp_cd left join gtr_trd_ids t1 on gtr.SRT_TID = t1.SRT_TID left join gtr_trd_ids t2 on gtr.ORD_SLS_TID = t2.SRT_TID left join gtr_exec_handler es on gtr.exec_source = es.exec_handler_cd where gtr.trade_date = '02/11/2014' and gtr.product_code not in ('EQTYSPDR','EQTYMSCI') and bus_product = ('SNGLST') and gtr.sales_channel = ('FAST') and gtr.group_type = 'UC' group by au.last_name+' '+au.first_name, t1.TRDR_NAME, t2.TRDR_NAME, gtr.symbol, gtr.sales_channel, gtr.exec_source, es.exec_handler_name, gic.mkt_sct_desc, gtr.SRT_TID order by cmmNet desc") 09:19:11 [DEBUG ExecutorRunner-pool-2-thread-108 F.?] Edit not allowed: Is not a SELECT statement 09:19:12 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:12 [DEBUG pool-3-thread-182 C.?] DefaultEditor1510: SybConnection.createStatement() 09:19:12 [DEBUG pool-3-thread-182 B.?] DefaultEditor1510: SybStatement.executeQuery("select user_name()") 09:19:32 [DEBUG pool-3-thread-182 C.?] RootConnection: SybConnection.createStatement() 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:19:32 [DEBUG pool-3-thread-182 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 F.?] Lease unused connection: unnamed4 - New Name: DefaultEditor1878 09:19:32 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:19:32 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("SELECT 1") 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:32 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:32 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 J.execute] Executing... 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:32 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:32 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:32 [DEBUG ExecutorRunner-pool-2-thread-108 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:19:32 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:32 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.execute("select posTrader = au.last_name+' '+au.first_name ,salesTrader = t1.TRDR_NAME ,salesTID = gtr.SRT_TID ,orderEntBy = t2.TRDR_NAME ,instrument = gtr.symbol ,salesChannel = gtr.sales_channel ,execSource = gtr.exec_source ,execHandlType = es.exec_handler_name ,gicsIndustry = gic.mkt_sct_desc ,cmmGross = round(convert(float, sum(gtr.COMM+gtr.OTC)),0) ,cmmNet = round(convert(float, sum((gtr.COMM+gtr.OTC) * case rec_type when 'I' THEN IsNull(ipsr.Inst,pts.Inst) when 'B' THEN IsNull(ipsr.BCC,pts.BCC) when 'C' THEN IsNull(ipsr.Citation,pts.Citation) when 'M' THEN IsNull(ipsr.IAD,pts.IAD) when 'R' THEN IsNull(ipsr.Retail,pts.Retail) end)),0) ,cmmPC = sum(gtr.production_credit) ,shares = sum(gtr.SHARES) ,ntnl = round(sum(gtr.ntnl_usd),0) from GatorSumNegRate gtr (index idx1_PRD_CDE1) left join nasd_apps_PTS_Rates pts (index idx1) on pts.RptType = 'CNR_REG' and pts.ProductID = 1 and (pts.EffDate <= gtr.trade_date and gtr.trade_date <= isnull(pts.EndDate, gtr.trade_date)) left join nasd_apps_IPSPTS_Rates ipsr (index PK_IPSPTS_Rates_1) on ipsr.ProductID = 1 and ipsr.cust_rollup_id = gtr.cust_rollup_id left join nasd_apps_PL_NTLogin nt on nt.EmpID = gtr.pos_emp_id left join iTB_audit_user au on au.user_id = nt.PrmFidUID and au.from_date <= gtr.trade_date and isnull(au.to_date,gtr.trade_date) >= gtr.trade_date and au.status = 'A' left join iTB_audit_user au2 on au2.trader_code = gtr.SRT_TID and au2.from_date <= gtr.trade_date and isnull(au2.to_date,gtr.trade_date) >= gtr.trade_date and au2.status = 'A' left join gtr_gic_map gic on gtr.ind_subgrp_cd = gic.ind_subgrp_cd left join gtr_trd_ids t1 on gtr.SRT_TID = t1.SRT_TID left join gtr_trd_ids t2 on gtr.ORD_SLS_TID = t2.SRT_TID left join gtr_exec_handler es on gtr.exec_source = es.exec_handler_cd where gtr.trade_date = '2/11/2014' and gtr.product_code not in ('EQTYSPDR','EQTYMSCI') and bus_product = ('SNGLST') and gtr.sales_channel = ('FAST') and gtr.group_type = 'UC' group by au.last_name+' '+au.first_name, t1.TRDR_NAME, t2.TRDR_NAME, gtr.symbol, gtr.sales_channel, gtr.exec_source, es.exec_handler_name, gic.mkt_sct_desc, gtr.SRT_TID order by cmmNet desc") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:33 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() 09:19:33 [DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") 09:19:33 [DEBUG ExecutorRunner-pool-2-thread-108 F.?] Edit not allowed: More than one table is referenced in the FROM clause 09:19:34 [DEBUG ExecutorRunner-pool-2-thread-108 AbstractFacade.getColumn] executing "select user_name()" 09:19:34 [DEBUG pool-3-thread-182 C.?] DefaultEditor1878: SybConnection.createStatement() {color:#ff0000}*09:19:34* {color}[DEBUG pool-3-thread-182 B.?] DefaultEditor1878: SybStatement.executeQuery("select user_name()") *{color:#ff0000}09:20:53{color}* [DEBUG pool-3-thread-182 C.?] RootConnection: SybConnection.createStatement() 09:20:53 [DEBUG ExecutorRunner-pool-2-thread-109 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:20:53 [DEBUG pool-3-thread-182 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 09:20:54 [DEBUG pool-3-thread-182 C.?] DefaultEditor14: SybConnection.createStatement() 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 09:20:54 [DEBUG pool-3-thread-182 B.?] DefaultEditor14: SybStatement.executeQuery("SELECT 1") 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 AbstractFacade.getColumn] executing "select user_name()" 09:20:54 [DEBUG pool-3-thread-182 C.?] DefaultEditor14: SybConnection.createStatement() 09:20:54 [DEBUG pool-3-thread-182 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 J.execute] Executing... 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 AbstractFacade.getColumn] executing "select user_name()" 09:20:54 [DEBUG pool-3-thread-182 C.?] DefaultEditor14: SybConnection.createStatement() 09:20:54 [DEBUG pool-3-thread-182 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()") 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 09:20:54 [DEBUG pool-3-thread-182 C.?] DefaultEditor14: SybConnection.createStatement() 09:20:54 [DEBUG pool-3-thread-182 B.?] DefaultEditor14: SybStatement.execute("declare @ErrNum int declare @ErrMsg varchar(255) declare @UnitID int declare @AvgDayN int declare @AsOfTD smalldatetime select @UnitID = 1 ,@AvgDayN = 20 ,@AsOfTD = null") 09:20:54 [DEBUG ExecutorRunner-pool-2-thread-109 AbstractFacade.getColumn] executing "select user_name()" 09:20:54 [DEBUG pool-3-thread-182 C.?] DefaultEditor14: SybConnection.createStatement() 09:20:54 [DEBUG pool-3-thread-182 B.?] DefaultEditor14: SybStatement.executeQuery("select user_name()")
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, Thanks for the log. It's still not obvious what's join on, because the log just shows that execution of a simple query takes a long time and that should not freeze the GUI. One thing that looks odd is the large number of executions of "select user_name()" after execution of the large SELECT starting at 09:19:32. DbVisualizer uses this query to get the current schema before and after executing a script. Do you always get this many "select user_name()" when you execute this large SELECT? Execution of the script that gets stuck for 1 min 20 sec starts at 09:19:34, just one second after the execution of the large SELECT ends. It looks like you are executing it in the same SQL Commander tab as you used for the large SELECT. Is that true? If so, how did you manage to replace the large SELECT with the script in less than a second? Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans, no, i did not have them both in the same tab.. Those were two separate sql tabs.. And yes, now that you pointed out the "select user_name" calls, i cleared the Debug window, and executed the statement below.. ------------------------- Product Information ------------------------ Product: DbVisualizer Pro 9.1.6 Build: #2117 (2014/01/26 21:20) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_65 Java Vendor: Sun Microsystems Inc. OS Name: Windows 7 OS Arch: x86 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: 15 Minor Version: 7 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/15.7.0/EBF 20809 SMP ESD#04 /P/x86_64/Enterprise Linux/ase157x/3245/64-bit/FBO/Fri Jan 4 05:11:12 2013 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/7.07 ESD #4 (Build 26792)/P/EBF20144/JDK 1.6.0/jdbcmain/OPT/Thu Jun 7 23:57:39 PDT 2012 --------------------------- Debug Printouts -------------------------- 13:41:26 [DEBUG pool-3-thread-224 C.?] RootConnection: SybConnection.createStatement() 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 13:41:26 [DEBUG pool-3-thread-224 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 13:41:26 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 13:41:26 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("SELECT 1") 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:41:26 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:41:26 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 J.execute] Executing... 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:41:26 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:41:26 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:41:26 [DEBUG ExecutorRunner-pool-2-thread-132 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 13:41:26 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:41:26 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.execute("select TrdDateNum = tdc.TrdDateNum ,Insatrument = im.Instrument ,BookID = im.BookID ,ProductID = 'SNGLST' ,GTR_SHARES = sum(gtr.SHARES) ,GTR_GRSCMM = sum(gtr.COMM + gtr.OTC) ,GTR_NETCMM = sum ( (gtr.COMM+gtr.OTC) * case gtr.rec_type when 'I' then IsNull(r.Inst,p.Inst) when 'B' then IsNull(r.BCC,p.BCC) when 'C' then IsNull(r.Citation,p.Citation) when 'M' then IsNull(r.IAD,p.IAD) when 'R' then IsNull(r.Retail,p.Retail) end) ,creDate = getdate() from GatorSumNegRate gtr inner join cnr_RevenueAccts ra on ra.ap_acct = isnull(gtr.revenue_account,'{null}') and ra.status = 'A' inner join gtr_sales_channel sc on sc.sales_channel_cd = gtr.sales_channel and sc.sales_channel_touch = 'H' inner join iTB_TradeDateCal tdc (index idx0) on tdc.ExchID = 'US' and tdc.YearNum = datepart(year, gtr.trade_date) and tdc.TradeDate = gtr.trade_date inner join cemr_CurBudgetStatsInstrMap im (index BSIM_LOAD_PK) on im.YearNum = datepart(year, gtr.trade_date) and im.TrdDateNum = tdc.TrdDateNum and im.Instrument = gtr.symbol inner join cemr_CurBudgetStatsScope bs on bs.YearNum = datepart(year, gtr.trade_date) and bs.TrdDateNum = tdc.TrdDateNum and bs.UntCode = 'D' and bs.BookID = im.BookID left join nasd_apps_PTS_Rates p on p.RptType = 'CNR_REG' and p.ProductID = 1 and (p.EffDate <= gtr.trade_date and gtr.trade_date <= isnull(p.EndDate, gtr.trade_date)) left join nasd_apps_IPSPTS_Rates r on r.ProductID = 1 and r.cust_rollup_id = gtr.cust_rollup_id where gtr.trade_date >= '01/01/2014' and (gtr.group_type = 'UC' OR gtr.group_type = 'NC') and gtr.bus_product = 'SNGLST' and isnull(gtr.product_code,'{null}') not in ('EQTYSPDR','EQTYMSCI') group by tdc.TrdDateNum, im.Instrument, im.BookID") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:00 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:00 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()") 13:42:00 [DEBUG ExecutorRunner-pool-2-thread-132 F.?] Edit not allowed: More than one table is referenced in the FROM clause 13:42:01 [DEBUG ExecutorRunner-pool-2-thread-132 AbstractFacade.getColumn] executing "select user_name()" 13:42:01 [DEBUG pool-3-thread-224 C.?] DefaultEditor2191: SybConnection.createStatement() 13:42:01 [DEBUG pool-3-thread-224 B.?] DefaultEditor2191: SybStatement.executeQuery("select user_name()")
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, Ah, I see now that two separate SQL Commander tabs were used. Is it possible that you hit Execute in the SQL Commander with the script that got stuck while the SQL Commander for the large query was still processing the result? Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans Unlikely...... I do not recall anything running at that time before I selected the text and hit F9 (execute).... But I will try to wath it now.. What are those more than frequent +select user_name+.. BTW, I also had a few floating sql windows open.. just fyi