Help with Service Connect! SC Version 8.03

Yahoo Archive
1
That is my biggest question with Service Connect as well. I would love
to hear some kind of answer that made sense.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lorraine Aiello
Sent: Thursday, July 23, 2009 10:09 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Help with Service Connect! SC Version 8.03





So now I'm told I should use GetRows. This brings up one of my most
frustrating things about Service Connect. Support taught me to do a
trace in my client as I use the client to do what needs to be done.
Then the trace will tell me what methods I need to use in my workflow.
How to read the trace and precisely pick out the methods needed is not
documented anywhere at all. The student manual doesn't cover it all all
and the class I went to never mentioned it.

Admittedly, I now see that GetByID is at the top of the trace log but
GetRow is not in there.

What really sends me over the edge, is that I'm told that my workflow
doesn't need to have all the methods shown in the trace. How am I
supposed to know what to use and what not to use????

Lorraine

--- On Wed, 7/22/09, netrippers <netrippers@...
<mailto:netrippers%40yahoo.com> > wrote:

From: netrippers <netrippers@... <mailto:netrippers%40yahoo.com> >
Subject: [Vantage] Re: Help with Service Connect! SC Version 8.03
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wednesday, July 22, 2009, 10:40 PM



When searching for if records exist you should use the GetRows method.
Otherwise when you are looking at the 'inbound messages' you will see a
complete with an error. When the error is that SC couldn't find the part
which really isn't an error. If you use the GetRows method then when
there is an error displayed there really was an error in the process.
Then you don't need to look at every message to see if the error was the
error you expected or an error you need to do something about.

--- In vantage@yahoogroups .com, "servconnsup" <servconnsup@ ...> wrote:
>
>
> Lorraine,
> Explanation of Error: You are trying create a new part data for a part
that already exists with that part number(Key).
>
> Sounds like you are trying to create a new part record, so to avoid
this error, do a PartService. GetByID first. Then do a "Choice" to give
your workflow direction of what it should do incase a part record with
the same part number exists. You can then either choose to update the
existing record, Send an email via Poster then finish, or just finish
without doing anything..
>
> Not sure if this is your issue, so I hope this helps.
>
> Ahmed
>
> --- In vantage@yahoogroups .com, "bw2868bond" <bwalker@> wrote:
> >
> > Your second conversion should be using GetNewPart Response schema as
it's input - your data should carry through in the usr container to be
mapped to the appropriate fields of the Update request output schema
> >
> >
> > --- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ >
wrote:
> > >
> > > I am struggling with this sub workflow and am hoping that some of
my colleagues out there will save me from going completely insane. This
workflow is supposed to take a list of parts from an Excel spreadsheet
and load them into the Part, Plant, and Warehouse tables in the
database.
> > >
> > > I'm getting the error "an entry with the same key already exists".
Of course, the error gives me no clue what table or what key it's
referencing.
> > >
> > > I'm new at sub workflows so here's what I did. My main workflow
has only the sub-workflow node in it at this time. The cycling
properties created a schema of its own I called sub-schema. I used my
own user schema in the properties for the main workflow. Then in the
sub workflow, my GetNewPart conversion uses the sub-schema as my input
schema. My mapping hardcodes the companyID under GetNewPartRequest and
maps every field in the dta row to the container I created under the
message extension tab. My web method runs and then a conversion for
updating the part uses the sub-schema as the input schema and all the
fields in the container under wfl/usr are mapped to the tables.
> > >
> > > In the Inbound Messages on the Service Connect Administration
Console, the execution point for Start shows the appropriate data from
my Excel spreadsheet coming in the dta node. This leads me to believe
that the data is getting passed from the main workflow to the sub
workflow successfully. I can't see any data of significance in the
GetNewPart conversion's message data because that method doesn't require
any data. BUT, that conversion should be sending the data through the
container on to the Update Part conversion. I don't think that's
happening. The message data for that conversion shows no data coming in
from the dta node or the wfl node. The execution point for the
PartService. Update is where the error is happening.
> > >
> > > I'm stumped and getting very frustrated. Please help!
> > >
> > > Lorraine Aiello
> > > Senior Programmer Analyst
> > > Gloucester Engineering Co., Inc.
> > > (plastics machinery manufacturing firm)
> > > Gloucester, MA
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
Â
I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
Â
I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
Â
In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService.Update is where the error is happening.
Â
I'm stumped and getting very frustrated. Please help!
Â
Lorraine Aiello
Senior Programmer Analyst
Gloucester Engineering Co., Inc.
(plastics machinery manufacturing firm)
Gloucester, MA




[Non-text portions of this message have been removed]
3
Your second conversion should be using GetNewPart Response schema as it's input - your data should carry through in the usr container to be mapped to the appropriate fields of the Update request output schema


--- In vantage@yahoogroups.com, Lorraine Aiello <lorraine.aiello@...> wrote:
>
> I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
> Â
> I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
> Â
> I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
> Â
> In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService.Update is where the error is happening.
> Â
> I'm stumped and getting very frustrated. Please help!
> Â
> Lorraine Aiello
> Senior Programmer Analyst
> Gloucester Engineering Co., Inc.
> (plastics machinery manufacturing firm)
> Gloucester, MA
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Lorraine,
Explanation of Error: You are trying create a new part data for a part that already exists with that part number(Key).

Sounds like you are trying to create a new part record, so to avoid this error, do a PartService.GetByID first. Then do a "Choice" to give your workflow direction of what it should do incase a part record with the same part number exists. You can then either choose to update the existing record, Send an email via Poster then finish, or just finish without doing anything.

Not sure if this is your issue, so I hope this helps.

Ahmed

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Your second conversion should be using GetNewPart Response schema as it's input - your data should carry through in the usr container to be mapped to the appropriate fields of the Update request output schema
>
>
> --- In vantage@yahoogroups.com, Lorraine Aiello <lorraine.aiello@> wrote:
> >
> > I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
> > Â
> > I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
> > Â
> > I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
> > Â
> > In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService.Update is where the error is happening.
> > Â
> > I'm stumped and getting very frustrated. Please help!
> > Â
> > Lorraine Aiello
> > Senior Programmer Analyst
> > Gloucester Engineering Co., Inc.
> > (plastics machinery manufacturing firm)
> > Gloucester, MA
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
5
When searching for if records exist you should use the GetRows method. Otherwise when you are looking at the 'inbound messages' you will see a complete with an error. When the error is that SC couldn't find the part which really isn't an error. If you use the GetRows method then when there is an error displayed there really was an error in the process. Then you don't need to look at every message to see if the error was the error you expected or an error you need to do something about.

--- In vantage@yahoogroups.com, "servconnsup" <servconnsup@...> wrote:
>
>
> Lorraine,
> Explanation of Error: You are trying create a new part data for a part that already exists with that part number(Key).
>
> Sounds like you are trying to create a new part record, so to avoid this error, do a PartService.GetByID first. Then do a "Choice" to give your workflow direction of what it should do incase a part record with the same part number exists. You can then either choose to update the existing record, Send an email via Poster then finish, or just finish without doing anything.
>
> Not sure if this is your issue, so I hope this helps.
>
> Ahmed
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > Your second conversion should be using GetNewPart Response schema as it's input - your data should carry through in the usr container to be mapped to the appropriate fields of the Update request output schema
> >
> >
> > --- In vantage@yahoogroups.com, Lorraine Aiello <lorraine.aiello@> wrote:
> > >
> > > I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
> > > Â
> > > I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
> > > Â
> > > I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
> > > Â
> > > In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService.Update is where the error is happening.
> > > Â
> > > I'm stumped and getting very frustrated. Please help!
> > > Â
> > > Lorraine Aiello
> > > Senior Programmer Analyst
> > > Gloucester Engineering Co., Inc.
> > > (plastics machinery manufacturing firm)
> > > Gloucester, MA
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
6
This goes to show how confused I'm getting. I should have known this. Thanks for setting me straight. BUT, unfortunately, it doesn't change my results. Nothing seems to be coming through that container.

--- On Wed, 7/22/09, bw2868bond <bwalker@...> wrote:


From: bw2868bond <bwalker@...>
Subject: [Vantage] Re: Help with Service Connect! SC Version 8.03
To: vantage@yahoogroups.com
Date: Wednesday, July 22, 2009, 9:21 PM


Â



Your second conversion should be using GetNewPart Response schema as it's input - your data should carry through in the usr container to be mapped to the appropriate fields of the Update request output schema

--- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ ...> wrote:
>
> I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
> Â
> I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
> Â
> I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
> Â
> In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService. Update is where the error is happening..
> Â
> I'm stumped and getting very frustrated. Please help!
> Â
> Lorraine Aiello
> Senior Programmer Analyst
> Gloucester Engineering Co., Inc.
> (plastics machinery manufacturing firm)
> Gloucester, MA
>
>
>
>
> [Non-text portions of this message have been removed]
>



















[Non-text portions of this message have been removed]
7
So now I'm told I should use GetRows. This brings up one of my most frustrating things about Service Connect. Support taught me to do a trace in my client as I use the client to do what needs to be done. Then the trace will tell me what methods I need to use in my workflow. How to read the trace and precisely pick out the methods needed is not documented anywhere at all. The student manual doesn't cover it all all and the class I went to never mentioned it.
Â
Admittedly, I now see that GetByID is at the top of the trace log but GetRow is not in there.
Â
What really sends me over the edge, is that I'm told that my workflow doesn't need to have all the methods shown in the trace. How am I supposed to know what to use and what not to use????
Â
Lorraine

--- On Wed, 7/22/09, netrippers <netrippers@...> wrote:


From: netrippers <netrippers@...>
Subject: [Vantage] Re: Help with Service Connect! SC Version 8.03
To: vantage@yahoogroups.com
Date: Wednesday, July 22, 2009, 10:40 PM


Â



When searching for if records exist you should use the GetRows method. Otherwise when you are looking at the 'inbound messages' you will see a complete with an error. When the error is that SC couldn't find the part which really isn't an error. If you use the GetRows method then when there is an error displayed there really was an error in the process. Then you don't need to look at every message to see if the error was the error you expected or an error you need to do something about.

--- In vantage@yahoogroups .com, "servconnsup" <servconnsup@ ...> wrote:
>
>
> Lorraine,
> Explanation of Error: You are trying create a new part data for a part that already exists with that part number(Key).
>
> Sounds like you are trying to create a new part record, so to avoid this error, do a PartService. GetByID first. Then do a "Choice" to give your workflow direction of what it should do incase a part record with the same part number exists. You can then either choose to update the existing record, Send an email via Poster then finish, or just finish without doing anything..
>
> Not sure if this is your issue, so I hope this helps.
>
> Ahmed
>
> --- In vantage@yahoogroups .com, "bw2868bond" <bwalker@> wrote:
> >
> > Your second conversion should be using GetNewPart Response schema as it's input - your data should carry through in the usr container to be mapped to the appropriate fields of the Update request output schema
> >
> >
> > --- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ > wrote:
> > >
> > > I am struggling with this sub workflow and am hoping that some of my colleagues out there will save me from going completely insane. This workflow is supposed to take a list of parts from an Excel spreadsheet and load them into the Part, Plant, and Warehouse tables in the database.
> > > Â
> > > I'm getting the error "an entry with the same key already exists". Of course, the error gives me no clue what table or what key it's referencing.
> > > Â
> > > I'm new at sub workflows so here's what I did. My main workflow has only the sub-workflow node in it at this time. The cycling properties created a schema of its own I called sub-schema. I used my own user schema in the properties for the main workflow. Then in the sub workflow, my GetNewPart conversion uses the sub-schema as my input schema. My mapping hardcodes the companyID under GetNewPartRequest and maps every field in the dta row to the container I created under the message extension tab. My web method runs and then a conversion for updating the part uses the sub-schema as the input schema and all the fields in the container under wfl/usr are mapped to the tables.
> > > Â
> > > In the Inbound Messages on the Service Connect Administration Console, the execution point for Start shows the appropriate data from my Excel spreadsheet coming in the dta node. This leads me to believe that the data is getting passed from the main workflow to the sub workflow successfully. I can't see any data of significance in the GetNewPart conversion's message data because that method doesn't require any data. BUT, that conversion should be sending the data through the container on to the Update Part conversion. I don't think that's happening. The message data for that conversion shows no data coming in from the dta node or the wfl node. The execution point for the PartService. Update is where the error is happening.
> > > Â
> > > I'm stumped and getting very frustrated. Please help!
> > > Â
> > > Lorraine Aiello
> > > Senior Programmer Analyst
> > > Gloucester Engineering Co., Inc.
> > > (plastics machinery manufacturing firm)
> > > Gloucester, MA
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>



















[Non-text portions of this message have been removed]