Re: Oracle/PowerBuilder dll connection issues

From: Dan <everkleer80_at_gmail.com>
Date: 12 Sep 2006 08:37:26 -0700
Message-ID: <1158075446.539545.116070@m73g2000cwd.googlegroups.com>

Sorry, don't know why my link above copied wrong... this one should be correct:
http://groups.google.com/group/comp.databases.oracle.misc/browse_frm/thread/c0adea9871bc2eab?hl=en

The following is an excerpt from the end of my pbtrace.log file - some data has been truncated/replaced with x's for confidentiallity purposes:

/*---------------------------------------------------*/
/*                 9/12/2006  10:41                  */
/*---------------------------------------------------*/


(a92008): LOGIN: (1020.064 MilliSeconds)

(a92008): CONNECT TO trace O84:

(a92008): LOGID=DCARTER

(a92008): DBPARM=PWExpDialog=1,PWDialog=1

(a92008): SERVER=hipmpuat (0.001 MilliSeconds)

(a92008): PREPARE: (0.000 MilliSeconds)

(a92008): BEGIN TRANSACTION: (0.000 MilliSeconds)

(a92008): PREPARE WITH BIND VARIABLES:
(a92008): select "SC_BASE"."STAFF"."STAFF_ID" ,

"SC_BASE"."STAFF"."NAME_FIRST" || ' ' || "SC_BASE"."STAFF"."NAME_LAST"
, "SC_BASE"."STAFF"."STATION" , "SC_BASE"."STAFF"."STATION_EXTENSION" ,
"SC_BASE"."STAFF"."STATUS" , "SC_BASE"."RIGHTS_STAFF_LINK"."RIGHTS_ID"

from sc_base.staff , sc_base.rights_staff_link where sc_base.staff.login_id =:1 and sc_base.rights_staff_link.staff_id =sc_base.staff.staff_id and sc_base.staff.active ='Y'
(a92008): VCHAR Length=7 ID=:1 *DCARTER* (10.667 MilliSeconds)
(a92008): GET AFFECTED ROWS: (0.023 MilliSeconds)
(a92008): ^ 0 Rows Affected
(a92008): GET NUMBER OF COLUMNS SELECTED: (84.094 MilliSeconds)
(a92008): ^ 6 Columns
(a92008): DESCRIBE SELECT: (0.002 MilliSeconds)
(a92008): 6 Bind Columns
(a92008): CHAR Length=13
(a92008): CHAR Length=52
(a92008): CHAR Length=16
(a92008): CHAR Length=6
(a92008): CHAR Length=2
(a92008): CHAR Length=13
(a92008): EXECUTE: (0.003 MilliSeconds)
(a92008): BIND SELECT OUTPUT BUFFER (PowerScript): (0.113 MilliSeconds)
(a92008): 6 Bind Columns
(a92008): CHAR Length=40
(a92008): CHAR Length=52
(a92008): CHAR Length=40
(a92008): CHAR Length=40
(a92008): CHAR Length=40
(a92008): CHAR Length=40
(a92008): FETCH NEXT: (33.014 MilliSeconds)
(a92008): COLUMN=S00056783684 COLUMN=Dan
Carter COLUMN=NULL COLUMN=NULL COLUMN=N COLUMN=R00000000001
(a92008): GET AFFECTED ROWS: (0.002 MilliSeconds)
(a92008): ^ 1 Rows Affected
(a92008): FETCH NEXT: (0.034 MilliSeconds)
(a92008):

Error 1 (rc 100)
(a92008): CANCEL: (0.002 MilliSeconds)
(a92008): PREPARE WITH BIND VARIABLES:
(a92008): SELECT "SC_BASE"."STAFF_PROGRAM_LINK"."PROGRAM_ID"
FROM "SC_BASE"."STAFF_PROGRAM_LINK" WHERE ( SC_BASE."STAFF_PROGRAM_LINK"."STAFF_ID" = :sStaffID )
(a92008): VCHAR Length=12 ID=:sStaffID *S00056783684* (0.059
MilliSeconds)
(a92008): BIND SELECT OUTPUT BUFFER (DataWindow): (0.016 MilliSeconds)
(a92008): ,len=5,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): EXECUTE: (35.139 MilliSeconds)
(a92008): FETCH NEXT: (0.051 MilliSeconds)
(a92008):

Error 1 (rc 100)
(a92008): PREPARE:
(a92008): SELECT "SC_BASE"."STAFF"."NAME_LAST" ,

"SC_BASE"."STAFF"."NAME_FIRST" ,           "SC_BASE"."STAFF"."LOGIN_ID"
,           "SC_BASE"."STAFF"."STAFF_ID" ,
"SC_BASE"."STAFF"."STATION_EXTENSION" ,
"SC_BASE"."STAFF"."STATUS" ,           "SC_BASE"."STAFF"."ACTIVE" ,
      "SC_BASE"."STAFF"."TITLE"     FROM "SC_BASE"."STAFF"     (0.047

MilliSeconds)
(a92008): BIND SELECT OUTPUT BUFFER (DataWindow): (0.114 MilliSeconds)
(a92008): ,len=32,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=22,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=14,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=14,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=7,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=3,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): ,len=52,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(a92008): EXECUTE: (56.481 MilliSeconds)
(a92008): FETCH NEXT: (189.200 MilliSeconds)
(a92008): COLUMN=xxxxxxxx COLUMN=xxxxx COLUMN=xxxxxxxxx

COLUMN=S00107781042 COLUMN=NULL COLUMN=N COLUMN=Y COLUMN=Underwriting
(a92008): FETCH NEXT: (0.002 MilliSeconds)
(a92008): COLUMN=xxxxxxxx COLUMN=xxxxx COLUMN=xxxxxxxx

COLUMN=S00000000001 COLUMN=xxxx COLUMN=NULL COLUMN=N COLUMN=Ex
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxxxxx COLUMN=xxxxxx COLUMN=xxxxxxxxxx

COLUMN=S00000000006 COLUMN=xxxx COLUMN=NULL COLUMN=N COLUMN=Ex
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxxxxxx COLUMN=xxxxxxxx COLUMN=xxxxxxxxxxx

COLUMN=S00000000009 COLUMN=xxxx COLUMN=NULL COLUMN=N COLUMN=Direct Marketing
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxxxxxxx COLUMN=xxxx COLUMN=xxxxx

COLUMN=S00000000010 COLUMN=xxxx COLUMN=NULL COLUMN=N COLUMN=QA Rep
(a92008): FETCH NEXT: (0.002 MilliSeconds)
(a92008): COLUMN=xxxx COLUMN=xxxxx COLUMN=xxxxx

COLUMN=S00000000011 COLUMN=xxxx COLUMN=NULL COLUMN=N COLUMN=Ex
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxxx COLUMN=xxxx COLUMN=xxxxxxxx

COLUMN=S00000000012 COLUMN=xxxx COLUMN=NULL COLUMN=Y COLUMN=Quality Assurance Rep
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxxxxx COLUMN=xxxxx COLUMN=xxxxxxxxxx

COLUMN=S00000000013 COLUMN=xxxx COLUMN=NULL COLUMN=Y COLUMN=Direct Marketing Rep

< 4,280 lines of this truncated >

(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxxxxx COLUMN=xxxx COLUMN=xxxxxxx

COLUMN=S00149443952 COLUMN=NULL COLUMN=N COLUMN=Y COLUMN=NULL
(a92008): FETCH NEXT: (0.001 MilliSeconds)
(a92008): COLUMN=xxx COLUMN=xxxxxx COLUMN=xxxx

COLUMN=S00149444050 COLUMN=NULL COLUMN=N COLUMN=Y COLUMN=NULL
(a92008): FETCH NEXT:

It always does this, coming to a 'FECTH NEXT', then hangs and my session gets dropped (I've verified this by watching my session in Toad for Oracle's session browser) and I have to end the process through the task manager. Assuming my math is correct, exactly 2150 rows are retrieved from the staff table before it hangs. No Sqlnet.log file is generated.

Hope this helps,
Dan Received on Tue Sep 12 2006 - 10:37:26 CDT