[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Ubuntu 10.04 server - Spagobi Server 3.5 Custom - TOS 5.1.1r84309 - Tomcat 6.0.24 - Can't see job  XML
Forum Index » Technical Help - SpagoBI Server - ETL
Author Message
oizo.spw

SpagoBI friend

Joined: 07/07/2012 17:43:25
Messages: 50
Offline

Hello,

With the configuration in object, I can deploy job on spagobi server at /var/lib/tomcat6/resources/talend/RuntimeRepository

But can't see it in documents (analytical model-Documents development - ETL folder have been created by me in functionnalities)

my engine-config.xml for SpagoBITalendEngine is :



Logs in catalina.out for this deployment are :


in SpagoBITalendEngine.log I can find :


Should I have some help to resolve it ?

I try to create a ETL document by hand with xml model ask say in this forum very often but get an error too in SpagoBITalendEngine.log:



Thank you.

Eric



This message was edited 4 times. Last update was at 14/09/2012 19:52:24


--
Server :
Ubuntu server 10.04
Tomcat 6.0.24
Spagobi 3.5.1
Java sun 1.6.0.31

Databases :
MySQL version 5.1.63 (DWH and Spagobi core)
Microsoft SQL server 200* (datasources)
Microsoft Acces 2003 (datasources)
Progress 9.1.e (datasource)

ETL :
TOS 5.1.*

Clients :
Ubuntu 10.04 desktop - Xubuntu 12.04 desktop - Windows XP - Windows Vista
Internet Explorer - Firefox
Microsoft Office - Openoffice
oizo.spw

SpagoBI friend

Joined: 07/07/2012 17:43:25
Messages: 50
Offline

Hello,

I have progress a little bit.

Those lines where missing in /tomcat6/conf/server.xml (in ubuntu 10.04 : /usr/share/tomcat6/conf/server.xml):




And a library was missing in /tomcat6/lib (in ubuntu 10.04 : /usr/share/tomcat6/lib) (get them in all in one package - foo-commonj.jar - concurrent.jar - commonj-twm.jar - I.m not sure of the one which solved the precedent error) .

Now I have the message :etl.process.started when executing ETL Document via Spagobi Server.

And some tempory folders are created in /var/lib/tomcat6/webapps/resources/talend/RuntimeRepository/java/Test/Hello



But I still have an error message in catalina.out and SpagoBI.log :



And can't see my TMsgBox jobs : hello world box

I continue ... with a data process, to test if its works.

Expect someone could help

Eric.

This message was edited 6 times. Last update was at 03/10/2012 16:20:37


--
Server :
Ubuntu server 10.04
Tomcat 6.0.24
Spagobi 3.5.1
Java sun 1.6.0.31

Databases :
MySQL version 5.1.63 (DWH and Spagobi core)
Microsoft SQL server 200* (datasources)
Microsoft Acces 2003 (datasources)
Progress 9.1.e (datasource)

ETL :
TOS 5.1.*

Clients :
Ubuntu 10.04 desktop - Xubuntu 12.04 desktop - Windows XP - Windows Vista
Internet Explorer - Firefox
Microsoft Office - Openoffice
oizo.spw

SpagoBI friend

Joined: 07/07/2012 17:43:25
Messages: 50
Offline

Hello,

It's solved.
A - check if those lines are in /tomcat6/conf/server.xml (in ubuntu 10.04 : /usr/share/tomcat6/conf/server.xml):


B - configure Spagobi server in TOS (preferences or ?)

1 - deploy the job with TOS (check before if the deploy folder is created - .../webapps/talend/RuntimeRepository/java/ chown and chmod if needed)
2 - create an XML file (you may found it under /var/lib/tomcat6/webapps/resources/talend/RuntimeRepository/java/TOSPROJECTNAME/TOSJOBNAME/spagobi.xml (core server with ubuntu 10.04)
3 - create a new ETL document with the spagobi.xml file as model
4 - save the ETL document

The process is not all self-deploying, you have to create the spagobi.xml file or get it from the server side deploy folder, and create a new ETL document (in server document creation) with this file as model.

Greatings,

Eric

This message was edited 4 times. Last update was at 03/10/2012 19:03:45


--
Server :
Ubuntu server 10.04
Tomcat 6.0.24
Spagobi 3.5.1
Java sun 1.6.0.31

Databases :
MySQL version 5.1.63 (DWH and Spagobi core)
Microsoft SQL server 200* (datasources)
Microsoft Acces 2003 (datasources)
Progress 9.1.e (datasource)

ETL :
TOS 5.1.*

Clients :
Ubuntu 10.04 desktop - Xubuntu 12.04 desktop - Windows XP - Windows Vista
Internet Explorer - Firefox
Microsoft Office - Openoffice
d.synchronized@gmail.com.spw

SpagoBI friend

Joined: 14/12/2012 05:15:51
Messages: 98
Offline

can you please explain me what should i do after the step 3?

i checked those lines in the server.xml and now i have spagobi.xml with me now what should i do i am gettng the same error .even i can not see my deployed job

thanks in advance
Dishant
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 83
Offline

Hi Eric,

I try to set up SpagoBI to run from our Ubuntu 12.04 server. Well, not much luck till now....I will try to follow your action list.
Are you actually aware of a good documentation about how to set up SpagoBI on Linux? I managed to make it work - properly - on my win7 machine..

Thanks alot,

Zsolt
terje.spw


[Avatar]

Joined: 05/06/2012 15:19:35
Messages: 9
Location: Oslo, Norway
Offline

Remember that your ETL Document must have the Status set to "Released" for it to be visible in the document tree for scheduling :)
[WWW]
 
Forum Index » Technical Help - SpagoBI Server - ETL
Go to:   
Powered by JForum 2.1.9 © JForum Team