jgersic93
Active Member
Hiya all. It was nice to have met a couple of people at Global Conference
and place a face with the messages on here. That said, here is my question
maybe someone had some experience in.
I am loading data into the F0911z1 table using the R09110Z report. If the
report is run in draft mode, it is ok. If the report is run in final, it
hangs. I have troubleshot the issue down the the transaction processing
being turned on in the report. If I turn the transaction processing option
off, it runs fine. This occurs both on the server and locally. I looked at
the DB (SQL 2000 SP2) and noticed that we get a blocking issue. If I kill
the blocking process, the job compeltes, but fails. I compared the report in
production where it works, and it is setup with the transaction processing
on. Therefore the only thing I can think of is either 1) the business
function(s) involved for transaction processing were not built properly the
last time, or 2) the DEV database has a setting different from the
production server. There are a number of SQL timeout thresholds you can set
but I have not dug into it yet.
Questions- Does anyone know what business function(s) are involved in
transaction processing? If so, I could move them from production and rebuild
them and see if it works..and 2) does anyone know of the specific sql
threshold that applies to blocking and how long a process will wait for the
blocking process to complete? I know the basics of SQL server, and am not
getting into it deeper, so excuse me for my freshman question pertaining to
it.
---------------------------------
OneWorld B733.3 (XE)
SP 19.1_B1, Update 6
Win2k Server SP2
SQL 2000, SP2
Metaframe 1.8a
---------------------------------
John Gersic
JDE CNC Administrator
MicroStrategy, Inc.
Ph: 703.744-6057
1861 International Drive
McLean, VA 22102
www.microstrategy.com <www.microstrategy.com>
and place a face with the messages on here. That said, here is my question
maybe someone had some experience in.
I am loading data into the F0911z1 table using the R09110Z report. If the
report is run in draft mode, it is ok. If the report is run in final, it
hangs. I have troubleshot the issue down the the transaction processing
being turned on in the report. If I turn the transaction processing option
off, it runs fine. This occurs both on the server and locally. I looked at
the DB (SQL 2000 SP2) and noticed that we get a blocking issue. If I kill
the blocking process, the job compeltes, but fails. I compared the report in
production where it works, and it is setup with the transaction processing
on. Therefore the only thing I can think of is either 1) the business
function(s) involved for transaction processing were not built properly the
last time, or 2) the DEV database has a setting different from the
production server. There are a number of SQL timeout thresholds you can set
but I have not dug into it yet.
Questions- Does anyone know what business function(s) are involved in
transaction processing? If so, I could move them from production and rebuild
them and see if it works..and 2) does anyone know of the specific sql
threshold that applies to blocking and how long a process will wait for the
blocking process to complete? I know the basics of SQL server, and am not
getting into it deeper, so excuse me for my freshman question pertaining to
it.
---------------------------------
OneWorld B733.3 (XE)
SP 19.1_B1, Update 6
Win2k Server SP2
SQL 2000, SP2
Metaframe 1.8a
---------------------------------
John Gersic
JDE CNC Administrator
MicroStrategy, Inc.
Ph: 703.744-6057
1861 International Drive
McLean, VA 22102
www.microstrategy.com <www.microstrategy.com>