Line: 34 Error: 217 Error creating product object

HCL Domino Domino Forum
1

I have this error coming in my agent:- Line: 34 Error: 217 Error creating product object)

the code snippet is as follows:-

Set  db = session.CurrentDatabase	



Dim LCsession As New LCSession

Error is coming in the line below:-

Dim connect As New LCConnection("oracle")

Dim connect2 As New LCConnection("oracle")

This agent connects to oracle using lotuscript extensions

and is scheduled agent. This agent runs fine if run from my client but it fails when run from server.

Why is this happening? Any help is most welcome.

2

Subject: Line: 34 Error: 217 Error creating product object

have you defined the “oracle” data source entry on the server where the agent runs?

3

Subject: Line: 34 Error: 217 Error creating product object

You need to setup/configure the Oracle client connectivity software on your server.

4

Subject: RE: Line: 34 Error: 217 Error creating product object

Thanks a lot for your response. I am checking that on the server and will give you a reply soon.

The TNS Entries have been checked and they seem to be fine.

I have also got this error:-

I added a few error-handling code to the agent to get a more accurate error message.

It really helped. It flashed this error message this time.

  1. (Pull_PS_Inf. Main Line: 45 Error: 12325 Error: ORA-01034: ORACLE not available, Connector ‘oracle’, Method -Connect- (1034))

This error came to one of my team mates who tried to run the agents from his clients.

  1. (Pull_PS_Inf. Main Line: 21 Error: 217 Error creating product object)

I had earlier got the error for TNS entry-could not resolve service name but it is not coming now. Instead, it gives the could not create product object error.

Thanks,

jitesh

5

Subject: RE: Line: 34 Error: 217 Error creating product object

Hi Friends,

Thank you for the information. I made the changes as you said. It is giving a different error now.

Error: 12809 Error: Invalid field) (Pull_PN_Inf. Main Line: 301 Error: 19 No RESUME)

I searched the Help File and found this about this error. Please note the number-12809 mentioned.

(Refer Lotus Notes Help v6.5 in the Connectors section )

Field-specific Parameterized Connector Errors

&H3209 12809 LCFAIL_INVALID_FIELD Invalid field [‘FIELDNAME’]

An LCFIELD object handle is either not a valid handle, or is zero. Object handles must be a valid value returned by a method which creates a new field. Handles are no longer valid once the object is freed.

As per our error-handler in the agent, it is being generated at Line No-59 of one of our sub-routines. This subroutine just

assigns the values from the Oracle field(Field Name->PNO) to the Notes Document field.

doc.PNO = Cstr(fldLst.PNO(0))

One more point…This agent takes a very long time to finish and needs atleast 14 hours to complete. It takes records from oracle and updates documents based on it. If the record fetched is not proesent, then it inserts the new oracle record into the Notes database.

Please give me your inputs. Any help is most welcome…

Thanks & Regards.

Jitesh