|
Home > Archive > Commerce Server General > April 2006 > Need help with DirectMailer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need help with DirectMailer
|
|
| gwheeloc 2006-03-09, 5:52 pm |
| 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:+Invalid
+argument+passed+to+the+method+or+proper
ty+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 method
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 even
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
| |
| gwheeloc 2006-03-10, 5:54 pm |
| 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 Direct
Mailer] Invalid argument passed to the method or property call. Process Exit
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. 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. "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
| |
|
| 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 Direct
> Mailer] Invalid argument passed to the method or property call. Process Exit
> 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. 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. "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
| |
| gwheeloc 2006-03-21, 3:10 am |
| 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 seen
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
| |
| Rahman 2006-04-01, 2:39 pm |
| 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,
| |
|
| 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
|
|
|
|
|