I have been trying to get DCR’s working and have hit a wall… When I try to import external records I get an “object variable not set at line 105” error. I’m not sure why I’m getting the error when I set DECS to do the same thing it works and when I turn on the use external data property for the database I can create new records on in the db2 table… when I modify a document created in notes it updates the db2 table. I just can’t seem to do the import… has any one else seen this type of issue? we are running domino 6.01 on the 400. I have been working on this for 3 days now and I’m starting to get upset…
Subject: I had same bug. It was fixed in 6.0.2 CF2.
SPR# MDKU57LRMT
Subject: Same error, no solution…
trying to import external records using odbc sql dcr. can browse data, so connection is ok.
//Trond-Are
Subject: DCR … HELP!!!
I had the same error in 6.02 CF2. But as long as you can “browse” you know the DCR is working. What I did was create the “key docs” myself in notes entering only the value for the key field to match the record in DB2 and it worked. If you have too many docs to enter manually you could write your own import agent setting only the key field value when the agent creates the docs. Just be careful to turn off the Database property “Allow connections…” while your are creating the key docs or else you will get errors on save since it will try and create these duplicate docs in DB2. Once the key docs are created, then turn the property back on.
Subject: DCR … HELP!!!
Just sharing som problems I’ve had with Db2 import.1. Make sure you are at least editor to DECS admin database.
-
Restart the db2 server before import.
-
Restart DECS
-
Make sure the DCR property is switched off on the database when importing records.
-
Make sure you have a correct mapping of key field in Notes to the db2 field.
Once something hangs it usually will hang for every further access.
If the old DCR still won´t work try creating a new one from scratch.