|
Home > Archive > Commerce Server Analysis > March 2004 > Extending Commerce Server Event trouble
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 |
Extending Commerce Server Event trouble
|
|
| A.J. van der Burg 2004-02-26, 4:35 am |
| Hi all,
I run through the entire tutorial on how to create you own
Commerce Server event, but in the end, during the import
dts task, I get an error on the report prep step:
A property required for task execution has not been set.
Property: PartitionName
Anybody ideas? TIA
Arnold Jan van der Burg
| |
| Maria Quian [MSFT] 2004-02-28, 11:35 am |
| Thank you for using Microsoft Newsgroups.
Could you give me the path to the tutorial you are following? The error is
stating that It is missing a required parameter. I would be happy to set
it up and give you additional information.
Maria Quian
Microsoft Technical Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
| |
|
| Hi Maria,
The tutorial I'm using can be found in the Commerce Server=20
Help file -> Developer's Guide -> Extending Commerce=20
Server ->
Extending the data warehouse -> Extending Commerce Events -
> Reporting on a custom Commerce Event.
I also found that the tutorial is lacking an important=20
step which is needed in setting up a new event. In the=20
first part ('Creating a custom Commerce event'), after=20
creating the VB script used to extend the data warehouse=20
schema and inserting the new commerce events into the data=20
warehouse, there should be a section on creating a new=20
event type, otherwise the step 'to add a new event type=20
description' is useless and the view created in this step=20
will not return the expected data.
The step that is needed here is to create a SQL script to=20
insert the two event types which are mentioned in the=20
'to add a new event type description' step, for example:
insert into eventtype(eventTypeID, EventDescription,=20
EventName, EventTypeInternalFlag)
values (0x000000003EB, NULL, 'ADDTOLIST', 1)
insert into eventtype(eventTypeID, EventDescription,=20
EventName, EventTypeInternalFlag)
values (0x000000003EC, NULL, 'DROPFROMLIST', 1)
go
TIA,
Arnold Jan van der Burg
>-----Original Message-----
>Thank you for using Microsoft Newsgroups.
>
>Could you give me the path to the tutorial you are=20
following? The error is=20
>stating that It is missing a required parameter. I=20
would be happy to set=20
>it up and give you additional information. =20
>
>Maria Quian
>Microsoft Technical Support
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.=20
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights=20
>reserved.
| |
| A.J. van der Burg 2004-03-04, 4:35 am |
| Hi Maria,
I already found the source of the error. In the tutorial=20
it states that the new record that is to be inserted into=20
the CubeProcInfo table is a virtual cube which is not the=20
case, because it's a standard cube.
Arnold Jan van der Burg
>-----Original Message-----
>Thank you for using Microsoft Newsgroups.
>
>Could you give me the path to the tutorial you are=20
following? The error is=20
>stating that It is missing a required parameter. I=20
would be happy to set=20
>it up and give you additional information. =20
>
>Maria Quian
>Microsoft Technical Support
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.=20
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights=20
>reserved.
| |
| Maria Quian [MSFT] 2004-03-05, 5:35 pm |
| Thank you for using Microsoft Newsgroups.
Sorry for the slow response, I am glad you were able to complete the
tutorial. I have made a note of your findings. Thanks again,
Maria Quian
Microsoft Technical Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
| |
| A.J. van der Burg 2004-03-18, 1:55 pm |
| Hi Maria,
I also found another error in the tutorial about creating=20
custom commerce server events. Because the cube created is=20
not of the virtual type, a partition size should be=20
inserted ('Reporting on a Custom Commerce Server Event',=20
step 28) , otherwise the stored procedures that create the=20
partitions will fail for this particular cube and the=20
partition will not be created and the cube will not be=20
processed.
Regards,
Arnold Jan van der Burg
>-----Original Message-----
>Thank you for using Microsoft Newsgroups.
>
>Sorry for the slow response, I am glad you were able to=20
complete the=20
>tutorial. I have made a note of your findings. Thanks=20
again,=20
>
>Maria Quian
>Microsoft Technical Support
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.=20
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights=20
>reserved.
|
|
|
|
|