Transport error: No response from server, timeout exceeded

[Former Member]

Hi, I get this error in .NET calling this query in an InfoObject?

Select SI_NAME,SI_ID,SI_KIND,SI_PATH,SI_FILES,SI_DESCRIPTION,SI_PARENT_FOLDER,SI_CREATION_TIME,SI_OWNER,SI_KEYWORD,SI_CORPORATE_CATEGORIES From CI_INFOOBJECTS Where SI_INSTANCE=0 AND SI_PARENT_FOLDER=0

Transport error: No response from server, timeout exceeded

Any Idea

Thanks, JP

[Former Member · Accepted solution]

I get this error message:

Transport error: No response from server, timeout exceeded

Is there a way to increase this timeout?

[ted_ueda · Accepted solution]

Did using the SI_PARENTID indexed properties work for you?

I really would discourage increasing the timeout (HKLM\Software\Business Objects\Suite <version>\CER\ConnectionTimeout).

Sincerely,

Ted Ueda

[Former Member]

Yes it did thanks a lot for your help

[Former Member]

Yes of course it is running.

The CMS is Big, and I want to get the folder tree list do you have any code sample to get the folder / file tree that is optimized for big CMS. It seems that asking for Parent Folder does not use any of the database indexes isn't it?

Note that the CMS is on DB2

[ted_ueda]

Just to clarify, what timeout are you encountering?

Is it the default 10 minute CORBA TCP/IP timeout?

SI_PARENT_FOLDER is not indexed.

SI_PARENTID is indexed.

For InfoObject objects, the SI_PARENTID for a scheduled instance points to the original document that was scheduled. For non-scheduled instances, the SI_PARENTID points to the parent Folder where the object may be found.

Sincerely,

Ted Ueda

[ted_ueda]

It tried connecting to the CMS, waited for a response, and none was forthcoming.

Is the CMS running properly?

Sincerely,

Ted Ueda