Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view
I'm facing multiple issues trying to import from Spago All.in.one 5.1 to Knowage using Spagobi2Knowage.

Is anyone facing the same problems?
Environment Knowage 6.1.1 - SpagoBI 5.1
in Standard by (120 points)
Dear,

I've just completed the process using oracle as DBMS.

Could you give me some infrmation about:

- DBMS

- SO

- send us all the log files

best regards

Angelo
I'm trying to import All in One Spago 5.1 into Knowage 6.1.1

From HSQL to MySQL. The OS is Windows Server 2012 R2 running MySQL 5.7.14.0

I intalled Knowage-CE using the installer. When i first ran Spagobi2Knowage process, I had an error because tables where not empty, so I dropped those tables and ran mysql-dbscripts-6_1_1_20171110 to create the empty tables.

How do I send you the error log? I have a 8000 char limit in the comments

Thanks in advance!
Dear,

the ETL process has been tested only with:

mysql-mysql

oracle-oracle

But I'm going to check the log file in order to find out the problem.

Best regards

A.
Hi Angelo! I was travellin, so I just checked your reply. I have changed the permissions to public so everyone can see the log file!

Thanks!

Manuel.-

1 Answer

0 votes
Hi,

are you still facing the issue?

Error is happening when trying to retrieve roles

could you check the following query in your source SPAGOBI gives result? look I provided SPAGOBI as organization but please put yours, check also that roles have ORGANIZATION not null, in some installations I found it was null, this would work anyay in SpagoBI because it uses default values but is not correct

thanks

SELECT
  EXT_ROLE_ID,
  NAME
FROM sbi_ext_roles
WHERE organization = 'SPAGOBI'
AND (
NAME =  '/spagobi/admin'
OR NAME =  '/spagobi/user'
OR NAME =  '/spagobi/dev'
OR NAME =  '/spagobi/test'
)
by (200 points)
Sorry, just saw this. Yes, still facing this issue and the query is giving me results also.
...