Need help Publishing

[Guest]

I have configured a couple of "sites" using RH Configuration Manager. My problem is I cannot publish to those sites. I am able to publish to http://servername/robohelp/admin. My config; W23K server running Tomcat 6.0, Roboserver 8 using Robo8 HTML to publish. Any help would be greatly appreciated
Thanks, Rich

[tuls_garg]

Hi Rich,

First you need to verify that those websites(which we call "context" in RoboHelp Server 8) are up and running. Say you have created a context called "robohelp2" then you can verify if its up and running by accessing " http://servername/robohelp2/admin" from browser. This should open up the admin page for your new context.

To publish to this context from RoboHTML 8, in the server name field, specify server url as "servername/robohelp2/server" and then publish using the default uid "admin" and default pwd "admin". If you do not provide the complete url then RoboHTMl will assume that you want to publish to the default context and it will publish to "servername/robohelp/server".

Tulika.
RoboHelp Server Team
Adobe

[Guest]

Thank you Tulika. The admin page did open but I could not log in as admin. Is there a place I could reset the password?

That is probably my problem, as I was getting connetion errors when trying to publish.

Thanks again,
Rich

[tuls_garg]

quote:

---

Originally posted by: Blizz1
Thank you Tulika. The admin page did open but I could not log in as admin. Is there a place I could reset the password?

That is probably my problem, as I was getting connetion errors when trying to publish.

Thanks again,
Rich

---

You can reset the admin password in "<RoboHelp Server Install Directory>/WEB-INF/<context-name>_server.properties" . So if you have a context named "IS", then your file will be names "IS_server.properties".
You need to change the property named "DefAdminPwd" and set it to any value of your choice and then restart Tomcat.

[Guest]

Hi Tulika, When I try to login to my sites admin page http://robo8/IS/admin
I get an error "Unable to connect to database. Kindly refer to tocat logs" the log shows a sql exception

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TSetting'

[tuls_garg]

quote:

---

Originally posted by: Blizz1
Hi Tulika, When I try to login to my sites admin page http://robo8/IS/admin
I get an error "Unable to connect to database. Kindly refer to tocat logs" the log shows a sql exception

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TSetting'

---

As for the exception, "Invalid object name 'TSetting", you can safely ignore it. First you verify if RoboHelp Server 8 has sufficient information to connect to database. To do so, launch Config manager and select the context you are using and click on the "Test Connection" button. In case you get "connection failed" dialog then you need to review your connection settings. Verify that DSN is properly created, its a System DSN and the username and password to connect to the DSN is correctly specified.

If "Test Connection" shows the dialog "Succesfully connected to database." but your admin page still gives you error then please attach your tomcat logs. We can take a look at it.

[Guest]

Hi Tulika, My ODBC connection tests okay
here is a portion of the error

[Guest]

Hi Tulika, Does the Sql db have to be on the same server as the Robohelp server software?
Thanks

[tuls_garg]

quote:

---

Originally posted by: Blizz1
Hi Tulika, Does the Sql db have to be on the same server as the Robohelp server software?
Thanks

---

Hi Rich,

You can have your SQL Server on a different machine that RoboHelp Server machine. You just need to create an ODBC DSN to connect to the SQL Server. Refer my thread Advanced Database Setup for RoboHelp Server 8 for more details on how to configure RoboHelp Server 8 to use SQL Server .

[Guest]

Hello, looks like my problem is the SQL db. The ODBC connection tests okay, but will not connect when I login to the site with the default admin,admin .

If I create a context with the default Access DB I am able to connect with no problems.

Thank you for your help
Rich

[Guest]

Still can't get a connection to SQL DB when loging into context admin page. Also when trying to publish large projects, to a site configured with Access DB, it publishes with no errors, I then go to my admin site and the project is not there. Is there any special considerations when setting up the DB. I had our DBA create it. I can get a connection when using ODBC test.

Thank you

[tuls_garg]

quote:

---

Originally posted by: Blizz1
...Also when trying to publish large projects, to a site configured with Access DB, it publishes with no errors, I then go to my admin site and the project is not there.....

---

Kindly attach the tomcat logs.
If project was successfully published and handled by server, you should get something like the following in your tomcat logs (localhost/catalina log)-

Mar 25, 2009 11:13:48 AM org.apache.catalina.core.ApplicationContext log
INFO: refreshed single project list
Mar 25, 2009 11:13:48 AM org.apache.catalina.core.ApplicationContext log
INFO: RoboHelp Server log[info] : .........Generation of search index for area general begins.............
Mar 25, 2009 11:13:48 AM org.apache.catalina.core.ApplicationContext log
INFO: RoboHelp Server log[info] : .........Generation of search index for area general completed.............

[Guest]

[Fatal Error] Training_Manual.ppf:43:29: The reference to entity "_Casualty" must end with the ';' delimiter.
org.xml.sax.SAXParseException: The reference to entity "_Casualty" must end with the ';' delimiter.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
at adobe.robohelp.server.HelpProject.openPPFFile(HelpProject.java:436)
at adobe.robohelp.server.HelpProject.ReadProjectName(HelpProject.java:339)
at adobe.robohelp.server.HelpProject.initialize(HelpProject.java:322)
at adobe.robohelp.server.HelpProjectList.getProjectsFromDisk(HelpProjectList.java:174)
at adobe.robohelp.server.GlobalData.refresh(GlobalData.java:149)
at adobe.robohelp.server.HelpArea.refresh(HelpArea.java:44)
at adobe.robohelp.server.AreaManager.refresh(AreaManager.java:121)
at adobe.robohelp.server.RoboHelpServer.refresh(RoboHelpServer.java:66)
at adobe.robohelp.server.RefreshServer.run(RefreshServer.java:94)
at java.lang.Thread.run(Unknown Source)

[tuls_garg · Accepted solution]

Hi Rich,

Apparently some of your topic file names contain either < (less than), > (greater than), " (quote), & (ampersand), ‘ (apostrophe).
You need to remove these characters from file name and then regenerate your help output and publish it again.

Tulika.