par_stmt_prepare set to zero

[Former Member]

in BGD log file I find the entry below:

--- BGD LOG ---

B Fri Oct 23 08:00:55 2009

B Connect to +DBO+0000 as with MSSQL_SERVER=PLATONTEST016 MSSQL_DBNAME=BP1 OBJECT_SOURCE=bp1

C Thread ID:5004

C dbmssslib.dll patch info

C patchlevel 0

C patchno 13

C patchcomment Errors when running with par_stmt_prepare set to zero (1253696)

C np:(local) connection used on PLATONTEST016

C Connected to db server : [PLATONTEST016] server_used : [np:(local)], dbname: BP1, dbuser: dbo

C pn_id:PLATONTEST016_BP1_BP1

B Connection 1 opened (DBSL handle 1)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 012 000 R/3 000000000 ACTIVE YES YES NO 000 255 255 20091022 170949 PLATONTEST016

B 012 001 +DBO+0000 012000040 ACTIVE NO NO NO 004 255 255 20091023 080054 PLATONTEST016

B 012 002 R/3*TIMESTAMP 012000031 DISCONNECTED NO NO NO 000 255 255 20091022 231353 PLATONTEST016

B

B Fri Oct 23 08:18:53 2009

B Disconnected from connection con_da={+DBO+0000,12000041,1}

What should I do with message "par_stmt_prepare set to zero (1253696)"?

When I check in RZ 11 parm dbs/mss/par_stmt_prepare is set to 1.

We are running BW on MSSql 2005, os win 2008.

[Former Member · Accepted solution]

Hi,

C dbmssslib.dll patch info
C patchlevel 0
C patchno 13
C patchcomment Errors when running with par_stmt_prepare set to zero (1253696)

have you tried to use the latest dbmsslib.dll instead?

Sven