Hi all,
PB 12.1 Net (6639), SQL Server 2005, SNC.
Stored procedure DW hangs PB (IDE not respond) when I try
retrieve. When I run app and retrieve on this dw hangs app
too.
I try SQLNCLI10 and SQLNCLI.
The same DW on PB 12.1 classic works OK.
In trace log I see PB not set parameters for procedure. On
retrieve dialog I set sBarcodeId to 24059589 but in trace
log I see sBarcodeId = 0.
My trace log :
(15e5fce8): DIALOG CONNECT TO TRACE SNC SQL NATIVE
CLIENT(OLE DB):
(15e5fce8): LOGID=...
(15e5fce8): SERVER=...
(15e5fce8): DBPARM=Database='...',Provider='SQLNCLI10'
(18.760 MS / 18.760 MS)
(15e5fce8): PROCEDURE DESCRIBE: (3.348 MS / 22.108 MS)
(15e5fce8): PROCEDURE DESCRIBE: (1.507 MS / 23.615 MS)
(15e5fce8): PROCEDURE PREPARE:
(15e5fce8): execute dbo.p_GetParamFromBarcodeForDSO_2010v2
@sBarcodeId = '0', @lOperId = 0, @bLogSekw = 0 (3.843 MS /
27.458 MS)
(15e5fce8): EXECUTE: (0.004 MS / 27.462 MS)
(15e5fce8): DESCRIBE: (0.065 MS / 27.527 MS)
(15e5fce8):
name=DocumentName,dsntype=varchar,len=201,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=FilePath,dsntype=varchar,len=201,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=LayerName,dsntype=varchar,len=51,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=OperId,dsntype=int,len=4,type=LONG,pbt=5,dbt=14,ct=0,prec=10
,scale=0
(15e5fce8):
name=OperName,dsntype=varchar(max),len=32767,type=LONGSTRING
,pbt=14,dbt=6,ct=0,prec=0,scale=0
(15e5fce8):
name=StanowiskoId,dsntype=int,len=4,type=LONG,pbt=5,dbt=14,ct=0
,prec=10,scale=0
(15e5fce8):
name=StanowiskoOpis,dsntype=varchar,len=51,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=GniazdoId,dsntype=int,len=4,type=LONG,pbt=5,dbt=14,ct=0
,prec=10,scale=0
(15e5fce8):
name=GniazdoOpis,dsntype=varchar,len=51,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=ElemTkId,dsntype=int,len=4,type=LONG,pbt=5,dbt=14,ct=0,prec=10
,scale=0
(15e5fce8):
name=ElemTkKod,dsntype=varchar,len=101,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8):
name=ElemRef,dsntype=varchar(max),len=32767,type=LONGSTRING,pbt=14
,dbt=6,ct=0,prec=0,scale=0
(15e5fce8):
name=ElemCut,dsntype=smallint,len=2,type=INT,pbt=6,dbt=16,ct=0
,prec=5,scale=0
(15e5fce8):
name=ElemUwagi,dsntype=varchar(max),len=32767,type=LONGSTRING
,pbt=14,dbt=6,ct=0,prec=0,scale=0
(15e5fce8):
name=ObiektFlag,dsntype=smallint,len=2,type=INT,pbt=6,dbt=16
,ct=0,prec=5,scale=0
(15e5fce8):
name=ErrorLog,dsntype=varchar,len=201,type=VCHAR,pbt=2,dbt=1
,ct=0,prec=0,scale=0
(15e5fce8): CANCEL: (0.121 MS / 27.648 MS)
(15e5fce8): OPEN CURSOR: (0.004 MS / 27.652 MS)
(2b0b8a8): DUMMY CURSOR CONNECTION :
(2b0b8a8): USERID=...
(2b0b8a8): LOGID=...
(2b0b8a8): SERVER=...
(2b0b8a8): DBPARM=Database='...',Provider='SQLNCLI10' (0.004
MS / 0.004 MS)
Where is the problem?
Best regards
Marek