What might prevent the directMailer from inserting the DM job into the
DirectMailer.dml_jobs table?  Recently something has changed in our CS2002
environment because now after I create a new DirectMail campaign item and
send a test message, BizDesk reports back that it was successful.  When i
check SQL Server I see the new job.  But when I look in the DML_Log file I
see this being reported "2006-03-09 02:00:00
 Attempt+to+create+a+new+job+for+the+site
+'cs2002StarterSite'+has+failed:+Inv
 alid+argument+passed+to+the+method+or+pr
operty+call:"

Plus no email is ever created.
Does anyone know what this message is referring to?

The App evt log on the server shows:
"SQL Server Scheduled Job 'TEST_CS_DM_CS2002StarterSite_13_0.585484'
(0xF7DACE209AB85341A3245D5E308A8304) - Status: Failed - Invoked on:
2006-03-09 14:15:07 - Message: The job failed.  The Job was invoked by User
cs2k2.  The last step to run was step 1
(TEST_CS_DM_CS2002StarterSite_13_0.585484_Step)."

when I try to run the job step through a cmd window using dmlrun.exe, I see
the following message reported back immediately:

Error: [Commerce Server Direct Mailer] Invalid argument passed to the me
thod
or
property call.

I checked the DCOM configs and made sure the correct permissions were
granted to the user cs2k2.  And that user has dbo permissions on the
directmailer dml_jobs db table.  I'm not aware of any other troubleshooting
steps I could perform to try and see where things are going wrong.  I've eve
n
use the SQL server profiler to see what tables are being touched, but I
didn't see any inserts into the dml_jobs table.

If anyone has any ideas or debugging techniques I could try I would
appreciate it.

thanks, gwheeloc

[ Post a follow-up to this message ]

Upon digging further I found that the job history in SQL Server shows this
additional information after the job is attempted.

"Executed as user: [localhost]\SYSTEM. Error: [Commerce Server Direc
t
Mailer] Invalid argument passed to the method or property call.  Process Exi
t
Code -2147024809.  The step failed."

This message is most likely related to the message in the prior post.  I
found the store procedure that is called when you send a test email or save
the new Direct Mailer campaign item as being:

declare @P1 uniqueidentifier
set @P1=NULL
exec sp_create_dml_sqlagent_job N'CS2002StarterSite', N'localhost', 14, 13,
20060308, 20060608, 80000, N' ', 2, 1, 0, 0, 0, @P1 output
select @P1

A valid GUID is returned but the job history is updated with the message
shown above.

Does anyone have a clue about this?

My environment setup
This is a Windows 2003 server being used as a test server with all the
CS2002 pieces on this one server. The server shares the domain with the
production servers and is configured just as the production servers.  This
direct mailer functionality works fine on those.  I use domain accounts for
everything so I'm puzzled.  I don't believe this to be a permission issue or
I would of expected to see the problem on the production server as well.  Th
e
big difference is that the production environment's database is on it own
server.

This makes me believe the problem lies within the confines of the database
software.  The error message is too generic to know where to look. "Invalid
argument passed to the method or property call"  Which one?  What is the
value of what was passed?  This information would be helpful.

gwheeloc

[ Post a follow-up to this message ]

hi
i have this same problem and i didn't find a solution yet
so, please tell me if u found a solution or if any one have a solution
help us

regards

gwheeloc wrote:
> Upon digging further I found that the job history in SQL Server shows this
> additional information after the job is attempted.
>
> "Executed as user: [localhost]\SYSTEM. Error: [Commerce Server Dir
ect
> Mailer] Invalid argument passed to the method or property call.  Process E
xit
> Code -2147024809.  The step failed."
>
> This message is most likely related to the message in the prior post.  I
> found the store procedure that is called when you send a test email or sav
e
> the new Direct Mailer campaign item as being:
>
> declare @P1 uniqueidentifier
> set @P1=NULL
> exec sp_create_dml_sqlagent_job N'CS2002StarterSite', N'localhost', 14, 13
,
> 20060308, 20060608, 80000, N' ', 2, 1, 0, 0, 0, @P1 output
> select @P1
>
> A valid GUID is returned but the job history is updated with the message
> shown above.
>
> Does anyone have a clue about this?
>
> My environment setup
> This is a Windows 2003 server being used as a test server with all the
> CS2002 pieces on this one server. The server shares the domain with the
> production servers and is configured just as the production servers.  This
> direct mailer functionality works fine on those.  I use domain accounts fo
r
> everything so I'm puzzled.  I don't believe this to be a permission issue 
or
> I would of expected to see the problem on the production server as well.  
The
> big difference is that the production environment's database is on it own
> server.
>
> This makes me believe the problem lies within the confines of the database
> software.  The error message is too generic to know where to look. "Invali
d
> argument passed to the method or property call"  Which one?  What is the
> value of what was passed?  This information would be helpful.
>
> gwheeloc

[ Post a follow-up to this message ]

Will do.  Usually someone knows something or can nudge you in a direction.
But because of the lack of response by anyone, even to say "I have never see
n
that before"  it doesn't look good.  I've tried reinstalling the Direct
Mailer portion thinking that would clear it up and it hasn't.

gwheeloc

[ Post a follow-up to this message ]

Hello,
I know its not a relevant topic but I am ind esparate need of help, was
wondering if you experts had any suggestions
I am trying to add Direct Mailer resource to the existing site.
While installing Commerce Server we skipped adding this resource and
now CS2002 has been upgraded to SP3 and FP1... so now when I am trying
to add this resource from CS2002 set up disk , it says setup cannot
continue as newer version is already installed, to continue setup
uninstall the newer version.

Any idea how do I go about adding this resource?

Thanks for any advice!

Production Box has

Windows 2003, CS 2002 SE FP1 with SP3 installed

Regards,

[ Post a follow-up to this message ]

hi
After monitoring the dmlrun.exe file (using filemon from
sysinternals.com ), i found that it calls a dll called ?????[

what the hell this dll is ?

regards

[ Post a follow-up to this message ]