|
| Provisionin to SQL error |
 |
Mon, 10 Mar 2008 08:45:02 -070 |
I trying to Provision object into a SQL table. During the export, I receive
an error "missing-anchor-component". The anchor field is generated by
SQL
using teh Identity settings. The provisioning does work, the rows get
created in the table. I need to run an import & sync to completely join the
objects but I believe that is normal.
Any insight to the "missing-anchor-component" error would be great.
|
| Post Reply
|
| Re: Provisionin to SQL error |
 |
Mon, 10 Mar 2008 09:09:03 -070 |
When creating the SQL MA, at the "Configuring Columns" the field is
selected
as the anchor.
"Tomasz Onyszko" wrote:
> JPH wrote:
> > I trying to Provision object into a SQL table. During the export, I
receive
> > an error "missing-anchor-component". The anchor field is
generated by SQL
> > using teh Identity settings. The provisioning does work, the rows get
> > created in the table. I need to run an import & sync to
completely join the
> > objects but I believe that is normal.
> >
> > Any insight to the "missing-anchor-component" error would be
great.
>
> How have You defined Your anchor in MA configuration?
>
> --
> Tomasz Onyszko
> http://www.w2k.pl/ - (PL)
> http://blogs.dirteam.com/blogs/tomek/ - (EN)
|
| Post Reply
|
| Re: Provisionin to SQL error |
 |
Mon, 10 Mar 2008 16:58:28 +010 |
JPH wrote:
> I trying to Provision object into a SQL table. During the export, I
receive
> an error "missing-anchor-component". The anchor field is
generated by SQL
> using teh Identity settings. The provisioning does work, the rows get
> created in the table. I need to run an import & sync to completely
join the
> objects but I believe that is normal.
>
> Any insight to the "missing-anchor-component" error would be
great.
How have You defined Your anchor in MA configuration?
--
Tomasz Onyszko
http://www.w2k.pl/ - (PL)
|
| Post Reply
|
| Re: Provisionin to SQL error |
 |
Mon, 10 Mar 2008 17:48:01 -070 |
Yes the Anchor is a single field. A numberic field in the DB that increments
itself automatically.
This is the code from the MV dll that creates the 'temporary' dn in the CS:
CSEntry csentry =
idvaultManagementAgent.Connectors.StartNewConnector("person");
ReferenceValue dn;
dn =
idvaultManagementAgent.EscapeDNComponent(System.Guid.NewGuid().ToString());
csentry.DN = dn;
csentry.CommitNewConnector();
This successfully creates and object in the CS with a GUID as th DN. When
the SQL MA Export profile runs - which is using no Advanced Attibute flows -
the row is created in the SQL DB - but the export returns the
"missing-anchor-component" error. The Full Import\Full Sync wll
perform the
Join and link up the object. So things work as expected. just the
mysterious error message.
Thanks in advance for you help.
Jim
"Tomasz Onyszko" wrote:
> JPH wrote:
> > When creating the SQL MA, at the "Configuring Columns" the
field is selected
> > as the anchor.
>
> OK - this is single field .. not combined anchor? Just asking to make
> sure. Can you post here your code which is being used tocreate an object
> in this SQL MA?
>
> Just to ask this question ... I'm sure You have checked it however ..
> have You checked if this ID has been generated in SQL?
>
> --
> Tomasz Onyszko
> http://www.w2k.pl/ - (PL)
> http://blogs.dirteam.com/blogs/tomek/ - (EN)
|
| Post Reply
|
| Re: Provisionin to SQL error |
 |
Mon, 10 Mar 2008 23:04:54 +010 |
JPH wrote:
> When creating the SQL MA, at the "Configuring Columns" the field
is selected
> as the anchor.
OK - this is single field .. not combined anchor? Just asking to make
sure. Can you post here your code which is being used tocreate an object
in this SQL MA?
Just to ask this question ... I'm sure You have checked it however ..
have You checked if this ID has been generated in SQL?
--
Tomasz Onyszko
http://www.w2k.pl/ - (PL)
|
| Post Reply
|
|
|
|
|
|
|
|
|
|