DOC 1 ERROR: eConnect The 'NONE' start tag on line 1 does not match the end tag of 'PAPROJNUMBER'. Line 1, position 2316.
When entering timesheets in the Timesheet Entry window, you can enter a line item that isn’t for a specific project by pressing TAB to default the project number to "
As logic would have you believe, if you are integrating a timesheet line that is not associated to a project, it would be enough to pass the same "
Now to the error...
The error clearly indicates that there is a problem with an XML tag - presumably when Integration Manager serializes the source data into its XML representation.
Since IM has to marshall the source data (also known as serialization), the "
<taPATimeSheetLineInsert>
<PATSTYP>1</< <="" font="">PATSTYP>
.
.
<PAPROJNUMBER><NONE></PAPROJNUMBER>
.
.
< font="">< font="">< font="">< font="">< font=""></taPATimeSheetLineInsert>
As shown above, the "
This is actually a good thing!
Furthermore, Microsoft has identified this to be an issue with the eConnect Adapter for Integration Manager and has scheduled this problem to be resolved in Service Pack 3 - no, it did not make the cut for 2010 R2/SP2.
However, the workaround is as follows:
1. Pass/Map a value of NONE to the Project Number field for the timesheet line in Integration Manager. If your source data includes the actual tags (< and >) you can use a simple field script to remove them.
2. Edit the eConnect taPATimeSheetLineInsertPRE stored procedure to include the following T-SQL code:
-- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 2.5 Generic license.
ALTER PROCEDURE dbo.taPATimeSheetLineInsertPRE
.
.
AS IF UPPER(@I_vPAPROJNUMBER) = 'NONE' BEGIN SELECT @I_vPAPROJNUMBER = '<NONE>'; END
Since the PRE stored procedure executes before the rest of the taPATimeSheetLineInsert code, the proper value will be passed in to the timesheet line, hence preventing the error.
Until next post!
MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/
No comments:
Post a Comment