If you want to use the built-in macros in mrStudio please find this
location on your system-
C:\Program Files\SPSS Dimensions\Accessories
..then look for WordCapture.exe. You can get its user manual as
WordCapture.doc at the same location. I hope it'll work for you.

Njoy,
Abhi


--- In NADUG@yahoogroups.com, "Jeff Thompson" <jeffreylthompson@...>
wrote:
>
> We've been using JEdit to script surveys for about a year.  Not
> because of licensing fees but for other production reasons.
>
> 1) There is no real "Macro" facility in mrStudio.  With JEdit we
can
> create complex macros that allow us to easily create metadata from
> text questionnaires
>
> 2) The MDD is not a human readable file, and so can't be used with
> code generation tools like CODESMITH or other internally produced
> survey generators.
>
> 3) We cannot use DIFF tools to easily merge MDD's.
>
> For these reasons we have developed a system of first creating the
> survey (as an IVS file) with a code generating tool, then
importing
> the file into mrStudio, and running the survey in debug mode.  At
> this point we do all the edits in mrStudio.
>
> We think the step by step debugging and Auto answer are a true
> productivity gain, and would use mrStudio completely if we could,
> but it is such a poor Text Editor that we would rather manage a
more
> complex process.
>
> If SPSS ever licenses the survey player Lite engine separately
from
> mrStudio (as they might with the CAPI version) then maybe an
> mrStudio free process would work.

Hi David,

What version of dimensions are you seeing this in ?

Doug

--- In NADUG@yahoogroups.com, "Zotter, E. David" <david@...> wrote:
>
> Is anyone else seeing this behavior?
>
>
>
> From: Zotter, E. David
> Sent: Wednesday, March 05, 2008 7:31 PM
> To: 'MR Tech Support'
> Cc: 'Leeser, Travis'
> Subject: RE: SPSS CaseID : CD/558968 - Customer reproting that
Engines are failing.
>
>
> It is my understanding that this topic has been discussed
internally at SPSS with product development group of
mrInterview/Dimensions.
>
>
> In summary:
>
> Even though under dimensionnet the interview engine is listed in a
failed status, it shows available and registered on the web tier via
the registeredengines.xml and as well registered via running
regintsvr.exe on the application box.
>
> Is the status in dimensionnet the determining factor on the engine
being available or is it a bug that can be ignored until the IISRESET
is performed in off hours.
>
>
>
> What I guess I'm looking for is.....  a status update on when this
bug might be fixed?   The standard answer seems to always be that it
is fixed in a future version that is unreleased.
>
> Let me know...
>
> Thanks,
>
> -David
>
>
>
> From: MR Tech Support [mailto:mrsupport@...]
> Sent: Tuesday, March 04, 2008 1:30 PM
> To: Zotter, E. David
> Subject: SPSS CaseID : CD/558968 - Customer reproting that Engines
are failing.
>
> GfK
> Company ID: 262565
> David Zotter
>
> David,
>
> I just got a call from Dennis at IP-Soft regarding the issue with
engines failing. I am currently waiting on the IVW and ISE logs, but
he did not have any specific information he could give me. Can you
give me some information on what you are seeing and why you believe
you are having engine problems. As much detail that you can give
would be appreciated.
>
> Chris
>

Hi David

We have running a CATI center with Dimensions 4.5 and this problem
keeps cropping up intermittently on our servers as well.

Regards
Maniish

--- In NADUG@yahoogroups.com, "Zotter, E. David" <david@...> wrote:
>
> Sorry about that, I guess I left out a critical part of the puzzle.
>
> We are seeing this with version 4.5....
>
> -David
>
> From: NADUG@yahoogroups.com [mailto:NADUG@yahoogroups.com] On
Behalf Of dporton
> Sent: Sunday, March 23, 2008 6:10 PM
> To: NADUG@yahoogroups.com
> Subject: [NADUG] Re: FW: SPSS CaseID : CD/558968 - Customer
reproting that Engines are failing.
>
>
> Hi David,
>
> What version of dimensions are you seeing this in ?
>
> Doug
>
> --- In NADUG@yahoogroups.com<mailto:NADUG%
40yahoogroups.com>, "Zotter, E. David" <david@> wrote:
> >
> > Is anyone else seeing this behavior?
> >
> >
> >
> > From: Zotter, E. David
> > Sent: Wednesday, March 05, 2008 7:31 PM
> > To: 'MR Tech Support'
> > Cc: 'Leeser, Travis'
> > Subject: RE: SPSS CaseID : CD/558968 - Customer reproting that
> Engines are failing.
> >
> >
> > It is my understanding that this topic has been discussed
> internally at SPSS with product development group of
> mrInterview/Dimensions.
> >
> >
> > In summary:
> >
> > Even though under dimensionnet the interview engine is listed in a
> failed status, it shows available and registered on the web tier via
> the registeredengines.xml and as well registered via running
> regintsvr.exe on the application box.
> >
> > Is the status in dimensionnet the determining factor on the engine
> being available or is it a bug that can be ignored until the
IISRESET
> is performed in off hours.
> >
> >
> >
> > What I guess I'm looking for is..... a status update on when this
> bug might be fixed? The standard answer seems to always be that it
> is fixed in a future version that is unreleased.
> >
> > Let me know...
> >
> > Thanks,
> >
> > -David
> >
> >
> >
> > From: MR Tech Support [mailto:mrsupport@]
> > Sent: Tuesday, March 04, 2008 1:30 PM
> > To: Zotter, E. David
> > Subject: SPSS CaseID : CD/558968 - Customer reproting that Engines
> are failing.
> >
> > GfK
> > Company ID: 262565
> > David Zotter
> >
> > David,
> >
> > I just got a call from Dennis at IP-Soft regarding the issue with
> engines failing. I am currently waiting on the IVW and ISE logs, but
> he did not have any specific information he could give me. Can you
> give me some information on what you are seeing and why you believe
> you are having engine problems. As much detail that you can give
> would be appreciated.
> >
> > Chris
> >
>

Hi,



I have found when using the TOM module of MrStudio 4.0, the export to
excel process can be very slow. When there are many tables,  or looped
tables i often get an unknown excel aggregator error when the export
fails. the odd thing is that i have been using MrStudio TOM and DMOM 4.0
for about a year on this machine.  I can go to another machine and
export the same Excel file in less than 1/2 the time without issue.  My
computer has twice the memory and processing speed of this computer

i am beginnig to think that MrStudio TOM has a hidden cache memory
somewhere on my computer that is almost full to capacity. And the
difference between the 2 computers is that the second, smaller computer
does not have as large of an mrstudio memory cache because it has not
been in an MrStudio TOM production mode for as long.....

Has anyone else had this problem? and if so, have you found a hidden
cache and found a way to remove it?

Although I will date myself, i have programmed scripts using quancept
and qcweb, but i haven't used the IOM module as of yet. Instead, i
have been concentrating on the DMOM and TOM modules for back-end
reporting. I used Quantum for 20+ years before switching over to
MrStudio TOM and DMOM, and i can see benefits to using both.

i have been successful at reporting data in MrStudio DMOM/TOM like
market share, processed (add or summary) tables, factor, target and
rim weights, calculated tables like total dollar outlay, dollars per
account, max number of accounts within loops, and dollars per user.
In Quantum, i would have used levels or process or m rows with id's
and ex statements to aggregate the same data.

So my interests mainly center on the backend MrStudio processes at
this time.

thanks for replying



--- In NADUG@yahoogroups.com, "Jeff Thompson" <jeffreylthompson@...>
wrote:
>
> It hasn't been too active recently, but I'm certainly happy to
share
> ideas.  What are your interests?
>
>
> --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> >
> > Hi!
> >
> > I just noticed this group on Yahoo.  I have been using the
mrStudio
> dms
> > and tom programs for about 3 months now and was looking for an
active
> > forum for sharing ideas, suggestions, etc....
> >
> > I noticed the last post was in November 06... Is this an active
group?
> >
> > Regards,
> >
> > juls
> >
>

Hi,

We have experienced the same results with mrStudio 4.0 as well.
Sometimes it results in tables missing (empty worksheets), other
times the unknown aggregator error.

Our 'fix' has always been to shut down mrStudio and re-run.

I haven't tested it in any more recent releases, but I'd expect that
they've improved the export.

--- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@...> wrote:
>
>
> Hi,
>
>
>
> I have found when using the TOM module of MrStudio 4.0, the export
to
> excel process can be very slow. When there are many tables,  or
looped
> tables i often get an unknown excel aggregator error when the
export
> fails. the odd thing is that i have been using MrStudio TOM and
DMOM 4.0
> for about a year on this machine.  I can go to another machine and
> export the same Excel file in less than 1/2 the time without
issue.  My
> computer has twice the memory and processing speed of this computer
>
> i am beginnig to think that MrStudio TOM has a hidden cache memory
> somewhere on my computer that is almost full to capacity. And the
> difference between the 2 computers is that the second, smaller
computer
> does not have as large of an mrstudio memory cache because it has
not
> been in an MrStudio TOM production mode for as long.....
>
> Has anyone else had this problem? and if so, have you found a
hidden
> cache and found a way to remove it?
>

I am not aware f any cache files that studio would use, so I think
you would need to check a few things on your slow machine.  When the
script is running, look at the memory in the taskbar, is it flipping
out and using swap space? I suspect it is and hence the slow down. To
help improve this you can make sure you don't have unwanted programs
running, check taskbar and see what is using memory and stop them if
needed. Another thing to do would be to do a checkdisk and a defrag.
If you have a really defragmented system then when the data is being
written to the disk it will take longer.

So in general my thoughts would be there is something making your
machine slower or using most of the memory up ?

Oh and i agree with kylesimpson 4.5 should be faster.


--- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@...> wrote:
>
> Hi,
>
> We have experienced the same results with mrStudio 4.0 as well.
> Sometimes it results in tables missing (empty worksheets), other
> times the unknown aggregator error.
>
> Our 'fix' has always been to shut down mrStudio and re-run.
>
> I haven't tested it in any more recent releases, but I'd expect
that
> they've improved the export.
>
> --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> >
> >
> > Hi,
> >
> >
> >
> > I have found when using the TOM module of MrStudio 4.0, the
export
> to
> > excel process can be very slow. When there are many tables,  or
> looped
> > tables i often get an unknown excel aggregator error when the
> export
> > fails. the odd thing is that i have been using MrStudio TOM and
> DMOM 4.0
> > for about a year on this machine.  I can go to another machine and
> > export the same Excel file in less than 1/2 the time without
> issue.  My
> > computer has twice the memory and processing speed of this
computer
> >
> > i am beginnig to think that MrStudio TOM has a hidden cache
memory
> > somewhere on my computer that is almost full to capacity. And the
> > difference between the 2 computers is that the second, smaller
> computer
> > does not have as large of an mrstudio memory cache because it has
> not
> > been in an MrStudio TOM production mode for as long.....
> >
> > Has anyone else had this problem? and if so, have you found a
> hidden
> > cache and found a way to remove it?
> >
>

Hi, and Thanks for your comments - i have checked my computer out but
the cpu usage doesn't go over 50% and the memory doesn't hit the max.
i have dual processors for 2.8 Ghz with 2.5 gb ram and am expecting
an upgrade soon. One thing i do notice is that having outlook open
often causes the unknown aggregator error in during an excel export.
if i have problems and shut outlook down i can run the same file
without issue. i suspect it has something to do with the ms clipboard
and hidden temp files, but as yet have not been able to find any
hidden files to remove.

i think my company is skipping 4.5 and will be loading 5.0 (currently
testing) or 5.5 on our machines. so i am also hoping that 5.0 or 5.5
improves this part of the TOM experience.


--- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@...> wrote:
>
> I am not aware f any cache files that studio would use, so I think
> you would need to check a few things on your slow machine.  When
the
> script is running, look at the memory in the taskbar, is it
flipping
> out and using swap space? I suspect it is and hence the slow down.
To
> help improve this you can make sure you don't have unwanted
programs
> running, check taskbar and see what is using memory and stop them
if
> needed. Another thing to do would be to do a checkdisk and a
defrag.
> If you have a really defragmented system then when the data is
being
> written to the disk it will take longer.
>
> So in general my thoughts would be there is something making your
> machine slower or using most of the memory up ?
>
> Oh and i agree with kylesimpson 4.5 should be faster.
>
>
> --- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@> wrote:
> >
> > Hi,
> >
> > We have experienced the same results with mrStudio 4.0 as well.
> > Sometimes it results in tables missing (empty worksheets), other
> > times the unknown aggregator error.
> >
> > Our 'fix' has always been to shut down mrStudio and re-run.
> >
> > I haven't tested it in any more recent releases, but I'd expect
> that
> > they've improved the export.
> >
> > --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> > >
> > >
> > > Hi,
> > >
> > >
> > >
> > > I have found when using the TOM module of MrStudio 4.0, the
> export
> > to
> > > excel process can be very slow. When there are many tables,  or
> > looped
> > > tables i often get an unknown excel aggregator error when the
> > export
> > > fails. the odd thing is that i have been using MrStudio TOM and
> > DMOM 4.0
> > > for about a year on this machine.  I can go to another machine
and
> > > export the same Excel file in less than 1/2 the time without
> > issue.  My
> > > computer has twice the memory and processing speed of this
> computer
> > >
> > > i am beginnig to think that MrStudio TOM has a hidden cache
> memory
> > > somewhere on my computer that is almost full to capacity. And
the
> > > difference between the 2 computers is that the second, smaller
> > computer
> > > does not have as large of an mrstudio memory cache because it
has
> > not
> > > been in an MrStudio TOM production mode for as long.....
> > >
> > > Has anyone else had this problem? and if so, have you found a
> > hidden
> > > cache and found a way to remove it?
> > >
> >
>

Hey thanks for commenting. i have found that empty worksheets can be a
problem, so i usually do a quick for each loop after populating to
remove any tables with a base of  zero - before the export takes place.
i have also found that having a table or default filter still active at
the end of the with tables loop can also cause the excel export to fail.

i also shut down mrstudio and often have to remove the temporary
application data/spss dimensions/mrstudio/4.0 temp file, but when i do
that all of the macros i create to use in mrstudio are also deleted -
and then i have to pull them in again.





--- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@...> wrote:
>
> Hi,
>
> We have experienced the same results with mrStudio 4.0 as well.
> Sometimes it results in tables missing (empty worksheets), other
> times the unknown aggregator error.
>
> Our 'fix' has always been to shut down mrStudio and re-run.
>
> I haven't tested it in any more recent releases, but I'd expect that
> they've improved the export.
>
> --- In NADUG@yahoogroups.com, "dancing_lake" chewygold@ wrote:
> >
> >
> > Hi,
> >
> >
> >
> > I have found when using the TOM module of MrStudio 4.0, the export
> to
> > excel process can be very slow. When there are many tables, or
> looped
> > tables i often get an unknown excel aggregator error when the
> export
> > fails. the odd thing is that i have been using MrStudio TOM and
> DMOM 4.0
> > for about a year on this machine. I can go to another machine and
> > export the same Excel file in less than 1/2 the time without
> issue. My
> > computer has twice the memory and processing speed of this computer
> >
> > i am beginnig to think that MrStudio TOM has a hidden cache memory
> > somewhere on my computer that is almost full to capacity. And the
> > difference between the 2 computers is that the second, smaller
> computer
> > does not have as large of an mrstudio memory cache because it has
> not
> > been in an MrStudio TOM production mode for as long.....
> >
> > Has anyone else had this problem? and if so, have you found a
> hidden
> > cache and found a way to remove it?
> >
>

hi,

I just create a variable at the top, to include all tables in and
then check right after populating to see if Xvariable = 0 then remove
the table.


--- In NADUG@yahoogroups.com, <pietro.tranquillino@...> wrote:
>
> How do you do it?
>
> ________________________________
>
> From: NADUG@yahoogroups.com [mailto:NADUG@yahoogroups.com] On
Behalf Of dancing_lake
> Sent: martedì 15 aprile 2008 13:34
> To: NADUG@yahoogroups.com
> Subject: [NADUG] Re: MrStudio Cache memory
>
>
>
>
>
> Hey thanks for commenting. i have found that empty worksheets can
be a
> problem, so i usually do a quick for each loop after populating to
> remove any tables with a base of zero - before the export takes
place.
> i have also found that having a table or default filter still
active at
> the end of the with tables loop can also cause the excel export to
fail.
>
> i also shut down mrstudio and often have to remove the temporary
> application data/spss dimensions/mrstudio/4.0 temp file, but when i
do
> that all of the macros i create to use in mrstudio are also
deleted -
> and then i have to pull them in again.
>
> --- In NADUG@yahoogroups.com <mailto:NADUG%
40yahoogroups.com> , "kylefsimpson" <kyle.simpson@> wrote:
> >
> > Hi,
> >
> > We have experienced the same results with mrStudio 4.0 as well.
> > Sometimes it results in tables missing (empty worksheets), other
> > times the unknown aggregator error.
> >
> > Our 'fix' has always been to shut down mrStudio and re-run.
> >
> > I haven't tested it in any more recent releases, but I'd expect
that
> > they've improved the export.
> >
> > --- In NADUG@yahoogroups.com <mailto:NADUG%
40yahoogroups.com> , "dancing_lake" chewygold@ wrote:
> > >
> > >
> > > Hi,
> > >
> > >
> > >
> > > I have found when using the TOM module of MrStudio 4.0, the
export
> > to
> > > excel process can be very slow. When there are many tables, or
> > looped
> > > tables i often get an unknown excel aggregator error when the
> > export
> > > fails. the odd thing is that i have been using MrStudio TOM and
> > DMOM 4.0
> > > for about a year on this machine. I can go to another machine
and
> > > export the same Excel file in less than 1/2 the time without
> > issue. My
> > > computer has twice the memory and processing speed of this
computer
> > >
> > > i am beginnig to think that MrStudio TOM has a hidden cache
memory
> > > somewhere on my computer that is almost full to capacity. And
the
> > > difference between the 2 computers is that the second, smaller
> > computer
> > > does not have as large of an mrstudio memory cache because it
has
> > not
> > > been in an MrStudio TOM production mode for as long.....
> > >
> > > Has anyone else had this problem? and if so, have you found a
> > hidden
> > > cache and found a way to remove it?
> > >
> >
>
>
>
>
>
> ====================================================
> This email is confidential and intended solely for the use of the
> individual or organisation to whom it is addressed. Any opinions or
> advice presented are solely those of the author and do not
necessarily
> represent those of the Millward Brown Group of Companies.  If you
are
> not the intended recipient of this email, you should not copy,
modify,
> distribute or take any action in reliance on it. If you have
received
> this email in error please notify the sender and delete this email
> from your system. Although this email has been checked for viruses
>  and other defects, no responsibility can be accepted for any loss
or
> damage arising from its receipt or use.
> ====================================================
>

Hi,

I have used both straight weights and the target, factor and rim weight
engines successfully in the DMOM and TOM modules, but noticed that the
position of the weight engine needs to be located at the end of the DMOM
script (before any onafterjob/onjobend transformations) or the weights
shown can be slightly different.

i realize that onnextcase editing statements can affect a weight matrix,
but i have found that onnextcase editing statements (unrelated to any
weight matrix included in a weight engine) can affect the weight engine
calculations in mrstudio 4.0... and that simply my moving the weight
engine, i can slightly alter the weights being applied.

has anyone else seen this?

This has got me interested now...

You are correct ... deleting the files in ...

C:\Documents and Settings\[Username]\Application
Data\SPSS\mrStudio\4.0.0.0

will get rid of your macros and restore any mrStudio to the factory
default. If you are testing 5.0 i suggest you patch to patch 2 before
you run any test's.

In my opinion if you can , i would test 4.5 fully patched also.

Back to your speed issue though, do you have any virus software
running ( is this running like mad when you run your script ) ? Have
you done a defrag and a check disk, delete all temp files on machine
fisrt with the disk cleanup tool ( Are you running XP? ) .  The fact
that outlook running causes some issues is interesting also, this
should not be the case at all, there is no copying or pasting going
on and if you are exporting to excel then outlook should have nothing
to do with it.  What data source are using for this script?


--- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@...> wrote:
>
> Hi, and Thanks for your comments - i have checked my computer out
but
> the cpu usage doesn't go over 50% and the memory doesn't hit the
max.
> i have dual processors for 2.8 Ghz with 2.5 gb ram and am expecting
> an upgrade soon. One thing i do notice is that having outlook open
> often causes the unknown aggregator error in during an excel
export.
> if i have problems and shut outlook down i can run the same file
> without issue. i suspect it has something to do with the ms
clipboard
> and hidden temp files, but as yet have not been able to find any
> hidden files to remove.
>
> i think my company is skipping 4.5 and will be loading 5.0
(currently
> testing) or 5.5 on our machines. so i am also hoping that 5.0 or
5.5
> improves this part of the TOM experience.
>
>
> --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> >
> > I am not aware f any cache files that studio would use, so I
think
> > you would need to check a few things on your slow machine.  When
> the
> > script is running, look at the memory in the taskbar, is it
> flipping
> > out and using swap space? I suspect it is and hence the slow
down.
> To
> > help improve this you can make sure you don't have unwanted
> programs
> > running, check taskbar and see what is using memory and stop them
> if
> > needed. Another thing to do would be to do a checkdisk and a
> defrag.
> > If you have a really defragmented system then when the data is
> being
> > written to the disk it will take longer.
> >
> > So in general my thoughts would be there is something making your
> > machine slower or using most of the memory up ?
> >
> > Oh and i agree with kylesimpson 4.5 should be faster.
> >
> >
> > --- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@>
wrote:
> > >
> > > Hi,
> > >
> > > We have experienced the same results with mrStudio 4.0 as
well.
> > > Sometimes it results in tables missing (empty worksheets),
other
> > > times the unknown aggregator error.
> > >
> > > Our 'fix' has always been to shut down mrStudio and re-run.
> > >
> > > I haven't tested it in any more recent releases, but I'd expect
> > that
> > > they've improved the export.
> > >
> > > --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> > > >
> > > >
> > > > Hi,
> > > >
> > > >
> > > >
> > > > I have found when using the TOM module of MrStudio 4.0, the
> > export
> > > to
> > > > excel process can be very slow. When there are many tables,
or
> > > looped
> > > > tables i often get an unknown excel aggregator error when the
> > > export
> > > > fails. the odd thing is that i have been using MrStudio TOM
and
> > > DMOM 4.0
> > > > for about a year on this machine.  I can go to another
machine
> and
> > > > export the same Excel file in less than 1/2 the time without
> > > issue.  My
> > > > computer has twice the memory and processing speed of this
> > computer
> > > >
> > > > i am beginnig to think that MrStudio TOM has a hidden cache
> > memory
> > > > somewhere on my computer that is almost full to capacity. And
> the
> > > > difference between the 2 computers is that the second,
smaller
> > > computer
> > > > does not have as large of an mrstudio memory cache because it
> has
> > > not
> > > > been in an MrStudio TOM production mode for as long.....
> > > >
> > > > Has anyone else had this problem? and if so, have you found a
> > > hidden
> > > > cache and found a way to remove it?
> > > >
> > >
> >
>

Yes - there is anti-virus software that runs in the background
(corporate standard). temp files are removed regularly, and i have
defragged the disk recently without much improvement, but it probably
needs it again. i am using XP with office 2007.

first data pulls usually come straight from the sql database, run
through dmom and then i usually use a ddf  as the data file for all mrs
scripts. i found it much faster than using xml.

i get the feeling that export problems occur when tom takes over the ms
clipboard during the export process; once the excel export process
begins, i can't copy or paste in any other application (e.g. notepad,
wordpad, etc..) because what pastes is usually the proportion, mean and
stat level text that appears in the bottom of an mrs-scripted table.

sometimes, after the excel export occurs, i have received an error
message after opening excel like, "can't copy, msclipboard is full".
this leads me to believe that mrstudio is not releasing the clipboard or
not emptying the clipboard.

and i agree mrstudio and outlook should not affect one another, but
there is a bleed through, perhaps with the shared clipboard, which may
be what causes the problem.

others where i work have also experienced this outlook/excel export
problem, and the best solution so far has just been to shut down outlook
while running problematic mrs scripts.

have you encountered this problem?




--- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@...> wrote:
>
> This has got me interested now...
>
> You are correct ... deleting the files in ...
>
> C:\Documents and Settings\[Username]\Application
> Data\SPSS\mrStudio\4.0.0.0
>
> will get rid of your macros and restore any mrStudio to the factory
> default. If you are testing 5.0 i suggest you patch to patch 2 before
> you run any test's.
>
> In my opinion if you can , i would test 4.5 fully patched also.
>
> Back to your speed issue though, do you have any virus software
> running ( is this running like mad when you run your script ) ? Have
> you done a defrag and a check disk, delete all temp files on machine
> fisrt with the disk cleanup tool ( Are you running XP? ) . The fact
> that outlook running causes some issues is interesting also, this
> should not be the case at all, there is no copying or pasting going
> on and if you are exporting to excel then outlook should have nothing
> to do with it. What data source are using for this script?
>
>
> --- In NADUG@yahoogroups.com, "dancing_lake" chewygold@ wrote:
> >
> > Hi, and Thanks for your comments - i have checked my computer out
> but
> > the cpu usage doesn't go over 50% and the memory doesn't hit the
> max.
> > i have dual processors for 2.8 Ghz with 2.5 gb ram and am expecting
> > an upgrade soon. One thing i do notice is that having outlook open
> > often causes the unknown aggregator error in during an excel
> export.
> > if i have problems and shut outlook down i can run the same file
> > without issue. i suspect it has something to do with the ms
> clipboard
> > and hidden temp files, but as yet have not been able to find any
> > hidden files to remove.
> >
> > i think my company is skipping 4.5 and will be loading 5.0
> (currently
> > testing) or 5.5 on our machines. so i am also hoping that 5.0 or
> 5.5
> > improves this part of the TOM experience.
> >
> >
> > --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> > >
> > > I am not aware f any cache files that studio would use, so I
> think
> > > you would need to check a few things on your slow machine. When
> > the
> > > script is running, look at the memory in the taskbar, is it
> > flipping
> > > out and using swap space? I suspect it is and hence the slow
> down.
> > To
> > > help improve this you can make sure you don't have unwanted
> > programs
> > > running, check taskbar and see what is using memory and stop them
> > if
> > > needed. Another thing to do would be to do a checkdisk and a
> > defrag.
> > > If you have a really defragmented system then when the data is
> > being
> > > written to the disk it will take longer.
> > >
> > > So in general my thoughts would be there is something making your
> > > machine slower or using most of the memory up ?
> > >
> > > Oh and i agree with kylesimpson 4.5 should be faster.
> > >
> > >
> > > --- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@>
> wrote:
> > > >
> > > > Hi,
> > > >
> > > > We have experienced the same results with mrStudio 4.0 as
> well.
> > > > Sometimes it results in tables missing (empty worksheets),
> other
> > > > times the unknown aggregator error.
> > > >
> > > > Our 'fix' has always been to shut down mrStudio and re-run.
> > > >
> > > > I haven't tested it in any more recent releases, but I'd expect
> > > that
> > > > they've improved the export.
> > > >
> > > > --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >
> > > > >
> > > > > I have found when using the TOM module of MrStudio 4.0, the
> > > export
> > > > to
> > > > > excel process can be very slow. When there are many tables,
> or
> > > > looped
> > > > > tables i often get an unknown excel aggregator error when the
> > > > export
> > > > > fails. the odd thing is that i have been using MrStudio TOM
> and
> > > > DMOM 4.0
> > > > > for about a year on this machine. I can go to another
> machine
> > and
> > > > > export the same Excel file in less than 1/2 the time without
> > > > issue. My
> > > > > computer has twice the memory and processing speed of this
> > > computer
> > > > >
> > > > > i am beginnig to think that MrStudio TOM has a hidden cache
> > > memory
> > > > > somewhere on my computer that is almost full to capacity. And
> > the
> > > > > difference between the 2 computers is that the second,
> smaller
> > > > computer
> > > > > does not have as large of an mrstudio memory cache because it
> > has
> > > > not
> > > > > been in an MrStudio TOM production mode for as long.....
> > > > >
> > > > > Has anyone else had this problem? and if so, have you found a
> > > > hidden
> > > > > cache and found a way to remove it?
> > > > >
> > > >
> > >
> >
>

Hi everyone,

In case you aren't aware, there are now two well populated Dimensions
forums.  The first is the NADUG forum from which you are reading this
post.  The second can be found here...

http://www.dimensionsusers.com/forum/

Please feel free to register and view/post topics on everything related
to Dimensions.

Best,
Jamey

This is interesting, I have done some investigating and you are very
correct with your thoughts. It does seem as if the clipboard is
used. which is news to me :-)

So no I have not come across this before, but then I don't really do
lots of tabulations. Can I suggest you try setting
UseFormattedAnnotations = false and let us know what happens?

I am now interested in discovering what is going on with the
clipboard, is it the fact that it is filling up with stuff, and
slowing you down, you say you have office 2003 and I seem to think
it saves stuff somewhere I will investigate this.
--- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@...> wrote:
>
>
>
>
> Yes - there is anti-virus software that runs in the background
> (corporate standard). temp files are removed regularly, and i have
> defragged the disk recently without much improvement, but it
probably
> needs it again. i am using XP with office 2007.
>
> first data pulls usually come straight from the sql database, run
> through dmom and then i usually use a ddf  as the data file for
all mrs
> scripts. i found it much faster than using xml.
>
> i get the feeling that export problems occur when tom takes over
the ms
> clipboard during the export process; once the excel export process
> begins, i can't copy or paste in any other application (e.g.
notepad,
> wordpad, etc..) because what pastes is usually the proportion,
mean and
> stat level text that appears in the bottom of an mrs-scripted
table.
>
> sometimes, after the excel export occurs, i have received an error
> message after opening excel like, "can't copy, msclipboard is
full".
> this leads me to believe that mrstudio is not releasing the
clipboard or
> not emptying the clipboard.
>
> and i agree mrstudio and outlook should not affect one another, but
> there is a bleed through, perhaps with the shared clipboard, which
may
> be what causes the problem.
>
> others where i work have also experienced this outlook/excel export
> problem, and the best solution so far has just been to shut down
outlook
> while running problematic mrs scripts.
>
> have you encountered this problem?
>
>
>
>
> --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> >
> > This has got me interested now...
> >
> > You are correct ... deleting the files in ...
> >
> > C:\Documents and Settings\[Username]\Application
> > Data\SPSS\mrStudio\4.0.0.0
> >
> > will get rid of your macros and restore any mrStudio to the
factory
> > default. If you are testing 5.0 i suggest you patch to patch 2
before
> > you run any test's.
> >
> > In my opinion if you can , i would test 4.5 fully patched also.
> >
> > Back to your speed issue though, do you have any virus software
> > running ( is this running like mad when you run your script ) ?
Have
> > you done a defrag and a check disk, delete all temp files on
machine
> > fisrt with the disk cleanup tool ( Are you running XP? ) . The
fact
> > that outlook running causes some issues is interesting also, this
> > should not be the case at all, there is no copying or pasting
going
> > on and if you are exporting to excel then outlook should have
nothing
> > to do with it. What data source are using for this script?
> >
> >
> > --- In NADUG@yahoogroups.com, "dancing_lake" chewygold@ wrote:
> > >
> > > Hi, and Thanks for your comments - i have checked my computer
out
> > but
> > > the cpu usage doesn't go over 50% and the memory doesn't hit
the
> > max.
> > > i have dual processors for 2.8 Ghz with 2.5 gb ram and am
expecting
> > > an upgrade soon. One thing i do notice is that having outlook
open
> > > often causes the unknown aggregator error in during an excel
> > export.
> > > if i have problems and shut outlook down i can run the same
file
> > > without issue. i suspect it has something to do with the ms
> > clipboard
> > > and hidden temp files, but as yet have not been able to find
any
> > > hidden files to remove.
> > >
> > > i think my company is skipping 4.5 and will be loading 5.0
> > (currently
> > > testing) or 5.5 on our machines. so i am also hoping that 5.0
or
> > 5.5
> > > improves this part of the TOM experience.
> > >
> > >
> > > --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> > > >
> > > > I am not aware f any cache files that studio would use, so I
> > think
> > > > you would need to check a few things on your slow machine.
When
> > > the
> > > > script is running, look at the memory in the taskbar, is it
> > > flipping
> > > > out and using swap space? I suspect it is and hence the slow
> > down.
> > > To
> > > > help improve this you can make sure you don't have unwanted
> > > programs
> > > > running, check taskbar and see what is using memory and stop
them
> > > if
> > > > needed. Another thing to do would be to do a checkdisk and a
> > > defrag.
> > > > If you have a really defragmented system then when the data
is
> > > being
> > > > written to the disk it will take longer.
> > > >
> > > > So in general my thoughts would be there is something making
your
> > > > machine slower or using most of the memory up ?
> > > >
> > > > Oh and i agree with kylesimpson 4.5 should be faster.
> > > >
> > > >
> > > > --- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@>
> > wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > We have experienced the same results with mrStudio 4.0 as
> > well.
> > > > > Sometimes it results in tables missing (empty worksheets),
> > other
> > > > > times the unknown aggregator error.
> > > > >
> > > > > Our 'fix' has always been to shut down mrStudio and re-run.
> > > > >
> > > > > I haven't tested it in any more recent releases, but I'd
expect
> > > > that
> > > > > they've improved the export.
> > > > >
> > > > > --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@>
wrote:
> > > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > >
> > > > > >
> > > > > > I have found when using the TOM module of MrStudio 4.0,
the
> > > > export
> > > > > to
> > > > > > excel process can be very slow. When there are many
tables,
> > or
> > > > > looped
> > > > > > tables i often get an unknown excel aggregator error
when the
> > > > > export
> > > > > > fails. the odd thing is that i have been using MrStudio
TOM
> > and
> > > > > DMOM 4.0
> > > > > > for about a year on this machine. I can go to another
> > machine
> > > and
> > > > > > export the same Excel file in less than 1/2 the time
without
> > > > > issue. My
> > > > > > computer has twice the memory and processing speed of
this
> > > > computer
> > > > > >
> > > > > > i am beginnig to think that MrStudio TOM has a hidden
cache
> > > > memory
> > > > > > somewhere on my computer that is almost full to
capacity. And
> > > the
> > > > > > difference between the 2 computers is that the second,
> > smaller
> > > > > computer
> > > > > > does not have as large of an mrstudio memory cache
because it
> > > has
> > > > > not
> > > > > > been in an MrStudio TOM production mode for as long.....
> > > > > >
> > > > > > Has anyone else had this problem? and if so, have you
found a
> > > > > hidden
> > > > > > cache and found a way to remove it?
> > > > > >
> > > > >
> > > >
> > >
> >
>

Thanks for the link, I will check it out.


--- In NADUG@yahoogroups.com, "jamey_corriveau" <jcorriveau@...> wrote:
>
> Hi everyone,
>
> In case you aren't aware, there are now two well populated Dimensions
> forums. The first is the NADUG forum from which you are reading this
> post. The second can be found here...
>
> http://www.dimensionsusers.com/forum/
>
> Please feel free to register and view/post topics on everything
related
> to Dimensions.
>
> Best,
> Jamey
>

I will run some tests and set the annotations to false and I'll let you
know what happens.

-- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@...> wrote:
>
> This is interesting, I have done some investigating and you are very
> correct with your thoughts. It does seem as if the clipboard is
> used. which is news to me :-)
>
> So no I have not come across this before, but then I don't really do
> lots of tabulations. Can I suggest you try setting
> UseFormattedAnnotations = false and let us know what happens?
>
> I am now interested in discovering what is going on with the
> clipboard, is it the fact that it is filling up with stuff, and
> slowing you down, you say you have office 2003 and I seem to think
> it saves stuff somewhere I will investigate this.
> --- In NADUG@yahoogroups.com, "dancing_lake" chewygold@ wrote:
> >
> >
> >
> >
> > Yes - there is anti-virus software that runs in the background
> > (corporate standard). temp files are removed regularly, and i have
> > defragged the disk recently without much improvement, but it
> probably
> > needs it again. i am using XP with office 2007.
> >
> > first data pulls usually come straight from the sql database, run
> > through dmom and then i usually use a ddf as the data file for
> all mrs
> > scripts. i found it much faster than using xml.
> >
> > i get the feeling that export problems occur when tom takes over
> the ms
> > clipboard during the export process; once the excel export process
> > begins, i can't copy or paste in any other application (e.g.
> notepad,
> > wordpad, etc..) because what pastes is usually the proportion,
> mean and
> > stat level text that appears in the bottom of an mrs-scripted
> table.
> >
> > sometimes, after the excel export occurs, i have received an error
> > message after opening excel like, "can't copy, msclipboard is
> full".
> > this leads me to believe that mrstudio is not releasing the
> clipboard or
> > not emptying the clipboard.
> >
> > and i agree mrstudio and outlook should not affect one another, but
> > there is a bleed through, perhaps with the shared clipboard, which
> may
> > be what causes the problem.
> >
> > others where i work have also experienced this outlook/excel export
> > problem, and the best solution so far has just been to shut down
> outlook
> > while running problematic mrs scripts.
> >
> > have you encountered this problem?
> >
> >
> >
> >
> > --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> > >
> > > This has got me interested now...
> > >
> > > You are correct ... deleting the files in ...
> > >
> > > C:\Documents and Settings\[Username]\Application
> > > Data\SPSS\mrStudio\4.0.0.0
> > >
> > > will get rid of your macros and restore any mrStudio to the
> factory
> > > default. If you are testing 5.0 i suggest you patch to patch 2
> before
> > > you run any test's.
> > >
> > > In my opinion if you can , i would test 4.5 fully patched also.
> > >
> > > Back to your speed issue though, do you have any virus software
> > > running ( is this running like mad when you run your script ) ?
> Have
> > > you done a defrag and a check disk, delete all temp files on
> machine
> > > fisrt with the disk cleanup tool ( Are you running XP? ) . The
> fact
> > > that outlook running causes some issues is interesting also, this
> > > should not be the case at all, there is no copying or pasting
> going
> > > on and if you are exporting to excel then outlook should have
> nothing
> > > to do with it. What data source are using for this script?
> > >
> > >
> > > --- In NADUG@yahoogroups.com, "dancing_lake" chewygold@ wrote:
> > > >
> > > > Hi, and Thanks for your comments - i have checked my computer
> out
> > > but
> > > > the cpu usage doesn't go over 50% and the memory doesn't hit
> the
> > > max.
> > > > i have dual processors for 2.8 Ghz with 2.5 gb ram and am
> expecting
> > > > an upgrade soon. One thing i do notice is that having outlook
> open
> > > > often causes the unknown aggregator error in during an excel
> > > export.
> > > > if i have problems and shut outlook down i can run the same
> file
> > > > without issue. i suspect it has something to do with the ms
> > > clipboard
> > > > and hidden temp files, but as yet have not been able to find
> any
> > > > hidden files to remove.
> > > >
> > > > i think my company is skipping 4.5 and will be loading 5.0
> > > (currently
> > > > testing) or 5.5 on our machines. so i am also hoping that 5.0
> or
> > > 5.5
> > > > improves this part of the TOM experience.
> > > >
> > > >
> > > > --- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@> wrote:
> > > > >
> > > > > I am not aware f any cache files that studio would use, so I
> > > think
> > > > > you would need to check a few things on your slow machine.
> When
> > > > the
> > > > > script is running, look at the memory in the taskbar, is it
> > > > flipping
> > > > > out and using swap space? I suspect it is and hence the slow
> > > down.
> > > > To
> > > > > help improve this you can make sure you don't have unwanted
> > > > programs
> > > > > running, check taskbar and see what is using memory and stop
> them
> > > > if
> > > > > needed. Another thing to do would be to do a checkdisk and a
> > > > defrag.
> > > > > If you have a really defragmented system then when the data
> is
> > > > being
> > > > > written to the disk it will take longer.
> > > > >
> > > > > So in general my thoughts would be there is something making
> your
> > > > > machine slower or using most of the memory up ?
> > > > >
> > > > > Oh and i agree with kylesimpson 4.5 should be faster.
> > > > >
> > > > >
> > > > > --- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@>
> > > wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > We have experienced the same results with mrStudio 4.0 as
> > > well.
> > > > > > Sometimes it results in tables missing (empty worksheets),
> > > other
> > > > > > times the unknown aggregator error.
> > > > > >
> > > > > > Our 'fix' has always been to shut down mrStudio and re-run.
> > > > > >
> > > > > > I haven't tested it in any more recent releases, but I'd
> expect
> > > > > that
> > > > > > they've improved the export.
> > > > > >
> > > > > > --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@>
> wrote:
> > > > > > >
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I have found when using the TOM module of MrStudio 4.0,
> the
> > > > > export
> > > > > > to
> > > > > > > excel process can be very slow. When there are many
> tables,
> > > or
> > > > > > looped
> > > > > > > tables i often get an unknown excel aggregator error
> when the
> > > > > > export
> > > > > > > fails. the odd thing is that i have been using MrStudio
> TOM
> > > and
> > > > > > DMOM 4.0
> > > > > > > for about a year on this machine. I can go to another
> > > machine
> > > > and
> > > > > > > export the same Excel file in less than 1/2 the time
> without
> > > > > > issue. My
> > > > > > > computer has twice the memory and processing speed of
> this
> > > > > computer
> > > > > > >
> > > > > > > i am beginnig to think that MrStudio TOM has a hidden
> cache
> > > > > memory
> > > > > > > somewhere on my computer that is almost full to
> capacity. And
> > > > the
> > > > > > > difference between the 2 computers is that the second,
> > > smaller
> > > > > > computer
> > > > > > > does not have as large of an mrstudio memory cache
> because it
> > > > has
> > > > > > not
> > > > > > > been in an MrStudio TOM production mode for as long.....
> > > > > > >
> > > > > > > Has anyone else had this problem? and if so, have you
> found a
> > > > > > hidden
> > > > > > > cache and found a way to remove it?
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

I just sent this off to SPSS support.  Posting here for your input.
I'll share with the group anything we learn.

At times we experience a high rate of failures with Site-To-Site
Activations via DimensionNet.  HTTPSYS is logging the following error
originating from requests POSTed to ActivationWebService.asmx and
FileManager.asmx: Connection_Abandoned_By_AppPool
SPSSDimensionNetPool.  Microsoft documentation states that the
error "Connection_Abandoned_By_AppPool" indicates that the error was
caused by a worker process stopping unexpectedly and orphaning requests.

Can you provide any insight on how to prevent these errors?  Would
increasing the number of worker processes in the SPSSDimensionNet
application pool (i.e. configured as a web garden) offer any relief?
Alternatively, would it be possible to have the ActivateWebService and
the FileManagerWebService applications operate with their own dedicated
application pool?

After continued investigation, we've discovered the source of these
Connection_Abandoned_By_AppPool SPSSDimensionNetPool errors.  Each of
these errors is preceded shortly by the following error found in the
Application Event Log:



.NET Runtime 2.0 Error: EventType clr20r3, P1 w3wp.exe, P2
6.0.3790.1830, P3 42435be1, P4 mrtables.webservice, P5 2.1.2.0, P6
4682617f, P7 129, P8 50, P9 exception, P10 NIL.



Additionally, each of these Connection_Abandoned_By_AppPool
SPSSDimensionNetPool errors coincides to the second with the
following warning found in the System Event Log:



The description for Event ID ( 1011 ) in Source ( W3SVC ) cannot be
found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve
this description; see Help and Support for details. The following
information is part of the event: SPSSDimensionNetPool, 4976,0



The number immediately following SPSSDimensionNetPool varies for each
event logged.  According to Microsoft KB911816
(http://support.microsoft.com/kb/911816), Unhandled exceptions cause
ASP.NET-based applications to unexpectedly quit in the .NET Framework
2.0.



We plan to implement a custom UnhandledException Module to trap these
errors. However, before we do, we seek input from SPSS on whether or
not SPSS has experienced (and remedied) the same problems in their
ASP practice either for the call center or for web interviewing.

how did you go with this ? did it reslove your issues ?

Update on message: EventType clr20r3, P1 xxx, P2 xxx, P3 xxx, P4 xxx,
P5 xxx, P6 xxx, P7 xxx, P8 xxx, P9 xxx, P10 xxx.

Still haven't found documentation on what all this means, but what
has become evident is that each and every one of the errors logged in
the Application Event log that correspond to the SPSSDimensionNet
application pool abandoning connections is this.

EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4
mrtables.webservice, P5 2.1.2.0, P6 4682617f, P7 129, P8 50, P9
exception, P10 NIL.

To the best of my ability the Pn parametershave the following
meaning...

P1, the hosting process, i.e. w3wp.e.e
P2, the hosting process version, 6.0.3790.1830
P3, ???
P4, the assembly from which the exception was raised, i.e.
mrtables.webservice
P5, the assembly version
P6, ???
P7, ???
P8, ???
P9, the exception type raised
P10, ???

Something in the mrtables.webservice assembly is causing the
SPSSDimensionNet application pool to crash bringing down all other
applications hosted by this pool including the Activate and
FileManager WebServices.

--- In NADUG@yahoogroups.com, "ken_beckett" <ken_beckett@...> wrote:
>
> After continued investigation, we've discovered the source of these
> Connection_Abandoned_By_AppPool SPSSDimensionNetPool errors.  Each
of
> these errors is preceded shortly by the following error found in
the
> Application Event Log:
>
>
>
> .NET Runtime 2.0 Error: EventType clr20r3, P1 w3wp.exe, P2
> 6.0.3790.1830, P3 42435be1, P4 mrtables.webservice, P5 2.1.2.0, P6
> 4682617f, P7 129, P8 50, P9 exception, P10 NIL.
>
>
>
> Additionally, each of these Connection_Abandoned_By_AppPool
> SPSSDimensionNetPool errors coincides to the second with the
> following warning found in the System Event Log:
>
>
>
> The description for Event ID ( 1011 ) in Source ( W3SVC ) cannot be
> found. The local computer may not have the necessary registry
> information or message DLL files to display messages from a remote
> computer. You may be able to use the /AUXSOURCE= flag to retrieve
> this description; see Help and Support for details. The following
> information is part of the event: SPSSDimensionNetPool, 4976,0
>
>
>
> The number immediately following SPSSDimensionNetPool varies for
each
> event logged.  According to Microsoft KB911816
> (http://support.microsoft.com/kb/911816), Unhandled exceptions
cause
> ASP.NET-based applications to unexpectedly quit in the .NET
Framework
> 2.0.
>
>
>
> We plan to implement a custom UnhandledException Module to trap
these
> errors. However, before we do, we seek input from SPSS on whether
or
> not SPSS has experienced (and remedied) the same problems in their
> ASP practice either for the call center or for web interviewing.
>

We've decided on abandoning the idea of registering an
UnhandledExceptionModule as while testing it, I realized that the
mrTables/WebService is logging to it's own DimensionNet log, TAB.tmp.
When examining logs from last week, I came across some very telling
information. Namely that each logged crash of the SPSSDimensionNet
application pool occurs immediately after an exception is logged in
the TAB.tmp log file.

I've annotated the logging to illustrate below. TAB prefixed entries
originate from the TAB.tmp file. APPEVT entires originate from the
Application Event log., HTTPSYS entries originate from the HttpErr
log. Lastly, SYSEVT entires originate from the System Event Log.

     TAB: 2008-05-14 09:36:39 errorServer: Value cannot be null.
Parameter name: value

     TAB: 2008-05-14 09:36:39 --------------

     TAB: 2008-05-14 09:36:39 Stack trace:

     TAB: 2008-05-14 09:36:39 --------------

     TAB: 2008-05-14 09:36:39 >>>> Boolean SetProperties
(System.String, System.String, System.String) File:  Line: 0

     TAB: 2008-05-14 09:36:39 >>>> System.Object _InvokeMethodFast
(System.Object, System.Object[], System.SignatureStruct ByRef,
System.Reflection.MethodAttributes, System.RuntimeTypeHandle) File:
Line: 0

     TAB: 2008-05-14 09:36:39 --- (stack dump stops at Invoke) ---

     TAB: 2008-05-14 09:36:39 Session ended (Void Session_End
(System.Object, System.EventArgs), 0)

  APPEVT: 2008-05-14 09:36:41 Type=Error, Source=.NET Runtime 2.0
Error Reporting, Description=EventType clr20r3, P1 w3wp.exe, P2
6.0.3790.1830, P3 42435be1, P4 mrtables.webservice, P5 2.1.2.0, P6
4682617f, P7 129, P8 50, P9 exception, P10 NIL.

HTTPSYS: 2008-05-14 09:36:51 xxx.xx.x.xx 52008 xxx.xx.x.xx 80
HTTP/1.1 POST /SPSSMR/ActivateWebService/ActivateWebService.asmx - 1
Connection_Abandoned_By_AppPool SPSSDimensionNetPool

  SYSEVT: 2008-05-14 09:36:51 Type=Warning, Source=W3SVC,
Description=The following information is part of the event:
SPSSDimensionNetPool...

     TAB: 2008-05-14 09:37:41 Web Service Started (Void
Application_Start(System.Object, System.EventArgs), 0)

The APPEVT, HTTPSYS, and SYSEVT logs all indicate that there was a
crash in the SPSSDimensionNet application pool.  The very last entry
shows that the mrTables/Web Service is starting back up upon the
first request received since the crash.

--- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@...> wrote:
>
> how did you go with this ? did it reslove your issues ?
>


Hi,

sorry it took so long... been busy
anyway.  not using the annotations helps the export speed, but the
clipboard still ties up during the export process - and i can't copy
and paste anything.

i have found that by closing outlook or running in safe mode,i can run
larger mrs script files.  otherwise i just have to split large runs up
or only populate s small number of tables at a time.

... okay, i am trying to export to excel. i have reduced the amount of
exporting tables from the maximum of 800+ to 6 tables at a time
(appending), but i still get the unknown excel message "not enough
storage space to populate".

c'mon. i have 4 gigs of ram ....  i really need to find where the
hidden cache is... obviously, there is a shared component or a maximum
clipboard amount i am missing....

btw, i have outlook shut down and i am not running in safe mode - just
over my company's network.

if i reduce the appending tables export from six tables at a time to
three, the excel export works without issue.

any insights would be extremly helpful.

thanks!