Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Trace Shows Dozens of Attempts

5 posts in General Discussion Last posting was on 2010-11-02 15:08:21.0Z
C Westphal Posted on 2010-10-14 21:56:37.0Z
Sender: 927.4cb5cb2d.1804289383@sybase.com
From: C Westphal
Newsgroups: ianywhere.public.general
Subject: SQL Trace Shows Dozens of Attempts
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cb77c95.306e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Oct 2010 14:56:37 -0700
X-Trace: forums-1-dub 1287093397 10.22.241.41 (14 Oct 2010 14:56:37 -0700)
X-Original-Trace: 14 Oct 2010 14:56:37 -0700, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8095
Article PK: 7115

We have a powerbuilder application utilizing an ASA database
that is at one location behaving very strangely. When the
application communicates across the network in some
instances
the queries from the application are sent dozens of times
instead of just once, as if they are failing and haveing to
be
resent over and over before finally succeeding.

The network configuration consists of two LANs bridged into
a
single LAN by a private T1 (not a VPN). Problems mostly
occur
going over the T1 to the other side of the network, although
local communication is a little sluggish. Logging into the
application takes 20 seconds, the same loging queries appear
repeatedly over that 20 seconds generating hundreds of lines
in
the ODBC trace file. By contrast, at the same machine and
same
ODBC entry/network path DBISQL is lightening fast, even
running
queries containing joins.


My two suspects at the moment are the free AVG anti-virus
employed at the store, and the fact that there is a VOIP
router
on the network that does not use the T1 but is present on
the
local LAN nonetheless.


This is a multidatabase situation using mobilink synchs,
however
the synchs work just fine, the problems are only with the
ASA
database server.

Any help would be much appreciated!


Jeff Albion [Sybase iAnywhere] Posted on 2010-10-18 18:34:59.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Trace Shows Dozens of Attempts
References: <4cb77c95.306e.1681692777@sybase.com>
In-Reply-To: <4cb77c95.306e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cbc9353$1@forums-1-dub>
Date: 18 Oct 2010 11:34:59 -0700
X-Trace: forums-1-dub 1287426899 10.22.241.152 (18 Oct 2010 11:34:59 -0700)
X-Original-Trace: 18 Oct 2010 11:34:59 -0700, vip152.sybase.com
Lines: 42
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8096
Article PK: 7112

Hello,

On 14/10/2010 5:56 PM, C Westphal wrote:
> We have a powerbuilder application utilizing an ASA database
> that is at one location behaving very strangely. When the
> application communicates across the network in some
> instances
> the queries from the application are sent dozens of times
> instead of just once, as if they are failing and haveing to
> be
> resent over and over before finally succeeding.

Which version of SQL Anywhere are you using?

How exactly have you determined this result? Can we see a Request-Level
Log (dbsrvX -zr SQL+HOSTVARS -zo rll.txt) with these requests?

> This is a multidatabase situation using mobilink synchs,
> however
> the synchs work just fine, the problems are only with the
> ASA
> database server.

Are you sure that your application and MobiLink server are not causing
blocking on the database server?

Working with technical support
(http://www.sybase.com/contactus/support/) is your best next step. We
can work interactively with you to help determine why your particular
server may be running slowly.

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


C. Westphal Posted on 2010-10-20 15:18:14.0Z
Sender: 3b08.4cbc6327.846930886@sybase.com
From: C. Westphal
Newsgroups: ianywhere.public.general
Subject: Re: SQL Trace Shows Dozens of Attempts
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cbf0836.7c15.1681692777@sybase.com>
References: <4cbc9353$1@forums-1-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4cbf0836"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Oct 2010 08:18:14 -0700
X-Trace: forums-1-dub 1287587894 10.22.241.41 (20 Oct 2010 08:18:14 -0700)
X-Original-Trace: 20 Oct 2010 08:18:14 -0700, 10.22.241.41
Lines: 512
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8097
Article PK: 7117

Sorry I did not mention the version, we are running ASA
10.0.1.3976. I will try to get the log file but that will
take some time as taking the database services impacts the
store business even further than already has occurred.

We determined the single connection as repeating dozens of
times by setting an ODBC trace at the client. The trace file
is attached. The trace file spans only 30 seconds of
communication, during which the only activity over the ODBC
was to login to our application. You can see the same
requests repeated over and over again when there should only
be one request and response.

Regarding conflicts with Mobilink and the ASA database
service, all of the services are running on unique ports so
there should be no conflict there unless you meant
something, in which case I am not 100% clear on how they
could conflict.

If we cannot sort it out here I will contact support.

Thanks,

Charles

> Hello,
>
> On 14/10/2010 5:56 PM, C Westphal wrote:
> > We have a powerbuilder application utilizing an ASA
> > database that is at one location behaving very
> > strangely. When the application communicates across the
> > network in some instances
> > the queries from the application are sent dozens of
> > times instead of just once, as if they are failing and
> > haveing to be
> > resent over and over before finally succeeding.
>
> Which version of SQL Anywhere are you using?
>
> How exactly have you determined this result? Can we see a
> Request-Level Log (dbsrvX -zr SQL+HOSTVARS -zo rll.txt)
> with these requests?
>
> > This is a multidatabase situation using mobilink synchs,
> > however
> > the synchs work just fine, the problems are only with
> > the ASA
> > database server.
>
> Are you sure that your application and MobiLink server are
> not causing blocking on the database server?
>
> Working with technical support
> (http://www.sybase.com/contactus/support/) is your best
> next step. We can work interactively with you to help
> determine why your particular server may be running
> slowly.
>
> Regards,
>
> --
> Jeff Albion, Sybase iAnywhere, an SAP Company
>
> iAnywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals SQL
> Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/


Jeff Albion [Sybase iAnywhere] Posted on 2010-10-20 19:06:36.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.11) Gecko/20101013 Lightning/1.0b2 Thunderbird/3.1.5
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Trace Shows Dozens of Attempts
References: <4cbc9353$1@forums-1-dub> <4cbf0836.7c15.1681692777@sybase.com>
In-Reply-To: <4cbf0836.7c15.1681692777@sybase.com>
Content-Type: multipart/mixed; boundary="------------090904020101040205060601"
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cbf3dbc$1@forums-1-dub>
Date: 20 Oct 2010 12:06:36 -0700
X-Trace: forums-1-dub 1287601596 10.22.241.152 (20 Oct 2010 12:06:36 -0700)
X-Original-Trace: 20 Oct 2010 12:06:36 -0700, vip152.sybase.com
Lines: 371
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8098
Article PK: 7116

Hi Charles,

On 20/10/2010 11:18 AM, C. Westphal wrote:
> We determined the single connection as repeating dozens of
> times by setting an ODBC trace at the client. The trace file
> is attached. The trace file spans only 30 seconds of
> communication, during which the only activity over the ODBC
> was to login to our application. You can see the same
> requests repeated over and over again when there should only
> be one request and response.

There are only two statements that I can find that are being repeated:

Statement #1:

SELECT "group1"."department_tb"."de_code" ,
"group1"."department_tb"."de_descript" FROM "group1"."department_tb"
WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and (
"group1"."department_tb"."de_code" is not NULL ) and (
"group1"."department_tb"."de_code" <> '' ) ORDER BY
"group1"."department_tb"."de_code" ASC

Statement #2:

SELECT "group1"."vendor_tb"."ve_name" ,
"group1"."vendor_tb"."ve_code" ,
"group1"."vendor_tb"."ve_max_rtn_months" ,
"group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb"
WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
"group1"."vendor_tb"."ve_code" ASC,
"group1"."vendor_tb"."ve_name" ASC

All other statements are executed exactly once. I've attached my summary
as a text document to this post.

Taking a look at the last repeated entries for Statement #2 (Lines 11824
and 12134), you can see that these are technically separate statements
being executed by your application (notice the "FreeStmt"/"AllocStmt" in
between each of these statements):

===========================
blw110 27c-dc4 ENTER SQLExecDirectW
HSTMT 09E11A50
WCHAR * 0x0C0C60DC [ -3] "SELECT
"group1"."vendor_tb"."ve_name" ,
"group1"."vendor_tb"."ve_code" ,
"group1"."vendor_tb"."ve_max_rtn_months" ,
"group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb"
WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
"group1"."vendor_tb"."ve_code" ASC,
"group1"."vendor_tb"."ve_name" ASC \ 0"
SDWORD -3
...

blw110 27c-dc4 ENTER SQLFreeStmt
blw110 27c-dc4 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
blw110 27c-dc4 ENTER SQLAllocStmt
blw110 27c-dc4 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
blw110 27c-dc4 ENTER SQLExecDirectW
HSTMT 09E11A50
WCHAR * 0x0C0C60DC [ -3] "SELECT
"group1"."vendor_tb"."ve_name" ,
"group1"."vendor_tb"."ve_code" ,
"group1"."vendor_tb"."ve_max_rtn_months" ,
"group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb"
WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
"group1"."vendor_tb"."ve_code" ASC,
"group1"."vendor_tb"."ve_name" ASC \ 0"
SDWORD -3
===========================

I would suggest looking at these statements in your application to
better understand why they are being executed at the ODBC level more
than once. I'm not familiar with PowerBuilder, so I cannot tell why this
may be occurring in your application. However, this is not a behaviour
of the SQL Anywhere ODBC driver.

Regards,

--
Jeff Albion, Sybase iAnywhere, an SAP Company

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

File: SQLthethird.LOG
00144: WCHAR * 0x0012CA10 [ -3] "set quoted_identifier on \ 0"
00644: WCHAR * 0x015AF7AE [ -3] "SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=Computerworks;Application=Booklog;Signature=000fa55157edb8e14d818eb4fe3db41447146f1571g2262467cef02b663773f4d2834266086a5ea5141'\ 0"
00812: WCHAR * 0x0012CA10 [ -3] "set quoted_identifier on \ 0"
01312: WCHAR * 0x015AF7AE [ -3] "SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=Computerworks;Application=Booklog;Signature=000fa55157edb8e14d818eb4fe3db41447146f1571g2262467cef02b663773f4d2834266086a5ea5141'\ 0"
01354: WCHAR * 0x01391018 [ -3] "SELECT us_userid FROM user_tb WHERE us_userid =? \ 0"
01514: WCHAR * 0x01391018 [ -3] "SELECT "group1"."security_profile_tb"."sp_profile" , "group1"."user_tb"."us_name" , "group1"."user_tb"."us_password" , "group1"."security_profile_tb"."sp_restricted_fields" , Coalesce ( "group1"."security_profile_tb"."sp_idle" , 0 ) FROM { oj "group1"."user_tb" LEFT OUTER JOIN "group1"."security_profile_tb" ON "group1"."user_tb"."us_security_level" ="group1"."security_profile_tb"."us_security_level" } WHERE "group1"."user_tb"."us_userid" =? \ 0"
01826: WCHAR * 0x01391018 [ -3] "SELECT wn_currentuser FROM workstation_tb WHERE wn_id =? \ 0"
01986: WCHAR * 0x01391018 [ -3] "update workstation_tb SET wn_currentuser =? , wn_signon_time =? WHERE wn_id =? \ 0"
02176: WCHAR * 0x014676A0 [ -3] "IF NOT EXISTS (SELECT * FROM sys.syscolumns WHERE tname = 'application_tb') THEN\ 9CREATE TABLE group1.application_tb (ap_db_version integer DEFAULT NULL) ; GRANT ALL ON group1.application_tb TO PUBLIC; END IF;\ 0"
02248: WCHAR * 0x013BAA14 [ -3] "select ap_db_version from group1.application_tb \ 0"
02380: WCHAR * 0x0147D0B8 [ -3] "SELECT 1 FROM sys.systable WHERE table_name ='v73_tb' \ 0"
02512: WCHAR * 0x0162DD64 [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
02594: WCHAR * 0x0162DD64 [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
02676: WCHAR * 0x0162DD64 [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
02986: WCHAR * 0x0162DD64 [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
03296: WCHAR * 0x0162DD64 [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
03606: WCHAR * 0x016226CC [ -3] "SELECT "group1"."store_tb"."st_id" , "group1"."store_tb"."st_taxid" , "group1"."store_tb"."st_taxrate1" , "group1"."store_tb"."st_taxrate2" , "group1"."store_tb"."st_taxrate3" , "group1"."store_tb"."st_exchange_rate" , "group1"."store_tb"."st_convert_rate" , "group1"."store_tb"."st_def_vendor1" , "group1"."store_tb"."st_def_vendor2" , "group1"."store_tb"."st_def_vendor3" , "group1"."store_tb"."st_def_dept" , "group1"."store_tb"."st_def_cashreg_pos" , "group1"."store_tb"."st_def_lineitem_pos" , "group1"."store_tb"."st_postday" , "group1"."store_tb"."st_storename" , "group1"."store_tb"."st_sales_person" , "group1"."store_tb"."st_time_clock" , "group1"."store_tb"."st_oas_ref" , "group1"."store_tb"."st_def_net_pricing" , "group1"."store_tb"."st_def_phone_sort" , "group1"."store_tb"."st_def_gm_dept" , "group1"."store_tb"."st_def_cust_lookup" , "group1"."store_tb"."st_gc_franking" , "group1"."store_tb"."st_oas_receipt" , "group1"."store_tb"."st_round_to" , "group1"."store_tb"."st_round_direction" , "group1"."store_tb"."st_avg_cost" , "group1"."store_tb"."st_drawer_cash_only" , "group1"."store_tb"."st_fats_year" , "group1"."store_tb"."st_fats_term" , "group1"."store_tb"."st_fa_override_term" , "group1"."store_tb"."st_frankref" , "group1"."store_tb"."st_auto_email" , "group1"."store_tb"."st_print_fulfillment" , "group1"."store_tb"."st_print_debit_rec" , "group1"."store_tb"."st_consolidate_statements" , "group1"."store_tb"."st_trans_detail_eop" , "group1"."store_tb"."st_item_detail_eop" , "group1"."store_tb"."st_print_approval" , "group1"."store_tb"."st_validate_..." SDWORD -3
04506: WCHAR * 0x00FC5260 [ -3] "{call group1.ap_SiteID( ) }\ 0"
04632: WCHAR * 0x00FC5260 [ -3] "{call group1.ap_SiteName( ) }\ 0"
04734: WCHAR * 0x01198024 [ -3] "SELECT afn_GetMyStoreID ( ) FROM dummy \ 0"
04866: WCHAR * 0x013B44F4 [ -3] "SELECT st_storename , st_addr1 , st_addr2 , st_city , st_state , st_zip , st_phone1 , st_def_top_msg , st_def_bot_msg , st_receipt_count , st_postday , st_def_cashreg_pos , st_def_vendor1 , st_def_vendor2 , st_def_vendor3 , st_def_dept , st_sales_person , st_time_clock , st_restricted_fields , st_gc_expire_months , st_oas_ref , st_def_net_pricing , st_def_phone_sort , st_def_gm_dept , st_gc_begin , st_gc_end , st_courseworks_store , st_courseworks_store_grp , st_def_cust_lookup , st_restricted_field_override , st_gc_franking , st_check_endorse , tx_code , st_store_num , st_chain_num , st_oas_receipt , st_stat_message , st_round_to , st_round_direction , st_fiscal_year , st_main_san , st_avg_cost , st_def_top_msg2 , st_def_top_msg3 , st_def_bot_msg2 , st_def_bot_msg3 , st_drawer_cash_only , st_check_franking , IsNull ( st_cut_paper , '0' ) , st_merchant_num , st_pccharge_exe , st_processor , st_timeout , st_checkcard , st_multitrans , st_till_control , st_gm_accounttype , st_gm_sitecode , st_gm_billtype , st_gm_ipaddress , st_gm_portnum , st_print_custid , st_offline , st_fa_override_term , st_frank1 , st_frank2 , st_frank3 , st_frank4 , st_frank5 , st_frank6 , st_frank7 , st_frank8 , st_frank9 , st_frankref , st_auto_email , st_print_fulfillment , st_print_debit_rec , st_consolidate_statements , st_print_fa_bal , st_item_detail_eop , st_trans_detail_eop , so_print_from_cashreg , so_form_qty , so_notify_userid , so_auto_delete , so_auto_email_user , so_auto_email_cust , so_deposit_pct , so_deposit_include_tax , st_validate_isbns , st_validation_type , st_exclude_mo_tax , st_giftcrd_thresh , st_mail_order_cc_prompt , st_after_midnight , st_sales_threshold , st_dflt_so_stock_level_1 , st_prompt_inactive_cust FROM group1.store_tb WHERE st_id =afn_GetMyStoreID ( ) \ 0"
08792: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
08874: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
08956: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
09266: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
09576: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
09886: WCHAR * 0x0B6C270C [ -3] "SELECT "group1"."store_tb"."st_id" , "group1"."store_tb"."st_taxid" , "group1"."store_tb"."st_taxrate1" , "group1"."store_tb"."st_taxrate2" , "group1"."store_tb"."st_taxrate3" , "group1"."store_tb"."st_exchange_rate" , "group1"."store_tb"."st_convert_rate" , "group1"."store_tb"."st_def_vendor1" , "group1"."store_tb"."st_def_vendor2" , "group1"."store_tb"."st_def_vendor3" , "group1"."store_tb"."st_def_dept" , "group1"."store_tb"."st_def_cashreg_pos" , "group1"."store_tb"."st_def_lineitem_pos" , "group1"."store_tb"."st_postday" , "group1"."store_tb"."st_storename" , "group1"."store_tb"."st_sales_person" , "group1"."store_tb"."st_time_clock" , "group1"."store_tb"."st_oas_ref" , "group1"."store_tb"."st_def_net_pricing" , "group1"."store_tb"."st_def_phone_sort" , "group1"."store_tb"."st_def_gm_dept" , "group1"."store_tb"."st_def_cust_lookup" , "group1"."store_tb"."st_gc_franking" , "group1"."store_tb"."st_oas_receipt" , "group1"."store_tb"."st_round_to" , "group1"."store_tb"."st_round_direction" , "group1"."store_tb"."st_avg_cost" , "group1"."store_tb"."st_drawer_cash_only" , "group1"."store_tb"."st_fats_year" , "group1"."store_tb"."st_fats_term" , "group1"."store_tb"."st_fa_override_term" , "group1"."store_tb"."st_frankref" , "group1"."store_tb"."st_auto_email" , "group1"."store_tb"."st_print_fulfillment" , "group1"."store_tb"."st_print_debit_rec" , "group1"."store_tb"."st_consolidate_statements" , "group1"."store_tb"."st_trans_detail_eop" , "group1"."store_tb"."st_item_detail_eop" , "group1"."store_tb"."st_print_approval" , "group1"."store_tb"."st_validate_..." SDWORD -3
10734: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."category_tb"."ca_code" , "group1"."category_tb"."ca_disc" FROM "group1"."category_tb" WHERE ( "group1"."category_tb"."ca_disc" > 0 ) \ 0"
10816: WCHAR * 0x0C092238 [ -3] "SELECT "group1"."department_tb"."de_code", "group1"."department_tb"."de_disc", "group1"."department_tb"."de_taxable", "group1"."sales_tax_tb"."tx_code", "group1"."sales_tax_tb"."tx_rate", "group1"."sales_tax_tb"."tx_rate2" FROM { oj "group1"."department_tb" LEFT OUTER JOIN "group1"."sales_tax_tb" ON "group1"."department_tb"."tx_code" = "group1"."sales_tax_tb"."tx_code" } \ 0"
10962: WCHAR * 0x0147D77E [ -3] "Select ado_value from add_in_options_tb where ad_code ='PVSM' and ado_code ='KEY' \ 0"
11062: WCHAR * 0x00E737AE [ -3] "select ado_value from add_in_options_tb where ad_code ='RENT' and ado_code ='KEY' \ 0"
11162: WCHAR * 0x0C093EAC [ -3] "SELECT "group1"."store_tb"."so_notify_userid" FROM "group1"."spclord_item_tb" , "group1"."store_tb" WHERE ( "group1"."spclord_item_tb"."sd_status" in ('K','R') ) and ( "group1"."spclord_item_tb"."sd_hold_until_date" < current date ) and ( "group1"."store_tb"."site_id" = afn_getMySiteID() ) And ( "group1"."store_tb"."so_auto_email_user" = 'T' ) \ 0"
11188: WCHAR * 0x0CAE8008 [ 68] "[Sybase][ODBC Driver][SQL Anywhere]Table 'spclord_item_tb' not found"
11218: WCHAR * 0x013BAA14 [ -3] "select ap_db_version from group1.application_tb \ 0"
11350: WCHAR * 0x0C0C60DC [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
11432: WCHAR * 0x0C0C60DC [ -3] "SELECT "group1"."department_tb"."de_code" , "group1"."department_tb"."de_descript" FROM "group1"."department_tb" WHERE ( "group1"."department_tb"."de_deleted" = 0 ) and ( "group1"."department_tb"."de_code" is not NULL ) and ( "group1"."department_tb"."de_code" <> '' ) ORDER BY "group1"."department_tb"."de_code" ASC \ 0"
11514: WCHAR * 0x0C0C60DC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
11824: WCHAR * 0x0C0C60DC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
12134: WCHAR * 0x0C0C60DC [ -3] "SELECT "group1"."vendor_tb"."ve_name" , "group1"."vendor_tb"."ve_code" , "group1"."vendor_tb"."ve_max_rtn_months" , "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM "group1"."vendor_tb" WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY "group1"."vendor_tb"."ve_code" ASC, "group1"."vendor_tb"."ve_name" ASC \ 0"
12444: WCHAR * 0x0C0DA3CC [ -3] "SELECT "group1"."store_tb"."st_id" , "group1"."store_tb"."st_taxid" , "group1"."store_tb"."st_taxrate1" , "group1"."store_tb"."st_taxrate2" , "group1"."store_tb"."st_taxrate3" , "group1"."store_tb"."st_exchange_rate" , "group1"."store_tb"."st_convert_rate" , "group1"."store_tb"."st_def_vendor1" , "group1"."store_tb"."st_def_vendor2" , "group1"."store_tb"."st_def_vendor3" , "group1"."store_tb"."st_def_dept" , "group1"."store_tb"."st_def_cashreg_pos" , "group1"."store_tb"."st_def_lineitem_pos" , "group1"."store_tb"."st_postday" , "group1"."store_tb"."st_storename" , "group1"."store_tb"."st_sales_person" , "group1"."store_tb"."st_time_clock" , "group1"."store_tb"."st_oas_ref" , "group1"."store_tb"."st_def_net_pricing" , "group1"."store_tb"."st_def_phone_sort" , "group1"."store_tb"."st_def_gm_dept" , "group1"."store_tb"."st_def_cust_lookup" , "group1"."store_tb"."st_gc_franking" , "group1"."store_tb"."st_oas_receipt" , "group1"."store_tb"."st_round_to" , "group1"."store_tb"."st_round_direction" , "group1"."store_tb"."st_avg_cost" , "group1"."store_tb"."st_drawer_cash_only" , "group1"."store_tb"."st_fats_year" , "group1"."store_tb"."st_fats_term" , "group1"."store_tb"."st_fa_override_term" , "group1"."store_tb"."st_frankref" , "group1"."store_tb"."st_auto_email" , "group1"."store_tb"."st_print_fulfillment" , "group1"."store_tb"."st_print_debit_rec" , "group1"."store_tb"."st_consolidate_statements" , "group1"."store_tb"."st_trans_detail_eop" , "group1"."store_tb"."st_item_detail_eop" , "group1"."store_tb"."st_print_approval" , "group1"."store_tb"."st_validate_..." SDWORD -3


Charles W Posted on 2010-11-02 15:08:21.0Z
Sender: 510b.4ccec9b9.1804289383@sybase.com
From: Charles W
Newsgroups: ianywhere.public.general
Subject: Re: SQL Trace Shows Dozens of Attempts [Solved]
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cd02965.7cc0.1681692777@sybase.com>
References: <4cbf3dbc$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Nov 2010 07:08:21 -0800
X-Trace: forums-1-dub 1288710501 10.22.241.41 (2 Nov 2010 07:08:21 -0800)
X-Original-Trace: 2 Nov 2010 07:08:21 -0800, 10.22.241.41
Lines: 595
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8103
Article PK: 7123

An update for anyone else that runs into similar problems:

Our issues turned out to be programmatic, related to the
database communication but internal to our PB code. Our
client has a particularly large database and crunching the
large amounts of data made these programmatic bottlenecks
known in the worst way while other users had not been
impacted.

Our login problem was due to two functions that called
dropdown data windows for system defaults. Since the tables
that filled the dropdowns contains 14,000 records and they
procedures were called twice for three different DDDWs, it
is no surprise that we saw a massive slow down here.

We had a second issue in which we were checking for
duplicated records in our central database. The second part
of that process was pulling all of the records (200k of
them!) accross the WAN in order to join them to a local
table. This should be solved by breaking the process into
two short calls instead of using a join and crunching data
on the client machine.

Thanks for your assistance on this!

-Charles

> Hi Charles,
>
> On 20/10/2010 11:18 AM, C. Westphal wrote:
> > We determined the single connection as repeating dozens
> > of times by setting an ODBC trace at the client. The
> > trace file is attached. The trace file spans only 30
> > seconds of communication, during which the only activity
> > over the ODBC was to login to our application. You can
> > see the same requests repeated over and over again when
> > there should only be one request and response.
>
> There are only two statements that I can find that are
> being repeated:
>
> Statement #1:
>
> SELECT "group1"."department_tb"."de_code" ,
> "group1"."department_tb"."de_descript" FROM
> "group1"."department_tb"
> WHERE ( "group1"."department_tb"."de_deleted" = 0 )
> and ( "group1"."department_tb"."de_code" is not
> NULL ) and ( "group1"."department_tb"."de_code"
> <> '' ) ORDER BY "group1"."department_tb"."de_code"
> ASC
>
> Statement #2:
>
> SELECT "group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code" ,
> "group1"."vendor_tb"."ve_max_rtn_months" ,
> "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM
> "group1"."vendor_tb"
> WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
> "group1"."vendor_tb"."ve_code" ASC,
> "group1"."vendor_tb"."ve_name" ASC
>
> All other statements are executed exactly once. I've
> attached my summary as a text document to this post.
>
> Taking a look at the last repeated entries for Statement
> #2 (Lines 11824 and 12134), you can see that these are
> technically separate statements being executed by your
> application (notice the "FreeStmt"/"AllocStmt" in between
> each of these statements):
>
> ===========================
> blw110 27c-dc4 ENTER SQLExecDirectW
> HSTMT 09E11A50
> WCHAR * 0x0C0C60DC [ -3] "SELECT
> "group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code" ,
> "group1"."vendor_tb"."ve_max_rtn_months" ,
> "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM
> "group1"."vendor_tb"
> WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
> "group1"."vendor_tb"."ve_code" ASC,
> "group1"."vendor_tb"."ve_name" ASC \ 0"
> SDWORD -3
> ...
>
> blw110 27c-dc4 ENTER SQLFreeStmt
> blw110 27c-dc4 EXIT SQLFreeStmt with return
> code 0 (SQL_SUCCESS) blw110 27c-dc4 ENTER
> SQLAllocStmt blw110 27c-dc4 EXIT SQLAllocStmt
> with return code 0 (SQL_SUCCESS) blw110 27c-dc4
> ENTER SQLExecDirectW
> HSTMT 09E11A50
> WCHAR * 0x0C0C60DC [ -3] "SELECT
> "group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code" ,
> "group1"."vendor_tb"."ve_max_rtn_months" ,
> "group1"."vendor_tb"."ve_rtn_perm_reqd" FROM
> "group1"."vendor_tb"
> WHERE ( group1.vendor_tb.ve_deleted = 0 ) ORDER BY
> "group1"."vendor_tb"."ve_code" ASC,
> "group1"."vendor_tb"."ve_name" ASC \ 0"
> SDWORD -3
> ===========================
>
> I would suggest looking at these statements in your
> application to better understand why they are being
> executed at the ODBC level more than once. I'm not
> familiar with PowerBuilder, so I cannot tell why this may
> be occurring in your application. However, this is not a
> behaviour of the SQL Anywhere ODBC driver.
>
> Regards,
>
> --
> Jeff Albion, Sybase iAnywhere, an SAP Company
>
> iAnywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals SQL
> Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/
>
>
> [stmts.txt]
> File: SQLthethird.LOG
> 00144: WCHAR * 0x0012CA10 [ -3]
> "set quoted_identifier on \ 0" 00644:
> WCHAR * 0x015AF7AE [ -3] "SET
> TEMPORARY OPTION
> CONNECTION_AUTHENTICATION='Company=Computerworks
> ;Application=Booklog
> ;Signature=000fa55157edb8e14d818eb4fe3db41447146f1571g2262
> 467cef02b663773f4d2834266086a5ea5141'\ 0" 00812:
> WCHAR * 0x0012CA10 [ -3] "set
> quoted_identifier on \ 0" 01312: WCHAR *
> 0x015AF7AE [ -3] "SET TEMPORARY OPTION
> CONNECTION_AUTHENTICATION='Company=Computerworks
> ;Application=Booklog
> ;Signature=000fa55157edb8e14d818eb4fe3db41447146f1571g2262
> 467cef02b663773f4d2834266086a5ea5141'\ 0" 01354:
> WCHAR * 0x01391018 [ -3] "SELECT
> us_userid FROM user_tb WHERE us_userid =? \ 0" 01514:
> WCHAR * 0x01391018 [ -3] "
> ;SELECT "group1"."security_profile_tb"
> ;."sp_profile" , "group1"."user_tb"
> ;."us_name" , "group1"."user_tb"
> ;."us_password" , "group1"."
> ;security_profile_tb"."sp_restricted_fields" ,
> Coalesce ( "group1"."security_profile_tb"
> ;."sp_idle" , 0 ) FROM { oj "group1"."
> ;user_tb" LEFT OUTER JOIN "group1"."
> ;security_profile_tb" ON "group1"."
> ;user_tb"."us_security_level" ="group1"
> ;."security_profile_tb"."us_security_level"
> ; } WHERE "group1"."user_tb"."
> ;us_userid" =? \ 0" 01826: WCHAR *
> 0x01391018 [ -3] "SELECT wn_currentuser FROM
> workstation_tb WHERE wn_id =? \ 0" 01986:
> WCHAR * 0x01391018 [ -3] "update
> workstation_tb SET wn_currentuser =? , wn_signon_time =?
> WHERE wn_id =? \ 0" 02176: WCHAR *
> 0x014676A0 [ -3] "IF NOT EXISTS (SELECT * FROM
> sys.syscolumns WHERE tname = 'application_tb') THEN\
> 9CREATE TABLE group1.application_tb (ap_db_version integer
> DEFAULT NULL) ; GRANT ALL ON group1.application_tb TO
> PUBLIC; END IF;\ 0" 02248: WCHAR *
> 0x013BAA14 [ -3] "select ap_db_version from
> group1.application_tb \ 0" 02380: WCHAR *
> 0x0147D0B8 [ -3] "SELECT 1 FROM
> sys.systable WHERE table_name ='v73_tb' \ 0" 02512:
> WCHAR * 0x0162DD64 [ -3] "SELECT
> "group1"."department_tb"."de_code"
> ; , "group1"."department_tb"
> ;."de_descript" FROM "group1"."
> ;department_tb" WHERE ( "group1"."
> ;department_tb"."de_deleted" = 0 ) and
> ( "group1"."department_tb"."
> ;de_code" is not NULL ) and ( "group1"
> ;."department_tb"."de_code" <> '' )
> ORDER BY "group1"."department_tb"."
> ;de_code" ASC \ 0" 02594: WCHAR
> * 0x0162DD64 [ -3] "SELECT "
> ;group1"."department_tb"."de_code" ,
> "group1"."department_tb"."
> ;de_descript" FROM "group1"."
> ;department_tb" WHERE ( "group1"."
> ;department_tb"."de_deleted" = 0 ) and
> ( "group1"."department_tb"."
> ;de_code" is not NULL ) and ( "group1"
> ;."department_tb"."de_code" <> '' )
> ORDER BY "group1"."department_tb"."
> ;de_code" ASC \ 0" 02676: WCHAR
> * 0x0162DD64 [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 02986: WCHAR
> * 0x0162DD64 [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 03296: WCHAR
> * 0x0162DD64 [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 03606: WCHAR
> * 0x016226CC [ -3] "SELECT "
> ;group1"."store_tb"."st_id" ,
> "group1"."store_tb"."st_taxid" ,
> "group1"."store_tb"."
> ;st_taxrate1" , "group1"."
> ;store_tb"."st_taxrate2" , "
> ;group1"."store_tb"."st_taxrate3" ,
> "group1"."store_tb"."
> ;st_exchange_rate" , "group1"."
> ;store_tb"."st_convert_rate" , "
> ;group1"."store_tb"."st_def_vendor1" ,
> "group1"."store_tb"."
> ;st_def_vendor2" , "group1"."
> ;store_tb"."st_def_vendor3" , "
> ;group1"."store_tb"."st_def_dept" ,
> "group1"."store_tb"."
> ;st_def_cashreg_pos" , "group1"."
> ;store_tb"."st_def_lineitem_pos" ,
> "group1"."st ore_tb"."st_postday"
> , "group1"."store_tb"."
> ;st_storename" , "group1"."
> ;store_tb"."st_sales_person" , "
> ;group1"."store_tb"."st_time_clock" ,
> "group1"."store_tb"."
> ;st_oas_ref" , "group1"."
> ;store_tb"."st_def_net_pricing" ,
> "group1"."store_tb"."
> ;st_def_phone_sort" , "group1"."
> ;store_tb"."st_def_gm_dept" , "
> ;group1"."store_tb"."
> ;st_def_cust_lookup" , "group1"."
> ;store_tb"."st_gc_franking" , "
> ;group1"."store_tb"."st_oas_receipt" ,
> "group1"."store_tb"."
> ;st_round_to" , "group1"."
> ;store_tb"."st_round_direction" ,
> "group1"."store_tb"."st_avg_cost"
> , "group1"."sto re_tb"."
> ;st_drawer_cash_only" , "group1"
> ;."store_tb"."st_fats_year" ,
> "group1"."store_tb"."st_fats_term"
> , "group1"."store_tb"."
> ;st_fa_override_term" , "group1"
> ;."store_tb"."st_frankref" ,
> "group1"."store_tb"."st_auto_email"
> ; , "group1"."store_tb"."
> ;st_print_fulfillment" , "group1"
> ;."store_tb"."st_print_debit_rec" ,
> "group1"."store_tb"."
> ;st_consolidate_statements" , "
> ;group1"."store_tb"."
> ;st_trans_detail_eop" , "group1"
> ;."s tore_tb"."st_item_detail_eop" ,
> "group1"."store_tb"."
> ;st_print_approval" , "group1"."
> ;store_tb"."st_validate_..." SDWORD
> -3 04506: WCHAR *
> 0x00FC5260 [ -3] "{call group1.ap_SiteID( ) }\
> 0" 04632: WCHAR * 0x00FC5260 [
> -3] "{call group1.ap_SiteName( ) }\ 0" 04734:
> WCHAR * 0x01198024 [ -3] "SELECT
> afn_GetMyStoreID ( ) FROM dummy \ 0" 04866:
> WCHAR * 0x013B44F4 [ -3] "SELECT
> st_storename , st_addr1 , st_addr2 , st_city , st_state ,
> st_zip , st_phone1 , st_def_top_msg , st_def_bot_msg ,
> st_receipt_count , st_postday , st_def_cashreg_pos ,
> st_def_vendor1 , st_def_vendor2 , st_def_vendor3 ,
> st_def_dept , st_sales_person , st_time_clock ,
> st_restricted_fields , st_gc_expire_months , st_oas_ref ,
> st_def_net_pricing , st_def_phone_sort , st_def_gm_dept ,
> st_gc_begin , st_gc_end , st_courseworks_store ,
> st_courseworks_store_grp , st_def_cust_lookup ,
> st_restricted_field_override , st_gc_franking ,
> st_check_endorse , tx_code , st_store_num , st_chain_num ,
> st_oas_receipt , st_stat_message , st_round_to ,
> st_round_direction , st_fiscal_year , st_main_san ,
> st_avg_cost , st_def_top_msg2 , st_def_top_msg3 ,
> st_def_bot_msg2 , st_def_bot_msg3 , st_drawer_cash_only ,
> st_check_franking , IsNull ( st_cut_paper , '0' ) ,
> st_merchant_num , st_pccharge_exe , st_processor ,
> st_timeout , st_checkcard , st_multitrans ,
> st_till_control , st_gm_accounttype , st_gm_sitecode ,
> st_gm_billtype , st_gm_ipaddress , st_gm_portnum ,
> st_print_custid , st_offline , st_fa_override_term ,
> st_frank1 , st_frank2 , st_frank3 , st_frank4 , st_frank5
> , st_frank6 , st_frank7 , st_frank8 , st_frank9 ,
> st_frankref , st_auto_email , st_print_fulfillment ,
> st_print_debit_rec , st_consolidate_statements ,
> st_print_fa_bal , st_item_detail_eop , st_trans_detail_eop
> , so_print_from_cashreg , so_form_qty , so_notify_userid ,
> so_auto_delete , so_auto_email_user , so_auto_email_cust ,
> so_deposit_pct , so_deposit_include_tax ,
> st_validate_isbns , st_validation_type , st_exclude_mo_tax
> , st_giftcrd_thresh , st_mail_order_cc_prompt ,
> st_after_midnight , st_sales_threshold ,
> st_dflt_so_stock_level_1 , st_prompt_inactive_cust FROM
> group1.store_tb WHERE st_id =afn_GetMyStoreID ( ) \ 0"
> 08792: WCHAR * 0x0C093EAC [ -3]
> "SELECT "group1"."department_tb"."
> ;de_code" , "group1"."
> ;department_tb"."de_descript" FROM "
> ;group1"."department_tb" WHERE ( "
> ;group1"."department_tb"."de_deleted"
> = 0 ) and ( "group1"."
> ;department_tb"."de_code" is not NULL ) and
> ( "group1"."department_tb"."
> ;de_code" <> '' ) ORDER BY "group1"
> ;."department_tb"."de_code" ASC
> \ 0" 08874: WCHAR * 0x0C093EAC [
> -3] "SELECT "group1"."
> ;department_tb"."de_code" , "
> ;group1"."department_tb"."de_descript"
> FROM "group1"."department_tb"
> WHERE ( "group1"."department_tb"."
> ;de_deleted" = 0 ) and ( "group1"
> ;."department_tb"."de_code" is not NULL )
> and ( "group1"."department_tb"
> ;."de_code" <> '' ) ORDER BY "
> ;group1"."department_tb"."de_code"
> ASC \ 0" 08956: WCHAR *
> 0x0C093EAC [ -3] "SELECT "group1"."
> ;vendor_tb"."ve_name" , "
> ;group1"."vendor_tb"."ve_code" ,
> "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 09266: WCHAR
> * 0x0C093EAC [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 09576: WCHAR
> * 0x0C093EAC [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 09886: WCHAR
> * 0x0B6C270C [ -3] "SELECT "
> ;group1"."store_tb"."st_id" ,
> "group1"."store_tb"."st_taxid" ,
> "group1"."store_tb"."
> ;st_taxrate1" , "group1"."
> ;store_tb"."st_taxrate2" , "
> ;group1"."store_tb"."st_taxrate3" ,
> "group1"."store_tb"."
> ;st_exchange_rate" , "group1"."
> ;store_tb"."st_convert_rate" , "
> ;group1"."store_tb"."st_def_vendor1" ,
> "group1"."store_tb"."
> ;st_def_vendor2" , "group1"."
> ;store_tb"."st_def_vendor3" , "
> ;group1"."store_tb"."st_def_dept" ,
> "group1"."store_tb"."
> ;st_def_cashreg_pos" , "group1"."
> ;store_tb"."st_def_lineitem_pos" ,
> "group1"."st ore_tb"."st_postday"
> , "group1"."store_tb"."
> ;st_storename" , "group1"."
> ;store_tb"."st_sales_person" , "
> ;group1"."store_tb"."st_time_clock" ,
> "group1"."store_tb"."
> ;st_oas_ref" , "group1"."
> ;store_tb"."st_def_net_pricing" ,
> "group1"."store_tb"."
> ;st_def_phone_sort" , "group1"."
> ;store_tb"."st_def_gm_dept" , "
> ;group1"."store_tb"."
> ;st_def_cust_lookup" , "group1"."
> ;store_tb"."st_gc_franking" , "
> ;group1"."store_tb"."st_oas_receipt" ,
> "group1"."store_tb"."
> ;st_round_to" , "group1"."
> ;store_tb"."st_round_direction" ,
> "group1"."store_tb"."st_avg_cost"
> , "group1"."sto re_tb"."
> ;st_drawer_cash_only" , "group1"
> ;."store_tb"."st_fats_year" ,
> "group1"."store_tb"."st_fats_term"
> , "group1"."store_tb"."
> ;st_fa_override_term" , "group1"
> ;."store_tb"."st_frankref" ,
> "group1"."store_tb"."st_auto_email"
> ; , "group1"."store_tb"."
> ;st_print_fulfillment" , "group1"
> ;."store_tb"."st_print_debit_rec" ,
> "group1"."store_tb"."
> ;st_consolidate_statements" , "
> ;group1"."store_tb"."
> ;st_trans_detail_eop" , "group1"
> ;."s tore_tb"."st_item_detail_eop" ,
> "group1"."store_tb"."
> ;st_print_approval" , "group1"."
> ;store_tb"."st_validate_..." SDWORD
> -3 10734: WCHAR *
> 0x0C093EAC [ -3] "SELECT "group1"."
> ;category_tb"."ca_code" , "
> ;group1"."category_tb"."ca_disc"
> FROM "group1"."category_tb" WHERE (
> "group1"."category_tb"."ca_disc"
> > 0 ) \ 0" 10816: WCHAR *
> 0x0C092238 [ -3] "SELECT "group1"."
> ;department_tb"."de_code", "group1"
> ;."department_tb"."de_disc", "
> ;group1"."department_tb"."de_taxable",
> "group1"."sales_tax_tb"."tx_code",
> "group1"."sales_tax_tb"."tx_rate",
> "group1"."sales_tax_tb"."tx_rate2"
> FROM { oj "group1"."department_tb" LEFT
> OUTER JOIN "group1"."sales_tax_tb" ON "
> ;group1"."department_tb"."tx_code" =
> "group1"."sales_tax_tb"."tx_code"
> } \ 0" 10962: WCHAR * 0x0147D77E [
> -3] "Select ado_value from add_in_options_tb
> where ad_code ='PVSM' and ado_code ='KEY' \ 0" 11062:
> WCHAR * 0x00E737AE [ -3] "
> ;select ado_value from add_in_options_tb where ad_code
> ='RENT' and ado_code ='KEY' \ 0" 11162: WCHAR
> * 0x0C093EAC [ -3] "SELECT "
> ;group1"."store_tb"."so_notify_userid"
> FROM "group1"."spclord_item_tb" ,
> "group1"."store_tb" WHERE ( "
> ;group1"."spclord_item_tb"."sd_status"
> in ('K','R') ) and ( "group1"."
> ;spclord_item_tb"."sd_hold_until_date" <
> current date ) and ( "group1"."
> ;store_tb"."site_id" = afn_getMySiteID() ) And
> ( "group1"."store_tb"."
> ;so_auto_email_user" = 'T' ) \ 0" 11188:
> WCHAR * 0x0CAE8008 [ 68] "
> ;[Sybase][ODBC Driver][SQL Anywhere]Table
> 'spclord_item_tb' not found" 11218: WCHAR *
> 0x013BAA14 [ -3] "select ap_db_version
> from group1.application_tb \ 0" 11350: WCHAR *
> 0x0C0C60DC [ -3] "SELECT "
> ;group1"."department_tb"."de_code" ,
> "group1"."department_tb"."
> ;de_descript" FROM "group1"."
> ;department_tb" WHERE ( "group1"."
> ;department_tb"."de_deleted" = 0 ) and
> ( "group1"."department_tb"."
> ;de_code" is not NULL ) and ( "group1"
> ;."department_tb"."de_code" <> '' )
> ORDER BY "group1"."department_tb"."
> ;de_code" ASC \ 0" 11432: WCHAR
> * 0x0C0C60DC [ -3] "SELECT "
> ;group1"."department_tb"."de_code" ,
> "group1"."department_tb"."
> ;de_descript" FROM "group1"."
> ;department_tb" WHERE ( "group1"."
> ;department_tb"."de_deleted" = 0 ) and
> ( "group1"."department_tb"."
> ;de_code" is not NULL ) and ( "group1"
> ;."department_tb"."de_code" <> '' )
> ORDER BY "group1"."department_tb"."
> ;de_code" ASC \ 0" 11514: WCHAR
> * 0x0C0C60DC [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 11824: WCHAR
> * 0x0C0C60DC [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 12134: WCHAR
> * 0x0C0C60DC [ -3] "SELECT "
> ;group1"."vendor_tb"."ve_name" ,
> "group1"."vendor_tb"."ve_code"
> , "group1"."vendor_tb"."
> ;ve_max_rtn_months" , "group1"."
> ;vendor_tb"."ve_rtn_perm_reqd" FROM "
> ;group1"."vendor_tb" WHERE (
> group1.vendor_tb.ve_deleted = 0 ) ORDER BY "
> ;group1"."vendor_tb"."ve_code"
> ASC, "group1"."vendor_tb"."
> ;ve_name" ASC \ 0" 12444: WCHAR
> * 0x0C0DA3CC [ -3] "SELECT "
> ;group1"."store_tb"."st_id" ,
> "group1"."store_tb"."st_taxid" ,
> "group1"."store_tb"."
> ;st_taxrate1" , "group1"."
> ;store_tb"."st_taxrate2" , "
> ;group1"."store_tb"."st_taxrate3" ,
> "group1"."store_tb"."
> ;st_exchange_rate" , "group1"."
> ;store_tb"."st_convert_rate" , "
> ;group1"."store_tb"."st_def_vendor1" ,
> "group1"."store_tb"."
> ;st_def_vendor2" , "group1"."
> ;store_tb"."st_def_vendor3" , "
> ;group1"."store_tb"."st_def_dept" ,
> "group1"."store_tb"."
> ;st_def_cashreg_pos" , "group1"."
> ;store_tb"."st_def_lineitem_pos" ,
> "group1"."st ore_tb"."st_postday"
> , "group1"."store_tb"."
> ;st_storename" , "group1"."
> ;store_tb"."st_sales_person" , "
> ;group1"."store_tb"."st_time_clock" ,
> "group1"."store_tb"."
> ;st_oas_ref" , "group1"."
> ;store_tb"."st_def_net_pricing" ,
> "group1"."store_tb"."
> ;st_def_phone_sort" , "group1"."
> ;store_tb"."st_def_gm_dept" , "
> ;group1"."store_tb"."
> ;st_def_cust_lookup" , "group1"."
> ;store_tb"."st_gc_franking" , "
> ;group1"."store_tb"."st_oas_receipt" ,
> "group1"."store_tb"."
> ;st_round_to" , "group1"."
> ;store_tb"."st_round_direction" ,
> "group1"."store_tb"."st_avg_cost"
> , "group1"."sto re_tb"."
> ;st_drawer_cash_only" , "group1"
> ;."store_tb"."st_fats_year" ,
> "group1"."store_tb"."st_fats_term"
> , "group1"."store_tb"."
> ;st_fa_override_term" , "group1"
> ;."store_tb"."st_frankref" ,
> "group1"."store_tb"."st_auto_email"
> ; , "group1"."store_tb"."
> ;st_print_fulfillment" , "group1"
> ;."store_tb"."st_print_debit_rec" ,
> "group1"."store_tb"."
> ;st_consolidate_statements" , "
> ;group1"."store_tb"."
> ;st_trans_detail_eop" , "group1"
> ;."s tore_tb"."st_item_detail_eop" ,
> "group1"."store_tb"."
> ;st_print_approval" , "group1"."
> ;store_tb"."st_validate_..." SDWORD
> -3
>
> [Attachment: stmts.txt]