Status Code: -2147482645 --- Status Message: Error executing an Sql 1

[smallredville]

Hi All,

Through this post I would like to check anyone who has encountered the following error message :

+++ Start of session errors +++
Status Code: -2147482645
Api Error:
Error Message:
Status Message: Error executing an Sql statement.
+++ End of session errors +++

I encountered the above error when my java program trying to put back a document into a destination (says folder A) in the livelink system. And the above error only happened for some documents, not all documents failed to be put back into the livelink system.


The destination contains documents and folders(subfolders) only.

The following is section of my code calling ListObjects():
/***************************** START : ListObjects() :: checking whether the (same name)PDF documents exist or not in the Livelink**********************************************/
//check document exist or not - exist = just add a new version to it
/* see if the object exists first */
if ((status = doc.ListObjects(volumeID, fileto, null, "NAME = '" + objName + "'", 0, results)) != 0) {

LivelinkHandler.writeSessionErrors(GlobalVariables.session);
LogHandler.writeProcessLog("Error in MainController.putBack() :: " +
"Error in ListObjects() :: " +
"objectName : " + objName + "\n");
return false;
}//end if


Lastly, many thanks in advance, =)
smallredville

 

[ggriffit]

do you have the Connect Logs from this server ? Do you have any DB Monitoring on the server ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[smallredville]

Hi Greg,

Thanks for the reply.

May I know where can I find the connect log?

Honestly, I am a newbie to livelink system.

Regards&Thanks,
smallredville

 

[smallredville]

Hi All,

Just wish to share that after searching at KC OpenText, we can get Connect Logs by :

-> activating it -> set wantLogs to true in the [options] section of your opentext.ini

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=10464048&objAction=view&show=2

Cheers,
smallredville

 

[smallredville]

Hi All,

May I know when actually we would need to retrieve the Connect Logs?

Or is it recommended that :

we should always set wantLogs to true in the [options] section of your opentext.ini?


Lastly, thank you,
smallredville

 

[ggriffit]

Generally to get these, I would edit the OpenText.ini file on the server in question and set the following options :

[GENERAL]
DEBUG=2

[OPTIONS]
WANTLOGS=TRUE
WANTVERBOSE=TRUE

Then restart the Livelink Server service, the logs will then begin to appear in the specified logs directory.

All you have to do then is repeat the issue, stop the services and review the logs for any obvious errors.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/