Hi Thomas,

Just a suggestion
Check permissions and privileges of the user 'Admin' on the database, and 
grant as needed


On Thursday, 3 January 2013 11:40:02 UTC+3, Thomas (Uganda) wrote:
>
> Hello 
>
> I am try to populate the 11 Reports Datawarehouse But the ETL Job 
> fails with the error below. 
>
> This is my local.properties 
>
> main.database=mydatabase 
> main.database.host=localhost 
> main.database.port=3306 
> main.database.user=admin 
> main.database.password=password 
> main.database.dbPentahoDW=mifosdw 
>
>
> I also created a user 
> User = mifos 
> password = mifos 
>
> But the ETL Job fails with the error below 
>
> Any pointer to what i cud be missing 
> Tx 
>
> ****************************************************************** 
> INFO  03-01 11:29:54,859 - Using "C:\Windows\TEMP\vfs_cache" as 
> temporary files store. 
> INFO  03-01 11:29:55,156 - Data Warehouse Initial Load - Start of job 
> execution 
> INFO  03-01 11:29:55,156 - Data Warehouse Initial Load - Starting 
> entry [Log Start Entry for Initial Load] 
> INFO  03-01 11:29:55,156 - Log Start Entry for Initial Load - Loading 
> transformation from XML file [file:///C:/Program Files/Apache Software 
> Foundation/Tomcat 6.0/webapps/config/ETL/MifosDataWarehouseETL/ 
> InitialLoadLogStartEntry.ktr] 
> INFO  03-01 11:29:55,265 - Initial Load Log Start Entry - Dispatching 
> started for transformation [Initial Load Log Start Entry] 
> INFO  03-01 11:29:55,281 - Initial Load Log Start Entry - This 
> transformation can be replayed with replay date: 2013/01/03 11:29:55 
> [DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifosdw? 
> useUnicode=true&characterEncoding=UTF-8 
> [DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifosdw? 
> useUnicode=true&characterEncoding=UTF-8 
> ERROR 03-01 11:29:55,359 - Set ETL start time and complete to date - A 
> database error occurred, stopping everything: 
> Error occured while trying to connect to the database 
>
> Invalid JNDI connection DestinationDB : Access denied for user 
> 'admin'@'localhost' (using password: YES) 
>
> ------------------------------------------------------------------------------
>  
>
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, 
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current 
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft 
> MVPs and experts. ON SALE this month only -- learn more at: 
> http://p.sf.net/sfu/learnmore_122712 
> _______________________________________________ 
> Mifos-users mailing list 
> [email protected] <javascript:> 
> https://lists.sourceforge.net/lists/listinfo/mifos-users 
>
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to